How to Enable Oracle Enterprise Manager Database Express on Oracle DB 12c ?

Asset ID:	1-71-2292800.1
Update Date:	2017-08-01
Keywords:

Solution Type Technical Instruction Sure

Solution 2292800.1 : How to Enable Oracle Enterprise Manager Database Express on Oracle DB 12c ?

Applies to:

Oracle Communications Performance Intelligence Center (PIC) Software - Version 10.2.1 to 10.2.1 [Release 10.0]
Information in this document applies to any platform.

Goal

Some customer issues may require a deeper investigation of the behavior of the Oracle Database installed on an IXP DWH or a NSP server. When this is the case using Oracle Enterprise Manager is very helpful.

Here is a simple procedure explaining how to setup the Oracle Enterprise Manager Database Express on Oracle DB 12c

Solution

Log on as oracle user on the IXP or NSP server and connect to sqlplus :

#sqlplus / as sydba

Run the following commands on the sqlplus prompt:

exec dbms_xdb_config.sethttpsport(1158);

grant EM_EXPRESS_BASIC to NSP;

grant EM_EXPRESS_BASIC to SYS;

If configuring an NSP server run also this command (replace IP_OF_SERVER by the actual IP of the server):

alter system set dispatchers = '(address=(protocol=tcp)(host=IP_OF_SERVER))(dispatchers=2)(service=NSP)(listener=NSP)';

If configuring an IXP server run also this command (replace IP_OF_SERVER by the actual IP of the server:

alter system set dispatchers = '(address=(protocol=tcp)(host=IP_OF_SERVER))(dispatchers=2)(service=IXP)(listener=IXP)';

As root user open the firewall on port 1158 with protocol TCP:

#firewall-cmd --permanent --add-port=1158/tcp

Reboot the server:

#reboot

You can now connect to Oracle Enterprise manager with a web browser (flash enabled) at the following address: https://IP_OF_SERVER:1158/em

Attachments

This solution has no attachment