3 Configuring Oracle Database

3.1.1 Using Oracle Net Configuration Assistant

When Oracle Net Server or Oracle Net Client is installed, Oracle Universal Installer automatically starts 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 $ORACLE_HOME/network/admin directory of the client installation.

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

$ $ORACLE_HOME/bin/netca

3.1.2 Using Oracle Database Upgrade Assistant

During an Oracle Database installation, you can choose to upgrade a database from an earlier release to the current release. However, if you choose not to upgrade a database during installation or if there are multiple databases that you want to upgrade, then you can run Oracle Database Upgrade Assistant after the installation.

If you installed Oracle Database 11g and chose not to upgrade the database during the installation, then you must upgrade the database before mounting it.

To start Oracle Database Upgrade Assistant, run the following command:

$ $ORACLE_HOME/bin/dbua

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

$ $ORACLE_HOME/bin/dbua -help

3.1.3 Using Oracle 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

• Create Automatic Storage Management disk groups

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

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

$ $ORACLE_HOME/bin/dbca

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

$ $ORACLE_HOME/bin/dbca -help

3.1.4 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. This is an optional step but Oracle recommends that you do it when you create the database and not at a later date.

To run the utlrp.sql script:

1. Switch user to oracle.

2. Use the oraenv or coraenv script to set the environment for the database on which 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. Run the following command to start SQL*Plus:

   $ sqlplus "/ AS SYSDBA"
   

4. If required, run the following command to start the database:

   SQL> STARTUP
   

5. Run the utlrp.sql script:

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