Sajid Quamer

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