5. Client Configuration

5.1 Windows Clients

SQL*Net configuration on the PC using newer versions of the Oracle Client Software is very easy. The best (and easiest) way of achiving a fully working client installation is to use the SQL*Net Easy Configuration tool supplied by Oracle.

This toolhas a wizard type interface to take you through the installation of the tnsnames.ora and sqlnet.ora files.

Select "Add Database Alias" and enter a name for the alias when prompted. This alias is the name you will refer to the database instance as, and as such should be the same as the instance name (orcl in this case).

Select TCP/IP as the protocol, and when prompted the hostname of the machine hosting the database and the instance name of the database.

That's it.

However, if you do not have the SQL*Net Easy Configuration Tool then don't worry. You can simply create the tnsnames.ora and the sqlnet.ora files in the $ORACLE_HOME/network/admin directory on the client exactly as they are on the server. This will provide an alias the same as on the server (always a good idea anyway).

5.2 Unix Clients

UNIX clients are not very different that windows clients. If you have the Network Manager from Oracle then user that in the same way as above, if not then you can, again, just use the same configuration files as the server in the $ORACLE_HOME/network/admin directory.