Oracle12C turns on and off em
open
Sys@jyCDB > alter session set container=jypdb
Session altered.
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
Close
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
