Re: sqlplus wrong?

On Sun, 10 Oct 2004 20:38:33 -0400, "MaoXuePeng" <mxp123q_at_126.com> wrote:

>I am sorry.
>
>The oracle version is ora9.0.1.0.1, OS version is Win2000.
>
>TNS name in tnsnames.ora is:
>TOUCH =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.16.27)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = LBS.CASWSOFT.CASW.COM)
> )
> )
>
>The detail of listener.ora is:
># LISTENER.ORA Network Configuration File:
>E:\oracle\ora90\NETWORK\ADMIN\listener.ora
># Generated by Oracle configuration tools.
>
>LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.16.27)(PORT = 1521))
> )
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.16.45)(PORT = 1521))
> )
> )
>
>SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = E:\oracle\ora90)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = lbs)
> (ORACLE_HOME = E:\oracle\ora90)
> (SID_NAME = lbs)
> )
> )
>
>The last log of listener.log is:
>TNSLSNR for 32-bit Windows: Version 9.0.1.1.1 - Production on
>11-10&#26376;-2004 08:19:42
>
>Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.
>
>param file E:\oracle\ora90\network\admin\listener.ora
>Write in E:\oracle\ora90\network\log\listener.log
>Write in E:\oracle\ora90\network\trace\listener.trc
>
>
>Begin as pid=584
>Listen&#65306;(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
>Listen&#65306;(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.16.27)(PORT=1521)))
>Error occured while listening:
>(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.16.45)(PORT=1521)))
>TNS-12545: No host.
> TNS-12560: TNS: Adapter error.
> TNS-00515: No host.
> 32-bit Windows Error: 49: Unknown error
>Not listen any more:
>(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
>Not listen any more:
>(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.16.27)(PORT=1521)))
>
>Thanks.
>MaoXuePeng.

I know you're trying to provide full information, but for the sake of security, you should have masked your IP address. I was able to paste your tnsnames entry into my tnsnames file and ...

C:\>sqlplus scott/tiger_at_touch

SQL*Plus: Release 9.2.0.1.0 - Production on Mon Oct 11 11:18:15 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:
ORA-12541: TNS:no listener

Hmm. If you listener were up and I corrrectly guessed the often-not-changed password of say SYSTEM or DBSNMP . . . Received on Mon Oct 11 2004 - 11:22:29 CDT