行业资讯

Oracle如何创建非1521端口监听

发布时间：2021-11-09 13:57:54 作者：小新
来源：亿速云 阅读：144

小编给大家分享一下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.


  5. LISTENER =

  6.   (DESCRIPTION_LIST =

  7.     (DESCRIPTION =

  8.       (ADDRESS = (PROTOCOL = TCP)(HOST = test-db)(PORT = 1521))

  9.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

  10.     )

  11.   )


  13. ADR_BASE_LISTENER = /u01/app/oracle




  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


  3. LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-APR-2018 00:09:29


  5. Copyright (c) 1991, 2011, Oracle. All rights reserved.


  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.


  5. LISTENER =

  6.   (DESCRIPTION_LIST =

  7.     (DESCRIPTION =

  8.       (ADDRESS = (PROTOCOL = TCP)(HOST = test-db)(PORT = 1521))

  9.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

  10.     )

  11.   )


  13. ADR_BASE_LISTENER = /u01/app/oracle




  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.   )



  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.   )


  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


  3. LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-APR-2018 00:16:18


  5. Copyright (c) 1991, 2011, Oracle. All rights reserved.


  7. Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...


  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)))


  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


  3. LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-APR-2018 00:18:08


  5. Copyright (c) 1991, 2011, Oracle. All rights reserved.


  7. Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...


  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)))


  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


  3. LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-APR-2018 00:32:38


  5. Copyright (c) 1991, 2011, Oracle. All rights reserved.


  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


  32. LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-APR-2018 00:32:45


  34. Copyright (c) 1991, 2011, Oracle. All rights reserved.


  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端口监听”这篇文章的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注亿速云行业资讯频道！

推荐阅读：
  1. Oracle新增监听以及创建实例
  2. oracle监听启动

免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。

oracle

上一篇：怎么解决Oracle启动报错ORA-00119问题

下一篇：Oracle如何手工创建数据库

相关阅读

您好，登录后才能下订单哦！

密码登录
登录注册
获取短信验证码
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》
产品服务
地区划分
帮助支持
关于我们
行业资讯-文章归档 问答-问答归档
广州亿速云计算有限公司

7*24小时在线电话：400-100-2938

7*24小时在线QQ：800811969

Copyright © Yisu Cloud Ltd. All Rights Reserved. 2018 版权所有
粤ICP备17096448号-1 粤公网安备 44010402001142号