I am still new with Oracle database.I want to connect client PC to the Oracle database server and retrive the table from Oracle database server and see the table from my client PC using GIS software name ARCVIEW.Did you all familiar with gis software?I have two question.Hostname refer for what?hostname of my pc or hostname for oracle database server?Where i can get the IP name of database server?I want to help my DBA because he forgot the ip number of server. I hope some one can help me
You need to have oracle client installed along with the tnsnames.ora file on your pc. This file should contain an entry of the database you are trying to connect to.
To find the ip address of the server, just do the following on the command line:
the hostname you're asking will be the server name which hosts the database that you are trying to connect to.