sqlplus windows-2000 - configuration help needed

[derekludwig]

Have a co-worker trying to run sqlplus from windows-2000 in order to connect to a database on a Solaris system. The tnsnames.ora contains:

FRED =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = name)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = fredb )
(SID_NAME = fredb )
)
)

She enters her username, password, and is using FRED for the host string. The error generated is:

ORA-12154: TNS:could not resolve service name

As this is outside my expertise, I figured all you oracle experts have seen this before, and can tell me what to tell her, so I can look like the professional I am [not ].



----------------
Derek Ludwig
derek<at>ludwig.com

 

[mpramods]

Maybe u want to try some solutions from the following thread.

http://www.orafaq.com/msgboard/sqlnet/messages/2544.htm

Thanks,
Pramod

 

[SantaMufasa]

Derek,

Have you resolved this issue yet?

Can you successfully connect to "fredb" from any remote client? If so, how does your friend's Windows2000 environment differ from the successfully connecting remote client?

Mufasa
(aka Dave of Sandy, Utah, USA @ 08:20 (07Mar04) UTC (aka "GMT" and "Zulu"), 01:20 (07Mar04) Mountain Time)