Configuring Oracle Apex on 11gR2

Might ask why you would want to run Apex?  Well Apex is a very power sql driven application module that allows even the noob to advanced programmer the ability to code and create useful pages/applications.  I personally don’t have any experience with Apex from a programming standpoint and decided to at least install it to […]

Change compatibility 11.2.0.3 Exadata – SIMPLE

Here is the quick, simple fool proof method to changing the compatibility parameter in the Oracle database in the Exadata configuration.  As is with most changes that can have a heavy impact on the database and its data, it is recommended to take a full backup before performing such changes. Following the below steps will […]

Hugepages on Exadata? Yes and No… part1

The topic of enabling hugepages on our Exadata environment.  Just opened an SR with Oracle Support to get some clarification.  I know that it is not enabled on the database servers, but is on the cell servers. Here you can see the database version we are using: Here you can see that hugepages in /etc/sysctl.conf […]

Creating multple database users with bash script (read from file)

I was just asked to create a large number of users in a database.  All of them with same default password and basic connect privileges. Rather than doing this hundreds of times I wrote a simple bash script to do it all for me. Here is the code:********************************************************* #!/bin/bash/ ######################################### Created by Michael Wilson# Created […]

SEV 1 SR – 8 Node Exadata Database Hang – Update 3

Before I get to the workaround that we are currently using in the event this happens, I would like to share with you that we are having the problem.  Oracle is still having us perform actions.  I’ll provide you what we are doing first, then I will share the workaround. Oracle wanted us to enable […]

Resetting the database incarnation using RMAN

Why would you need to reset the database incarnation?  There are only 2 scenarios.   You are attempting a restore or recover of the database to an SCN to a point in time before the resetlogs command was issued. You are trying to rewind the database to a point in time using flashback database to a […]

Continuous Physical Data Block Corruption Issues – post 3

We have officially resolved our physical data block corruption.  The final action plan provided by My Oracle Support came 8 days after SR creation, several escalations and manager phone calls as well as being assigned to an “expert” data corruption specialist. The solution = copy datafile that contains the corrupt blocks from the physical standby […]

Continuous Physical Data Block Corruption Issues – post 2

So the issues are still persisting in the system.  We still have 3 corrupt data blocks (123456, 123457, 123458).  Only 1 data file is still affected (100).  Here are some of the latest steps that Oracle Support has requested from us: ##################################################Generic Note————————1- Please run the sundiag.sh on each of your exadata cells and upload […]

Recovering from Physical Database Block Corruption

We were performing an incremental backup of our production database when  it failed due to physical block corruption.  This is an 8 node exadata system with an 8 node physical standby and dataguard.  To correct the database physical block corruption we performed the following steps.  Hope this is helpful for others who have experience this […]