CHAPTER 7. Maintaining the Oracle Products
Information can tell us everything. It has all the answers. But they are answers to questions we have not asked, and which doubtless don't even arise.
Jean Baudrillard, French semiologist. Cool Memories, Chapter 5 (1987
tr. 1990).
This chapter describes the following product installation maintenance procedures:
- Installing an independent tools environment
- Adding or upgrading products
- Relinking the Oracle code
Installing an Independent Tools Environment
In an independent tools installation, Oracle and/or user applications connect to an Oracle7 Server (on the same node or another node) using one of the SQL*Net communication protocols. Applications communicate with another process (called a server process) over SQL*Net, which submits requests to the Oracle7 Server on behalf of the application. This server process then returns the results to the application over the same SQL*Net connection.
Implement the following steps to install independent tools:
- Which Oracle products (besides SQL*Net) are to be installed?
- Which SQL*Net network protocol will the client use to communicate to the server machine (for example, TCP/IP)?
2. Once you have decided the Oracle products that you want to install, do the following:
- Create the Oracle Server Database Administrator Account and root directory, as described in Chapter 1.
- Log onto the Oracle Server Database Administrator Account.
- Mount your distribution media and restore the appropriate BOOT.BCK (if loading from CD-ROM, the first BOOT.BCK to restore is located in the [SERVER] directory). The BACKUP command to be used is:
$ BACKUP/LOG <ddcn>:[SERVER]BOOT.BCK/SAVE_SET -
ORA_INSTALL:/NEW_VERSION/BY_OWNER=PARENT
where:
<ddcn> is the name of your CD-ROM device.
3. Invoke the Oracle Installation procedure by entering the following command:
$ ORACLEINS
- Select Option 1, "Create a new Oracle system".
- When prompted for "Root directory?", press RETURN to accept the default.
- When prompted for the saveset location, enter the device name with the correct directory (for example, DKA100:[SERVER]).
- Select Option 1, "Software Installation and Upgrade Menu," from the Main Menu.
- Select Option 1, "Select Products to Load".
Select all the Oracle products that you want to install. From the Server Bundle, YOU MUST SELECT NETCONFIG and UTIL.
- Select Option 2, "Select Build Configuration Options."
For NETCONFIG, change the following entries:
Enable appropriate SQL*Net Change to "Y".
protocol driver/adapter
(for example, DECnet, TCP/IP)
- Select Option 3, "Load and Build Selected Products".
The Oracle installer now loads and builds the selected products.
4. If you need to load and build additional products from any other CD-ROM directories, do the following:
- Restore the BOOT.BCK from that CD-ROM directory, by entering the following:
$ BACKUP/LOG <ddcn>:[<bundle>]BOOT.BCK/SAVE_SET -
ORA_INSTALL:/NEW_VERSION/BY_OWNER=PARENT
where:
<ddcn> is the name of your CD-ROM device.
- Invoke the Oracle Installation procedure by entering the following command:
$ @ORA_INSTALL:ORACLEINS
- Select Option 3, "Reconfigure existing products, manage the database, or load the demo tables".
- Follow the same instructions as in Step 3 above (starting with the step that begins with, "When prompted for 'Root directory?'...").
Reconfiguring Products
Perform the following steps to change product configuration options or to relink products. Verify that your system has Oracle7 installed.
The following figure shows the menus in ORACLEINS that you use to reconfigure a product.
Figure 7-1 Installation
Note: If you are reconfiguring NETCONFIG or the RDBMS, shut down the instance and deinstall the shareable images before reconfiguring. See the section, "Shutting Down Oracle7 via Server Manager, " page 6 - 14 for more information.
1. Run the ORAUSER file for your database by entering the following line:
$ @<database directory>:ORAUSER_<dbname>
2. If you plan to reconfigure or relink the Oracle7 Server or SQL*Net, you must shut down the database:
3. Remove the shareable images.
4. Run the installation script by entering the following line:
The ORACLE Installation Startup Menu appears as follows:
5. From this menu, select Option 3, "Reconfigure existing products, manage the database, or load demo tables". You are prompted to verify the root directory and supply a saveset location.
After you enter this information, the Main Menu appears as shown here:
6. Select Option 1 from the Main Menu. The Software Installation and Upgrade Menu appears as shown here:
7. To reconfigure software products, select Option 2 from the Software Installation and Upgrade Menu.
The Select Configuration Options Menu appears:
- Modify the configuration options for each product as needed. For more information about individual product configuration options, see Appendix A, "Oracle7 Product Configuration."
- Exit each configuration menu, then enter E to return to the Software Installation and Upgrade Menu.
8. To relink software products, select Option 4, "Build Selected Licensed Products," from the Software Installation and Upgrade Menu.
9. Exit ORACLEINS and return to the DCL prompt. You have now completed reconfiguring or relinking your Oracle products. Note that if you previously shut down the database (to reconfigure or relink Oracle7 or SQL*Net), you will need to restart the database.
10. If the product you have reconfigured has changed its executable name since the last installation, and you install the product into shared memory, you must run the following command procedure:
$ ORA_INSTALL:ORA_INSUTL.COM
Removing Products
To remove products, issue the following command:
$ @ORA_INSTALL:ORA_DEINST <product name>
where:
<product name> is the mnemonic used in the ORA_UTIL:PRODUCTS.TXT file.
For example, if you want to completely get rid of SQL*Plus, issue the following command:
$ @ORA_INSTALL:ORA_DEINST SQL*PLUS
Adding or Upgrading Products
This section applies to all Oracle products except earlier versions of Oracle7 and SQL*Net. It has the following topics:
- Preparing to add or upgrade
- Building or upgrading database tables
- Restarting parallel mode (optional)
Preparing to Add or Upgrade
Before you add or upgrade a product, perform the following steps:
1. Verify that your system has Oracle7 installed.
2. Log onto your OpenVMS machine.
3. Run the following ORAUSER file for your database:
$ @ORA_DB:ORAUSER_<dbname>
4. If you plan to upgrade any Oracle product tables, change the Oracle SYSTEM password to MANAGER.
Note: If you do not change the Oracle SYSTEM password to MANAGER, your installation may fail. Oracle installation scripts often assume the password is MANAGER. Alternatively, you can check for hardcoded user names and passwords in the Oracle scripts and change them to your own user names and passwords.
5. Back up the old code and database files (data, redo log, and control).
6. Mount the distribution media.
7. Restore the product`s BOOT.BCK saveset into the ORA_ROOT:[INSTALL] directory. Refer to Step 2 ![[*]](jump.gif)
for more information.
This saveset contains the updated PRODUCTS.TXT file used by the installation procedure to upgrade the products on the distribution media.
After completing these preliminary steps, you are ready to load and configure your Oracle products. The following figure shows the ORACLEINS menu items you will use to add or upgrade a product.
Figure 7-2 Installation
Adding or Upgrading a Product Summary
2. From the Installation Startup Menu, select Option 3, "Reconfigure system, manage database, load demo tables".
3. From the Main Menu, select Option 1, "Software Installation and Upgrade Menu".
4. Select products to load.
6. Load and build selected products.
7. Exit and return to the Main Menu.
9. Build or upgrade database tables menu.
Starting Up an Instance
If the database is running, go to the next section "Building or Upgrading Database Tables".
If you previously shut down the database (to upgrade the Oracle7 server or SQL*Net), you need to start it up again. From the Main Menu, select Option 2, "Instance Creation and Instance Startup Menu". This brings up a submenu, from which you should select Option 2, "Startup an Existing Instance". To restart your database, enter its instance ID when prompted to do so. Return to the Main Menu.
Building or Upgrading Database Tables
Before building database tables, you must have created the SCOTT account. This is created automatically when Building Database Tables for RDBMS.
From the Main Menu, select Option 3, "Build or Upgrade Database Tables Menu".
1. Enter the item number of each product whose database tables you want to upgrade, or enter A for all products. Steps 2 and 3 must be completed for each product you choose.
2. When prompted to initialize or upgrade the system tables, enter U to upgrade existing products or I to initialize new products.
3. When prompted if you want to create demo tables, enter Y if you want to create them or N if you do not want to create them.
Press E to exit ORACLEINS and return to the DCL prompt. The upgrade procedure is now complete.
Restarting Parallel Mode (Optional)
In addition, if you used ORACLEINS to restart a database instance, note that it is operating in exclusive mode. To run the instance in parallel mode, you need to restart the database in parallel mode, via Server Manager. For more information about running parallel mode, see Oracle7 for OpenVMS Server and Tools Administrator's Guide.
Relinking the Oracle Code
The Oracle code must be relinked under the following conditions:
- Change to operating system, for example upgrade
- Change to SQL*Net configuration
- Change to RDBMS configuration
Step 1 Shutdown the Given Database(s)
First verify that you are pointed to the right database instance. At the DCL prompt:
$ SHOW LOGICAL ORA_SID
ORA_SID" = "V733" (LNM$JOB_TABLE)
Invoke SVRMGR and connect internal. Select from the view V$PROCESS. If no other processes are active and you are pointed to the right instance, shut down the given database.
Once the database is shut down, all Oracle background process will no longer exist. Type SHOW SYSTEM at the OS prompt to verify.
Step 2 Remove Images
1. Execute command file ORA_RDBMS:REMORACLE.COM
$ @ORA_RDBMS:REMORACLE
Note: Generally no response is yielded other than the return of the system prompt.
Step 3 Invoke the Oracle Installation Utility
1. Type ORACLEINS at the system prompt.
$ ORACLEINS
This yields the ORACLE Installation Startup Menu.
2. From this menu, choose option 3, "Reconfigure existing products, manage the database, and/or load the demo tables".
3. Press the return key until you reach the "Main Menu".
4. Choose option 1, "Software Installation and Upgrade Menu". This yields the menu, "Software Installation and Upgrade Menu".
You are presented with a list of Oracle products that can be installed, upgraded, or reconfigured.
6. Choose the number for NETCONFIG only.
The current configuration options for NETCONFIG are yielded:
7. At the prompt, type E to exit this menu with selected options.
You are again presented with the list of products. Note, -rebuild appears next to NETCONFIG, for example:
8. Type E again to exit this menu with selected products.
You are returned to the Software Installation and Upgrade Menu and you are prompted to Enter a number or (E)XIT to return to the Main Menu.
9. Select option 4, "Build Selected Licensed Products".
Invoke ORA_UTIL:INSUTILITY.COM, if you install the given tools into memory. Invoke ORA_DB:STARTUP_EXCLUSIVE_<dbname>.COM or ORA_DB:STARTUP_PARALLEL_<dbname>.COM, whichever mode is applicable.
Note: If you have an automatic startup Oracle script, you may run it instead