Re: sqlplus wrong?

From: ats <damorgan_at_x.washington.edu>
Date: Sun, 10 Oct 2004 20:44:49 -0700
Message-ID: <1097466242.42137@yasure>

MaoXuePeng wrote:

>>Whether lbs or lbs2 or lbs2.casw ... Why do you think a   
>>listener 
>>connecting to lbs should connect to lbs.caswsoft.casw.com?

>
>
> I am sorry, I was confused now.
>
>

>>Check out your SQLNET.ORA and get your naming straight.

>
>
> The SQLNET.ORA is:
>
> # SQLNET.ORA Network Configuration File:
> E:\oracle\ora90\network\admin\sqlnet.ora
> # Generated by Oracle configuration tools.
>
> NAMES.DEFAULT_DOMAIN = caswsoft.casw.com
>
> SQLNET.AUTHENTICATION_SERVICES= (NTS)
>
> NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
>
> ==================================================
>
>

>>The next step is to show us the SQLPLus command with the > real

>
> servername
>

>>that you are using, and the actual error message.  A 
>>copy/paste of the
>>session would be the best (you can blank out the password)

>
>

>>For example, 

>
>

>>sqlplus scott/tiger_at_lbs2

>
>
> The SQLPLUS command is: sqlplus navi/*****@lbs2
> And the error is: ORA-12535: TNS: timed out
>
> --
> Thanks.
> MaoXuePeng.

Rename SQLNET.ORA to SQLNET.XXX and make the lbs?% names match.

Daniel Morgan Received on Sun Oct 10 2004 - 22:44:49 CDT