|Oracle® Database Client Installation Guide
11g Release 1 (11.1) for AIX Based Systems
|PDF · Mobi · ePub|
This chapter describes how to complete postinstallation tasks after you have installed the software. It includes information about the following topics:
You must perform the tasks listed in the "Required Postinstallation Tasks" section. Oracle recommends that you perform the tasks listed in the "Recommended Postinstallation Tasks" section after all installations.
If you install and intend to use any of the products listed in the "Required Product-Specific Postinstallation Tasks" section, then you must perform the tasks listed in the product-specific subsections.
Note:This chapter describes basic configuration only. Refer to Oracle Database Administrator's Reference for Linux and UNIX, Oracle Database Administrator's Guide and product-specific administration and tuning guides for more detailed configuration and tuning information.
You must perform the tasks described in the following sections after completing an installation:
Check the My Oracle Support (formerly OracleMetaLink) Web site for required patches for the installation.
To download required patches:
Use a Web browser to view My Oracle Support (formerly OracleMetaLink) Web site:
Log in to My Oracle Support (formerly OracleMetaLink).
Note:If you are not an My Oracle Support (formerly OracleMetaLink) registered user, click Register Here and follow the registration instructions.
On the main My Oracle Support (formerly OracleMetaLink) page, click Patches and Updates.
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.
Find the latest patch set for Oracle Database using Oracle Support (formerly OracleMetaLink).
From the list of available patches, select a patch to download.
Patch sets for Oracle databases are identified as x.x.x PATCH SET FOR ORACLE DATABASE SERVER.
Review the README file before proceeding with the download.
Each patch has a README file with installation requirements and instructions. Some patches install with Oracle Universal Installer; others require special procedures. Oracle recommends that you always read the README file before proceeding.
Download and install the patch.
Download Instant Client from Oracle Technology Network
If you want to place the files in the existing directory, then ensure that the directory is empty.
If you want to place the files into a different directory (and remove the previous files), ensure that you update the
PATH environment variable setting to reflect the new location.
Note:A restriction on using Instant Client or Instant Client Light is that you cannot perform patch upgrades on it using the
opatchutility. The reason is that the Instant Client installation does not create an inventory, which the patch upgrade process needs in order to perform. The absence of an inventory also means that installed intern patch reporting and conflict detection before a patch attempt are not possible.
If you installed the Instant Client installation type, you can configure users' environments to enable dynamically linked client applications to connect to a database as follows:
Set the appropriate shared library path environment variable for the platform to specify the directory that contains the Instant Client libraries. For the Instant Client installation type, this directory is the Oracle home directory that you specified during the installation, for example:
Use one of the following methods to specify database connection information for the client application:
Specify a SQL connect URL string using the following format:
TNS_ADMIN environment variable to specify the location of the
tnsnames.ora file and specify a service name from that file.
TNS_ADMIN environment variable and set the
TWO_TASK environment variable to specify a service name from the
Note:You do not have to specify the
Oracle recommends that you perform the tasks described in the following section after completing an installation:
When you install Instant Client, the Instant Client libraries are installed under the
ORACLE_HOME directory and the Instant Client Light specific library is installed under the
/light directory. To configure Instant Client Light, you must replace the
so file with the
After replacing the library file, you must set the
LD_LIBRARY_PATH environment variable to point to the location of the Instant Client shared library files.
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 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
Before you can connect Instant Client (including Instant Client Light) to an Oracle database, make sure that the
LD_LIBRARY_PATH environment variable specifies the directory that contains the Instant Client libraries. This directory is the
ORACLE_HOME directory that you specified during installation.
For example, the shared libraries for Instant Client or Instant Client Light (if you have configured Instant Client Light), are in:
After you have checked the
LD_LIBRARY_PATH environment variable, you can use any of the following methods to specify Oracle Database connection information for client applications:
You can specify a connection address to an Oracle Database directly from a client application, without having to configure a
tnsnames setting for the Instant Client. This method is convenient in that you do not have to create and manage a
tnsnames.ora file. However, the application users will need to specify the host name and port number when they want to log in to the application.
For example, you run SQL*Plus on the client computer and want to connect to the
sales_us database, which is located on a server whose host name is
shobeen and port number is
1521, then you can log in as follows:
Enter user-name: system@admin@//shobeen:1521/sales_us
Similarly, in the application code, you can use Oracle Call Interface net naming methods to create the Instant Client-to-Oracle Database connection. For example, the following formats in the
OCIServerAttach() call specify the connection information:
Specify a SQL connect URL string using the following format:
Alternatively, you can specify the SQL connect information as an Oracle Net keyword-value pair. For example:
"(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=shobeen) (PORT=1521))(CONNECT_DATA=(SERVICE_NAME=sales_us)))"
See Also:Oracle Call Interface Programmer's Guide for more information on using Oracle Call Interface Instant Client
By default, when you install Instant Client, Oracle Universal Installer does not include a sample
tnsnames.ora file nor the Oracle Net Configuration Assistant utility normally used to create it. However, if you want to shield users from having to specify actual host names and port numbers, you may want to consider using a
tnsnames.ora file to set the Client-to-Oracle Database connection.
You can create the
tnsnames.ora file manually by copying and modifying a version of this file from another Oracle installation, or you can use Oracle Net Configuration Assistant to create and manage it for you.
Run Oracle Universal Installer.
Select the Custom installation type.
In the Summary screen, click Install, then click Exit and Yes to exit Oracle Universal Installer.
On each client computer, configure either of the following settings:
tnsnames.ora file in the
/network/admin directory, and make sure that the
ORACLE_HOME environment has been set to this Oracle home.
See Also:Oracle Call Interface Programmer's Guide for more information on Oracle Call Interface Instant Client connection strings
A direct address, as described under "Specifying a Connection by Using the Easy Connect Naming Method"
Oracle Net keyword-value pair
tnsnames.ora entry and
TNS_ADMIN is set to the location of
tnsnames.ora entry and the following:
tnsnames.ora file located in
ORACLE_HOME environment variable set to this Oracle home
This method allows the applications to specify internally a connection string if the application code itself uses an empty connection string. The benefit of an empty connect string is that the application itself does not need to specify the
tnsnames.ora entry. Instead, when a user invokes the application, the location of the database is determined by a script or the environment, depending on where you have set the
TWO_TASK environment variable. The disadvantage of using empty strings is that you need to configure this additional information in order for the application to connect to the database.
For information about setting up additional user accounts, refer to Oracle Database Administrator's Reference for Linux and UNIX.
NLS_LANG is an environment variable that specifies the locale behavior for Oracle software. This variable sets the language and territory used by the client application and the database server. It also declares the character set of the client, which is the character set of data entered or displayed by an Oracle client program, such as SQL*Plus.
See Also:Appendix B, "Configuring Oracle Database Globalization Support" for more information about the
Note:The character set of the data displayed is determined by the environment of the operating system, such as keyboard driver and fonts in use. The
NLS_LANGcharacter set should match the operating system.
The client static library (
libclntst11.a) is not generated during installation. If you want to link the applications to the client static library, you must first generate it as follows:
Switch user to
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=/u01/app/oracle/product/11.1.0/db_1 $ export ORACLE_HOME
% setenv ORACLE_HOME /u01/app/oracle/product/11.1.0/db_1
Enter the following command:
The following sections describe platform-specific postinstallation tasks that you must perform if you install and intend to use the products mentioned:
Note:You need only perform postinstallation tasks for products that you intend to use.
If you have an earlier release of Oracle software installed on this system, you might want to copy information from the Oracle Net
listener.ora configuration files from the earlier release to the corresponding files for the new release.
If necessary, you can also add connection information for additional database instances to the new file.
This section describes postinstallation tasks for Oracle precompilers:
Note:All precompiler configuration files are located in the
Verify that the
PATH environment variable setting includes the directory that contains the C compiler executable.
Table 4-1 shows the default directories and the appropriate command to verify the path setting of the compiler.
Verify that the PATH environment variable setting includes the directory that contains the FORTRAN compiler executable. You can verify the path setting by using the
which xlf command. .