Newbie Question (9i)

[Arda]

Hi fellows. I'm having the following problem and would like to have your advice on how to see through it. TNSNAMES.ORA Follows

*******************************
EXTPROC_CONNECTION_DATA.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(CONNECT_DATA = (SID = EXTPROC))
)

TCP-LOOPBACK.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA = (SID = ))
)

BASE1.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.5)(PORT = 1521))
(CONNECT_DATA = (SID = BASE1))
)
***************************
Now if I tnsping80 either base1 or base1.world from my workstation I get the following answer:

Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.5)(PORT=1521))
OK (170 msec)

Which would be correct.

Whereas if I tnsping base1 from server I get this error:

Used parameter files:
/u01/app/oracle/product/9.2.0.1.0/network/admin/sqlnet.ora
/u01/app/oracle/product/9.2.0.1.0/network/admin/tnsnames.ora

TNS-03505: Failed to resolve name

On the other hand base1.world pings correctly from server.

My question would be: Why can't I tnsping base1 from server and only base1.world whereas both can be pinged from workstation. Also issuing a "sqlplus system@base1/manager" from server ends in the same error.

Thanks in advance, and Best Regards.

[marist89]

I'd look at your default domain in the sqlnet.ora on the server.

[Arda]

Thanks Marist.
What should it read, so that I can connect using SID as well?

[badrinathn]

Oracle Network Administrators Guide