Accessing the database instance from a remote machine on the listener port

[Kiran_27]

Hi ,

How do I access the database instance from a remote machine on the listener port using Oracle Client and Toad software.
I am able to connect toad and oracle client but it is showing the following error- ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
Regards
Kiran

[Alexander M. Ermes]

Hi there.
Check your net configuration.
Try to put the server with the database on it in the hosts file on your system, where you try to connect to the database.
Then start the net config assistant to check your settings. There is a step in the net config, where you can check the connection.
Setup the user and password to whatever you need and test the connection. Another way is the tnsping of the database.

tnsping $ORACLE_SID

Rgds
Alexander M. Ermes

[Indira Aramandla · Accepted solution]

Hi Kiran,

On the remote machine where you have Oracle client installed did you complete the Net configuration.

If you did then you will see the file tnsnames. ora file in the $ORACLE_HOME/netwrok/admin/ directory (Eg: if the remote machine was your PC and you installed Oracle clinet on your C drive in C:\oracle directory then tnsnames file will be located at C:\oracle\network\admin\tnsnames.ora. Adn this file should have the following entry.

host_sid.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))
)
(CONNECT_DATA =
(SID = )
(SERVER = DEDICATED)
)
)

Here the host is the server name on whoch the oracle database is, sid_name is the database name.
The above is all for the clinet side. Then on the other server where the database is physically located make sure the listener is runing. Similar to the above you will have the tnsnames.ora and listener.ora files located in $TNS_ADMIN directory and make sure the listener is runing by lsntctl status commnad.

If all is done as above then the simple test to see if you can connect to the database from the remote machine, is at the command prompt type tnsping where name is the name that you specisied in the tnsnames.ora file on the client side.

Then you can logon to the database using TOAD.

I hope this helps.

Indira A