Readmeout Oracle DBA Blog Specifically Focusing on database administration, RMAN Backup and recovery, restore, cloning, performance tuning and sharing best practices.
Oracle Apps Administration categories is related to EBS issues and solutions.
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
CREATE TABLE– Using create table we can create empty table in oracle database. SQL create table syntax. We all are aware that table is very important object in each and every database, so let start creating table in database. CREATE TABLE is the key word telling database to create new table in … Read more
Here we will Restore rman backup to different server with different database name. Perform backup on production server and we will restore it on any QC,DEV or UAT server. We have taken “RMAN backup” of PROD and will restore rman backup to different server with different database name. Let’s take two servers … Read more
Here we will discuss about requirement configure shell script, configure shell script to backup & schedule shell script for rman backup script to complete rman full backup using crontab in Linux, Solaris and Unix platform. Cron job will be triggered as per scheduled time. How to schedule shell script for rman backup? In this … Read more
In this post we will understand how to execute root.sh and orainstroot.sh scripts and What is the importance of executing orainstRoot.sh and root.sh scripts . Post installation steps, we have to execute two scripts ‘orainstRoot.sh’ and ‘root.sh’ scripts and Oracle also suggest backing up the ‘orainstRoot.sh’ and ‘root.sh’ scripts. These two scripts we should execute as ‘root’ user as it … Read more
Resolved printing lp and lpr return unauthorized error and MSG-00002: reject in Linux CUPS print server. Many times, Invoice printing failed as lp: Unauthorized below while ebs user’s trying to print from oracle application. Here I will show how to resolve lp: Unauthorized issue in CUPS Server printers.conf setting. Error showing in ebs Request log. … Read more