Shulou(Shulou.com)06/01 Report--

Https://database-hostname:portnumber/em/

Look up the port number of non-CDB

Select dbms_xdb_config.gethttpsport () from dual

Check the https port number of CDB

Alter session set container=CDB$ROOT;select dbms_xdb_config.gethttpsport () from dual

Check the https port number of PDB

Alter session set container=PDB1;select dbms_xdb_config.gethttpsport () from dual

Monitoring must be activated

Non-default listening port

Local_listener=inst1

Inst1 must be in tnsnames.ora, for example

Inst1= (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=host_name) (PORT=1234)) (CONNECT_DATA= (SERVICE_NAME=service_name) (SERVER=DEDICATED)

3. Allow tcp dispatchers to enter init.ora to manage EM through the following configuration

Dispatchers= "(PROTOCOL=TCP) (SERVICE=XDB)"

4. Restart the database to make the changes take effect in the init.ora file

5. Use DBMS_XDB_CONFIG.SETHTTPSPORT to set the https port of em

The https port in xdbconfig.xml will be updated

(no matter what port number it is set to, it cannot conflict with other service ports of this server)

Set the non-CDB https port

Conn sys / as sysdba;sql > exec DBMS_XDB_CONFIG.SETHTTPSPORT (5500)

Set the CDB https port

Conn sys / as sysdba;sql > alter session set container=CDB$ROOT;sql > exec DBMS_XDB_CONFIG.SETHTTPSPORT (5501)

Set the PDB https port

Conn sys / as sysdba;sql > alter session set container=PDB1;sql > exec DBMS_XDB_CONFIG.SETHTTPSPORT (5502)

Use the following command to confirm the port registered on the monitor

$lsnrctl status | grep-I 5502

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcps) (HOST=hostname.example.com) (PORT=5502))

) (Security= (my_wallet_directory=/$ORACLE_BASE/admin/sid/xdb_wallet))

(Presentation=HTTP) (Session=RAW))

Access em and connect to non-CDB,CDB,PDB according to port number

Https://database-hostname:portnumber/em/

The user logged in is authorized by dba

Document link:

Http://docs.oracle.com/database/121/ADMQS/GUID-EB851101-07BE-4038-BB9D-06E01CC7F5D5.htm#ADMQS032

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.