Re: sqlplus wrong?

From: Hans Forbrich <news.hans_at_telus.net>
Date: Mon, 11 Oct 2004 01:43:56 GMT
Message-ID: <wzlad.16347$663.16204@edtnps84>

MaoXuePeng wrote:

> Sorry. There is another servername in tnsnames.ora:
>
> LBS2 =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.16.45)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = lbs2.casw)
> )
> )

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 Received on Sun Oct 10 2004 - 20:43:56 CDT