Oracle12C 开启关闭em

排第四偶家

　　开启

　　sys@jyCDB>>
　　Session>　　Elapsed: 00:00:00.21
　　sys@jyCDB> exec DBMS_XDB_CONFIG.SETHTTPPORT(5505);
　　PL/SQL procedure successfully completed.
　　Elapsed: 00:00:01.91
　　[grid@shurkcs ~]$ lsnrctl status
　　LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 23-FEB-2018 08:47:21
　　Copyright (c) 1991, 2016, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=shurkcs.com)(PORT=1521)))
　　STATUS of the LISTENER
　　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@jyCDB> 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.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=shurkcs.com)(PORT=1521)))
　　STATUS of the LISTENER
　　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