Setting Oracle Client

(1) Installation procedure

For details about how to install Oracle Client, see the Oracle website and corresponding Oracle manuals.

(2) Setting up the environment

This section describes how to set up an Oracle client.

Set up the client as follows:

ORACLE_HOME

If you intend to use Oracle Client, specify the home directory for Oracle software.

LD_LIBRARY_PATH

Specify the Oracle software library directory.

For AIX, specify LIBPATH as the directory. For HP-UX, specify SHLIB_PATH as the directory.

Specify $ORACLE_HOME/lib.

NLS_LANG

Specify the character encoding of the installation environment.

Table 8.3 NLS_LANG Settings

Language	Encoding	NLS_LANG
Japanese version	EUC	JAPANESE_JAPAN.JA16EUC
	SHIFT-JIS	JAPANESE_JAPAN.JA16SJIS (*1)
	UTF-8	JAPANESE_JAPAN.AL32UTF8
English version	-	AMERICAN_AMERICA.AL32UTF8（*2）

*1	:	If the character encoding of the database is Unicode, specify JAPANESE_JAPAN.JA16SJISTILDE.
*2	:	To use data that includes Japanese, specify a value as if you were using the Japanese version.

TNS_ADMIN (required only if using TNS connection)

Specify the tnsnames.ora directory in which the net service name is described. If you omit this setting and attempt to establish a TNS connection, tnsnames.ora in $ORACLE_HOME/network/admin is used.

(3) Using a net service name to connect

To connect using a net service name described in the local naming parameter file (tnsnames.ora), you must specify the environment variable TNS_ADMIN or ORACLE_HOME. For details about how to configure the environment variables, see (2) Setting up the environment in Setting Oracle Client.

Also make sure that the local naming parameter file (tnsnames.ora) exists in the directory where you set the environment variable.

Use the Database Connection - Detailed Information screen of DataMagic to specify the net service name used for the connection.

1. Setting Database Connection - Detailed Information screen of DataMagic.

Enter or select the following items.

Product type

: Select Oracle.

Database name

: Select TNS.

TNS

: The net service name used to connect.

TNS (Browse button)

: Displays the Select TNS screen.

This screen displays the net service names written in the local naming parameter file tnsnames.ora. Select the net service name used to connect from this screen, and then click the OK button.

User ID

: Enter the user ID.

Password

: Enter the password.

Screen 8.3 Database Connection - Detailed Information screen

Screen 8.4 Select TNS