ORACLE Configuration

# ------------------------------------------------------------------------
su - oracle

# ------------------------------------------------------------------------
# Version Variable
# ------------------------------------------------------------------------
#

ORA_VER_INST="11.2.0.4"
ORA_VER_INST="12.1.0.2"
ORA_VER_INST="12.2.0.1"
ORA_VER_INST="12.2.0.2"
ORA_VER_INST="18.1.0.1"
ORA_VER_INST="18.1.0.2"
ORA_VER_INST="18.2.0.1"
ORA_VER_INST="18.2.0.2"
ORA_VER_INST="18.3.0.1"
ORA_VER_INST="18.3.0.2"
ORA_VER_INST="18.4.0.1"
ORA_VER_INST="19.1.0.1"
ORA_VER_INST="19.2.0.2"
ORA_VER_INST="19.3.0.1"

# ------------------------------------------------------------------------
# Oracle Edition
# ------------------------------------------------------------------------
#

ORA_EDITION="db_SE_01"
ORA_EDITION="db_SE1_01"
ORA_EDITION="db_SE2_01"
ORA_EDITION="db_EE_01"
ORA_EDITION="db_PE_01"
ORA_EDITION="db_XE_01"

# ------------------------------------------------------------------------
# SRV01 - ORACLE
# ------------------------------------------------------------------------
#

cat > /home/oracle/.cdb1 <<EOF
# Variables Of Environment ORACLE [ ORACLE ]
export TMP=/tmp
export TMPDIR=\${TMP}
export HOST=\`hostname\`
export UPTIME=\`uptime | sed 's/.*up \([^,]*\), .*/\1/'\`
export ORACLE_HOSTNAME=\${HOST}
export ORACLE_BASE=/u01/app/oracle
export ORACLE_VERSION=${ORA_VER_INST}
export ORACLE_EDITION=${ORA_EDITION}
export ORACLE_HOME=\${ORACLE_BASE}/product/\${ORACLE_VERSION}/\${ORACLE_EDITION}
export GRID_HOME=/u01/app/\${ORACLE_VERSION}/grid
export ORACLE_TERM=xterm
export ORACLE_UNQNAME=cdbprod
export ORACLE_SID=cdbprod
export GRID_SID="+ASM"
export OGG_HOME=\${ORACLE_BASE}/product/ogg_19c
export TFA_HOME=\${ORACLE_HOME}/suptools/tfa/release/tfa_home
export OCK_HOME=\${ORACLE_HOME}/suptools/orachk
export OH=\${ORACLE_HOME}
export DBS=\${ORACLE_HOME}/dbs
export TNS=\${ORACLE_HOME}/network/admin
export OGG=\${OGG_HOME}
export TFA=\${TFA_HOME}
export OCK=\${OCK_HOME}
export ORATOP=\${ORACLE_HOME}/suptools/oratop/oratop
export OPATCH=\${ORACLE_HOME}/OPatch
export JAVA_HOME=\${ORACLE_HOME}/jdk
export PS1=\$'[ \${ORACLE_SID} ]|[ \${LOGNAME}@\h:\`pwd\`: ]\$ '
export PATH=\${PATH}:/usr/sbin:/usr/bin:/sbin:/bin:\${ORACLE_HOME}/bin:\${GRID_HOME}/bin:\${OPATCH}:\${ORACLE_HOME}/perl/bin:\${JAVA_HOME}/bin:\${OGG_HOME}:\${TFA_HOME}/bin:\${OCK_HOME}/
export LD_LIBRARY_PATH=\${ORACLE_HOME}/lib:\${ORACLE_HOME}/perl/lib:\${GRID_HOME}/lib:/lib:/usr/lib
export CLASSPATH=\${ORACLE_HOME}/JRE:\${ORACLE_HOME}/jlib:\${ORACLE_HOME}/rdbms/jlib
export ALERTDB=\${ORACLE_BASE}/diag/rdbms/\${ORACLE_UNQNAME}/\${ORACLE_SID}/trace/alert_\${ORACLE_SID}.log
export ALERTDG=\${ORACLE_BASE}/diag/rdbms/\${ORACLE_UNQNAME}/\${ORACLE_SID}/trace/drc\${ORACLE_SID}.log
export ALERTGG=\${OGG_HOME}/ggserr.log
export ALERTASM=\${ORACLE_BASE}/diag/asm/+asm/\${GRID_SID}/trace/alert_\${GRID_SID}.log
export LSNRCTL=\`ps -ef | grep tnslsnr | grep -v "grep" | wc -l\`
alias dblog='tail -f \${ALERTDB}'
alias dglog='tail -f \${ALERTDG}'
alias gglog='tail -f \${ALERTGG}'
alias asmlog='tail -f \${ALERTASM}'
alias sqlplus='rlwrap sqlplus'
alias s='rlwrap sqlplus / as sysdba'
alias rman='rlwrap rman'
alias r='rlwrap rman target /'
alias dgmgrl='rlwrap dgmgrl'
alias d='rlwrap dgmgrl /'
alias asmcmd='rlwrap asmcmd'
alias a='rlwrap asmcmd'
alias adrci='rlwrap adrci'
alias ad='rlwrap adrci'
alias ggsci='rlwrap \${OGG_HOME}/ggsci'
alias ogg='rlwrap \${OGG_HOME}/ggsci'
alias p='ps -ef | grep pmon | grep -v grep'
alias l='rlwrap lsnrctl status'
alias rest='crsctl stat res -t -init'
alias res='crsctl stat res -t'
alias orat='\${ORATOP}/oratop -f -i 10 / as sysdba'
alias meminfo='free -m -l -t'
alias psmem='ps auxf | sort -nr -k 4'
alias psmem10='ps auxf | sort -nr -k 4 | head -10'
alias pscpu='ps auxf | sort -nr -k 3'
alias pscpu10='ps auxf | sort -nr -k 3 | head -10'
alias cpuinfo='lscpu'
umask 0022
clear
if [[ \${ORACLE_SID} = \`ps -ef | grep pmon | grep -i \${ORACLE_SID} | awk '{ print \$NF }' | sed s/ora_pmon_//g\` ]]
then
  DB_STATUS="ONLINE"
else
  DB_STATUS="OFFLINE"
fi
if [ \${LSNRCTL} != 0 ]
then
  DB_LISTNER="ONLINE"
else
  DB_LISTNER="OFFLINE"
fi
echo ">----------------------------------------------------------------------------------------------"
echo "# SERVER_UPTIME.....: [ \${UPTIME} ]"
echo "# ORACLE_BASE.......: [ \${ORACLE_BASE} ]"
echo "# ORACLE_HOME.......: [ \${ORACLE_HOME} ]"
echo "# ORACLE_VERSION....: [ \${ORACLE_VERSION} ]"
echo "# ORACLE_SID........: [ \${ORACLE_SID} ]"
echo "# DATABASE_STATUS...: [ \${DB_STATUS} ]"
echo "# LISTENER_STATUS...: [ \${DB_LISTNER} ]"
echo ">----------------------------------------------------------------------------------------------"
EOF

grep -v '^#\|^$' /etc/oratab

# ------------------------------------------------------------------------
chown oracle.oinstall /home/oracle/.cdb1

echo ". /home/oracle/.cdb1" >> /home/oracle/.bash_profile