Linux下启动Oracle11g数据库监听问题的解决

安装环境：

ORACLE_HOME = /home/oracle/oracle/product/11.2.0/db_1

ORACLE_HOME/network/admin/listener.ora文件如下：

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 27-JUL-2012 14:53:28Copyright (c) 1991, 2009, Oracle.  All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=drum)(PORT=1521)))STATUS of the LISTENER------------------------Alias                     LISTENERVersion                   TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionStart Date                27-JUL-2012 14:48:11Uptime                    0 days 0 hr. 5 min. 17 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Parameter File   /home/oracle/oracle/product/11.2.0/db_1/network/admin/listener.oraListener Log File         /home/oracle/oracle/diag/tnslsnr/drum/listener/alert/log.xmlListening Endpoints Summary...  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=drum.smartquick.com.cn)(PORT=1521)))Services Summary...Service "sqtest" has 2 instance(s).  Instance "sqtest", status UNKNOWN, has 1 handler(s) for this service...  Instance "sqtest", status READY, has 1 handler(s) for this service...Service "sqtestXDB" has 1 instance(s).  Instance "sqtest", status READY, has 1 handler(s) for this service...The command completed successfully

关闭的步骤如下：

sqlplus下执行

shutdown

exit

在系统命令行执行

lsnrctl stop