Readmeout Oracle DBA Blog Specifically Focusing on database administration, RMAN Backup and recovery, restore, cloning, performance tuning and sharing best practices.
Sajid QuamerIntroduction: – In this article we will resolve error ORA-39065 unexpected master process exception in DISPATCH. While exporting table in oracle using datapump, facing error ora-39065. How to resolve ORA-39065 unexpected master process? Execution: – Export Logs: – After executing the data pump utility expdb to export the table, below errors ORA-39065: unexpected master process … Read more
Introduction:- In this article we will learn how to resolve the ORA 39213 metadata processing is not available error while trying to export the table in oracle using dataPump utility. Using Datapump utility we can export/import any database objects in oracle. While doing the facing error ORA 39213 metadata processing. Exporting table using DataPump. $expdp … Read more
Introduction:- In this article, we will resolve the ORA 19502 write error.In logs showing as RMAN abort with ORA-19502: write error on file and ORA-27072: File I/O error. Below error coming while trying to restore the oracle database using RMAN backup. channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore … Read more
Introduction:- In this article, we will ugrade jdk with oracle database using opatch apply. Before upgrade the JDK, need to verify the correct version. Before we go to upgrade the JDK . First of all need to check the existing jdk version. Check jdk version. $ORACLE_HOME/jdk/bin/java -version Currently we have … Read more
Introduction: – In this article, we will resolve the error ‘Terminating the instance due to error 16038’. Encountered the error while trying to open the database. How to fix Terminating the instance due to error 16038. I have encountered the error while trying to open the database. To successfully startup the database we need to clear … Read more
Introduction:- In this article, we will learn how to export and import database objects using datapump in oracle. Steps to execute Datapump (expdb,impdp). Data Pump utility to export/import database objects. Oracle Data Pump is a newer, faster and more flexible alternative to the traditional “exp” and “imp” utilities used in previous Oracle versions. In addition to … Read more
Introduction:- In this article, We will resolve the issue ‘Unable to read the value of s_file_edition_type from the context file’. After executing checkMTpatch.sh on appsTier we will face this error. Execution:- If you are planning to upgrade R12.1.X to R12.2.X. After executing checkMTpatch.sh on appsTier getting below error. Solution:- If you are running the utility … Read more
Introduction:- In order to start Node Manager in r12.2. We must be use adnodemgrctl.sh script. adnodemgrctl.sh: exiting with status 0 Steps to start Node Manager:- Before start the node mnager we will ensure no any previous sessoin on server. Use ps -ef|grep <OS_User> Source run environment:- $. /xxx/fs1/EBSapps/appl/APPSPHASE1_xxxtest.env cd $ADMIN_SCRIPTS_HOME $sh adnodemgrctl.sh start … Read more
Introduction:- In this article, we will cover how to start admin server on patch file system in EBS. To start/stop admin server, we must be using the command adadminsrvctl.sh. How to start admin server on patch file system. To understand How to start admin server on patch environment. we must be use forcepatchfs option as … Read more
Introduction: – In this article, we will learn how to fix error ORA-20099 E-Business Suite Patch Edition does not exist. Due to this error failed DB connection, it was unable to read Topology model for correct TNS config. How to fix ORA-20099 E-Business Suite Patch Edition does not exist. To resolve ora-20099, we need follow … Read more