UAYOR – Use at your on risk. OS: Linux CentOS 5.4 CFS: OCFS2 - /u01 Oracle clusterware installation (11.1.0.6.0) finished successfully , but when trying to run root.sh in the first node I’m getting the following error: [root@prod10 oracle]# sh -x /u00/clusterware/11.1.0/crs/root.sh + /u00/clusterware/11.1.0/crs/install/rootinstall + /u00/clusterware/11.1.0/crs/install/rootconfig Checking to see if Oracle CRS stack is ...
The Query Processing category includes the statistics used to calculate the hit ratio for the database. In this post are just explained the most important. This information is related to the dynamic statistic table v$sysstat. The main purpose of this post is to add basic knowledge when trying to tune queries in oracle database environments ...
Clusterware internals Let to me make a brief introduction, the Oracle clusterware software is installed in the cluster with its own set of binaries. CRS Home and Oracle Home are in different locations, it means that there are two installations initially. The clusterware software installs and configures both the Voting Disk file and the OCR ...
UPDATE 02-JUL-2010 : Please read my white paper here. The effect of accessing blocks in the global cache and maintaining coherency is represented by “The Global Cache Service” statistics for current and cr blocks, for example, gc current blocks received, gc cr blocks received, and so on Much of these GC waits are blamed on ...
Parallel in standalone Databases The parallel options invoke multiple processes to utilize spare system resources to reduce the time required to complete tasks or jobs. The parallel options do not reduce the amount of resources required by the processing; rather, they spread the processing burden across multiple CPUs. In order to get the most benefit ...
11g Supports upgrades from 9i Releases 1 and 2 and Oracle Database Release 1 and 2. From Any version <= 9.0.1.4 You must upgrade to Oracle 10.2 using a supported upgrade path(s). It is not supported to upgrade to Oracle 11g from a direct migration unless you use import/export or SQL*Plus method. From: Any version ...
A time ago I found this ONT tutorial that describes how to use ADDM in a RAC environment to identify database level issues, and drill down to affected database instances. Database ADDM for RAC is not just a report of reports but has independent analysis that is appropriate for RAC. Downlaod the tutorial scripts from ...
11g R1 11.1.0.6 (from my old blog) The big red has enhanced Real Application Clusters in Oracle11g and we see many exciting new features, great work ! Oracle 11g RAC parallel upgrades A very challenging and complex 11g new feature. Oracle RAC load balancing advisor – Was introduced in 10gr2, in 11g we see a ...