- Introduction: In this article, we will see how to manage the database or perform DBA operation using the OEM step by step.
- Prerequisites: Below are the minimum requirements for Linux environment:
- Target database should be up & running.
- Sys user password of target database.
- Environment:
- Summary of activities: We will cover below sections in database using OEM.
- Now let's proceed to add the target host in OEM step by step:
| Hostname | oem.oraeasy.com |
|---|---|
| OS | OL 7.3 |
| OEM Version | 13c Release 5 (13.5) |
| Hostname | uat.oraeasy.com |
|---|---|
| OS | OL 8.5 |
| Database Name | ORCLDB |
| Database Version | 19c (19.27) |
Performance
1. Using OEM, we can monitor the database performance like its active sessions,wait events, queries consuming high CPU ..etc. Follow below:Click on Targets -> Database. Then click on the database you want to monitor.
Click on Peformance -> Performance Hub -> SQL Monitoring.
Now provide the sys user credential of that database.
Here you can view all the running SQLs for that particular time. You can also view CPU utlilization or User I/O in a graphically way.
Click on any SQL ID & you can view its details.
You can explore more with the given option to monitor the database performance.
2. We can also fetch the AWR report using OEM. Follow below:
Click on Peformance -> Performance Hub -> AWR -> AWR Reprt.
Provide the Begin & End snapshot to fetch the AWR report. Then click on Generate Report.
AWR report generation is in progress.
Now you can view the AWR report. Also you can download the AWR report by clicking on Save to File.
Backup
2. We can also execute or schedule the RMAN backup via OEM. Follow below:Click on Availability -> Backup & Recovery -> Schedule Backup.
Select the option for backup & host credential details. Then click on Schedule Customized Backup.
Here select the type of backup like Full or Incremental, mode of backup like Online or Offline. Then click Next.
Select the destination for the backup like Disk. Click Next.
Schedule the backup timing & its interval. Click Next.
Here you can review the script & job details. You can also edit the RMAN script by clicking on Edit RMAN Script. Then click on Submit Job
RMAN job has been created successfully. Click on View Job to see the progress.
Monitor the progress.
You can also check on the target server.
[oracle@uat ~]$ ps -ef|grep rman
oracle 12945 12921 7 21:46 ? 00:00:00 rman app/oracle/product/19c/dbhome_1/bin/rman
oracle 12947 5427 0 21:46 pts/1 00:00:00 grep --color=auto rman
[oracle@uat ~]$
[oracle@uat 2025_09_20]$ ls -lrth
total 823M
-rw-r-----. 1 oracle oinstall 823M Sep 20 21:48 o1_mf_nnndf_BACKUP_ORCLDB_202509_ndxnvf98_.bkp
[oracle@uat 2025_09_20]$
[oracle@uat 2025_09_20]$ pwd
/u01/app/oracle/fast_recovery_area/ORCLDB/3D7F7AEE5DB8A4EEE0650A00273EBB20/backupset/2025_09_20
[oracle@uat 2025_09_20]$ hostname
uat.oraeasy.com
[oracle@uat 2025_09_20]$
Now backup has been completed successfully.
Users
3. We can also manage the user & create new one as well via OEM. Follow below:Click on Security -> Users.
Here you can find all the details of the users of database.
By giving the user name and click Go to list any particular user. Click on View to show more details.
TEST user details.
By clicking on Edit you can do the changes in user configurtion. Here we change its account status from Unlocked to Locked.
By clicking on Show SQL, you can view the SQL command.
Now if you want create any user. Click on Create where list of users are shown. Then you can provide the deatils and click OK.
User TESTOEM has been created successfully.
Schema Export
4. We can also perform Export/Import activity via OEM. Follow below for Export backup of a schema:Click on Schema -> Database Export/Import -> Export to Export Files.
Select what you want to export like Schema & select crdential for host. Then click Continue.
Provide the schema name & click Select.
Review the schema name & click Next.
Provide the directory name, log file name & other details. Then click Next.
Provide the name for dump file & click Next.
Configure the schedule & interval. Also provide the export job name & click.
Review the details & click Submit .
Export job has been successfully created.
Monitor the progress.
You can also check on the target server.
[oracle@uat 3D7F7AEE5DB8A4EEE0650A00273EBB20]$ pwd
/u01/app/oracle/admin/orcldb/dpdump/3D7F7AEE5DB8A4EEE0650A00273EBB20
[oracle@uat 3D7F7AEE5DB8A4EEE0650A00273EBB20]$
[oracle@uat 3D7F7AEE5DB8A4EEE0650A00273EBB20]$ ls -lrth
total 348K
-rw-r-----. 1 oracle oinstall 344K Sep 20 22:55 EXPDAT01.DMP
-rw-r--r--. 1 oracle oinstall 1.2K Sep 20 22:55 EXPDAT.LOG
[oracle@uat 3D7F7AEE5DB8A4EEE0650A00273EBB20]$
[oracle@uat 3D7F7AEE5DB8A4EEE0650A00273EBB20]$ hostname
uat.oraeasy.com
[oracle@uat 3D7F7AEE5DB8A4EEE0650A00273EBB20]$
Now schema export backup has been completed.
Tablespace
4. Now we will see how to manage tablespace & its datafiles via OEM. Follow below:Click on Administration -> Storage -> Tablespaces.
You can view all the tablespace list here. Click on any tablepsace like Sysaux.
Now you can see the details of the Sysaux tablespace.
Now click on Create to create a new tablespace on tablespace list screen. Provide the tablepsace name like TESTBS
After clicking Add on the datafile section, then provide the datafile details
Provide file size & extent details. Click Continue.
Review the details & click OK.
Now tablepsace has been created.
You can view the tablepsace details.
If you want to add a datafile in that tablepsace then click Edit.
Click on Add in the datafile section.
Provide the details for the datafile and click OK.
Review the details & click Apply.
Now datafile has been added.
Parameters
5. We can update the intialization parameter via OEM. Follow below:Click on Administration -> Intialization Parameters.
You can view all the parameter details here.
We can change the parameter like open_cursors which is modifiable without restart of database.
Parameter has been modified.
You can view the changed value of parameter.
Thank you for reading!
I hope this content has been helpful to you. Your feedback and suggestions are always welcome — feel free to leave a comment or reach out with any queries.
Abhishek Shrivastava
Comments
Post a Comment