Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Net Assistant test ok, but command line login does not work. connectivity problems

Re: Net Assistant test ok, but command line login does not work. connectivity problems

From: Trifon Anguelov <trifona_at_pacbell.net>
Date: Fri, 28 Sep 2001 23:31:53 +0000
Message-ID: <3BB50869.F1980E7A@pacbell.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US