When i got a request to apply a patch, i did a prereq check and faced the below error. RAM:oracle$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version…
Read MoreApplies to: Oracle Application Object Library – Version 12.1.1 to 12.1.3 [Release 12.1] Information in this document applies to any platform. Symptoms Unable to login R12 Applications with Sysadmin user…
Read MoreBelow script is for finding the Apex Page Time ********************************************************************************************************** /home/oracle/backup/scripts/pagetime.sh . /home/oracle/db.env export SC_LOG=/Backup/pagetime/fms_`date +%d_%b_%Y_%H_%M`.log sqlplus -s <<EOF >>/usr/tmp/tmp2.log connect /as sysdba spool \$SC_LOG select flow_id,step_id,sum(elap)/count(*) “Average” from FLOWS_030100.WWV_FLOW_ACTIVITY_LOG…
Read MoreWe can use the below script for moving files (like export dumps/RMAN backups) to FTP server for safety purpose. ******************************************************************************************************************** cat /TESTDB/app/bkp_scripts/test_sunday_to_ftp.sh . /home/oracle/test.env USERNAME=”—-Enter your username here—-” PASSWORD=”—-Enter your…
Read MoreError: ======= 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 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 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 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 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 MoreCreate ReportsToolsInstance in 12c Reports 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 AdminServer, connect(“weblogic”,”weblogic_password”,”hostname:7001″) 3.…
Read More