Re: SQLPLUS question

ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS 1 (or you can make a new profile if you don't want to change the default profile)

This only works for Oracle 8.x (not 7.x).

Murty Adavi wrote:

> I am calling 'sqlplus' in a shell script and passing login & password info
> through environment variables.
> Is there any way of making 'sqlplus' NOT prompt 3 times for correct
> login/password ?
> In other words, I want sqlplus return an error status upon encountering
> incorrect login/password without
> waiting for correct login & password, so that I can trap the exit code on
> the next line and take appropriate action.
>
> Eg. I want to set up the following C shell script as a cron job....
>
> sqlplus $USERID/$PASSWD _at_$MYORASID @script.sql
> if($status != 0) then
> exit 1
> endif
>
> When the env. variable USERID is set to an incorrect login, the control is
> indefinitely waiting at the first line
> for the correct login info.
Received on Tue Dec 18 2001 - 16:44:52 CET