Let’s see how to access EM express for various types of databases.
Oracle 12c has introduced multitenant architecture in which we can have different types of databases:
– CDB’s
– PDB’s
– Non CDB’s
Let’s see how to access EM express for various types of databases:
Accessing EM express for CDB’s
At the root container, data is displayed for the entire CDB, and all actions taken impact all containers. Data pertaining to a PDB, such as a user or a SQL statement, is qualified with the container name. The actions a user can perform at the root container include:
– viewing and setting initialization parameters;
– administering common users and privileges; and
– managing memory configuration, undo information and redo logs.
– Find out the port on which EM Express is configured:
Three methods are available:
1. When dbca completes, note down the the port on which EM Express is configured as displayed.
2.Find out status of the listener
[oracle@em12c /]$ lsnrctl status (output trimmed) Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=em12c.oracle.com)(PORT=1522))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=em12c.oracle.com)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/cdb1/xdb_wallet))(Presentation=HTTP)(Session=RAW))
3. Login to CDB as issue the sql query as follows:
SQL> conn sys/oracle@cdb1 as sysdba select dbms_xdb_config.gethttpsport from dual; GETHTTPSPORT ------------ 5500
– Access EM express by entering following URL in the browser:
https://<hostname>:5500/em
Accessing EM express for PDB’s
When a user is connected to a PDB, data is displayed only for the container in question, and actions only impact that container.
– Login to PDB
SQL> alter session set container=pdb1; sho con_name CON_NAME ------------------------------ PDB1
– Configure the port (5501) for EM express as follows:
SQL> exec dbms_xdb_config.sethttpsport(5501);
– Confirm that EM has been configured on specified port (1501)
SQL> select dbms_xdb_config.gethttpsport from dual; GETHTTPSPORT ------------ 5501
– Access EM express by entering following URL in the browser:
https://<hostname>:5501/em
Accessing EM express for Non-CDB’s
For a non- CDB, and all actions a user can perform in a non-CDB are available:
– viewing and setting initialization parameters;
– administering common users and privileges;
– managing memory configuration, undo information and redo logs.
– managing tablespaces etc.
– Find out the port on which EM Express is configured:
Two methods are available:
1. When dbca completes, note down the the port on which EM Express is configured as displayed.
2. Login to non-CDB (Note container name as Non consolidated)
SQL> conn sys/oracle@ncdb as sysdba sho con_name CON_NAME ------------------------------ Non Consolidated
– Issue the sql query as follows:
select dbms_xdb_config.gethttpsport from dual; GETHTTPSPORT ------------ 5502
– Access EM express by entering following URL in the browser:
https://<hostname>:5502/em