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 ------------
0SQL> select dbms_xdb_config.gethttpport from dual; GETHTTPPORT ------------
0If 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
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.