OVERVIEW To make client connection to a database you need to create an Oracle Network Service entry. This will create an appropriate entry in the tnsnames.ora file. This example session uses dbsrv1 as the Oracle DB Server.
PROCEDURE Sun cd /<ORACLE_HOME>/.../bin ./netmgr Windows Start Menu->Programs->Oracle OraHome92->Configuration and Migration Tools->Net Manager Create ShortCut using: C:\oracle\ora92\bin\launch.exe "C:\oracle\ora92\network\tools" ..\network\tools\netmgr.cl
Expand + Local then select Service Naming Select Add (+) button on left. Enter: Service Name: dbsrv1.dev02 Select Protocol: TCP/IP Enter Hostname and Port Number: dbsrv1 1521 Enter Service Name (as it is known on the server): dev02 Select Connection Type: Dedicated Server
Select: Test Exit Oracle Net Mgr and Select Yes to save.
Entry will have been made in the tnsnames.ora
APPENDIX - tnsnames.ora Example Common path to file: C:\<ORACLE_HOME>\network\admin\tnsnames.ora