1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 | #!/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 - gets information from the v$database table# : creates variables to use in this script# Dev Notes : function to update the cluster and add clusters from here# : will be forthcoming, should be in the QA menu#---------------------------------------------------------------------------# Features 2 add :# This script need to check to see if the TNS entries are there for the APEX database# Add TNS names entries for the BRAIN1D database if not found# Also create a .env file dbadmin_apex.conf############################################################################# This is the menuing system for the DBA general stuff# automate a lot of the DBA tasks# Michael Culp 2010# Make sure the EOF end is aligned on the 1st column# If you want the sys password used, create the .syspasswd############################################################################# Next line uncomment for debugging purposes only# set -xv# Look for SQL Plus############################################################################qa_init(){echoecho "QA Init function......"echo}qa_dbrd(){echoecho "QA Dashboard function......"echo}qa_sho_cmd(){echoecho "QA Show commands and aliases....."echo} |