Install Oracle Database Client

Install Oracle Database 23ai Client x64 (version 23.0.0.0.0 or later).

Note: Only the 64-bit version is supported.

To download the Oracle Database, refer to Oracle Support. To install the Oracle Database, a service contract with Oracle is required.

To run the installation procedure, select Runtime and follow the instructions in the installer.

To copy SQL*Net files

Copy your tnsnames.ora and sqlnet.ora files from the database server to <Oracle Instance Home>\ network\admin.

Note: Adding the files is recommended and not overwriting the files.

To edit TNSNAMES.ORA

In environments with a single application server and multiple database servers, the tnsnames.ora file is updated to include alias definitions for all databases. The alias entries from the database servers are combined into a single tnsnames.ora file.

Copy the alias from the other database server tnsnames.ora files and include them in the database server.

For example:

1. Login in to DatabaseServer1 (for example a production database server).

2. Open the tnsnames.ora file on the database server.

3. Locate the alias entry that starts with ERMPRODDB, and copy the include with the next eight lines.

4. On the application server, open the tnsnames.ora file and paste the copied alias entry into the file.

5. Repeat steps 2-4 for any additional database servers.

6. After all required aliases are added, the tnsnames.ora file on the application server contains entries for all configured databases. The tnsnames.ora file is as follows:

ERMTESTDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = testdatabaseserver.aveva.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XEPDB1)
)
)

ERMPRODDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = proddatabaseserver.aveva.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XEPDB1)
)
)

To edit SQLNET.ORA

Edit the <Oracle Home>\Network\Admin\SQLNET.ORA file and to comment out add a # before the following line:

SQLNET.AUTHENTICATION_SERVICES = (NTS)

Ensure the order of the NAMES.DIRECTORY_PATH is so that TNSNAMES is the first:

NAMES.DIRECTORY_PATH = (TNSNAMES, HOSTNAME)

To set TNS_ADMIN / ORACLE_HOME Environment Variable

If a single Oracle Client installation is performed, then it is not required to set the environment variable.

If multiple instances of Oracle Client are installed, set one of the two following environment variables:

• TNS_ADMIN: The path to the tnsnames.ora file to use, e.g. c:\app\client\product\19.0.0\client_1\network\admin

• ORACLE_HOME: The path to Oracle Home to use, e.g. c:\app\client\product\19.0.0\client_1