Function library called apex_common.ksh (rename it later)
Functions include currently:
######################################################
# SECTION
# Initialize section
# and test functions
#
# mrctest
# root_setup
# init_apex
######################################################
# SECTION GENERAL DB
# Initialize section
# and test functions
#
# db_fixes_ver
######################################################
# SECTION APEX SPECIFIC
# Initialize section and test functions
#
# apex_hc
# lst_db - needs init_apex fn executed first
# lst_db_all
# lst_db_full
# count_db
# count_cls
# count_mch
# find_db
# find_mch
# find_cls
#########################
# Utility
#
# cnt_yn
# gen_srv_lst
# gen_srv_lst_verbose
# lst_type_hm ()
# lst_type_dir ()
# lst_db_apex_id ()
# db_rec_parm()
# db_psu
# sho_env - THIS MAY BE DUPLICATE
# sho_alias - THIS MAY BE DUPLICATE
# ins_audit_old ()
#################################################################
# ASM Section
#
# asm_disk
# asm_disk_sysasm
# sho_asm_disk
# asm_unbal
# asm_dsk_sze
# asm_0002
# asm_disk_ops
# asm_test
######################################
# Utility section #2
#
# chk_sqlp
# next_menu
# chk_sys_pass
# run_sql_statement
# dir_chk
# dir_chk_cr
# remote_connect
# db_switch
######################################################################
# Utility section #3
#
# initialize
# init_mrc
# gen_db_lst
# crs_srv_lst_cfg
# crs_sho_srv_cfg_home
# crs_sho_srvctl_cfg
# crs_sho_srvctl_stat
# crs_sho_srvctl_db_stat
# test_vip
# ocr_chk
# find_db_02
#####################################################################
# Utility functions
#
# save_env
# sho_env
# rest_env
# disp_inst
# rest_save
# chk_db_nm2dblst
# sho_insts
# chg_inst
# chk_db_running
# get_crs_clust_name
# insertMCH_InCentralRepository
# updt_mch_InCentralRepository
# mch_InCentralRepository
# get_inst_details
# insertInst_InCentralRepository
# inst_InCentralRepository
# get_db_details
# update_mach_details
# update_db_details
# cpu_usage_02
# sho_db_details
# updt_db_InCentralRepository
# db_InCentralRepository
# insertDB_InCentralRepository
# insertDB_APEX
# mrc_readdb
# mrc_upd_disk
###########################################################
# Cluster functions
#
# cls_qa_chk () - Cluster QA check
# cls_qa_upd () - Update the cluster record
# cls_qa_rev ()
# cls_rec_disp ()
# db_qa_chk ()
# db_qa_upd()
# db_qa_rev()
# sho_db_ver() - Show database version
# find_db2()
# sho_cls()
# sho_apex_db
# sho_apex_app
###########################################################
# DB Utility
#
# db_ind_size
# db_size_comp
# db_size
# db_loop_inst - Loop through the database instances
# db_stub - Stub function
# dashboard - This is the dashboard function
# menu_sel_text
###########################################################
# ORAchk section
# init_orachk - Sets up the variables needed for running the ORAchk stuff
# start_orachk - Starts ORAchk daemon
# get_all_parms_orachk - Shows all of the parms for ORAchk
# status_orachk - Shows the status of ORAchk
# stop_orachk - Stops the ORAchk daemon
# version_orachk - Shows the version of ORAchk
# all_orachk
# orachk --help
###########################################################
# dcli_ver
# dcli_hlp
# init_exp
# init_exp_scp
# BatchExpert
# Batch_Expert_scp
# dir_cr_apex
# dir_cr_cls
# ins_audit
# clustat
# sho_webdb
# sho_dir
# init_oem
# oem_stat_agt
# oem_stat_agt_hb
# oem_stat_sched
# oem_stat_sched_db
# tblspc_used
# enable_bct
# use_lrg_pgs
# fts_mrc
# lst_dba_users
# lst_any_apex_users
# lst_dba_sys_privs
# add_tgt
# huge_pages
# sho_huge_pages
# sho_alias
# sho_memory
# sho_sysctl
# must_gather
# usage_mg
awr_stats_mrc_fn.ksh - Is the function that uses the functions listed below
# awr_set_env
# awr_get_ver
# awr_inst_no
# awr_dbid
# awr_max_snap
# awr_min_snap
# awr_stat_10 - AWR Stats for Oracle version 10g
# awr_stat_11 - AWR Stats for Oracle version 11g
# awr_stat_12 - AWR Stats for Oracle version 12c
main_menu
menu_02
menu_03 -
menu_perftune - Performance tuning menu
menu_tmplt - menu template
test_load - test load function from the DPODS project
sess_trc - Session trace could be very useful
trnc_tbl - Truncate table function
sho_const - Shows the contraints
buff_blast - This will clear the buffer for the SGA
cannot_use_thi_sql_id_mrc() - Needs some work
find_sql_ids - Find SQL IDs
sho_plan_sql_id - Shows the plan from a SQL ID
Sho_db_param - Shows the current database parameters
Sho_dbid - shows the current database dbid
sho_dbid_fn.ksh - Script that uses the function
chg_awr_days - takes 2 parameters, db_id and retention value in minutes
chk_fra - Check and sho the FRA space
sho_dir_s20 - show the directory for scripts from
chk_interconn - Check the interconnect
chk_interconn_fn.ksh - Script that uses the function
chk_svcs - check the services of a database
#################################################
DDL_COMMON.ksh
#################################################
lst_objs_all
lst_objs_schm - List all objects by schema, schema is the parameter
lst_objs_schm_tbls - uses the LIKE
lst_objs_PIPER
test_conn_user - test what they can read as $1 user, $2 pword
cnt_CST_L01_OWNER
cnt_PIPER_D11_OWNER
qry_template_function
lst_users
lst_all_users
drp_app_users
sho_users
sho_quotas
sho_sessions
sho_session_02
chg_quota_PIPER_D11_OWNER
chg_pword_PIPER_D11_STAGING
chg_pword_all_PIPER_D11
qry_01_test
qry_02_test
qry_03_test
qry_04_test
qry_05_test
qry_06_test
qry_07_test
qry_08_test
chg_pword_all_CST_L01
chg_pword_all_MISITE
chg_pwd
obj_cnt
grant_piper_d11_user_role
cr_ctrl_hst_tab
cr_cntrl_tab - original function NOT USED anymore
test_ctrl_tab
sho_stg_tbl_cnt
sho_tbl_cnt_core
sho_trigger_cnt
sho_seq
grnt_role
test_conn_user
test_conn_core_tbl
cr_dba_gg_tst_usr
cr_dba_gg_tst_objs
sho_gg_test_tbl
test_gg_ins
test_gg_upd
gg_stat
gg_start_extr
gg_cr_extr_parm
gg_cr_repl_parm
test_gg_del
cr_180_trunc
cr_180_stats
test_query_11
gg_chk_ddl
sho_roles
sho_all_db_roles - Shows all roles in the database
cp_ddl_com
sho_db_param
sho_svcs
const
cp_piper_dev
cp_piper_exa_TT
cp_piper_exa_PD
cp_piper_ddl_com_dev
DBADMIN_APEX.ksh