一个正常的oracle数据库,在一同事用root帐号reboot后,重启后,出现oracle数据库监听出现异常,用netca重建监听后,问题依然没有解决!请oracle高手帮忙看看,在线等待,问题很紧呀!谢谢环境信息:
操作系统:SUSE 9 SP2
数据库:ORACLE 10
SHELL信息:bash
用户群主:user======================以下操作过程中的信息=================================
oracle@linux:~> ls
10201_database_linux32.zip database Documents oraInventory sqlnet.log
bin db_script oracle public_html
oracle@linux:~> lsnrctl statusLSNRCTL for Linux: Version 10.2.0.1.0 - Production on 20-JUN-2009 18:11:25Copyright (c) 1991, 2005, Oracle. All rights reserved.Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
oracle@linux:~> netcaOracle Net Services Configuration:
Configuring Listener:SSEDB
ServiceAliasException: Could not save Service Alias: TNS-04406: Object already e
xists
Default local naming configuration complete.
Listener configuration complete.
Oracle Net Listener Startup:
Running Listener Control:
/home/oracle/oracle/product/10.2.0/db_1/bin/lsnrctl start SSEDB
Listener Control complete.
Listener started successfully.
Oracle Net Services configuration successful. The exit code is 0oracle@linux:~> lsnrctl status ssedbLSNRCTL for Linux: Version 10.2.0.1.0 - Production on 20-JUN-2009 18:11:55Copyright (c) 1991, 2005, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=linux)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias SSEDB
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 20-JUN-2009 18:11:47
Uptime 0 days 0 hr. 0 min. 7 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/oracle/product/10.2.0/db_1/network/admin/
listener.ora
Listener Log File /home/oracle/oracle/product/10.2.0/db_1/network/log/ss
edb.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
oracle@linux:~>=====================以下是操作的日志信息======================
操作系统:SUSE 9 SP2
数据库:ORACLE 10
SHELL信息:bash
用户群主:user======================以下操作过程中的信息=================================
oracle@linux:~> ls
10201_database_linux32.zip database Documents oraInventory sqlnet.log
bin db_script oracle public_html
oracle@linux:~> lsnrctl statusLSNRCTL for Linux: Version 10.2.0.1.0 - Production on 20-JUN-2009 18:11:25Copyright (c) 1991, 2005, Oracle. All rights reserved.Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
oracle@linux:~> netcaOracle Net Services Configuration:
Configuring Listener:SSEDB
ServiceAliasException: Could not save Service Alias: TNS-04406: Object already e
xists
Default local naming configuration complete.
Listener configuration complete.
Oracle Net Listener Startup:
Running Listener Control:
/home/oracle/oracle/product/10.2.0/db_1/bin/lsnrctl start SSEDB
Listener Control complete.
Listener started successfully.
Oracle Net Services configuration successful. The exit code is 0oracle@linux:~> lsnrctl status ssedbLSNRCTL for Linux: Version 10.2.0.1.0 - Production on 20-JUN-2009 18:11:55Copyright (c) 1991, 2005, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=linux)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias SSEDB
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 20-JUN-2009 18:11:47
Uptime 0 days 0 hr. 0 min. 7 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/oracle/product/10.2.0/db_1/network/admin/
listener.ora
Listener Log File /home/oracle/oracle/product/10.2.0/db_1/network/log/ss
edb.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
oracle@linux:~>=====================以下是操作的日志信息======================
Fatal NI connect error 12514, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.168.39.101)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=SSEDB)(CID=(PROGRAM=java@linux)(HOST=linux)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 10.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production
Time: 20-JUN-2009 18:04:49
Tracing not turned on.
Tns error struct:
ns main err code: 12564
TNS-12564: TNS:connection refused
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
***********************************************************************
Fatal NI connect error 12514, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.168.39.101)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=SSEDB)(CID=(PROGRAM=java)(HOST=linux)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 10.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production
Time: 20-JUN-2009 18:04:55
Tracing not turned on.
Tns error struct:
ns main err code: 12564
TNS-12564: TNS:connection refused
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 20-JUN-2009 18:03:54Copyright (c) 1991, 2005, Oracle. All rights reserved.System parameter file is /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /home/oracle/oracle/product/10.2.0/db_1/network/log/ssedb.log
Trace information written to /home/oracle/oracle/product/10.2.0/db_1/network/trace/ssedb.trc
Trace level is currently 0Started with pid=7229
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Listener completed notification to CRS on startTIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
WARNING: Subscription for node down event still pending
20-JUN-2009 18:03:54 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=linux)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=SSEDB)(VERSION=169869568)) * status * 0
WARNING: Subscription for node down event still pending
20-JUN-2009 18:04:16 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=linux)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=ssedb)(VERSION=169869568)) * status * 0
20-JUN-2009 18:04:49 * (CONNECT_DATA=(SERVICE_NAME=SSEDB)(CID=(PROGRAM=java@linux)(HOST=linux)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.168.39.101)(PORT=32849)) * establish * SSEDB * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
20-JUN-2009 18:04:55 * (CONNECT_DATA=(SERVICE_NAME=SSEDB)(CID=(PROGRAM=java)(HOST=linux)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.168.39.101)(PORT=32851)) * establish * SSEDB * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
WARNING: Subscription for node down event still pending
20-JUN-2009 18:05:17 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=linux)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=SSEDB)(VERSION=169869568)) * status * 0
WARNING: Subscription for node down event still pending
20-JUN-2009 18:05:17 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=linux)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=SSEDB)(VERSION=169869568)) * status * 0
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux)(PORT=1521)))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Listener completed notification to CRS on stop
20-JUN-2009 18:05:18 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=linux)(USER=oracle))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=SSEDB)(VERSION=169869568)) * stop * 0TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 20-JUN-2009 18:11:47Copyright (c) 1991, 2005, Oracle. All rights reserved.System parameter file is /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /home/oracle/oracle/product/10.2.0/db_1/network/log/ssedb.log
Trace information written to /home/oracle/oracle/product/10.2.0/db_1/network/trace/ssedb.trc
Trace level is currently 0Started with pid=6766
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Listener completed notification to CRS on startTIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
WARNING: Subscription for node down event still pending
20-JUN-2009 18:11:47 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=linux)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=SSEDB)(VERSION=169869568)) * status * 0
WARNING: Subscription for node down event still pending
20-JUN-2009 18:11:55 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=linux)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=ssedb)(VERSION=169869568)) * status * 0