I am trying to upgrade all of our databases from 11.2.0.2 to 11.2.0.3 this year. My first upgrades were on a 2-node RAC primary with 2-node RAC standby database in a testbed. There isn’t much to this database as it is just a starter database. But this let me test out the upgrade on RAC …
Category: RAC
Jan 10
Changing SYS password in RAC
I recently came across this blog post about changing the SYS password in RAC databases: http://marioalcaide.wordpress.com/2011/05/24/changing-sys-password-in-rac-databases/ The author of this blog post makes the claim that the “SYS password is instance specific in RAC databases”. This claim is incorrect. I posted a comment to prove this falseness of this statement and offered the real culprit …
Dec 19
Extend EM Grid Control to New Nodes
If you’ve followed some of my recent posts, you know that I have been working on extending my existing RAC database cluster to new hardware. I now have my instances running on the new nodes. My applications are now connecting to the new instances. It’s now time to work on some of the behind-the-scenes items. …
Dec 18
Manually Add New RAC Instance
To start this post, I will say that if at all possible, you should use the DBCA to add a new instance to your RAC database. The DBCA will take care of all of the details for you. It’s a simple 6-page wizard and your new instance is up and running on your new node. …
Dec 03
ORA-01264 in Physical Standby
I am in the process of replacing hardware for an existing 3-node RAC cluster. This system is also a primary to a 2-node RAC standby database. To replace the hardware, my plan is to temporarily extend the cluster into a 6-node configuration, 3 old servers and 3 new servers. Once I have the instances running …
Aug 21
Relink Grid Infrastructure
I recently had to work with my SysAdmin on a minor OS upgrade on a two-node RAC cluster. I am running Oracle Grid Infrastructure 11.2.0.2 with Oracle RDBMS 11.2.0.2 and we were upgrading from Oracle Enterprise Linux 5.2 to 5.8. As most Oracle DBA’s know, it is a good idea to recompile the Oracle software …
Apr 30
_gc_fusion_compression
I found this very cool blog post which discusses how Oracle decides how much of a datablock to transmit across a RAC cluster interconnect: http://orainternals.wordpress.com/2012/04/29/_gc_fusion_compression/ Get the right amount of low cost levitra exercise.Getting adequate exercise is important for informing and using protection. The Recommended Dosage of Kamagra Jelly Kamagra Jelly may outcome with austere …
Apr 26
Blackouts with EMCLI
In my previous post, I talked about how to set a Enterprise Manager blackout with the Agent’s emctl utility on the command line. Everything was working fine until I tried to set a blackout with a clustered database. When trying to set a blackout on a clustered database target you will get an error similar …
Nov 11
Installing RAC for a Database with Datafiles
Not that long ago, I needed to upgrade Oracle Clusterware and RDBMS from 11.1.0.7 to 11.2.0.2. I have tons of experience with the Oracle RDBMS software, but I suspect that I am like most DBA’s in that my Clusterware experience is not at the same level as my RDBMS experience. So while I had no …
Jul 19
ORA-4031 errors with Direct NFS
This is an old problem for me which I resolved quite a while ago, but I figured I’d finally write it up. When I started at my new company, the production database would crash about once a month with ORA-4031 memory errors. The current DBA figured the problem was lack of bind variables in application …