Below 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 MoreThe below script is to check Long running 12c forms in Forms Application server #!/bin/bash ############################################################################### # File Name : long_runn_forms.sh # Author : Vimal Raju # Date :…
Read MoreThe below script is to get metadata for all dblinks # @(#) ==================================================================== # @(#) Reverse engineering all database links # @(#) # @(#) # @(#) Format: reverse_all_dblinks.sql #…
Read MoreThe below script is to Disable constraints, SET PAGES 0 SET TRIMSPOOL ON SET LINES 200 set echo off set feedb off set trimspool on set verify off col…
Read MoreThe below script is to Enable constraints, SET PAGES 0 SET TRIMSPOOL ON SET LINES 200 set echo off set feedb off set trimspool on set verify off col…
Read MoreThe below script is to enable Archivelog and Flashback, set echo off set feedb off set heading off set verify off set trimspool on set lines 200 set define…
Read More