Skip to main content
Unix & Linux

Return to Question

highlight the whole block
Source Link
Siva
Siva
  • 9.3k
  • 9
  • 60
  • 88
/oracle/GR1/121/bin/sqlplus / as sysdba <<EOF >> $LOGFILE
whenever sqlerror exit sql.sqlcode;
set echo on;
set serveroutput on;
STARTUP;
EXIT
EOF

Already tried it with the path, but it hasn't worked. Anyone can help?

/oracle/GR1/121/bin/sqlplus / as sysdba <<EOF >> $LOGFILE
whenever sqlerror exit sql.sqlcode;
set echo on;
set serveroutput on;
STARTUP;
EXIT
EOF

Already tried it with the path, but it hasn't worked. Anyone can help?

/oracle/GR1/121/bin/sqlplus / as sysdba <<EOF >> $LOGFILE
whenever sqlerror exit sql.sqlcode;
set echo on;
set serveroutput on;
STARTUP;
EXIT
EOF

Already tried it with the path, but it hasn't worked.

highlight the whole block
Source Link
edit approved Feb 20, 2020 at 13:09
dragosht
edit approved Feb 20, 2020 at 13:09
dragosht
  • 259
  • 2
  • 9

/oracle/GR1/121/bin/sqlplus / as sysdba <<EOF >> $LOGFILE whenever sqlerror exit sql.sqlcode; set echo on; set serveroutput on; STARTUP; EXIT EOF

/oracle/GR1/121/bin/sqlplus / as sysdba <<EOF >> $LOGFILE
whenever sqlerror exit sql.sqlcode;
set echo on;
set serveroutput on;
STARTUP;
EXIT
EOF

Already tried it with the path, but it hasn't worked. Anyone can help?

/oracle/GR1/121/bin/sqlplus / as sysdba <<EOF >> $LOGFILE whenever sqlerror exit sql.sqlcode; set echo on; set serveroutput on; STARTUP; EXIT EOF

Already tried it with the path, but it hasn't worked. Anyone can help?

/oracle/GR1/121/bin/sqlplus / as sysdba <<EOF >> $LOGFILE
whenever sqlerror exit sql.sqlcode;
set echo on;
set serveroutput on;
STARTUP;
EXIT
EOF

Already tried it with the path, but it hasn't worked. Anyone can help?

Source Link
plattio
plattio
  • 71
  • 2
  • 7

sqlplus doesn't work in Crontab

/oracle/GR1/121/bin/sqlplus / as sysdba <<EOF >> $LOGFILE whenever sqlerror exit sql.sqlcode; set echo on; set serveroutput on; STARTUP; EXIT EOF

Already tried it with the path, but it hasn't worked. Anyone can help?