Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Monday, May 11, 2015

12c: Enterprise Manager Database Express

For Oracle Database 12c, Enterprise Manager Express enables you to perform administrative tasks such as managing user security and managing database memory and storage. You can also view performance and status information about your database. You can access Enterprise Manager Database Express using the URL that was displayed during installation. The default port used is 5011. In case you want to use a different port, you need to configure the port using the dynamic protocol registration method. After the HTTP port is configured, you use it to access Enterprise Manager Express.

The DB Express runs entirely with pl/sql code within the XDB schema. It’s XDB that leverages its features to enable a web-based console, and it’s embedded by default in the database.
To enable it, it’s necessary to check that the parameter dispatchers is enabled for XDB:

SQL> show parameter dispatcher

------------------------------------ ----------- ------------------------------
dispatchers string (PROTOCOL=TCP) (SERVICE=orclXDB)
max_dispatchers integer

and then set an https port unique on the server:

SQL> exec dbms_xdb_config.sethttpsport (5500);

If you’ve already done it but you don’t remember the port number you can get it with this query:

SQL> select dbms_xdb_config.gethttpsport () from dual;

You can now access the web interface by using the address:https://yourserver:5502/em

https://ws9374:5500/em (connect with sys or system user)

You can use EM Express to manage a non-CDB, a CDB, or a PDB. For each non-CDB, CDB, or PDB that you want to manage using EM Express on a given host, a unique HTTPS port must be configured. A different port must be configured for each container in a CDB that you want to manage using EM Express.

Setting for PDB
alter session set container=PDB1;

SQL> select name, open_mode from v$pdbs;

------------------------------ ----------

SQL> alter pluggable database PDBORCL open;

Pluggable database altered.

SQL> select dbms_xdb_config.gethttpsport() from dual;


PL/SQL procedure successfully completed.

Access the PDB now

No comments: