Oracle 19c Enterprise Manager Database Express Not Working – Solving

To performance monitoring, administrators commonly use Enterprise Manager Database Express.

If you are not able to access Enterprise Manager Database Express it might be there is no port number set, you wallet file has no permisson of 600, listener does not working or your browser do not have flash player. I am going to show set the port number and give permisson to wallet files. To check these setting follow the lines below;

First check the port;

SQL> select dbms_xdb_config.gethttpsport from dual;
GETHTTPSPORT
------------
   0 
SQL> select dbms_xdb_config.gethttpport from dual;
GETHTTPPORT
 ------------ 
   0 

If you see 0 both of them, execute these procedures. 

SQL> exec dbms_xdb_config.sethttpsport(5500);

SQL> exec dbms_xdb_config.sethttpport(5501); 

select again, you will see 5500 set.

SQL> select dbms_xdb_config.gethttpsport from dual;
 GETHTTPSPORT
 5500

If you still cannot connect, check the wallet files.

The wallet files should normally have permission 600, but that doesn’t allow successful display of the EM Express page when RDBMS sits on top of GI with role separation. For configuration of this;

Check the ditectory of wallet files, run this command fist;

lsnrctl stat | grep HTTP

output is;   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=localhost)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/candb/xdb_wallet))(Presentation=HTTP)(Session=RAW))
copy the directory and write ls -l command.

[[email protected] Downloads]# cd /u01/app/oracle/admin/candb/xdb_wallet
[[email protected] xdb_wallet]# ls -l
total 8
-rw-------. 1 oracle oracle 3880 Mar 10 07:52 cwallet.sso
-rw-------. 1 oracle oracle 3835 Mar 10 07:52 ewallet.p12  

You will see they have -rw permisson. You have to set with -rw-r
Changing mode to 640 to allow for group oinstall to read the wallet files makes the EM Express page available via browser.

[[email protected] xdb_wallet]# chmod 640 ./*
[[email protected] xdb_wallet]# ls -l
total 8
-rw-r-----. 1 oracle oracle 3880 Mar 10 07:52 cwallet.sso
-rw-r-----. 1 oracle oracle 3835 Mar 10 07:52 ewallet.p12 

Now you can connect with browser.

https://localdomain:5500/em

Related Post

Leave a Reply

Your email address will not be published. Required fields are marked *