Readmeout Oracle DBA Blog Specifically Focusing on database administration, RMAN Backup and recovery, restore, cloning, performance tuning and sharing best practices.
Introduction:- In this article, we will lean how to how to EBS Restrict Applications Users To Be Signed In Only Once At Any Time. As we know that by default any given user can by default open multiple sessions with Oracle Applications. Use the following SQL to confirm if the event already exists and is … Read more
In this post we will resolve the ‘java.lang.OutOfMemoryError Java heap space’ issue while apply the Oracle WebLogic Server Patch Set Update 10.3.6.0.191015. Here we will know how to resolve out of memory error in java. Install bsu patches using sh bsu.sh install and resolve. Java.Lang.OutOfMemoryError java heap space issue Error:- Facing below error as ‘outofmemoryerror’ while executing … Read more
Introduction:- In this article, we are going to resolve ORA-12547 TNS lost lost contact error. Error:- ORA-12547: TNS:lost contact $ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Thu Mar 25 09:38:40 2021 Copyright (c) 1982, 2013, Oracle. All rights reserved. ERROR: ORA-12547: TNS:ost contact Above error can occur for many reason. In my … Read more
Introduction: – 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