Solution to the Problem of enabling Oracle11g database listening in Linux

Solution to oracle 11g database listening in Linux: ORACLE_HOME =/home/oracle/product/11.2.0/db_1ORACLE_HOME/network/admin/listener. the ora file is as follows: [plain] # listener. ora Network Configuration File:/home/oracle/product/11.2.0/db_1/network/admin/listener. ora # Generated by Oracle configuration tools. www.2cto.com SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = sqtest) (ORACLE_HOME =/home/oracle/ Oracle/product/11.2.0/db_1) (SID_NAME = sqtest) LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = drum) (PORT = 1521 ))) ADR_BASE_LISTENER =/home/oracle ORACLE_HOME/network/admin/tnsnames. the ora file is as follows: [plain] # tnsnames. ora Network Configuration File:/home/oracle/product/11.2.0/db_1/network/admin/tnsnames. ora # Generated by Oracle configuration tools. www.2cto.com sqltest = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521) (CONNECT_DATA = (SID = sqtest ))) run lsnrctl start. The result is as follows: [plain] TNSLSNR for Linux: version 11.2.0.1.0-Production System parameter file is/home/oracle/product/11.2.0/db_1/network/admin/listener. ora Log messages written to/home/oracle/diag/tnslsnr/drum/listener/alert/log. xml Listening on: (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = drum.smartquick.com.cn) (PORT = 1521) Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = drum) (PORT = 1521) STATUS of the LISTENER www.2cto.com ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0-Production Start Date 27-JUL-2012 14:48:11 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authen Tication snmp off Listener Parameter File/home/oracle/product/11.2.0/db_1/network/admin/listener. ora Listener Log File/home/oracle/diag/tnslsnr/drum/listener/alert/log. xml Listening Endpoints Summary... (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = drum.smartquick.com.cn) (PORT = 1521) Services Summary... service "sqtest" has 1 instance (s ). instance "sqtest", status UNKNOWN, has 1 handl Er (s) for this service... the command completed successfully: run The following command under sqlplus to fix instance registration: sqlplus/as sysdba www.2cto.com startupalter system register; then run The lsnrctl status command to display The following information: [plain] LSNRCTL for Linux: version 11.2.0.1.0-Production on 27-JUL-2012 14:53:28 Copyright (c) 1991,200 9, Oracle. all rights reserved. connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = drum) (PORT = 1521) STATUS of the L ISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0-Production Start Date 27-JUL-2012 14:48:11 Uptime 0 days 0 hr. 5 min. 17 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File/home/oracle/product/11.2.0/db_1/network/admin/listener. ora Listener Log File/home/oracle/diag/tnslsnr/drum/listener/alert/log. Xml www.2cto.com Listening 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, ha S 1 handler (s) for this service... The command completed successfully found that The database instance has registered The listener successfully. The shutdownexit command is executed on the system command line under www.2cto.com sqlplus and the lsnrctl stop author whyonly