DBA Maestro - Helpful DBA tips

12.1.0.2 Grid Infrastructure Upgrade: From 11.2.0.4 To 12.1.0.2 Using GI Clone I used the following methodology to upgrade from 11.2.0.4 to 12.1.0.2 RAC.  This is particularly useful from a time perspective to avoid having to do a separate patching when it comes to applying bundle patches (Exadata) or PSUs.  I tested this process in my non-production environment and highly advise you to do the same to ensure the process is seamless. A) Prepare SOURCE GI home (In this case it is 12.1.0.2) to be cloned: ******************************** Follow documentation for "Preparing the Oracle Grid Infrastructure Home for Cloning" at https://docs.oracle.com/database/121/CWADD/clonecluster.htm#CWADD92116 Oracle® Clusterware Administration and Deployment Guide 12c Release 1 (12.1) Part Number E16794-16 ******************************** A01) Stop all databases via srvctl (run by oracle) srvctl stop database -d {db_unique_name} A02) Stop CRS (run by root) export ORACLE_HO...

I encountered a very weird issue in Oracle on 11.2 RAC that I couldn't find any reference to on Metalink.  The issue occurred after I created a RAC database, registered it to CRS manually, started it up via srvctl. Everything was working fine up to this point.  The problem arose when I stopped and restarted the database with srvctl; only the first instance would start successfully.  The second instance wouldn't start due to this error: CRS-2664: Resource 'ora.asm' is already running on ' node_name ' This was very strange because the instance would start just fine if I used sqlplus.  After further research amongst my colleagues and me, we found that there was an uncommented line in the /etc/hosts file that was causing the issue.  The line was: ::1   localhost6.localdomain6 localhost6 After having the SA comment this line out and bounce the second node that was having the problem starting the second instance, the second instances were started and rest...