Posts

Configuring Oracle Enterprise Manager 24ai

Image
  Step 01 - Install and configure an Oracle Database on the EM server. You can follow the below guide to install an Oracle 19c Database: Installing Oracle Database 19c on Linux 8 (OL8) Server Step 02 - Patch the DB home + DB (Optional) Step 03 -  Install the required software to the server and create the following mkdir -p /home/u01/app/oracle/middleware_24ai mkdir -p /home/u01/app/oracle/agent_24ai Step 04 - Run the following in the Database. sqlplus / as sysdba alter system set "_allow_insert_with_update_check"=true scope=both Step 05 - Extract the zip file unzip V1046951-01.zip unzip V1046952-01.zip unzip V1046953-01.zip unzip V1046954-01.zip unzip V1046955-01.zip The extracted files: em24100_linux64-2.zip em24100_linux64-3.zip em24100_linux64-4.zip em24100_linux64-5.zip em24100_linux64.bin Make sure all the extracted files as well as the zip files are located in the same location or else you will encounter the following error when running the executable: ERROR: Installer ...
Post a Comment
Read more

Configuring Agents on Oracle Enterprise Manager 24ai

Image
  Step 01 - Check ./emctl status oms -details Oracle Enterprise Manager 24ai Release 1 Copyright (c) 1996, 2024 Oracle Corporation.  All rights reserved. Console Server Host        : <redacted> HTTP Console Port          : 7788 HTTPS Console Port         : 7803 HTTP Upload Port           : 4889 HTTPS Upload Port          : 4903 EM Instance Home           : /home/u01/app/oracle/middleware_24ai/gc_inst/em/EMGC_OMS1 OMS Log Directory Location : /home/u01/app/oracle/middleware_24ai/gc_inst/em/EMGC_OMS1/sysman/log OMS is not configured with SLB or virtual hostname Agent Upload is locked. OMS Console is locked. Active CA ID: 1 Console URL: https://<redacted>:7803/em Upload URL: https://<redacted>:4903/empbs/upload WLS Domain Information Domain Name            : GCDomain Admin Se...
Post a Comment
Read more

How to Add Databases to Oracle Enterprise Manager 24ai

Image
  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
Post a Comment
Read more

Configuring an Oracle Standby Database

Image
My Environment for this practice:      Primary Environment Standby Environment DB_NAME PRODTEST DB_NAME PRODTEST DB_UNIQUE_NAME PRODTEST DB_UNIQUE_NAME STBTEST IP 10.14.1.162 IP 10.14.2.251 DATABASE VERSION 19.3.0.0.0 DATABASE VERSION 19.3.0.0.0 OS OLE 8 OS OLE 8 Step 01 - Make sure the primary database is running in archive log mode. [oracle@testserver-k ~]$ sqlplus / as sysdba SQL> archive log list; Database log mode              Archive Mode Automatic archival             Enabled Archive destination            USE_DB_RECOVERY_FILE_DEST Oldest online log sequence     7 Next log sequence to archive   9 Current log sequence           9 # In this case the database is already running in archive log mode. But if it is not in archive log mode follow the below steps to alter it to archive log mode. SQL> shu immediate S...
Post a Comment
Read more