Script 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 MoreThe below script is to disable the plan baseline. # @(#) # @(#) ==================================================================== # @(#) Disable the SQL plan baseline # @(#) # @(#) # @(#) Format: disable_plan_baseline.sql…
Read MoreThe below script is to enable the plan baseline # @(#) # @(#) ==================================================================== # @(#) Change SQL plan baseline attribute (set fixed to yes) # @(#) # @(#)…
Read More