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

Creating and Configuring an Oracle Database for RPM Based

In the last post, we installed Oracle 19c Database Software by running RPM Package. Now, we are going to create and configure a Database with default Setting.Log in as root and run the below command to configure an Oracle Database instance. [root@oracle19c dbhome_1]# /etc/init.d/oracledb_ORCLCDB-19c configure Configuring Oracle Database ORCLCDB. [FATAL] [DBT-06103] The port (1,521) is […]

Read More

ORACLE 19C RPM BASED SOFTWARE INSTALLATION

Oracle 19c can be installed on Oracle Linux using an RPM. This article describes the RPM installation of Oracle Database 19c 64-bit on Oracle Linux 7 (OL7) 64-bit.  The naming convention for RPM packages is name–version–release.architecture.rpm. Installing Oracle Database RPM Manually Login as Root and Download and install the Oracle Preinstallation RPM [root@oracle19c sw]# curl -o […]

Read More

Recover table in oracle 12c

Oracle 12.2 came with a new feature , we can simply recover a single table in a database. In below example we will see how we can restore a table of pluggable database. Step 1 : Connect to RMAN Step 2 : Use following command to recover table I.E. here I have table TEST which […]

Read More

MUST_RENAME_THIS_DATAFILE on RAC Standby

Few days ago i got the activity to create the 2 NODE RAC DR on EXADATA for 2 NODE RAC Production. Here I am listing few issues that made this activity perfect case for Data Guard beginners Environment:Production Database Name: Financedb_unique_name : finance Standby Database Name : Finstandbydb_unique_name : finstandby Production OS Node: agoracledba1 agoracledba2Standby […]

Read More