apex_common.ksh function library

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

Leave a Reply

Your email address will not be published. Required fields are marked *