Tag Archive: 11gR2

Extending RAC Database Home Hangs

Recently I had to extend the RAC database home of an existing RAC cluster to two new servers using addnode.sh and it was hanging at 100%. The particular version of the Oracle database is 11.2.0.3 running on Oracle Enterprise Linux 5.8.  I didn’t see anything in the log files but notice that the underlying java server process is consuming 100% of CPU when issuing top. I try restarting the addnode.sh step multiple times but I continue seeing the same behavior (even waiting more than 60 minutes with no progression). I start by increasing the Java heap size for the JRE used by the…
Read more

Adding New SAN Disks to ASM for OCR Disk Group

Recently we had to migrate our ASM disks to a new SAN.  In this particular post we’ll take a look at the steps we went through for the diskgroup that is used by our Oracle RAC servers for the Oracle Cluster Registry (OCR) and the voting files.  The environment is Oracle database 11.2.0.3 on Oracle Linux 6.4.  This particular diskgroup (we’ll call it OCR) was originally created with 3 disks with normal redundancy.  We provisioned 3 new LUNS from our new SAN to replace the current OCR disks. Note: The original disks were named VOL1 – VOL3 while the new ones…
Read more

XLA_GLT Tables Not Being Dropped in EBS 12.1.3

The Problem Recently I was going through a list of our top largest tables in our E-Business Suite (12.1.3) database (11.2.0.3) and found many tables in the GL schema that began with XLA_GLT_*.  Looking into this further I found over 300 of these tables (which also had indexes and synonyms) consuming over 30 Gigs of space.     Research After doing some research on My Oracle Support I found several articles that helped explain what we are seeing.  One of them in particular was a direct match to our problem, “SLA: Temporary Tables XLA_GLT_ % Are no Longer Dropped (Doc…
Read more

RMAN Duplicate Error with ASM and 4k Sector Size Disk

The Problem I recently ran into an issue when performing a RMAN duplicate on a server with a fresh installation of OEL 6.4 x86-64 using a brand new SAN (NetApp Data ONTAP 8.2).  The database version is Enterprise Edition 11.2.0.3. The datafiles restored without an issue but when we got to those archived redo logs I hit an ORA-00600.  Specifically it was this error. At first I chalked it up as a fluke, so I tried the RMAN duplicate again.  Well the datafiles restored just fine but once again when I got to the archived redo logs I hit the ORA-00600…
Read more