$ pwd
/oracle/product/9/db_1/network/log

$ ls -l
总计 11848
-rw-r--r--   1 oracle   oinstall    6049792 12月19 2007   listener.log
-rw-r--r--   1 oracle   oinstall        674  6月18 21时33 sqlnet.log
-rw-r--r--   1 oracle   oinstall        418  7月29 2007   start.log
-rw-r--r--   1 oracle   oinstall       1245  7月29 2007   stat.log

$ lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.1.0 - Production on 02-JUL-2008 14:58:59
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=db1_srv)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.1.0 - Production
Start Date                16-NOV-2007 16:48:05
Uptime                    228 days 21 hr. 10 min. 55 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /oracle/product/9/db_1/network/admin/listener.ora
Listener Log File         /oracle/product/9/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.11)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "ora9i" has 1 instance(s).
  Instance "ora9i", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

$ tail -f listener.log
19-DEC-2007 16:53:48 * (CONNECT_DATA=(SID=ora9i)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.11)(PORT=40768)) * establish * ora9i * 0
19-DEC-2007 16:54:13 * (CONNECT_DATA=(SID=ora9i)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.11)(PORT=40771)) * establish * ora9i * 0
19-DEC-2007 16:54:20 * (CONNECT_DATA=(SID=ora9i)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.11)(PORT=40772)) * establish * ora9i * 0
19-DEC-2007 16:54:29 * (CONNECT_DATA=(SID=ora9i)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.11)(PORT=40773)) * establish * ora9i * 0
19-DEC-2007 16:54:36 * (CONNECT_DATA=(SID=ora9i)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.11)(PORT=40774)) * establish * ora9i * 0
19-DEC-2007 16:54:47 * (CONNECT_DATA=(SID=ora9i)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.11)(PORT=40776)) * establish * ora9i * 0
19-DEC-2007 16:58:09 * (CONNECT_DATA=(SID=ora9i)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.11)(PORT=40785)) * establish * ora9i * 0
19-DEC-2007 16:58:09 * (CONNECT_DATA=(SID=ora9i)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.11)(PORT=40786)) * establish * ora9i * 0
19-DEC-2007 16:58:09 * (CONNECT_DATA=(SID=ora9i)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.11)(PORT=40787)) * establish * ora9i * 0
19-DEC-2007 16:59:18 * (CONNECT_DATA=(SID=ora9i)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.11)(PORT=40792)) * establish * ora9i * 0
19-DEC-2007 16:59:27 * (CONNECT_DATA=(SID=ora9i)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.11)(PORT=407^C$

$ lsnrctl set log_status on
LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.1.0 - Production on 02-JUL-2008 14:59:56
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=db1_srv)(PORT=1521)))
LISTENER parameter "log_status" set to ON
The command completed successfully

$sqlplus
SQL*Plus: Release 9.2.0.1.0 - Production on Wed Jul 2 15:03:10 2008
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production


$ tail -f listener.log
19-DEC-2007 16:53:48 * (CONNECT_DATA=(SID=ora9i)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.11)(PORT=40768)) * establish * ora9i * 0
19-DEC-2007 16:54:13 * (CONNECT_DATA=(SID=ora9i)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.11)(PORT=40771)) * establish * ora9i * 0
19-DEC-2007 16:54:20 * (CONNECT_DATA=(SID=ora9i)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.11)(PORT=40772)) * establish * ora9i * 0
19-DEC-2007 16:54:29 * (CONNECT_DATA=(SID=ora9i)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.11)(PORT=40773)) * establish * ora9i * 0
19-DEC-2007 16:54:36 * (CONNECT_DATA=(SID=ora9i)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.11)(PORT=40774)) * establish * ora9i * 0
19-DEC-2007 16:54:47 * (CONNECT_DATA=(SID=ora9i)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.11)(PORT=40776)) * establish * ora9i * 0
19-DEC-2007 16:58:09 * (CONNECT_DATA=(SID=ora9i)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.11)(PORT=40785)) * establish * ora9i * 0
19-DEC-2007 16:58:09 * (CONNECT_DATA=(SID=ora9i)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.11)(PORT=40786)) * establish * ora9i * 0
19-DEC-2007 16:58:09 * (CONNECT_DATA=(SID=ora9i)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.11)(PORT=40787)) * establish * ora9i * 0
19-DEC-2007 16:59:18 * (CONNECT_DATA=(SID=ora9i)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.11)(PORT=40792)) * establish * ora9i * 0
19-DEC-2007 16:59:27 * (CONNECT_DATA=(SID=ora9i)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.11)(PORT=407

重起listener后问题解决.