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 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
Introduction: – The Likely cause of this issue is prefs.ora file is missing in Application user’s $HOME. We need to copy this to $HOME. Oracle Report Builder warning in r12 REP-0004 Warning Unable to open user preference file. Resolving REP-0004 Warning Unable to open user preference file. Error: – Showing … Read more
opmnctl opmn is not running| In this post describe how to resolve the opmnctl opmn failed to start a managed process after the maximum retry limit issue. Opmnctl opmn is not running. Scenario: Recently we have got error ‘Failed to start managed process after the maximum retry limit’ because copied IAS from different machine and try to start the … Read more
Suppose your index is not being used by SQL query with cost-based optimizer. Index monitoring allow you to easy identify the unused indexes (that are not being used) in oracle database. You can use alter index index_name monitoring command to enable the oracle index usage monitoring. Index usage monitoring Syntax to enable monitoring: – Once you … Read more