Header for MRCENV file
[code language=”sql”] ############################################################################# # Script name..: mrcenv # Description..: environment file for mrc consulting llc # : use this file so as not to impact / change # : customer .profile or .bash_profile # Customer…..: <customer name> ############################################################################# # Author…….: Michael Culp # Contact……: # Phone/text…: 864.999.9999 or 864.999.9999 # email……..: mike.culp@gmail.com # Created……: 10/16/2007 […]
.kshrc and .bashrc for persistent settings
In order to get set -o vi This should be set at the .kshrc or .bashrc level [code language=”sql”] # M Culp # .kshrc # Source global definitions if [ -f /etc/kshrc ]; then . /etc/kshrc fi # use emacs editing mode by default # set -o emacs set -o vi # User specific aliases […]
gi_common.ksh
[code language=”sql”] ########################################################## # # MCulp 06/2019 # gi_common.ksh # Author: Michael Culp mike.culp@gmail.com # : 864-630-2118 # ########################################################## gi_init() # Set parameters here for other functions to use { clear echo echo "Test…" echo GRID_HOME=/manh/oracle_crs/product/18.1.0/crs_1a } gi_net_test() { scnm=$1 clear echo echo "Testing "$scnm" 6 times" echo # nslookup fadmanh18-scan nslookup $scnm nslookup $scnm […]
space.ksh
[code language=”sql”] #!/bin/ksh ############################################################################# # # # FILENAME: space.ksh [ORACLE_SID] # # # # Purpose: Generate a space report for an Oracle instance. # # # # This report will work for Versions 8i, 9i,10g,11g,12c of Oracle. # # # # Parameters: Passing the ORACLE_SID is optional. If left off, it will # # run […]
QA Common Library
[code language=”sql”] #!/bin/ksh ############################################################################ # Script Name..: qa_common.ksh # Description..: # Author…….: Michael Culp # Date………: 04/20/2013 # Version……: .08 # Modified By..: Michael Culp # Date Modified: 11/02/2015 # Comments…..: # Schema owner.: # Login User…: # Run Order….: # Dependent on.: # Script type..: # : # Functions : next_menu # : get_db_details […]
tablespace.sql
[code language=”sql”] set head off pagesize 0 linesize 500 (select dbname from v$database) || ‘,’ || tablespace_name || ‘,’ || round(current_usage_gb) space_used_gb || ‘,’ || round(current_free_gb) || ‘,’ || round(maxgb) from ( with tbsname as ( select tablespace_name from dba_tablespaces ), auto_ex_no as ( select tablespace_name,bytes maxbytes from ( select tablespace_name , sum(bytes) bytes from dba_data_files […]
table_degrees.sql
[code language=”sql”] set linesize 200 col owner for a39 col table_name for a39 select (select db_unique_name from v$database) dbname,owner, table_name, degree from dba_tables where degree > 1 and owner not in ( ‘APPQOSSYS’, ‘DBA_RO’,’DBSNMP’,’DIP’, ‘FOGLIGHT5X’,’FOGLIGHT5′, ‘GEMS_READ’,’ORACLE’,’ORACLE_OCM’, ‘OUTLN’,’SQLTXADMIN’,’SQLTXPLAIN’,’SYS’, ‘SYSTEM’,’WMSYS’,’TRCANLZR’,’PERFSTAT’, ‘SITEADM’,’QUEST’,’INETDBA’,’ORACHK_CM’,’FLOW_FILES’,’APEX_040200′ ) order by owner; [/code]
check_ac.sql adv compression
[code language=”sql”] set head off set feedback off set serveroutput on whenever sqlerror exit; set termout on set scan off set linesize 128 declare v_hostname sys.v$instance.host_name%TYPE; v_dbname sys.v$database.db_unique_name%TYPE; v_db_role sys.v$database.database_role%TYPE; ex_custom exception; rowcnt number := 0; v_message varchar2(50); v_installed number := 0; v_used number := 0; v_ac_cnt number := 0; sql_stmt1 varchar2(1000) := ‘WITH […]
Cleanup Script
[code language=”sql”] #!/bin/ksh ############################################################################ # Script Name..: cleanup_audit_files.ksh # Description..: Script to delete .aud and .xml logs older than 1 day. # Author…….: # Date………: 02/06/2014 # Version……: # Modified By..: # Date Modified: # Comments…..: # Schema owner.: # alter session set current # Login User…: # Run Order….: # Dependent on.: # Script […]
Install SQLT Script
[code language=”sql”] #!/bin/ksh # # Script to install SQLT # # — usage: /oracle/admin/scripts/install_sqlt.ksh <DBNAME> # #################################################################################### DBNAME=$1 APP_ID=$2 log=/oracle/admin/scripts/install_sqlt_$DBNAME.log mkdir -p /ora01/SQLT/$DBNAME cp /oracle/admin/scripts/sqlt.zip /ora01/SQLT/$DBNAME cd /ora01/SQLT/$DBNAME unzip sqlt.zip cd /ora01/SQLT/$DBNAME/sqlt/install sqlplus -s "/ as sysdba" <<EOF @sqdrop.sql exit EOF sqlplus -s "/ as sysdba" <<EOF @sqcinternal.sql exit EOF exit [/code]