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

Start with....

select :WORKSPACE_ID from dual;

In the SQL Workshop's "SQL Command Processor" to determine your workspaces workspace_id (also known as a security_group_id internally).  Assuming that query came back with a value of 12345, you could then run a block like.


BEGIN
    wwv_flow_api.set_security_group_id(p_security_group_id=>12345);

    wwv_flow_fnd_user_api.create_fnd_user(
    p_user_name     => 'regular_user',
    p_email_address => 'myemail@mydomain.com',
    p_web_password  => 'regular1') ;

    wwv_flow_fnd_user_api.create_fnd_user(
    p_user_name       => 'developer_user',
    p_email_address   => 'myemail@mydo.com',
    p_web_password    => 'dev1',
    p_developer_privs => 'ADMIN') ;

end;
/

Create page items

Ready for Action?

LET'S GO!
Copyright 2024 IT Remote dot com
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram