Solution to Oracle 11g Database listening in Linux

Installation environment:

Oracle_HOME =/home/oracle/product/11.2.0/db_1

The ORACLE_HOME/network/admin/listener. ora file is as follows:

1. # Listener. ora Network Configuration File:/home/oracle/product/11.2.0/db_1/network/admin/listener. ora
2. # Generated by Oracle configuration tools.
4. SID_LIST_LISTENER =
5. (SID_LIST =
6. (SID_DESC =
7. (GLOBAL_DBNAME = sqtest)
8. (ORACLE_HOME =/home/oracle/product/11.2.0/db_1)
9. (SID_NAME = sqtest)
10. )
11. )
14. LISTENER =
15. (DESCRIPTION =
16. (ADDRESS = (PROTOCOL = TCP) (HOST = drum) (PORT = 1521 ))
17. )
19. ADR_BASE_LISTENER =/home/oracle

The ORACLE_HOME/network/admin/tnsnames. ora file is as follows:

1. # Tnsnames. ora Network Configuration File:/home/oracle/product/11.2.0/db_1/network/admin/tnsnames. ora
2. # Generated by Oracle configuration tools.
4. Sqltest =
5. (DESCRIPTION =
6. (ADDRESS_LIST =
7. (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521 ))
8. )
9. (CONNECT_DATA =
10. (SID = sqtest)
11. )
12. )

Run lsnrctl start. The result is as follows:

1. TNSLSNR for Linux: Version 11.2.0.1.0-Production
2. System parameter file is/home/oracle/product/11.2.0/db_1/network/admin/listener. ora
3. Log messages written to/home/oracle/diag/tnslsnr/drum/listener/alert/log. xml
4. Listening on: (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = drum.smartquick.com.cn) (PORT = 1521 )))
6. Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = drum) (PORT = 1521 )))
7. STATUS of the LISTENER
8. ------------------------
9. Alias LISTENER
10. Version TNSLSNR for Linux: Version 11.2.0.1.0-Production
11. Start Date 27-JUL-2012 14:48:11
12. Uptime 0 days 0 hr. 0 min. 0 sec
13. Trace Level off
14. Security ON: Local OS Authentication
15. SNMP OFF
16. Listener Parameter File/home/oracle/product/11.2.0/db_1/network/admin/listener. ora
17. Listener Log File/home/oracle/diag/tnslsnr/drum/listener/alert/log. xml
18. Listening Endpoints Summary...
19. (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = drum.smartquick.com.cn) (PORT = 1521 )))
20. Services Summary...
21. Service "sqtest" has 1 instance (s ).
22. Instance "sqtest", status UNKNOWN, has 1 handler (s) for this service...
23. The command completed successfully

Run the following command under sqlplus to fix the registered instance,

Sqlplus/as sysdba

Startup

Alter system register;

Then run the lsnrctl status Command to display the following information:

1. LSNRCTL for Linux: Version 11.2.0.1.0-Production on 27-JUL-2012 14:53:28
3. Copyright (c) 1991,200 9, Oracle. All rights reserved.
5. Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = drum) (PORT = 1521 )))
6. STATUS of the LISTENER
7. ------------------------
8. Alias LISTENER
9. Version TNSLSNR for Linux: Version 11.2.0.1.0-Production
10. Start Date 27-JUL-2012 14:48:11
11. Uptime 0 days 0 hr. 5 min. 17 sec
12. Trace Level off
13. Security ON: Local OS Authentication
14. SNMP OFF
15. Listener Parameter File/home/oracle/product/11.2.0/db_1/network/admin/listener. ora
16. Listener Log File/home/oracle/diag/tnslsnr/drum/listener/alert/log. xml
17. Listening Endpoints Summary...
18. (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = drum.smartquick.com.cn) (PORT = 1521 )))
19. Services Summary...
20. Service "sqtest" has 2 instance (s ).
21. Instance "sqtest", status UNKNOWN, has 1 handler (s) for this service...
22. Instance "sqtest", status READY, has 1 handler (s) for this service...
23. Service "sqtestXDB" has 1 instance (s ).
24. Instance "sqtest", status READY, has 1 handler (s) for this service...
25. The command completed successfully

The database instance has been successfully registered for the listener.

To disable the service, follow these steps:

Run SQL plus

Shutdown

Exit

Execute in the system command line

Lsnrctl stop