阿坝州网站建设公司

Oracle如何创建非1521端口监听-创新互联

小编给大家分享一下Oracle如何创建非1521端口监听，相信大部分人都还不怎么了解，因此分享这篇文章给大家参考一下，希望大家阅读完这篇文章后大有收获，下面让我们一起去了解一下吧！

专业从事成都网站设计、成都做网站,高端网站制作设计,小程序制作,网站推广的成都做网站的公司。优秀技术团队竭力真诚服务，采用H5页面制作+CSS3前端渲染技术，成都响应式网站建设，让网站在手机、平板、PC、微信下都能呈现。建站过程建立专项小组，与您实时在线互动，随时提供解决方案，畅聊想法和感受。



现有的监听文件配置

点击(此处)折叠或打开

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


本文标题：Oracle如何创建非1521端口监听-创新互联
本文网址：http://azwzsj.com/article/ijiij.html

其他资讯