Oracle 创建非1521端口监听

现有的监听文件配置

点击(此处)折叠或打开

1. [oracle@test-db admin]$ cat listener.ora
   
2. # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
   
3. # Generated by Oracle configuration tools.
   
4. 
   
5. LISTENER =
   
6.   (DESCRIPTION_LIST =
   
7.     (DESCRIPTION =
   
8.       (ADDRESS = (PROTOCOL = TCP)(HOST = test-db)(PORT = 1521))
   
9.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
   
10.     )
    
11.   )
    
12. 
    
13. ADR_BASE_LISTENER = /u01/app/oracle
    
14. 
    
15. 
    
16. 
    
17. SID_LIST_LISTENER =
    
18.   (SID_LIST =
    
19.     (SID_DESC =
    
20.       (GLOBAL_DBNAME=orcl)
    
21.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    
22.      (SID_NAME = orcl)
    
23.     )
    
24.   )

目前的监听状态

点击(此处)折叠或打开

1. [oracle@test-db admin]$ lsnrctl status
   
2. 
   
3. LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-APR-2018 00:09:29
   
4. 
   
5. Copyright (c) 1991, 2011, Oracle. All rights reserved.
   
6. 
   
7. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test-db)(PORT=1521)))
   
8. STATUS of the LISTENER
   
9. ------------------------
   
10. Alias LISTENER
    
11. Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
    
12. Start Date 03-APR-2018 23:30:31
    
13. Uptime 0 days 0 hr. 38 min. 57 sec
    
14. Trace Level off
    
15. Security ON: Local OS Authentication
    
16. SNMP OFF
    
17. Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
    
18. Listener Log File /u01/app/oracle/diag/tnslsnr/test-db/listener/alert/log.xml
    
19. Listening Endpoints Summary...
    
20.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test-db)(PORT=1521)))
    
21.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
    
22. Services Summary...
    
23. Service "orcl" has 1 instance(s).
    
24.   Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
    
25. Service "orclXDB" has 1 instance(s).
    
26.   Instance "orcl", status READY, has 1 handler(s) for this service...
    
27. Service "primary_orcl" has 1 instance(s).
    
28.   Instance "orcl", status READY, has 1 handler(s) for this service...
    
29. The command completed successfully

----------------------------------分隔线-----------------------------------------

在listener.ora文件中添加1522端口的监听，添加后的文件内容如下

点击(此处)折叠或打开

1. [oracle@test-db admin]$ cat listener.ora
   
2. # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
   
3. # Generated by Oracle configuration tools.
   
4. 
   
5. LISTENER =
   
6.   (DESCRIPTION_LIST =
   
7.     (DESCRIPTION =
   
8.       (ADDRESS = (PROTOCOL = TCP)(HOST = test-db)(PORT = 1521))
   
9.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
   
10.     )
    
11.   )
    
12. 
    
13. ADR_BASE_LISTENER = /u01/app/oracle
    
14. 
    
15. 
    
16. 
    
17. SID_LIST_LISTENER =
    
18.   (SID_LIST =
    
19.     (SID_DESC =
    
20.       (GLOBAL_DBNAME=orcl)
    
21.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    
22.      (SID_NAME = orcl)
    
23.     )
    
24.   )
    
25. 
    
26. 
    
27. #1522
    
28. MY_LISTENER =
    
29.   (DESCRIPTION_LIST =
    
30.     (DESCRIPTION =
    
31.       (ADDRESS = (PROTOCOL = TCP)(HOST = test-db)(PORT = 1522))
    
32.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
    
33.     )
    
34.   )
    
35. 
    
36. #用于在1522端口注册服务
    
37. SID_LIST_MY_LISTENER =
    
38.   (SID_LIST =
    
39.     (SID_DESC =
    
40.       (GLOBAL_DBNAME=orcl)
    
41.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    
42.      (SID_NAME = orcl)
    
43.     )
    
44.   )

启动1522端口监听

点击(此处)折叠或打开

1. [oracle@test-db admin]$ lsnrctl start my_listener
   
2. 
   
3. LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-APR-2018 00:16:18
   
4. 
   
5. Copyright (c) 1991, 2011, Oracle. All rights reserved.
   
6. 
   
7. Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
   
8. 
   
9. TNSLSNR for Linux: Version 11.2.0.3.0 - Production
   
10. System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
    
11. Log messages written to /u01/app/oracle/diag/tnslsnr/test-db/my_listener/alert/log.xml
    
12. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test-db)(PORT=1522)))
    
13. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))
    
14. 
    
15. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test-db)(PORT=1522)))
    
16. STATUS of the LISTENER
    
17. ------------------------
    
18. Alias my_listener
    
19. Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
    
20. Start Date 04-APR-2018 00:16:18
    
21. Uptime 0 days 0 hr. 0 min. 0 sec
    
22. Trace Level off
    
23. Security ON: Local OS Authentication
    
24. SNMP OFF
    
25. Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
    
26. Listener Log File /u01/app/oracle/diag/tnslsnr/test-db/my_listener/alert/log.xml
    
27. Listening Endpoints Summary...
    
28.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test-db)(PORT=1522)))
    
29.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))
    
30. Services Summary...
    
31. Service "orcl" has 1 instance(s).
    
