Oracle tnsnames.ora

[Simon Wickham_6]

Sorry just one quick thing first try to set the ip address and host name of the servers in the /etc/hosts file of your client.

Regard,
Simon

[Frank de Vries]

I would check two variables are set and
if yes what are the values ?
TNS_ADMIN
and
TWO_TASK

Because if you run sqlplus /nolog
or connect / as sysdba you should
not use NET8 as the / implies
a local connect.
A remote connect would be like this
system/passwd@ORASERV.TEST01

So you get the ORA-12545 on a local
connect implies something else like
TWO_TASK is set wrong or something.



Regards,
Frank

[Eric Antunes]

Hi Kalin,

Lanch SQL*Net Easy Configuration (it is normally installed with SQL*Plus) to configure the local (in the client) tnsnames.ora.

Best Regards,

Eric Antunes

[Eric Antunes]

In the SQL*Net Easy configuration, create 2 TNS aliases, one with the host name and another with the host IP: if only the IP works it is because your client is in a different subnet than the database server...

Best Regards,

Eric Antunes

[renarios]

The Oracle SID and domain do not compare to what's in the sqlnet.ora

Please try the following:
tnsping ORASERV.TEST01. Does that work?

Lookup in your sqlnet.ora what the value of your default_domain is (i.e. WORLD) and use that in your Oracle name. Thus, change 'ORASERV.TEST01 =' to TEST01.WORLD.

Check also that you can ping your oracle server (ping oraserv).

If you checked the above, you can also tnsping TEST01 and start an sqlplus session to it.

Please give some feedback, so we can help you out.

Cheers,

Renarios

[Yogeeraj_1]

hi kalin,

just for a test, can you try to connect as:

sqlplus
scott/tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oraserv)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=test01)))

(nb. if you don't have the scott schema, you can always substitute accordinlgy)

thanks

kind regards
yogeeraj