本帖最后由 244159303 于 2013-3-27 15:49 编辑
配置监听报错,寻解决方案:
26-MAR-2013 17:55:12 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=fh)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * status * 0
26-MAR-2013 17:58:15 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=fh)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * status * 0
26-MAR-2013 17:58:25 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=fh)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * status * 0
配置方法如下:
1、listener.ora配置内容如下:
$ more listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = fh)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(SID_NAME = fh)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.0.5)(PORT = 1521))
)
________________________________________________________________________
$ more tnsnames.ora
TEST1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.0.5)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = fh)
)
)
——————————————————————————————————————————————
2、启动后查看状态:status UNKNOWN
$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 27-MAR-2013 09:47:16
Copyright (c) 1991, 2007, Oracle.All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias
LISTENER
Version
TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date
27-MAR-2013 09:46:19
Uptime
0 days 0 hr. 0 min. 57 sec
Trace Level
off
Security
ON: Local OS Authentication
SNMP
OFF
Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "fh" has 1 instance(s).
Instance "fh", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
——————————————————————————————————————————————————————————
3、报错日志:
[oracle@fohow admin]$ tail -f /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Trace information written to /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
Trace level is currently 0
Started with pid=9766
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.0.5)(PORT=1521)))
Listener completed notification to CRS on start
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
26-MAR-2013 17:55:12 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=fh)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * status * 0
26-MAR-2013 17:58:15 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=fh)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * status * 0
26-MAR-2013 17:58:25 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=fh)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * status * 0