Re: sqlplus wrong?

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sun, 10 Oct 2004 19:07:10 -0700
Message-ID: <1097460514.215419@yasure>

First

> TNS name in tnsnames.ora is:
> (CONNECT_DATA =
> (SERVICE_NAME = LBS.CASWSOFT.CASW.COM)
Then

> (SID_DESC =
> (GLOBAL_DBNAME = lbs)
> (ORACLE_HOME = E:\oracle\ora90)
> (SID_NAME = lbs)
> )
>
> Thanks.
> MaoXuePeng.

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

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

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Sun Oct 10 2004 - 21:07:10 CDT