Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!logbridge.uoregon.edu!newsfeed.stanford.edu!sn-xit-03!sn-xit-11!sn-xit-08!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: ats <damorgan@x.washington.edu>
Newsgroups: comp.databases.oracle.server
Subject: Re: sqlplus wrong?
Date: Sun, 10 Oct 2004 20:44:49 -0700
Organization: Ye 'Ol Disorganized NNTPCache groupie
Message-ID: <1097466242.42137@yasure>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax)
X-Accept-Language: en-us, en
MIME-Version: 1.0
References: <ed27a04563ef7b7e00169ac63003f148@localhost.talkaboutdatabases.com> <1097431501.944251@yasure> <072cd16965ffb6737dda717c16787e19@localhost.talkaboutdatabases.com> <1097460514.215419@yasure> <30d35ecb7cb008d7d982fbf38d7ac1b4@localhost.talkaboutdatabases.com>
In-Reply-To: <30d35ecb7cb008d7d982fbf38d7ac1b4@localhost.talkaboutdatabases.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Cache-Post-Path: yasure!unknown@oracle.advtechserv.com
X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/)
X-Complaints-To: abuse@supernews.com
Lines: 52
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:226682

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@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