4 Post-installation Tasks

Downloading and Installing Patches

Check the OracleMetalink Web site for required patches for your installation. To download required patches:

1. Use a Web browser to view the OracleMetalink Web site:

   http://metalink.oracle.com
   
   

2. Log in to OracleMetalink.

   
   

   Note: If you are not an OracleMetalink registered user, click Register for MetaLink! and follow the registration instructions.

   
   

3. On the main OracleMetalink page, click Patches.

4. Select Simple Search.

5. Specify the following information, then click Go:

   • In the Search By field, choose Product or Family, then specify RDBMS Server.

   • In the Release field, specify the current release number.

   • In the Patch Type field, specify Patchset/Minipack.

   • In the Platform or Language field, select your platform.

Configuring Oracle Products

Many Oracle products and options must be configured before you use them for the first time. Before using individual Oracle Database products or options, see the appropriate manual in the product documentation library, available on the Oracle Documentation Library CD-ROM, the DVD-ROM, or on the OTN Web site.

Backing Up the root.sh Script

Oracle recommends that you back up the root.sh script after you complete an installation. If you install other products in the same Oracle home directory, then the Oracle Universal Installer updates the contents of the existing root.sh script during the installation. If you require information contained in the original root.sh script, then you can recover it from the backed up root.sh file.

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 might be in an invalid state, including packages, procedures, and types. This is an optional step but Oracle recommends that you do it during installation and not at a later date.

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

1. Switch user to oracle.

2. Use the oraenv or coraenv script to set the environment for the database where you want to run the utlrp.sql script:

   • Bourne, Bash, or Korn shell:

     $ . /usr/local/bin/oraenv
     
     

   • C shell:

     % source /usr/local/bin/coraenv
     
     

   When prompted, specify the SID for the database.

3. Start SQL*Plus, as follows:

   $ sqlplus "/ AS SYSDBA"
   
   

4. If necessary, start the database:

   SQL> STARTUP
   
   

5. Run the utlrp.sql script:

   SQL> @?/rdbms/admin/utlrp.sql
   
   

Setting Up User Accounts

For information about setting up additional user accounts, see the Oracle Database Administrator's Reference for UNIX Systems.

Generating the Client Static Library

The client static library (libclntst10.a) is not generated during installation. If you want to link your applications to the client static library, you must first generate it as follows:

1. Switch user to oracle.

2. Set the ORACLE_HOME environment variable to specify the Oracle home directory used by the Oracle Database installation. For example:

   • Bourne, Bash, or Korn shell:

     $ ORACLE_HOME=/Volumes/u01/app/oracle/product/10.1.0/db_1 
     $ export ORACLE_HOME
     
     

   • C shell:

     % setenv ORACLE_HOME /Volumes/u01/app/oracle/product/10.1.0/db_1
     
     

3. Enter the following command:

   $ $ORACLE_HOME/bin/genclntst
   

Configuring Oracle Net Services

If you have an existing installation of Oracle software on this system, you might want to copy information from the Oracle Net tnsnames.ora configuration file from the existing installation to the corresponding file for the new installation.

If necessary, you can also add connection information for additional database instances to the new file.

Configuring Oracle Label Security

If you installed Oracle Label Security, you must configure it in a database before you use it. You can configure Oracle Label Security in two ways; with Oracle Internet Directory integration and without Oracle Internet Directory integration. If you configure Oracle Label Security without Oracle Internet Directory integration, you cannot configure it to use Oracle Internet Directory at a later stage.

Installing Natively Compiled Java Libraries for Oracle JVM and Oracle interMedia

If you plan to use Oracle JVM or Oracle interMedia, Oracle strongly recommends that you install the natively compiled Java libraries (NCOMPs) used by those products from the Oracle Database 10g Companion CD. These libraries are required to improve the performance of the products on your platform.

For information about how to install products from the Companion CD, see the "Installing Oracle Database 10g Products from the Companion CD" section.

Installing Oracle Text Supplied Knowledge Bases

An Oracle Text knowledge base is a hierarchical tree of concepts used for theme indexing, ABOUT queries, and deriving themes for document services. If you plan to use any of these Oracle Text features, you can install two supplied knowledge bases (English and French) from the Oracle Database 10g Companion CD.

For information about how to install products from the Companion CD, see the "Installing Oracle Database 10g Products from the Companion CD" section.

Configuring Oracle Precompilers

The following section describes post-installation tasks for Oracle precompilers.