资讯

精准传达 • 有效沟通

从品牌网站建设到网络营销策划，从策略到执行的一站式服务

网站建设 >

查看其它板块

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://cdkjz.cn/article/ijiij.html
返回首页 了解更多建站资讯

相关资讯

多年建站经验

多一份参考，总有益处

联系快上网，免费获得专属《策划方案》及报价

咨询相关问题或预约面谈，可以通过以下方式与我们联系

大客户专线   成都：13518219792   座机：028-86922220

在线咨询 提交需求
友情链接 交换友情链接
重庆网站建设营销型网站建设成都网站设计瑞杰管理衣柜书柜酒柜定制中国电信西部信息中心机房雅安网站建设防护网厂手机网站设计南京护栏钻孔机

成都网站建设公司地址：成都市青羊区太升南路288号锦天国际A座10层 建设咨询028-86922220

成都快上网科技有限公司-四川网站建设设计公司 | 蜀ICP备19037934号 Copyright 2020,ALL Rights Reserved cdkjz.cn | 成都网站建设 | © Copyright 2020版权所有.

专家团队为您提供成都网站建设,成都网站设计,成都品牌网站设计,成都营销型网站制作等服务,成都建网站就找快上网！ | 成都网站建设哪家好？ | 网站建设地图