#!/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() { echo echo "QA Init function......" echo } qa_dbrd() { echo echo "QA Dashboard function......" echo } qa_sho_cmd() { echo echo "QA Show commands and aliases....." echo }