Wednesday, May 31, 2017

Setup Oracle 12c Enterprise Manager Express for a PDB

   Although to create a PDB is much more simple even using a manual procedure, to setup Oracle EM Express with another HTTPS port for the newly created PDB becomes an issue, as the manual method does not do it automatically for you. To  create a Oracle EM Express for the PDB, please follow the steps below:


sqlplus sys/xxxxxx@pdborcl as sysdba
SQL> select name from v$pdbs;

NAME
------------------------------
PDBORCL

SQL> select dbms_xdb_config.gethttpsport from dual;

GETHTTPSPORT
------------
           0


   Now we understood that Oracle EM Express is not configured for tyhe PDB. The below steps will show us how to configure the podrt no 5001 for the PDB


SQL> execute  dbms_xdb_config.sethttpsport(5001)
          
SQL> select dbms_xdb_config.gethttpsport from dual;

GETHTTPSPORT
------------
        5001


  Now you can access the login page of Oracle EM Express for the new PDBORCL database, typing
https://<machine_name>:5501/em
in your web browser


No comments:

Post a Comment