本文共 3786 字，大约阅读时间需要 12 分钟。
开启
sys@jy> alter session set container=jypdb;Session altered.
Elapsed: 00:00:00.21
sys@jy> exec DBMS_XDB_CONFIG.SETHTTPPORT(5505);PL/SQL procedure successfully completed.
Elapsed: 00:00:01.91
[grid@shurkcs ~]$ lsnrctl statusLSNRCTL for Linux: Version 12.2.0.1.0 - Production on 23-FEB-2018 08:47:21
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production Start Date 23-FEB-2018 08:28:03 Uptime 0 days 0 hr. 19 min. 17 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /U01/u01/app/grid/product/12.2.0/crs/network/admin/listener.ora Listener Log File /U01/u01/grid/diag/tnslsnr/shurkcs/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=shurkcs.com)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=shurkcs.com)(PORT=5500))(Security=(my_wallet_directory=/U01/u01/app/oracle/admin/jy/xdb_wallet))(Presentation=HTTP)(Session=RAW)) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=shurkcs.com)(PORT=5505))(Presentation=HTTP)(Session=RAW)) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM", status READY, has 1 handler(s) for this service... Service "+ASM_DATA" has 1 instance(s). Instance "+ASM", status READY, has 1 handler(s) for this service... Service "65c890ff89c39408e053ce05080aaa04" has 1 instance(s). Instance "jy", status READY, has 1 handler(s) for this service... Service "jy" has 1 instance(s). Instance "jy", status READY, has 1 handler(s) for this service... Service "jyXDB" has 1 instance(s). Instance "jy", status READY, has 1 handler(s) for this service... Service "jypdb" has 1 instance(s). Instance "jy", status READY, has 1 handler(s) for this service... The command completed successfully 关闭 sys@jy> exec DBMS_XDB_CONFIG.SETHTTPPORT(0);PL/SQL procedure successfully completed.
Elapsed: 00:00:00.17
[grid@shurkcs ~]$ lsnrctl status
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 23-FEB-2018 08:50:12
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production Start Date 23-FEB-2018 08:28:03 Uptime 0 days 0 hr. 22 min. 8 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /U01/u01/app/grid/product/12.2.0/crs/network/admin/listener.ora Listener Log File /U01/u01/grid/diag/tnslsnr/shurkcs/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=shurkcs.com)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=shurkcs.com)(PORT=5500))(Security=(my_wallet_directory=/U01/u01/app/oracle/admin/jy/xdb_wallet))(Presentation=HTTP)(Session=RAW)) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM", status READY, has 1 handler(s) for this service... Service "+ASM_DATA" has 1 instance(s). Instance "+ASM", status READY, has 1 handler(s) for this service... Service "65c890ff89c39408e053ce05080aaa04" has 1 instance(s). Instance "jy", status READY, has 1 handler(s) for this service... Service "jy" has 1 instance(s). Instance "jy", status READY, has 1 handler(s) for this service... Service "jyXDB" has 1 instance(s). Instance "jy", status READY, has 1 handler(s) for this service... Service "jypdb" has 1 instance(s). Instance "jy", status READY, has 1 handler(s) for this service... The command completed successfully本文转自whshurk 51CTO博客，原文链接：http://blog.51cto.com/shurk/2072266，如需转载请自行联系原作者