Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Net Assistant test ok, but command line login does not work. connectivity problems
simon gu wrote:
> Net Assistant test ok, but command line login does not work.
> connectivity problems
>
> hi, gurus,
>
> I could install ora817 client on win2000 pro. Using Net8 assistant, I
> could setupa servicing name, and test it just ok.
>
> however, it does not work on command line: sqlplus scott/tiger_at_o3. The
> Error is ORA_12154: TNS could not resolve service name.
>
> and also sqlplus will not connect to the servrer, using scott/tiger,
> host_string: o3. the same error message.
>
> The related 2 .ora files are print in part for refereces.
>
> please offer your suggestions and any hints. thanks in advance.
>
> tnsnames.ora --------------
> O3 =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = goldfinger)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = o3)
> )
> )
>
> sqlnet.ora-----------------------------------
> SQLNET.ORA Network Configuration File:
> C:\oracle\ora81\network\admin\sqlnet.ora
> # Generated by Oracle configuration tools.
>
> SQLNET.AUTHENTICATION_SERVICES= (NTS)
>
> NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
Simon,
in sqlnet.ora set up:
SQLNET.DEFAULT_DOMAIN = WORLD in tnsnames.ora change:
O3 to O3.WORLD
from the MS-DOS prompt check : C:\> tnsping O3
Hope that helps.
Trifon Anguelov
Senior Oracle DBA
www.dbaclick.com Received on Fri Sep 28 2001 - 18:31:53 CDT