7.0 to 7.1 on Netware

Here are some instructions to make your trip from Oracle 7.0 to Oracle 7.1 on Netware a little easier.

Upgrading from a 7.0 to a 7.1 Oracle Database for Netware:

Please follow the following steps to upgrade Oracle 7.0 to Oracle 7.1 on a Netware server:

1. Shutdown NORMAL your Oracle 7.0 database using the Oracle 7.0 release.
2. Unload the Oracle 7.0 modules from memory
   : oraunld
   
3. Make a back-up of your Oracle 7.0 database.
4. Deinstall Oracle 7.0 utilities before installing Oracle 7.1. To de-install Oracle 7.0 utilities follow the following steps: Step A: Load INSTALL.NLM (the Netware installation utility) : LOAD INSTALL Step B: Go down to "Products Options" and hit [Enter] This will give you a "Currently Installed Products" window. Step C: Hit the [Insert] key in this window. You will then be prompted for a pathname. Enter the CD-ROM source destination. e:\netware\install OR volumename:\netware\install Depending on how your CD-ROM is set-up. Step D: You will then be prompted for a number of responses, (e.g. volume name, directory name). Choose the defaults. Step E: You will be asked to Choose a method for install: (*) Typical Install ( ) Custom Install IMP: ****CHOOSE THE CUSTOM INSTALL METHOD You can choose this option by pressing the [down arrow] so that Custom Install option is selected and then pressing the [Space Bar]. Step F: You will get two screens, a "Products Available" screen, and a "Products Installed" screen. CTRL-F6 lets to toggle between screens. Toggle to "Products installed" screen by pressing the keys CTRL and F6 together. CTRL-F6. Step G: Select the 7.0 utilities and the SQL*NET only, DO NOT Select the Oracle 7.0 Server. TAB over to remove and press [Enter]. This will de-install Oracle7.0 utilities. You can now proceed with Step 5 of the install process.
5. Toggle back to "Products Available screen" by pressing CTRL and F6 keys together. CTRL-F6. You will be presented a list of products options to install from. To Install Oracle 7.1, choose the following. Oracle Installer 3.0.10.3.2A Oracle Distributed Option 7.1.3.3.2 Oracle7 Server 7.1.3.3.2 Oracle7 Utilities 7.1.3.3.0A Required Support Files 7.1.3.3.2 SQL*NET SPX 1.1.2.2.4 After selecting these items, TAB over to install and press [Enter].
6. The Installer will prompt you for a Installation type. Choose the Option:
   • Upgrade 7.0 database
7. You will next be asked the location of your init.ora and control files. Answer appropriately.
8. You will be asked for a listener name. Answer appropriately.
9. Once you are done answering these questions, the installer will begin copying new NLMs (v7.1.3.3.2) to your ORACLE_HOME\NLM dir. Once the installer is done with the copying of all the needed NLMs, it will bring you back to the products available screen, you can exit safely from the installer at this stage. To exit the Installer press F4 from the "Products Available" screen, and scroll down to EXIT.
10. You must now startup your database using the release 7.1 and run some scripts. To startup your database, please go to the : prompt on the netware server and issue the following commands.
    : oraload
    : load sqldba
    SQLDBA> connect internal SQLDBA> startup pfile=sys:\oranw\rdbms70\init.ora

        Note 1:  Your database files and init.ora file are in the RDBMS70
        directory.  You have a new init.ora in the RDBMS71 directory.  The
        RDBMS71 is your default directory, not RDBMS70.  Hence to startup your
        database smoothly you must specify the correct init.ora file using the
        pfile option.  In your case this will be the init.ora in the RDBMS70
        directory.  If you do not wish to specify the pfile option during
        startup then you must copy your init.ora from your RDBMS70 dir to your
        RDBMS71 dir.

        Note 2:   The init.ora must also point to your correct controlfiles.
        Make sure you have the following line in the init.ora.
                control_files = ("volumename:\pathname\controlfilename.ora")
        e.g.    control_files = ("sys:\oranw\rdbms70\control1.ora")

        General Reminder:  Since with the 7.1 of Oracle for Netware it is now
        possible to have multiple databases running on the same Netware server.
        Please familiarize yourself with the file configuration of such an
        environment.  This information is provided on pgs 4-27 to 4-30 of your
        IUG.

11.  After starting up your database properly please run the following scripts,
     in the exact order.
        a.  Run cat70101.sql as INTERNAL
        b.  Run cat70102.sql as INTERNAL
        c.  Run cat7103.sql as INTERNAL
        d.  Run catalog.sql as INTERNAL
        e.  Run catproc.sql as INTERNAL (PL/SQL functionality)
        f.  Run catparr.sql as INTERNAL (parallel server option)

12.  Your database is now upgraded to release 7.1.  Rerun the utlxplan.sql
     script in any schema in which you wish to use EXPLAIN PLAN.

13.  Your directory structure (under ORACLE_HOME) after the install will be as
     follows.
        ORACLE_HOME:\NLM
                          \RDBMS70
                          \PLSQL20
                          \DBS
                          \RDBMS71
                          \PLSQL21
                          \DATABASE
                          \NET11
     Please verify that this is indeed the case.  At this point your 7.0
     database has been completely upgraded to Oracle 7.1.

Hope this helps someone

shiraz

-- 
Shiraz Kanga (skanga_at_oracle.com) Tel: (415)506-5412 Fax: (415)506-7822
Analyst -- Desktop Netware Group - Worldwide Technical Support - 3OP11
Oracle Corporation 500 Oracle Pkwy, MS 659311, Redwood Shores CA 94065
"I work for Oracle - I speak and type (over here at least) for myself"