Error: ======= while creating a database using Database Configuration Assistant (DBCA) the following error is encountered: “Recovery Manager Failed to Restore Datafiles Solution:-1 Check the compatibility of ASM & Database…
Read MoreHow to Backup ORACLE_HOME binaries and Oracle INVENTORY ORACLE_HOME and INVENTORY need to backup before Database / OS level patching Table of Contents ______________________________________ Backup ORACLE_HOME and INVENTORY 1. Shutdown…
Read MoreBelow is the script to compile all the INVALID objects and script to compile specific objects in oracle database. ************************************************************************************ SET SERVEROUTPUT ON SIZE 1000000 BEGIN FOR cur_rec IN…
Read MoreDB : Oracle 19.5 OS : RHEL 7 Expdp is failing due to the below error in my 19c database Export: Release 19.0.0.0.0 – Production on Thu Apr 30 06:06:42…
Read MoreScript to stop 12c Forms & Reports *************************************************************************** export MW_HOME=/u01/app/oracle/middleware export DOMAIN_HOME=$MW_HOME/user_projects/domains/ClassicDomain echo “Stop WLS_FORMS” $DOMAIN_HOME/bin/stopManagedWebLogic.sh WLS_FORMS echo “Stop WLS_REPORTS” $DOMAIN_HOME/bin/stopManagedWebLogic.sh WLS_REPORTS echo “Stop OHS” $DOMAIN_HOME/bin/stopComponent.sh ohs1 echo “Stop…
Read MoreIssue:- alert found into the alert logfile. Warning: VKTM detected a forward time drift. Time drifts can result in unexpected behavior such as time-outs. Please see the VKTM trace file…
Read MoreThe web-based Enterprise Manager tool was introduced in Oracle 10g and has significant functionality improvements over previous versions. How to solve an Enterprise Manager configuration issue, this article explains the…
Read MoreScript to start 12c Forms & Reports, ************************************************************************************ export MW_HOME=/u01/app/oracle/middleware export DOMAIN_HOME=$MW_HOME/user_projects/domains/ClassicDomain echo “Starting NodeManager” nohup $DOMAIN_HOME/bin/startNodeManager.sh > /dev/null 2>&1 & sleep 120 echo “Starting OHS” nohup $DOMAIN_HOME/bin/startComponent.sh ohs…
Read MoreORA-65259: partial synchronization of application is disallowed You have started application Sync but you find it is taking more time to complete this action. By mistake or purposely you did…
Read MoreCreate the Standalone reports server using WebLogic Scripting Tool (WLST) after 12c Forms & Reports installation. 1. Login WebLogic Scripting Tool, cd $ORACLE_HOME/oracle_common/common/bin ./wlst.sh 2. Connect to the AdminServer, connect(“weblogic”,”weblogic_password”,”hostname:7001″)…
Read More