Oracle如何创建非1521端口监听

小编给大家分享一下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工具测试可以正常连接。

以上是“Oracle如何创建非1521端口监听”这篇文章的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注亿速云行业资讯频道！