32.   Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
    
33. The command completed successfully

使用PLSQL Developer工具测试可以正常连接。

-----------------------分割线----------------------------
在1522端口注册服务器还有一种方法，就是使用tnsnames.ora文件
在去掉了listener.ora中有关 SID_LIST_MY_LISTENER 静态注册的代码后，重启 my_listener 监听发现没有任何服务注册

点击(此处)折叠或打开

1. [oracle@test-db admin]$ lsnrctl start my_listener
   
2. 
   
3. LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-APR-2018 00:18:08
   
4. 
   
5. Copyright (c) 1991, 2011, Oracle. All rights reserved.
   
6. 
   
7. Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
   
8. 
   
9. TNSLSNR for Linux: Version 11.2.0.3.0 - Production
   
10. System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
    
11. Log messages written to /u01/app/oracle/diag/tnslsnr/test-db/my_listener/alert/log.xml
    
12. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test-db)(PORT=1522)))
    
13. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))
    
14. 
    
15. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test-db)(PORT=1522)))
    
16. STATUS of the LISTENER
    
17. ------------------------
    
18. Alias my_listener
    
19. Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
    
20. Start Date 04-APR-2018 00:18:08
    
21. Uptime 0 days 0 hr. 0 min. 0 sec
    
22. Trace Level off
    
23. Security ON: Local OS Authentication
    
24. SNMP OFF
    
25. Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
    
26. Listener Log File /u01/app/oracle/diag/tnslsnr/test-db/my_listener/alert/log.xml
    
27. Listening Endpoints Summary...
    
28.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test-db)(PORT=1522)))
    
29.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))
    
30. The listener supports no services
    
31. The command completed successfully

在tnsnames.ora文件中添加如下代码

点击(此处)折叠或打开

1. my_orcl =
   
2.   (DESCRIPTION =
   
3.     (ADDRESS = (PROTOCOL = TCP)(HOST = test-db)(PORT = 1522))
   
4.     (ADDRESS = (PROTOCOL = TCP)(HOST = test-db)(PORT = 1521))
   
5.     (CONNECT_DATA =
   
6.       (SERVER = DEDICATED)
   
7.       (SERVICE_NAME = orcl)
   
8.     )
   
9.   )

注：如果不添加(ADDRESS = (PROTOCOL = TCP)(HOST = test-db)(PORT = 1521))这段的话，那么在默认1521端口中将不会有服务注册

登录数据库设置local_listener参数

点击(此处)折叠或打开

1. alter system set local_listener='my_orcl' scope=both;

使用命令分别检查监听状态

点击(此处)折叠或打开

1. [oracle@test-db admin]$ lsnrctl status
   
2. 
   
3. LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-APR-2018 00:32:38
   
4. 
   
5. Copyright (c) 1991, 2011, Oracle. All rights reserved.
   
6. 
   
7. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test-db)(PORT=1521)))
   
8. STATUS of the LISTENER
   
9. ------------------------
   
10. Alias LISTENER
    
11. Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
    
12. Start Date 03-APR-2018 23:30:31
    
13. Uptime 0 days 1 hr. 2 min. 6 sec
    
14. Trace Level off
    
15. Security ON: Local OS Authentication
    
16. SNMP OFF
    
17. Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
    
18. Listener Log File /u01/app/oracle/diag/tnslsnr/test-db/listener/alert/log.xml
    
19. Listening Endpoints Summary...
    
20.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test-db)(PORT=1521)))
    
21.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
    
22. Services Summary...
    
23. Service "orcl" has 1 instance(s).
    
24.   Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
    
25. Service "orclXDB" has 1 instance(s).
    
26.   Instance "orcl", status READY, has 1 handler(s) for this service...
    
27. Service "primary_orcl" has 1 instance(s).
    
28.   Instance "orcl", status READY, has 1 handler(s) for this service...
    
29. The command completed successfully
    
30. [oracle@test-db admin]$ lsnrctl status my_listener
    
31. 
    
32. LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-APR-2018 00:32:45
    
33. 
    
34. Copyright (c) 1991, 2011, Oracle. All rights reserved.
    
35. 
    
36. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test-db)(PORT=1522)))
    
37. STATUS of the LISTENER
    
38. ------------------------
    
39. Alias my_listener
    
40. Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
    
41. Start Date 04-APR-2018 00:18:08
    
42. Uptime 0 days 0 hr. 14 min. 37 sec
    
43. Trace Level off
    
44. Security ON: Local OS Authentication
    
45. SNMP OFF
    
46. Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
    
47. Listener Log File /u01/app/oracle/diag/tnslsnr/test-db/my_listener/alert/log.xml
    
48. Listening Endpoints Summary...
    
49.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test-db)(PORT=1522)))
    
50.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))
    
51. Services Summary...
    
52. Service "orclXDB" has 1 instance(s).
    
53.   Instance "orcl", status READY, has 1 handler(s) for this service...
    
54. Service "primary_orcl" has 1 instance(s).
    
55.   Instance "orcl", status READY, has 1 handler(s) for this service...
    
56. The command completed successfully

使用PLSQL Developer工具测试可以正常连接。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/2317695/viewspace-2152591/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/2317695/viewspace-2152591/