Oracle Corner

Cloning a database where source Oracle Home has a higher DST patch than a destination Oracle home  Example: Source database has a DST patch ...

OEM13c occasionally leaves orphaned alerts or targets in suspended mode, that clearstate can't remove.  After some investigation, I...

Clusterize the database oh; cd dbs cp initDBNAME.ora initDBNAME.ora.singleinstance create pfile='/oracle/DBNAME/121/dbs/initDBNAM...

Prepare OLD database cd $ORACLE_HOME/dbs; cp orapwDBNAME orapwDBNAME.beforemigration orapwd file=/oracle/DBNAME/12102/dbs/orapwDBNAME s...

If standby is considerably lagging behind production, “roll it forward” using the incremental backup. DR DGMGRL> edit database 'D...

This was a tricky one. I migrated OEM 13c from Linux 5 to Linux 6 without any issues. When I tried the same migration, just this time fro...

OEM target stuck in "Notification Blackout" This is OMS 13c bug. As there is no emctl or emcli command that can fix this probl...

This happened during the apply of PSU 26610308 on GI. The opatch script rolled back 2 patches on one node of the cluster, but not on the ot...

We received an alert for one of our cluster standby databases, with OEM metric "Redo Apply Rate (KB/second) " showing 0, indicati...

This is a pretty simple problem, and there is an Oracle bug explained in Doc ID 2145349.1, but Oracle support doesn't offer solution, ...

When you use OEM to create a standby on RAC, it will create a single instance on one standby node, which you later need to convert to a clus...

Note After upgrading to 12.1.0.2 on RAC cluster, we had a very slow SQL below that was reading column group statistics:      select count(...

Create wallet mkdir $ORACLE_HOME/wallets cd  $ORACLE_HOME/wallets orapki wallet create -wallet $ORACLE_HOME/wallets -pwd xxx -auto...

BEGIN  DBMS_AUTO_SQLTUNE.set_auto_tuning_task_parameter(  parameter => '_sqltune_control',  value => 15);  END;  / 

Symptoms SQL Tuning Advisor recommends lots of plans with PX hints, claiming that parallelism puts the cost down. That might be a case, ...

Symptoms After a RAC node reboot, one of the ASM disks didn't get mounted. We could see the disk (partition) /dev/> with ...

Symptoms TNS-12518: TNS:listener could not hand off client connection TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter ...

The upgrade had quite a few bugs/problems, for which we couldn't find solutions either on Oracle support site or Google, therefore list...

I couldn't find this error anywhere on Google, and IBM Support has been looking into it for 2 days without help. I found the workaround,...

I was installing 12c database from the NFS mounted share, and the installation failed at the second step with the INS-10331 error. O...

I couldn't find this anywhere else on the Internet, therefore worth posting. Default value of  _sys_logon_delay 12c parameter is 1. ...

2 products exist for managing: Cc + Ops Center (host management) Oracle HTTP server is started up implicitly when OMS is started. Managed ...

OMS is a J2EE app deployed via Web Logic. It has 3 apps: 1 - The Console serves up all the /em URLs. 2 - PBS (Platform Background Services...

Idea Flashback to be enabled per pluggable database, instead of per the whole instance. Why? Because I like flashback and use ...

Latest patch right now: 12.1.0.2 OEM CC Chargeback basaed on capacity App Mgmt: based on APIs: PS, VMware,...             Plugg-ins ...