Drop ASM Diskgroup in Oracle 19c.
Follow the below steps to drop the ASM Diskgroup. 1. Check the ASM diskgroup. 2. Drop ASM diskgroup. 3. Check the disk dropped from from ASM Diskgroup 1. Check the…
Read MoreCreate ASM Diskgroup in Oracle 19c
Follow the below steps to create the ASM Diskgroup. 1. Create ASM disk. 2. Check the ASM disks. 3. Create ASM diskgroup. 4. Check the newly added disk in ASM…
Read MoreScript to compile all the INVALID objects and script to compile specific object type
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
Script 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
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 Standalone reports server in 12c Reports using WebLogic Scripting Tool (WLST)
Create 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)
Create 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 MoreScript to check Long running 12c forms in Forms Application server
The 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 MoreScript to get metadata for all dblinks
The below script is to get metadata for all dblinks # @(#) ==================================================================== # @(#) Reverse engineering all database links # @(#) # @(#) # @(#) Format: reverse_all_dblinks.sql #…
Read MoreScript to Disable constraints
The 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 More