Setting up Oracle on the application server

After you create a database, set the character sets, created the table spaces, transaction logs, and database schema users, you are ready to install Oracle client on the application server.

About this task

The file tnsnames.ora can be found in the $ORACLE_HOME/network/admin directory. Check connectivity between the application server and database server by using tnsping or SQLPlus on the application server.

Procedure

Install Oracle client on the application server.

Make sure that you have an entry of the database in tnsnames.ora file on the application server where the Oracle client is installed.