Sql*Plus Returns Exit Code 0 from Cron Job when the Login Fails

(Doc ID 463274.1)

Last updated on AUGUST 24, 2017

Applies to:

SQL*Plus - Version: 9.2.0.6
This problem can occur on any platform.

Symptoms

Below SQL*Plus script is run from a cron job.

$cat tt.sql

export ORACLE_SID=ORCL
export ORACLE_HOME=/usr/home/10g
sqlplus username/password@connect_string
echo 'status ' $?

When the script is run from the shell prompt, the exit status is 1.

When run as a cron job, the exit status is 0.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms