Category Archives: Oracle Database

ORA-38706: Cannot turn on FLASHBACK DATABASE logging. ORA-38709: Recovery Area is not enabled. (#OracleDataguard)

Issue: When trying to turn on the flash back in Oracle database, it gives the below error, SQL> alter database flashback on; alter database flashback on *ERROR at line 1: ORA-38706: Cannot turn on FLASHBACK DATABASE logging. ORA-38709: Recovery Area … Continue reading

Posted in Oracle Database | Leave a comment

ORA-16664: unable to receive the result from a database

Issue: The “show configuration verbose” command in dgmgrl is showing the below error, when the primary database server was rebooted. KING_ADG – Physical standby database Error: ORA-16664: unable to receive the result from a database Cause:  The network between primary … Continue reading

Posted in Oracle Database | Leave a comment

ORA-16642: DB_UNIQUE_NAME mismatch while adding a Standby Database in DG Broker

Issue: ORA-16642: DB_UNIQUE_NAME mismatch while adding a Standby Database in DG Broker. DGMGRL> add database KINGADG as connect identifier is kingadg maintained as physical; Error: ORA-16642: DB_UNIQUE_NAME mismatch   Resolution: Make sure the DB_UNIQUE_NAME is different in all DBs (Primary and … Continue reading

Posted in Oracle Database | Leave a comment

make: Fatal error: Command failed for target `libnmemso’ while running “adlnkoh.sh” to relink Oracle Home

Issue: make: Fatal error: Command failed for target `/u01/app/oracle/product/KING/11204/sysman/lib/libnmemso.so’ Current working directory /u01/app/oracle/product/KING/11204/sysman/lib *** Error code 1 make: Fatal error: Command failed for target `libnmemso’ Failed linking targets agent /u01/app/oracle/product/KING/11204/sysman/lib Resolution: Try to relink the OH after performing “clone.pl”. cd /u01/app/oracle/product/KING/11204/clone/bin … Continue reading

Posted in Oracle Applications/Apps DBA, Oracle Database | Leave a comment

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