Category Archives: Oracle Database

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

Sysaux Tablespace growing Huge – SM/OPTSTAT, SM/AWR

There are some beautiful note ids in Oracle, which talks about the purging strategy of Sysaux. I’ve put together few note ids which will be of help for quick reference. Below are the details, Suggestions if Your SYSAUX Tablespace Grows … Continue reading

Posted in Oracle Database | Leave a comment

ORA-27125: unable to create shared memory segment

Issue: The below issue has been observed in Oracle Database 12c (in specific 12.1.0.2) on AIX OS, when LOCK_SGA parameter is set. SQL> startup ORA-27125: unable to create shared memory segment IBM AIX RISC System/6000 Error: 1: Not owner   … Continue reading

Posted in Oracle Database | Leave a comment

rtld: 0712-001 Symbol CreateIoCompletionPort was referenced $ORACLE_HOME/lib/libttsh12.so(), but a runtime definition of the symbol was not found.

Issue: While connecting to Oracle Database from IBM AIX Operating system, the below errors were noticed. $ Sqlplus ‘/ as sysdba’ Could not load program sqlplus: rtld: 0712-001 Symbol CreateIoCompletionPort was referenced from module /mnt/oracle/oradb/product/12.1.0.2/lib/libttsh12.so(), but a runtime definition of … Continue reading

Posted in Oracle Database | Leave a comment