Friday, October 14, 2016

Configuring OEM Express Control

Starting 12c, OEM Database Control has been replaced by OEM Database Express. OEM Express configuration is very simple as compared to previous OEM Database Control. Following is the method to configure OEM Express. OEM Express Database is configured separately for container database and each pluggable database. Method is same; you just need to set current container to pluggable database for which you want to configure the OEM, and execute the steps as explained bellow.

Container database
Check dispatcher configuration in the database
SQL> show parameter dispatcher

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dispatchers                          string      (PROTOCOL=TCP) (SERVICE=salman12XDB)
max_dispatchers                      integer

Check current port set for XML DB. If not set, set the port
SQL> SELECT dbms_xdb_config.gethttpsport from dual;

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

SQL>  exec dbms_xdb_config.sethttpsport(5000)

PL/SQL procedure successfully completed.

SQL> SELECT dbms_xdb_config.gethttpsport from dual;

GETHTTPSPORT
------------
        5000

If you check listener status, you can see the port.
C:\>lsnrctl status

LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 04-DEC-2015 16:33:13

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SALMQURE-SG)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
Start Date                04-DEC-2015 08:53:23
Uptime                    0 days 7 hr. 39 min. 49 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\app\salmqure\product\12.1.0\dbhome_1\network\admin\listener.ora
Listener Log File         C:\app\salmqure\product\12.1.0\dbhome_1\log\diag\tnslsnr\SALMQURE-SG\listener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SALMQURE-SG)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=SALMQURE--SG)(PORT=5000))(Security=(my_wallet_directory=C:\APP\SALMQURE\admin\salman12\xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "pdb1.sg.oracle.com" has 1 instance(s).
  Instance "salman12", status READY, has 1 handler(s) for this service...
Service "pdb2.sg.oracle.com" has 1 instance(s).
  Instance "salman12", status READY, has 1 handler(s) for this service...
Service "salman12.sg.oracle.com" has 1 instance(s).
  Instance "salman12", status READY, has 1 handler(s) for this service...
Service "salman12XDB.sg.oracle.com" has 1 instance(s).
  Instance "salman12", status READY, has 1 handler(s) for this service...
The command completed successfully

C:\>



Start using OEM Database Express using URL similar to the following
https://<host_name>:port_number

For example




For Pluggable Database
SQL> alter session set container=pdb1;

Session altered.

SQL> select name,open_mode from v$pdbs;

NAME                           OPEN_MODE
------------------------------ ----------
PDB1                           READ WRITE

SQL> SELECT dbms_xdb_config.gethttpsport from dual;

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

SQL>  exec dbms_xdb_config.sethttpsport(5001)

PL/SQL procedure successfully completed.

SQL> SELECT dbms_xdb_config.gethttpsport from dual;

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

Now use following URL to access OEM for pluggable database


No comments:

Popular Posts - All Times