Oracle tnsnames configuration

Usually the file is located under:

C:\oracle\tns_admin\tnsnames.ora

You can add an entry like this:

<myapp> = (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<ipaddress>)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(service_name=<myapp_servicename>)))

If everything is ok you can try to test the connection

Issuing a ping

tnsping myapp

or login as user

sqlplus myuser@myapp

or login as sysdba

sqlplus sys@myapp as sysdba

Leave a comment

Your email address will not be published. Required fields are marked *