Re: sqlplus wrong?

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月-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：(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) Listen：(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. Received on Sun Oct 10 2004 - 19:38:33 CDT