Open
[Email protected] Cdb> alter session set CONTAINER=JYPDB;
Session altered.
elapsed:00:00:00.21
[Email protected] Cdb> exec dbms_xdb_config. Sethttpport (5505);
PL/SQL procedure successfully completed.
elapsed:00:00:01.91
[Email protected] ~]$ lsnrctl status
Lsnrctl for linux:version 12.2.0.1.0-production on 23-feb-2018 08:47:21
Copyright (c) 1991, 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. Min. 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, have 1 handler (s) for the This service ...
Service "+asm_data" has 1 instance (s).
Instance "+asm", status ready, have 1 handler (s) for the This service ...
Service "65c890ff89c39408e053ce05080aaa04" has 1 instance (s).
Instance "JY", status ready, have 1 handler (s) for the This service ...
Service "JY" has 1 instance (s).
Instance "JY", status ready, have 1 handler (s) for the This service ...
Service "Jyxdb" has 1 instance (s).
Instance "JY", status ready, have 1 handler (s) for the This service ...
Service "jypdb" has 1 instance (s).
Instance "JY", status ready, have 1 handler (s) for the This service ...
The command completed successfully
Shut down
[Email protected] Cdb> exec dbms_xdb_config. Sethttpport (0);
PL/SQL procedure successfully completed.
elapsed:00:00:00.17
[Email protected] ~]$ lsnrctl status
Lsnrctl for linux:version 12.2.0.1.0-production on 23-feb-2018 08:50:12
Copyright (c) 1991, 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. 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, have 1 handler (s) for the This service ...
Service "+asm_data" has 1 instance (s).
Instance "+asm", status ready, have 1 handler (s) for the This service ...
Service "65c890ff89c39408e053ce05080aaa04" has 1 instance (s).
Instance "JY", status ready, have 1 handler (s) for the This service ...
Service "JY" has 1 instance (s).
Instance "JY", status ready, have 1 handler (s) for the This service ...
Service "Jyxdb" has 1 instance (s).
Instance "JY", status ready, have 1 handler (s) for the This service ...
Service "jypdb" has 1 instance (s).
Instance "JY", status ready, have 1 handler (s) for the This service ...
The command completed successfully
oracle12c Turn off EM