Re: sqlplus wrong?

From: MaoXuePeng <mxp123q_at_126.com>
Date: Sun, 10 Oct 2004 22:59:15 -0400
Message-ID: <30d35ecb7cb008d7d982fbf38d7ac1b4@localhost.talkaboutdatabases.com>

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

Received on Sun Oct 10 2004 - 21:59:15 CDT