Category Archives: Oracle Database

Migrating 2 node RAC Cluster to new H/W and Adding a Failed Node back in RAC Cluster (#OracleRACAddNode, #OracleRAC)

Scenario: RAC Cluster Database which was setup on 2 nodes, needs a migration to new H/W. Also, adding to this, the 2nd node of RAC Cluster is dead just before this activity was started (& this 2nd node cannot be … Continue reading

Posted in Oracle Database, Oracle RAC | Leave a comment

ORA-39117: Type needed to create table is not included in this operation

Issue: ORA-39117: Type needed to create table is not included in this operation. Failing sql is: CREATE TABLE “MVDEMO2″.”CITIES_US” (“LOCATION” “MDSYS”.”SDO_GEOMETRY” , “CITY” VARCHAR2(42 BYTE), “STATE_ABRV” VARCHAR2(2 BYTE), “POP90” NUMBER, “RANK90” NUMBER) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS … Continue reading

Posted in OBIEE, Oracle Database | Leave a comment

PRVG-1011 : The CRS software versions found on cluster nodes “node1” and “node2” do not match on Linux

Issue: [TASKNODEADDDELETE]:TASK_SUMMARY:FAILED:CRITICAL:VERIFICATION_FAILED ERRORMSG(node2): PRVG-1011 : The CRS software versions found on cluster nodes “node1” and “node2” do not match INFO: *************** End of CVU Error logs *************** INFO: All forked task are completed at state performChecks Resolution: Make sure that … Continue reading

Posted in Oracle Database, Oracle RAC | Leave a comment

Exception in thread “AddNode API Thread” java.lang.OutOfMemoryError: Java heap space (#addnode.sh, #RAC, #Java.OutOfMemory)

Issue: I was trying to add a node in RAC environment using the below command; the prerequisites were all met and the copy portion of files was in progress. But, after some time, noticed that files were not being copied … Continue reading

Posted in Oracle Database, Oracle RAC | Leave a comment

ORA-17503: ksfdopn:10 Failed to open file, ORA-01017: invalid username/password; logon denied while logging in as sysdba or sysasm (#ORA-01017 #ASM)

Issue: The RAC environment has been migrated to new server with same ips and hostname; post migration, we are seeing below error messages while connecting to ASM instance and the CRS service was not coming up [asmora@hostname dbs]$ sqlplus / … Continue reading

Posted in Oracle Database, Oracle RAC | Leave a comment

ORA-14020: this physical attribute may not be specified for a table partition (#Oracle Partitions)

Issue: While I was Range Partitioning a table on 2 columns (Year) and (Month), I was stuck with the below error, ORA-14020: this physical attribute may not be specified for a table partition   Cause: Could be because of a … Continue reading

Posted in Oracle Database | Leave a comment

Purge BIPLATFORM Schema (S_NQ_ACCT) in OBIEE Database

Purge BIPLATFORM Schema in OBIEE: Analysis: In RCU Schemas of OBIEE, DEV_BIPLATFORM schema occupies decent amount of space if Usage Tracking is enabled. And out of which, LOBSEGMENT is the Object Type which would be consuming more space than the … Continue reading

Posted in OBIEE, Oracle Database | Leave a comment

Importance of OLR (Oracle Local Registry):

A component called “OLR” is introduced in 11gR2, which will be installed on every node of Cluster. This component is not shared by other nodes and is specific to the respective node. OLR will be setup when Oracle Clusterware is … Continue reading

Posted in Oracle Database, Oracle RAC | Leave a comment

Oracle Clusterware Concepts

Oracle Clusterware Concepts: Oracle Clusterware is the heart of Oracle RAC Database. Clusterware concepts are very important for a DBA to ride Oracle RAC Databases. The main concepts of Oracle Clusterware are as follows. Oracle Clusterware mainly has 2 components, … Continue reading

Posted in Oracle Database, Oracle RAC | Leave a comment

Applying patches to RAC environments (on Linux) in a rolling manner, with zero downtime to applications.

The scope of this post is to apply patches to RAC environments (on Linux) in a rolling manner, with zero downtime to applications. Pre-requisites RAC environment (2 or more nodes) Application should be RAC aware Refer the Note id (756671.1) … Continue reading

Posted in Oracle Database, Oracle RAC | Leave a comment