Readmeout Oracle DBA Blog Specifically Focusing on database administration, RMAN Backup and recovery, restore, cloning, performance tuning and sharing best practices.
In this post we will fix Unable to initialize state monitor Not able to create new database connection. oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Not able to create new database connection: FNDSECURITY_APPL_SERVER_ID In my case FND_NODES table and dbc file both have different SERVER_ID. Once I have updated the dbc file as FND_NODES , issue got resolved. … Read more
Introduction:- Here will cover how to fix collect2 ld returned 1 exit status. Below error occurs during relink while applying the patch in oracle database. See how to Issue the failed relink command: How resolve collect2 ld returned 1 exit status. Error:- collect2: ld returned 1 exit statusmake[1]: *** [/data02/1124home/sysman/lib/libnmemso.so] Error 1make: *** [libnmemso] Error … Read more
In this post we will cover ORA-48223 Interrupt Requested Fetch Aborted Return Code [12751] [HM_FINDING]. Error:- ORA-48223 Interrupt Requested Fetch Aborted Return Code [12751] [HM_FINDING] | Errors in file /data01/ORAHOME/log/diag/rdbms/ace/PROD/trace/PROD_m000_7649.trc: ORA-51106: check failed to complete due to an error. See error below. Fixing ORA-48223 Interrupt Requested Fetch Aborted à If anyone facing … Read more
In this post we cover how Restore and Recover the noarchivelog database. Suppose any datafile lost and we trying to recover the oracle database in noarchivelog mode, it will give the below error. Error:- Here we are facing error while recovering database. RMAN> recover database; Starting recover at 24-MAR-18 using channel … Read more
In this post we will cover how to fix ORA-00392 log of thread is being cleared, operation not allowed. How to fix ORA-00392 log of thread is being cleared Problem:- Solution:- Check current status of logfile. We can see here redo logfile group 3,4 & 5 is showing as clearing. So we need to clear … Read more
Resolve kkjcre1p unable to spawn jobq slave process. We are facing this issue while doing shutdown oracle database. Root Cause: – This situation occurs while we fire “shutdown immediate”in oracle database. Continuously error message is coming in alert log file. resolve kkjcre1p unable to spawn jobq slave process, slot 0, error 1089 in oracle database. … Read more
Introduction: – In this post we will cover how to check tablespace size in oracle database. Using dba_data_files and dba_free_space to check tablespace size. Follow the below steps to monitory the oracle database utilization. How to check tablespace size in oracle database Here I will explain how to check tablespace size in oracle. Every DBA … Read more
Introduction: – In this post we will learn Purge obsolete logs in oracle EBS r12. Purging is regular activity to clear old logs from log location. We can improve performance our database and apps to clear obsolete logs which is not required. Following command will help you in regular activity to Purge obsolete logs in … Read more
In this post I am going to describe you Oracle Database Monitoring Scripts for every DBA for oracle database. Oracle database health check:- Oracle Database Monitoring Scripts. DBA Daily checklists: 1: Health check of the Database. 2: Viewing the Alert log file to analyze the ORA errors if any. … Read more
LsInventory session failed: RawInventory gets null OracleHomeInfo | In Oracle EBS Instance, recently I have faced the error as lsinventory session failed while try to run ./opatch lsinventory in our Instance. OPatch wasn’t able to find the database home in central Inventory, due to this issue (opatch failed with error code 73) unable to do the … Read more