Connecting to EM Express on Oracle Database Cloud Service
Enterprise Manager is a web-based database management tool. It resides within the database and is a handy tool to monitor and measure performance along with performing basic Database management functions. The Enterprise Manager Express works only when the database is OPEN and available. Further documentation on EM Express can be found here.
This is a blog that describes the process of connecting to EM Express. This is my practical experience with EM express on Oracle Database Cloud Service.
Prerequisites :
- Sign up for Oracle Cloud.
- Create required VCN consisting of Public/Private Subnet with attached Route Table enabled.
- Create Database cloud service.
Follow along to Startup and monitor your database using Oracle EM Express.
Create the database cloud service.
SSH into to your Oracle Database Cloud Service
Log into the oracle user
sudo su - oracle
Setup the oracle environment
. oraenv 
Log into sqlplus prompt to execute the following code
EXEC DBMS_XDB_CONFIG.SETHTTPSPORT(5500);
SELECT DBMS_XDB_CONFIG.GETHTTPSPORT() FROM DUAL;
EXIT;
After exiting from SQLPlus prompt check the listener control status for the wallet
lsnrctl status | grep HTTP
Log out from oracle user and log into grid user and set up the oracle environment
sudo su - grid
. oraenv
Again check the listener control status for the wallet and make a note of the wallet location and change directory to that wallet location and change permission to read/write to owner and read to group (640) to all files in that folder
lsnrctl status | grep xdb_wallet
cd /path/to/the/xdb_wallet/location
chmod 640 /path/to/the/xdb_wallet/location/*
Log out of grid user and log into root user. Save the original iptables to a temporary location and add the new input to allow traffic on EM Express port (5500)
sudo su -
iptables-save > /tmp/iptables.origiptables -I INPUT 8 -p tcp -m state --state NEW -m tcp -dport 5500 -j ACCEPT -m comment --comment "Required for EM Express"
Check the iptables service, save and reload the iptables service
service iptables status
/sbin/service iptables save
Log into the EM express from your browser
https://<Public_IP>:5500/em
If you have enabled EM Express on CDB then enter username and password
username : sys
password : db_password
container name : blank
Viola! you are now logged into the EM Express
Oracle Enterprise Manager Express needs is a free resource in all Editions but, it needs access to certain packs (Oracle Performance Diagnostic Pack and Oracle SQL Tuning Pack) which are not available in SE Edition, but is avaible in all other Editions (EE, EE-HP, EE-EP).
About Author:
Phani Turlapati is a Cloud Engineer at Oracle Inc. He’s been with Oracle for over 3 years. He started out at Solution engineering hub at Oracle focusing on various design solutions to help customer to value-add to their businesses. He’s a part of Database Team focusing on all things database. Prior to Oracle he had worked as Software Engineer developing application on Java Platform.
The blog is my view and is no way related to Oracle.
Feel free to comment on the above post. Your feedback is valuable!
