How to Add Databases to Oracle Enterprise Manager 24ai

 
After successfully configuring hosts on the EM you can proceed with adding databases to the EM for monitoring. If you have not added hosts to the EM, follow the below guide:
Configuring Agents on Oracle Enterprise Manager 24ai

Step 01 - Add clusters of the servers.

This is only necessary if we are going to add rac databases.

1. Go to Setup > Add Target > Auto Discovery Results


2. Select the clusters and select Promote


Step 02 - Add the databases

Method 1 - Add Using Guided Process



1. Select the target




2. Select the Databases you want to add and fill the correct credentials


Method 2 - Add targets Manually


1. Select the host of the database you want to add.


2. Add the correct details of the database.



Step 03 - Check whether the databases are added successfully

Comments

Post a Comment

Popular posts from this blog

Installing Oracle Database 19c on Linux 8 (OL8) Server

Image
Step 1 - Install the Relevant Software Install the Oracle Database 19c Enterprise Edition 19.3.0.0.0 from Oracle Software Delivery Cloud or any other method you prefer. (If your server has an internet connection you can use the wget method to install the software) As a best practice create a separate directory named 'SOFTWARES' where you can move installation files. Step 2 - Add the following lines to the ' /etc/sysctl.conf ' file as root user. fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 kernel.panic_on_oops = 1 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 net.ipv4.conf.all.rp_filter = 2 net.ipv4.conf.default.rp_filter = 2 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 9000 65500 Step 3 - Add the following lines to a file called ' etc/security/limits.d/oracle-database-preinstall-19c.conf'  file or...
Read more

Oracle GoldenGate Real-Time Replication (Unidirectional)

Image
Below is the specs of the source and target I used for this demonstration: Source: OL 7.9 / DB 11.2.0.2 / GoldenGate 12.3 / Classic Extract Target: OL 8 / DB 19c / GoldenGate 19.1 / Integrated Replicat (The reason I used GoldenGate 12.3 in the source server is since GoldenGate 19c does not support Oracle Database 11.2.0.2 The source DB server use the classic extract method to extract the trail files since integrated extract method is not supported.) Ports to be opened: 7809               Source --> Target -- Manager Port 7810-7820     Source --> Target -- Collector Ports 1521               Source --> Target -- Listener Port (Strictly not necessary but better to have opened) 22                    Bidirectional -- SSH Port Make sure the tns entries are clearly specified in the tnsnames.ora file. Phase 0: OS Setup & Installation ...
Read more

Repository Configuration Utility (RCU) for Oracle Forms & Reports

Image
  Step 1 - To Complete the RCU Configuration create a database in the same server. Follow this guide to create a Oracle 19c Database Step 2 - To carry out the RCU configuration run the the Repository Configuration Utility (RCU). [weblogic@testserver-k ~]$ $MW_HOME/oracle_common/bin/rcu After successfully running the Repository Configuration Utility (RCU) follow the below guide to create a WebLogic Domain. Creating a WebLogic Domain
Read more