crond scheduler in oracle dba

--u02/schedule_scripts -- where is file save .sh  

 .sh 
#/bin/bash
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
export ORACLE_SID=***
export ORACLE_UNQNAME=***
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:/usr/local/bin:/usr/sbin:/usr/bin:/usr/openwin/bin:/usr/ucb:$ORACLE_HOME/bin
#export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH PATH
sqlplus scott/tiger <<EOF
exec procedure_name;
exit
EOF
=====================================================================
 
.sh 
#/bin/bash
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
export ORACLE_SID=orcl
export ORACLE_UNQNAME=orcl
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:/usr/local/bin:/usr/sbin:/usr/bin:/usr/openwin/bin:/usr/ucb:$ORACLE_HOME/bin
#export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH PATH
sqlplus reportdb/r <<EOF
 
# write here your program code
insert into test_tab(id , edate)
select 1, sysdate from dual;
commit;
exit
EOF

--u02/schedule_scripts --crontab -e where is file in 

15 20 * * * /u02/schedule_scripts/test_crond.sh >>/u02/schedule_scripts/error_Log.txt

# go to folder to then run

sh  test_crond.sh 

//////////////////////////////////

# Oracle Settings

export TMP=/tmp

export TMPDIR=$TMP

export ORACLE_HOSTNAME=ol8dbs.localdomain

export ORACLE_UNQNAME=orcl

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1

export ORA_INVENTORY=/u01/app/oraInventory

export ORACLE_SID=orcl

export PDB_NAME=orclpdb

export DATA_DIR=/u01/oradata

export PATH=/usr/sbin:/usr/local/bin:$PATH

export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib