HSTCREATE – Host create scripts

Host common is a library of functions that will help to create, maintain, hosts involved with Oracle databases as well as other types of servers

This file should also have the

List of functions

HSTCREATE => hst_common.ksh
HSTCREATE – Library of creation scripts for creating and maintaining hosts
Linux_common.ksh should be used in this capacity to link in the necessary low-level scripts to perform

/oracle/admin/scripts/hstcreate – current production copy of the scripts
/oracle/admin/scripts/hstcreate/dev – development stuff

Using DBAdmin there are several functions that can be utilized for these purposes

hst_create.ksh –

[code language=”sql”]
initapex()
{

}

This function shows the banner of the script and the script name along with the arguments file
disp_banner_hst_cr ()
{
echo
echo "Host create script……….: hst_create.ksh"
echo "Host create arguments file..: hst_create.args"
echo
}

function next_menu
{
echo
echo "# ———————————————————————– #"
echo "[ … Press any key to continue … ]"
read next
}

init_apex ()
{

# Initialize the database access to DBAdmin
# Set this up on a separate database
export BRAIN1D='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=49125))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DBADMD01)))’
export DBADM='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=49125))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DBADMD01)))’
export DBADM42='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=49125))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=BRAIN1D)))’

export UsrPwd=’hc_core/somepassword’
export UsrPwd2=’dba01/somepassword’

}

host_apex_chk ()
{
####################################################################
# prereq is init_apex function should be included
# Set the hostname then search for the host record in APEX
# once you get the DBAdmin host record in mach_id
####################################################################
# grab the hostname
hst_nm=`hostname`

# echo $hst_nm
mach_id=`${ORACLE_HOME}/bin/sqlplus -s $UsrPwd2@$BRAIN1D <<EOF
set head off feed off pages 0 trimspool on
select MCH_ID from dba01.machine where MCH_NM=upper(‘$hst_nm’);
— select MCH_ID from dba01.machine;
— exit;
EOF`

mch_nm=`${ORACLE_HOME}/bin/sqlplus -s $UsrPwd2@$BRAIN1D <<EOF
set head off feed off pages 0 trimspool on
select MCH_NM from dba01.machine where MCH_NM=upper(‘$hst_nm’);
— exit;
EOF`

# Uncomment the next line for debugging purposes
# echo "DBAdmin record no…: "$mach_id

}

This is a directory checking function, if the directory doesn’t exists it creates it

chk_gen_dir ()
{
############################################################################
# Check to see if the directory to generate the files exists
# added /scripts to the end of the gendir to check
############################################################################
if [ ! -d $gendir/scripts ] ; then
# echo "Directory "${gendir}" does not exist"
print "\nDirectory ${gendir}/scripts does not exist"
print "\nDirectory ${gendir}/scripts needs to be created "
ans=
while [ -z $ans ]
do
echo -n "Create directory? ${gendir}/scripts "
read ans
done
if [[ $ans =~ ^[Yy]$ ]]
then
print "\n…Creating directory…."
# mkdir ${gendir}/scripts
# mkdir ${gendir}/scripts
print "\n…Not Creating directory in test mode…."
else
print "\n…Not Creating directory…."
print "\nExiting program"
exit
fi
else
print "\nDirectory ${gendir}scripts exists"
echo
ls ${gendir}/scripts

ans=
while [ -z $ans ]
do
echo -n "Do you wish to overwrite what is already generated? "
read ans
done

if [[ $ans =~ ^[Yy]$ ]]
then
print "\n…Continuing…………………………."
else
print "\n….Exiting program without creating scripts"
exit
fi

ans=
while [ -z $ans ]
do
echo -n "Proceed to script creation? "
read ans
done

if [[ $ans =~ ^[Yy]$ ]]
then
print "\n…………………………………….."
else
print "\n….Exiting program without creating scripts"
exit
fi

if [ ! -d $gendir/logs ] ; then
# echo "Directory "${gendir}/logs" does not exist"
print "\nDirectory ${gendir}/logs does not exist"
print "\nDirectory ${gendir}/logs needs to be created "
ans=
while [ -z $ans ]
do
echo -n "Create directory? ${gendir}/logs "
read ans
done
if [[ $ans =~ ^[Yy]$ ]]
then
print "\n…Creating directory…."
# mkdir ${gendir}/logs
# mkdir ${gendir}/logs
print "\n…Not Creating directory in test mode…."
else
print "\n…Not Creating directory…."
print "\nExiting program"
exit
fi
else
print "\nDirectory ${gendir}/logs exists"
echo
ls ${gendir}/logs

ans=
while [ -z $ans ]
do
echo -n "Do you wish to overwrite what is already generated? "
read ans
done

if [[ $ans =~ ^[Yy]$ ]]
then
print "\n…Continuing…………………………."
else
print "\n….Exiting program without creating scripts"
exit
fi

ans=
while [ -z $ans ]
do
echo -n "Proceed to script creation? "
read ans
done

if [[ $ans =~ ^[Yy]$ ]]
then
print "\n…………………………………….."
else
print "\n….Exiting program without creating scripts"
exit
fi

pauseit
clear
}

cr_hst_crontab ()
{
############################################################################
# Create the crontab entries
############################################################################

echo "…Creating crontab file entries……."
echo > crontab_${db_assn_name}.txt
cat << EOS >> crontab_${db_assn_name}.txt
Text goes here
EOS
}

cr_sysctl ()
{
echo "…Creating sysctl.conf recommendations……."
####################################################################################################
# Create the cr_<database name>_dbca.ksh script /oracle/admin/scripts/rspfiles
####################################################################################################
# echo > cr_${host_name}_sysctl.ksh
cat << EOS > cr_${host_name}_sysctl.conf
#!/bin/ksh
############################################################################
# Script Name..:
# Description..:
# Author…….: $auth
# Date………: $use_date
# Version……:
# Modified By..:
# Date Modified:
# Comments…..:
# Schema owner.:
# : alter session set current should be used to change schemas
# Login User…:
# Run Order….:
# Dependent on.:
# Script type..:
############################################################################

# Kernel sysctl configuration file for Red Hat Linux
#
# For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and
# sysctl.conf(5) for more details.

# Controls IP packet forwarding
net.ipv4.ip_forward = 0

# Controls source route verification
net.ipv4.conf.default.rp_filter = 1

# Do not accept source routing
net.ipv4.conf.default.accept_source_route = 0

# Controls the System Request debugging functionality of the kernel
kernel.sysrq = 1

# Controls whether core dumps will append the PID to the core filename
# Useful for debugging multi-threaded applications
kernel.core_uses_pid = 1

# Controls the use of TCP syncookies
net.ipv4.tcp_syncookies = 1

# Controls the maximum size of a message, in bytes
kernel.msgmnb = 65536

# Controls the default maxmimum size of a mesage queue
kernel.msgmax = 65536

# Controls the maximum shared segment size, in bytes
kernel.shmmax = 68719476736