Database Blog

Application clone error in R12.2: Error while executing alter_ebs_logon_trigger.sql

Issue: Recently while doing clone for R12.2 environment, faced the below issue. Configuring: Run file system…. LogFile located at /u01/apps/fs1/inst/apps/PROD_server1/admin/log/clone/run/RCloneApplyAppstier_04190811.log ERROR: Failed to configure the target system, please check the…

Read More

How to apply PSU patch in Grid Home

Steps to apply PSU patch in GRID Home, 1. Download the PSU patch from oracle support. 2. Check the opatch version before applying the patch. If you have older opatch…

Read More

Deinstall 19c Grid Home

The following steps to Deinstall 19c Grid Home, 1. Stop all the database which are related to ASM instance. 2. Stop all the listeners which are related to ASM instance.…

Read More

Deinstall 19c Oracle Home

The following steps to Deinstall 19c Oracle Home, 1. Stop all the database which are running under this oracle home. 2. Stop all the listeners which are running under this…

Read More

How To Resolve Agent Stuck Issue

How To Resolve Agent Stuck Issue: ================================= Workout 1. emctl stop agent 2. ps -ef | grep emagent kill all the process 3. emctl start agent Oracle Enterprise Manager 11g…

Read More

Agent deployment On Target Host

AGENT DEPLOYMENT ON TARGET HOST: ================================= 1) Before creating agent image sync the EM CLI client with OMS emcli login -username=sysman -password=******** emcli sync 2)Getting agent image from OMS HOST…

Read More

Flashback Restore Point

FLASHBACK RESTORE POINT: ======================= Restore point plays important role in restore and recovery scenario as it allows to store the state of the database to a certain point. The database…

Read More

Mount ACFS after Reboot On Standalone GI

Description  In this case we are using standalone grid infrastructure and having an ACFS file system in it. In Standalone, ACFS does not start automatically so create rc.local script to…

Read More

ORACLE WALLETS

Oracle Wallets Oracle Wallet is a container/repository that stores credentials such as certificates, certificate requests, and private keys, with oracle wallets we can also connect to a particular database schema…

Read More

MANUAL DATAGUARD SWITCHOVER 19c

MANUAL DATAGUARD SWITCHOVER 19c Switch over: It is reversal of role between a standby database and a primary database. The primary database assumes role of standby database and the standby…

Read More