咨询热线 ：
028-86922220
×
01
关于我们

公司简介

发展历程

02
服务项目

高端网站建设

微信开发

APP开发

网络营销服务

电商网站定制

生物医药网站建设

外贸网站建设

教育培训网站建设

03
小程序开发

小程序开发

功能应用

客户案例

04
案例展示

网站建设案例

小程序案例

电商平台案例

APP案例

系统平台案例

05
建站动态

网站建设

网站设计

网站营销

小程序

06
联系我们

公司地址

人才招聘

地址：成都市太升南路288号锦天国际A幢1002号

电话：028-86922220

028-86922220

大橙子网站建设，新征程启航

为企业提供网站建设、域名注册、服务器等服务

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://dzwzjz.com/article/ijiij.html

其他资讯

分享至：
关于我们
公司简介 发展历程
服务项目
高端网站建设 小程序开发 APP开发 网络营销
建站知识
行业新闻 建站学堂 常见问题
联系我们
公司地址 人才招聘
成都 达州
电话：028-86922220
地址：成都市太升南路288号锦天国际A幢1002号
电话：028-86922220
地址：达州市南岸区弹子石腾龙大道58号2栋21-6
友情链接： 青羊总部基地   电信成都枢纽中心   手机微信网站   品牌网站定制   App开发   成都网站建设   led无边发光字   温江网站设计   定制网站   高端网站建设   
版权所有：青羊区大橙子信息咨询工作室 蜀ICP备2022028542号-14
在线咨询
服务热线
服务热线：028-86922220
TOP