ORAXperts do appologize in advance for any inconvenience being caused to its readers while we complete transformation of our website. ORAXperts appreciate your co-operation.

I recently deployed Oracle RAC database 11.2.0.2 on three nodes 11.2.0.2 Oracle Grid Infrastructure and found that Oracle has introduced another virtual private IP, which runs on top of the private interface.
I am sure lots of you would have seen this extra IP in Oracle 11.2.0.2 Grid Infrastructure and definitely thought about it what is this extra IP for.

While installing Oracle Grid Infrastructure 11.2.0.2 on RHEL 5, I was getting error PRVF-5636.
Run the following command to check exact response time the DNS taking to resolve the non-existing domain name.As per error description, Oracle reports this error if DNS is not able to resolve the given domain name with in 15 seconds.

Oracle reboots the failed node to resolve the split-brain situation and to implement the node fencing. Oracle can not differentiate between an actual node failure or simply hanging node hence reboots the failed or hanging node to isolate it from the rest of the active cluster nodes. This is good but painful practice when users have large size clusters and cluster nodes reboot causing global resources to freeze during this node fencing operation.

Starting with Oracle Grid Infrastructure 11g Release 2 and onwards, Oracle uses Grid Plug and Play profile to store the important information to start the Oracle Clusterware such as name of the cluster, private and public interfaces and location of Voting disk.

Mostly developer underestimate the power of this wonderful PL/SQL package, which can help to identify the problematic code location in the application. This package is available from long time I think from Oracle 8i onwards and hasn’t got enough blessing from the developer community. I just create a simple test case to showcase the benefits of this package:

One o prerequisites to add another node into an existing Oracle 11g Cluster is to configure user equivalence for software owner used to install Oracle Grid Infrastructure. Traditionally database administrators configure this by creating RSA and DSA keys manually using keygen command. As you know that starting with Oracle 11g Release 2, Oracle introduced automatic SSH setup functionality via Oracle Universal Installer. In fact, Oracle Universal Installer internally uses this script sshUserSetup.sh located at sshsetup sub directory of Oracle Grid Infrastructure 11g Release 2 software.

Large enterprises are continuously under pressure to reduce overall operating cost of their IT systems to remain competitive in the global market. Storage is becoming cheap day by day and organizations want to store every possible data into the digital format. Knowing that in typical IT systems, mostly storage is allocated during the project implementation phase including expected storage growth for next few years. This extra storage remains idle for long time adding extra ownership cost to the organization.

Recently, I was approached by one of my customer’s dba team. They were migrating data from their production database running on Oracle DBMS to a Tera data database system. One column of type VARCHAR2 from the source table had multiple end of line and carriage return characters because that column was related to a comment field on the front end form. Tera data was not able to handle these special characters and was failing the import process.

The book Oracle Database 11g Oracle Real Application Clusters Handbook, 2nd Edition, which I have co-authored with K Goplakrishnan has been published by McGraw Hill and available in the market now.
This book is available on Amazon at Click Here