Hi Folks -
I'm trying to create a simple script I can run for a migration effort I will be doing.
The issue I am having trouble with is calling sqlplus within my script. Here is my script, am I doing anything wrong?
cd /u01/app/oracle/admin/ORCL/
sudo -s mkdir -p dpdumpstg
sudo -s mkdir -p dpdumpintg
sudo -s rm -f /dpdumpstg/*.*
sudo -s rm -f /dpdumpintg/*.*
sudo -s chown oracle:oinstall ./dpdumpstg
sudo -s chown oracle:oinstall ./dpdumpintg
sudo -s setfacl -m 'u:opc:rwx' /u01/app
sudo -s setfacl -m 'u:opc:rwx' /u01/app/oracle
sudo -s setfacl -m 'u:opc:rwx' /u01/app/oracle/admin
sudo -s setfacl -m 'u:opc:rwx' /u01/app/oracle/admin/ORCL
sudo -s setfacl -m 'u:opc:rwx' /u01/app/oracle/admin/ORCL/dpdumpstg/
sudo -s setfacl -m 'u:opc:rwx' /u01/app/oracle/admin/ORCL/dpdumpintg/
sudo -su oracle sqlplus /nolog <<EOF
connect / as sysdba;
CREATE OR REPLACE DIRECTORY DATA_PUMP_STG AS '/u01/app/oracle/admin/ORCL/dpdumpstg/';
EOF
It claims sqlplus is not a valid command. But if i sudo -su oracle manually in the command window, and then do sqplus / as sysdba it works.
Any ideas? Thank you!