| Oracle® Database Administrator’s Reference 10g Release 1 (10.1) for UNIX Systems: AIX-Based Systems, hp HP-UX PA-RISC (64-bit), hp Tru64 UNIX, Linux x86, and Solaris Operating System (SPARC) Part No. B10812-01 |
|
 |
 |
| Oracle® Database Administrator’s Reference 10g Release 1 (10.1) for UNIX Systems: AIX-Based Systems, hp HP-UX PA-RISC (64-bit), hp Tru64 UNIX, Linux x86, and Solaris Operating System (SPARC) Part No. B10812-01 |
|
|
|
This chapter describes how to administer Oracle Database and Oracle software on UNIX systems. It contains the following sections:
If you install additional Oracle products after the initial installation, use the Database Configuration Assistant to configure your database for the new products, as follows.
Start the database, if necessary.
Enter the following command to start the Database Configuration Assistant:
$ $ORACLE_HOME/bin/dbca
Select Configure Database Options.
From the list of available databases, select the database that you want to configure.
Choose the products that you want to enable from the list, then click Finish.
Configuration Assistants are usually run during an installation session, but you can also run them in stand-alone mode. As with Oracle Universal Installer, you can run each of the assistants non-interactively using a response file. This section describes how to use the following Oracle configuration assistants:
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 Client installation, then Oracle Net Configuration Assistant automatically creates a configuration that is consistent with the selections made during the installation. The Installer automatically runs the 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 the Oracle Net Configuration Assistant to create a more detailed configuration, by entering the following command:
$ $ORACLE_HOME/bin/netca
|
Note: When you use the Database Configuration Assistant to create a database, it automatically updates the network configuration files to include information for the new database. |
During an Oracle Database installation, the installer enables you 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 is more than one database that you want to upgrade, you can run the Database Upgrade Assistant after the installation.
If you installed Oracle10i software and chose not to upgrade the database during the installation, then you must upgrade the database before mounting it.
To start the Database Upgrade Assistant, enter the following command:
$ $ORACLE_HOME/bin/dbua
For information about the command line options available with the Database Upgrade Assistant, use the -help or -h command line arguments, as follows:
$ $ORACLE_HOME/bin/dbua -help
|
See Also: For more information about upgrades, see the Oracle Database Installation Guide for UNIX Systems and the Oracle Database Upgrade Guide. |
You can use the 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 the Database Configuration Assistant, enter the following command:
$ $ORACLE_HOME/bin/dbca
For information about the command line options available with the Database Configuration Assistant, use the -help or -h command line arguments, as follows:
$ $ORACLE_HOME/bin/dbca -help
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 when you create the database and not at a later date.
To run the utlrp.sql script, follow these steps:
Switch user to oracle.
Use the oraenv or coraenv script to set the environment for the database where you want to run the utlrp.sql script:
For the Bourne, Bash or Korn shell:
$ . /usr/local/bin/oraenv
For the C shell:
$ source /usr/local/bin/coraenv
When prompted, specify the SID for the database.
Start SQL*Plus, as follows:
$ sqlplus "/ AS SYSDBA"
If necessary, start the database:
SQL> STARTUP
Run the utlrp.sql script:
SQL> @?/rdbms/admin/utlrp.sql
You can relink your product executables manually using the relink shell script located in the $ORACLE_HOME/bin directory. You must relink the product executables every time you apply an operating system patch or after an operating system upgrade. If you are running an Oracle Real Application Clusters installation, must relink the product executables on each cluster node, unless the Oracle home directory is shared across the cluster using a cluster file system.
|
Note: Shut down all executables that are running in the Oracle home directory that you are relinking. Also shut down applications linked with Oracle shared libraries. |
Depending on the products that have been installed in the Oracle home directory, the relink script manually relinks Oracle product executables.
To relink product executables, enter the following command, where argument is one of the values listed in Table 3-1:
$ relink argument
Table 3-1 Relink Script Arguments
| Argument | Description |
|---|---|
all |
Every product executable that has been installed |
oracle |
Oracle Database executable only |
network |
net_client, net_server, cman |
client |
net_client, plsql |
client_sharedlib |
Client shared library |
interMedia |
ctx |
ctx |
Oracle Text utilities |
precomp |
All precompilers that have been installed |
utilities |
All utilities that have been installed |
oemagent |
oemagent
Note: To give the correct permissions to the |
ldap |
ldap, oid |
