Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
Go to solution
Kiran_27
Advisor

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

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
2 REPLIES
Alexander M. Ermes
Honored Contributor

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

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
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
Indira Aramandla
Honored Contributor
Solution

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

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
Never give up, Keep Trying