Skip Headers
Oracle® Database Administrator's Reference
10g Release 2 (10.2) for hp OpenVMS

Part Number B25416-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

3 Configuring Oracle Products

This chapter describes how to configure Oracle Database and Oracle software on OpenVMS. It contains the following sections:

3.1 Configuring the Database for Additional Oracle Products

If you install additional Oracle products after the initial installation, then use Oracle Database Configuration Assistant to configure the database for the new products, as follows.

  1. Start the database, if necessary.

  2. Enter the following command to start Oracle Database Configuration Assistant:

    $ dbca
    
    
  3. Select Configure Database Options.

  4. From the list of available databases, select the database that you want to configure.

  5. Choose the products that you want to enable from the list, and then click Finish.

3.2 Using Configuration Assistants as Standalone Tools

Configuration Assistants are usually run during an installation session, but you can also run them in standalone mode. As with Oracle Universal Installer, you can run each of the assistants noninteractively using a response file. This section contains the following topics:

3.2.1 Using Oracle Net Configuration Assistant

When Oracle Net Server or Oracle Net Client is installed, Oracle Universal Installer automatically launches Oracle Net Configuration Assistant.

If you choose to perform a separate Oracle Database Client installation, then Oracle Net Configuration Assistant automatically creates a configuration that is consistent with the selections made during the installation. Oracle Universal Installer automatically runs Oracle Net Configuration Assistant to set up a net service name in the local naming file located in the ORA_ROOT:[network.admin] directory of the client installation.

After the installation is complete, you can use Oracle Net Configuration Assistant to create a more detailed configuration, by entering the following command:

$ netca

Note:

When you use Oracle Database Configuration Assistant to create a database, this assistant automatically updates the network configuration files to include information for the new database.

3.2.2 Using Database Configuration Assistant

You can use Oracle Database Configuration Assistant to:

  • Create a default or customized database

  • Configure an existing database to use Oracle products

  • Generate a set of DCL and SQL scripts that you can inspect, modify, and run at a later time to create a database

To start Oracle Database Configuration Assistant, enter the following command:

$ dbca

For information about the command line options available with Oracle Database Configuration Assistant, use the -help or -h command line arguments, as follows:

$ dbca -help

3.2.3 Configuring New or Upgraded Databases

Oracle recommends that you run the utlrp.sql script after creating or upgrading a database. This script recompiles all PL/SQL modules that may be in an invalid state, including packages, procedures, and types. Although it is optional, Oracle recommends that you perform this step when you create the database and not later.

To run the utlrp.sql script, follow these steps:

  1. Log in as the oracle user.

  2. Set up the Oracle environment for the Oracle home by running ORAUSER.COM with the required sid parameter.

  3. Start SQL*Plus, as follows:

    $ sqlplus "/ AS SYSDBA"
    
    
  4. If necessary, start the database:

    SQL> STARTUP
    
    
  5. Run the utlrp.sql script:

    SQL> @ORA_ROOT:[RDBMS.ADMIN]UTLRP.SQL
    

3.3 Relinking Executables

You can relink the product executables by using the script that was created by Oracle Universal Installer. It is necessary to relink after an operating system upgrade and after most Oracle software patches. Some operating system patches may also require relinking of Oracle products.The command to relink is as follows:

@ora_root:[bin]relink all

The relink script manually relinks Oracle product executables, depending on the products that have been installed in the ORACLE_HOME directory.

3.3.1 Support for Shared Libraries in RMAN

Starting with Oracle9i Database release 2 (9.2.0.2), support for shared libraries in RMAN has been available. If you want to change the specified Media Management Library (MML), then you need not perform a relink. You can explicitly override the specified MML by using the ALLOCATE CHANNEL command as follows:

RUN
{
  ALLOCATE CHANNEL c1 DEVICE TYPE sbt PARMS='SBT_LIBRARY=mymml';
}

In this example, mymml is the full path for the shared library that is provided by the third-party vendor.

RMAN on OpenVMS defaults to the Serial Backup Tape (SBT) disk implementation (which is statically linked), unless it is explicitly overridden with the SBT_LIBRARY parameter on the ALLOCATE CHANNEL command.

Note that because the shared library is called into the server, third-party vendors who are supplying their own MML must ensure that their library is compiled 64-bit. The Oracle Database 10g code was compiled by using the qualifier /NAMES=AS_IS, and the symbol vector must exactly match the entry point names as indicated in the SBT API specification. The compilation qualifiers /FLOAT=IEEE/IEEE_MODE=DENORM/GRANULARITY=BYTE should also be used.