- Copy the TNS file from Girish system (He has the server) to your system
- TNS file is located in the following pathsourcedrive:\oracle\ora92\network\admin
- Now connect using Oracle SQL*Plus client using the login credentials
Now you can also find the hostname to be used using the TNS file:
RDBDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = PAR1RDBDB)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = RDB) ))
If the above pasted code is the content of the TNS file then you can connect to the sever using the hostname RDBDB!