current_user="$(/usr/bin/whoami)"
#echo "\$current_user $current_user"
HOME="/home/${current_user}"
#echo "\$HOME $HOME"
export DB_BASE="/u01/app/${current_user}"
#echo "\$DB_BASE $DB_BASE"
export DB_HOME="${DB_BASE}/product/11.2.0.4/dbhome_1"
#echo "\$DB_HOME $DB_HOME"


export ORACLE_HOME="${DB_HOME}"


export log_datetime="$(date +'%Y%m%d_%H%M%S')"
#echo "log_datetime ${log_datetime}"
export ORACLE_UNQNAME="nowatzki"
export ORACLE_SID="${ORACLE_UNQNAME}"

#echo "\$ORACLE_UNQNAME $ORACLE_UNQNAME"

export sqlplus_script_loc="${HOME}/scripts/upgrade_db"
export sqlplus_script_log_loc="${sqlplus_script_loc}/log"

export sqlplus_prefix="catupgrd_main"
export sqlplus_suffix="sql"
export sqlplus_script="${sqlplus_prefix}.${sqlplus_suffix}"
export sqlplus_script_fp="${sqlplus_script_loc}/${sqlplus_script}"


export sqlplus_script_log_suffix="log"
export sqlplus_script_log_prefix="${sqlplus_prefix}_${log_datetime}.${sqlplus_script_log_suffix}"
#echo "\$sqlplus_script_log_prefix $sqlplus_script_log_prefix"
export sqlplus_script_log_fp="${sqlplus_script_log_loc}/${sqlplus_script_log_prefix}"


$ORACLE_HOME/bin/sqlplus / as sysdba @"${sqlplus_script_fp}" ${sqlplus_script_log_fp}

SPOOL &1

SET ECHO ON

SELECT sys_context('userenv','sid') FROM dual;

@?/rdbms/admin/catupgrd.sql;

SET ECHO OFF

SPOOL OFF

exit

nohup catupgrad_main.sh &