OutOfMemoryError:Java Heap Space on OEM 12c Agent

Sometimes we face issues like OEM agent 12c crashed and found the below error messages on gcagent.log[/agent_inst/sysman/log/gcagent.log]. Cause: When an OEM agent collects metrics data, it uses java memory. If it does not have access to the required amount of java memory which is specified in the configuration, the OEM agent may crash. Solution: 1- […]

Read More

Difference Between Local Listener and Remote Listener

LOCAL_LISTENER is a listener that is running on the same machine as this instance. REMOTE_LISTENER is a listener that is not running on the same machine as this instance. Local Listener and Remote Listener concept comes with ORACLE RAC where a single database has multiple instances. Consider an example of 2 Node RAC Database which […]

Read More

How Delete Statement Works

When Oracle receives sql/Delete query, it requires to run some pre-tasks before actually being able to really run the query. During parsing, Database validate the syntax of the statement whether the query is valid or not. Database validate the semantic of the statement. It checks whether a statement is meaningful or not. If syntax/Semantic check […]

Read More

How Update Statement Works

When Oracle receives sql/update query, it requires to run some pre-tasks before actually being able to really run the query. During parsing, Database validate the syntax of the statement whether the query is valid or not. Database validate the semantic of the statement. It checks whether a statement is meaningful or not. If syntax/Semantic check […]

Read More

How Insert Statement Works

When Oracle receives sql/insert query, it requires to run some pre-tasks before actually being able to really run the query.   During parsing, Database validate the syntax of the statement whether the query is valid or not.   Database validate the semantic of the statement. It checks whether a statement is meaningful or not.   […]

Read More

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