I have an oracle server on my network! I have the client installed on my machine! If I want to connect to the server then I will have to do the following: 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!
Being in the industry for almost two decades, one thing that's been constant is change and my curiosity. I In this fast world of IT...being curious, learning and learning by doing is quintessential :) Here is my way of learning and sharing what I learnt!!! Author: Sirisha Reddy G V