How Select Statement Works

When Oracle receives a sql query, it requires to run some pre tasks before actually being able to really run the query.Combination of these tasks is called parsing. During parsing the below operations used to perform. Database validate the syntax of the statement whether the query is valid or not.For example, the following statement fails […]

Read More

Oracle 19C Active Data Guard DML Redirection Feature

This article describes about the Oracle 19C new feature – Active Data Guard DML Redirection. ACTIVE DATA GUARD DML REDIRECT feature enables DML operation on the standby database to be redirected to and run on the primary database instead of failing, where the data changes will be applied. The updated data will then be streamed […]

Read More

Steps to Create,Drop and Flashback Guaranteed restore point in Dataguard

CREATE GUARANTEED RESTORE POINT: Stop redo transport and redo apply a)If broker is not configured: On primary database: SQL> alter system set log_archive_dest_state_2=’defer’; On standby database: SQL> alter database recover managed standby database cancel; b)If broker is in place: DGMGRL> edit database db set state = ‘TRANSPORT-OFF’; DGMGRL> edit database db01 set state = ‘APPLY-OFF’; […]

Read More

Steps to recover WebLogic Credential [OEM 12cR5]

In this post we will discuss the steps to decrypt WebLogic credential from Boot Properties. During OEM upgrade process when WebLogic password is required, if you have forget the password you can decrypt the WebLogic credential using below steps. 1.Go to your domain/bin directory where setDomainEnv.sh file present. oracle=>cd /u01/app/app00/cloudc/gc_inst/user_projects/domains/GCDomain/bin oracle=>ls -ltr total 60 drwxr-x—. […]

Read More

OEM Management Agent Installation Using Silent Method

This post explains about the steps are used by DBAs to install OEM agent using Silent Method. On the OMS host, you need to login using the EMCLI command [Note that SYSMAN password is required] oracle=>emcli login -username=sysman 2.oracle=>emcli sync Synchronized successfully Note Message should be “synchronized successfully” 3) List support platforms [Run it on […]

Read More

Agent Blocked (Bounce Counter Mismatch) OEM 12C/13C

Started seeing this OEM error alert mails for OEM agents. EM Incident: Critical:New: – Agent Blocked (Bounce Counter Mismatch) Cause For every agent in the repository OEM maintains a Bounce Counter.At the time of agent restart, if the agent side Bounce Counter value is not in sync with repository, then uploads from this agent is […]

Read More

Basic Commands For Controlling OEM 12C/13C Cloud Control

Use the below command to Stop only the Oracle Management Service: emctl stop oms Use the below command to stop Oracle Management Service including Administartion Server, HTTP Server and Node Manager: emctl stop oms -all Use the below command to check the status of OMS: emctl status oms Use the below command to get detailed […]

Read More