Oracle® Database Installation Guide 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. B10811-01 |
|
![]() |
![]() |
This chapter describes how to complete post-installation tasks after you have installed the software. It includes information about the following topics:
You must perform the tasks listed in the "Required Post-installation Tasks" section. Oracle recommends that you perform the tasks listed in the "Recommended Post-installation Tasks" section after all installations.
If you installed and intend to use any of the products listed in the "Required Product-Specific Post-installation Tasks" section, you must perform the tasks listed in the product-specific subsections.
Note: This chapter describes basic configuration only. See the Oracle Database Administrator's Reference for UNIX Systems and product-specific administration and tuning guides for more sophisticated configuration and tuning information. |
You must perform the tasks described in the following sections after completing an installation:
Check the OracleMetalink Web site for required patches for your installation. To download required patches:
Use a Web browser to view the OracleMetalink Web site:
http://metalink.oracle.com
Log in to OracleMetalink.
Note: If you are not an OracleMetalink registered user, click Register for MetaLink! and follow the registration instructions. |
On the main OracleMetalink page, click Patches.
Select Simple Search.
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
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.
After you run the root.sh
script during the installation, enter the following commands as root
:
# cd oracle_home/bin # mv extjob.nobody extjob # chown extjob extjob # chmod 4711 extjob
In this example, oracle_home
is the Oracle home directory where you installed the software and extjob
is the unprivileged user that you created in the "HP-UX Only: Creating an Unprivileged User" section.
Oracle recommends that you perform the tasks in the following section after completing an installation:
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.
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:
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
For information about setting up additional user accounts, see the Oracle Database Administrator's Reference for UNIX Systems.
The client static library (libclntst.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:
Switch user to oracle
.
Set the ORACLE_HOME environment variable to specify the Oracle home directory used by the Oracle Database 10g installation. For example:
Bourne shell (sh
), Bash shell (bash
), or Korn shell (ksh
):
$ ORACLE_HOME=/u01/app/oracle/product/10.1.0/db_1; export ORACLE_HOME
C shell (csh
or tcsh
):
% setenv ORACLE_HOME /u01/app/oracle/product/10.1.0/db_1
Enter the following command:
$ $ORACLE_HOME/bin/genclntst
The following sections describe platform-specific post-installation tasks that you must perform if you installed and intend to use the products mentioned:
Installing Natively Compiled Java Libraries for Oracle JVM and Oracle interMedia
AIX, HP-UX, and Solaris: Configuring Oracle JDBC/OCI Driver for JDK 1.4
Note: You need only perform post-installation tasks for products that you intend to use. |
If you have a previous release of Oracle software installed on this system, you might want to copy information from the Oracle Net tnsnames.ora
and listener.ora
configuration files from the previous release to the corresponding files for the new release.
If you are upgrading from a previous release of Oracle Database, Oracle recommends that you use the current release of Oracle Net listener instead of the listener from the previous release.
To use the listener from the current release, you may need to copy static service information from the listener.ora
file from the previous release to the version of that file used by the new release.
For any database instances earlier than release 8.0.3, add static service information to the listener.ora
file. Oracle Database releases later than release 8.0.3 do not require static service information.
Unless you are using a central tnsnames.ora
file, copy Oracle Net service names and connect descriptors from the previous release tnsnames.ora
file to the version of that file used by the new release.
If necessary, you can also add connection information for additional database instances to the new file.
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.
Note: To configure Oracle Label Security with Oracle Internet Directory integration, Oracle Internet Directory must be installed in your environment and the Oracle database must be registered in the directory. |
See Also: For more information about Oracle Label Security enabled with Oracle Internet Directory, see the Oracle Label Security Administrator's Guide. |
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.
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.
Note: You can extend the supplied knowledge bases depending on your requirements. Alternatively, you can create your own knowledge bases, possibly in languages other than English and French. For more information about creating and extending knowledge bases, see the Oracle Text Reference. |
For information about how to install products from the Companion CD, see the "Installing Oracle Database 10g Products from the Companion CD" section.
To configure Oracle Messaging Gateway, see the section about Messaging Gateway in the Oracle Streams Advanced Queuing User's Guide and Reference manual. When following the instructions listed in that manual, refer to this section for additional platform-specific instructions about configuring the listener.ora
, tnsnames.ora
, and mgw.ora
files.
To modify the listener.ora
file, follow the instructions listed in one of the following sections, depending on your platform:
Linux and Tru64 UNIX: Modifying the listener.ora File for External Procedures
AIX, HP-UX, and Solaris: Modifying the listener.ora File for External Procedures
Table 4-1 describes the environment variables and settings used in the examples in these sections. In each path shown in Table 4-1, replace oracle_home
with the full path of the Oracle home directory.
Table 4-1 Environment Variables and Settings
Platform | Environment Variable | Setting |
---|---|---|
AIX | LIBPATH |
/oracle_home/jdk/jre/bin: /oracle_home/jdk/jre/bin/classic: /oracle_home/lib32 |
HP-UX | SHLIB_PATH |
/oracle_home/jdk/jre/lib/PA_RISC: /oracle_home/jdk/jre/lib/PA_RISC/server: /oracle_home/lib32 |
Linux x86 | LD_LIBRARY_PATH |
/oracle_home/jdk/jre/lib/i386: /oracle_home/jdk/jre/lib/i386/server: /oracle_home/lib |
Linux Itanium | LD_LIBRARY_PATH |
/oracle_home/jdk/jre/lib/ia64: /oracle_home/jdk/jre/lib/ia64/server: /oracle_home/lib |
Tru64 UNIX | LD_LIBRARY_PATH |
/oracle_home/jdk/jre/lib/alpha/classic: /oracle_home/lib |
Solaris | LD_LIBRARY_PATH |
/oracle_home/jdk/jre/lib/sparc: /oracle_home/lib32 |
To modify the $ORACLE_HOME/network/admin/listener.ora
file for external procedures:
Back up the listener.ora
file.
Ensure that the default IPC protocol address for external procedures is set as follows:
(ADDRESS = (PROTOCOL=IPC)(KEY=EXTPROC))
Add static service information for a service called mgwextproc
by adding the following lines to the SID_LIST parameter for the listener in the listener.ora
file:
(SID_DESC =
(SID_NAME = mgwextproc)
(ENVS = LD_LIBRARY_PATH=library_path_paths)
(ORACLE_HOME = oracle_home
)
(PROGRAM = extproc)
)
For example, on Linux x86:
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1) (PROGRAM = extproc) ) (SID_DESC = (SID_NAME = mgwextproc) (ENVS = LD_LIBRARY_PATH =/u01/app/oracle/product/10.1.0/db_1/jdk/jre/ lib/i386:/u01/app/oracle/product/10.1.0/db_1/jdk/jre/lib/i386/server: /u01/app/oracle/product/10.1.0/db_1/lib) (ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1) (PROGRAM = extproc) ) )
In this example:
The ENVS parameter defines the LD_LIBRARY_PATH environment variable.
Table 4-1 lists the platform-specific value for each platform (library_path_paths
). If necessary, you must also add any additional library paths required for non-Oracle messaging systems, for example WebSphere MQ or TIBCO Rendezvous.
oracle_home
is the path of the Oracle home directory.
extproc
is the external procedure agent executable file.
To modify the $ORACLE_HOME/network/admin/listener.ora
file for external procedures:
Back up the listener.ora
file.
Ensure that the default IPC protocol address for external procedures is set as follows:
(ADDRESS = (PROTOCOL=IPC)(KEY=EXTPROC))
Add static service information for a service called mgwextproc
by adding the following lines to the SID_LIST parameter for the listener in the listener.ora
file:
(SID_DESC =
(SID_NAME = mgwextproc)
(ENVS = LIBRARY_PATH=library_path_paths)
(ORACLE_HOME = oracle_home
)
(PROGRAM = extproc32)
)
For example, on HP-UX:
Note: The LD_PRELOAD environment variable is only required on HP-UX PA-RISC. |
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1) (PROGRAM = extproc) ) (SID_DESC = (SID_NAME = mgwextproc) (ENVS= EXTPROC_DLLS=/u01/app/oracle/product/10.1.0/db_1/lib32/libmgwagent.sl, LD_PRELOAD=/u01/app/oracle/product/10.1.0/db_1/jdk/jre/lib/PA-RISC/server/ libjvm.sl, SHLIB_PATH=/u01/app/oracle/product/10.1.0/db_1/jdk/jre/lib/ PA_RISC:/u01/app/oracle/product/10.1.0/db_1/jdk/jre/lib/PA_RISC/server: /u01/app/oracle/product/10.1.0/db_1/lib32) (ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1) (PROGRAM = extproc32) ) )
In this example:
The ENVS parameter defines the platform-specific library search path environment variable (LIBRARY_PATH
).
Table 4-1 lists the platform-specific environment variable name and the recommended value for each platform (library_path_paths
). If necessary, you must also add any additional library paths required for non-Oracle messaging systems, for example WebSphere MQ or TIBCO Rendezvous.
oracle_home
is the path of the Oracle home directory.
extproc
and extproc32
are the 64-bit and 32-bit external procedure agent executable files, respectively.
Note: For Oracle Messaging Gateway, you must specify the 32-bit external procedure agent (extproc32 ). |
To modify the $ORACLE_HOME/network/admin/tnsnames.ora
file for external procedures:
Back up the tnsnames.ora
file.
In the tnsnames.ora
file, add a connect descriptor with the net service name MGW_AGENT
, as follows:
MGW_AGENT = (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=IPC)(KEY=EXTPROC))) (CONNECT_DATA= (SID=mgwextproc) (PRESENTATION=RO)))
In this example:
The value specified for the KEY parameter must match the value specified for that parameter in the IPC protocol address in the listener.ora
file.
The value of the SID
parameter must match the service name in the listener.ora
file that you specified for the Oracle Messaging Gateway external procedure agent in the previous section (mgwextproc
).
To modify the $ORACLE_HOME/mgw/admin/mgw.ora
file for external procedures, set the CLASSPATH environment variable to include the classes in the following table and any additional classes required for Oracle Messaging Gateway to access non-Oracle messaging systems, for example WebSphere MQ or TIBCO Rendezvous classes:
Classes | Path |
---|---|
Oracle Messaging Gateway | ORACLE_HOME /mgw/classes/mgw.jar |
JRE internationalization | ORACLE_HOME /JRE/lib/i18n.jar |
JRE runtime | ORACLE_HOME /JRE/lib/rt.jar |
Oracle JDBC | ORACLE_HOME /jdbc/lib/ojdbc14.jar |
Oracle internationalization | ORACLE_HOME /jdbc/lib/orai18n.jar |
SQLJ | ORACLE_HOME /sqlj/lib/translator.zip ORACLE_HOME /sqlj/lib/runtime12.zip |
JMS Interface | ORACLE_HOME /rdbms/jlib/jmscommon.jar |
Oracle JMS implementation | ORACLE_HOME /rdbms/jlib/aqapil3.jar |
Java Transaction API | ORACLE_HOME /jlib/jta.jar |
The following section describes post-installation tasks for Oracle precompilers.
Note: All precompiler configuration files are located in the$ORACLE_HOME/precomp/admin directory. |
Verify that the PATH environment variable setting includes the directory that contains the C compiler executable. Table 4-2 shows the default directories and the appropriate commands to verify the path setting, depending on your platform and compiler.
To configure the Oracle JDBC/OCI Driver for JDK 1.4 on AIX, HP-UX, or Solaris platforms, include the $ORACLE_HOME/lib
directory in the value specified by the shared library path environment variable for your platform. The following table lists the environment variable for each platform:
Platform | Environment Variable |
---|---|
AIX | LIBPATH |
HP-UX | LD_LIBRARY_PATH |
Solaris | LD_LIBRARY_PATH_64 |
The Oracle Database 10g Companion CD contains additional products that you can install. Whether you need to install these products depends on which Oracle Database products or features that you plan to use. If you plan to use the following products or features, Oracle strongly recommends that you install the products from the Companion CD:
Oracle JVM
Oracle interMedia
Oracle Text
Oracle Workflow
To install Oracle Database 10g products from the Companion CD, follow these steps:
Note: For more detailed installation information, see the Oracle Database Companion CD Installation Guide, which is available on the Companion CD. |
Insert the Oracle Database 10g Companion CD into the disc drive.
If necessary, log into the system as the user who installed Oracle Database (typically the oracle
user).
Enter a command similar to the following to start the Installer:
$ /cdrom/runInstaller
Use the following guidelines to complete the installation:
On the Specify File Locations screen, select the Oracle home name and path for the Oracle Database 10g installation where you want to install the products.
On the Select a Product to Install Screen, select Oracle Database 10g Products.
Unless you want to install Legato Single Server Version, enter 3 at the prompt displayed by the root.sh
script.
Note: For more information about any of the Installer screens, click Help. |