Re: HP-UX 11i/8.1.7.4/login.sql

I got same problem. what I did is before call sqlplus /nolog, I rename the glogin.sql to something else and change back after the jobs done. That is most easy step I need to do.

Joan

John Carlson wrote:
>
> The way I do it is to create another login.sql script for batch jobs only and place that in another directory. I have also created a file I call ".cronenv" under $HOME. This sets environment variables needed for cron jobs. In it, I set SQLPATH so the first place it looks is the directory I placed my new login.sql file.
>
> SQLPATH=$HOME/cron_out:.:$HOME/dbacommon/tools/sqlscripts:$SQLPATH
>
> Then I put:
> . $HOME/.cronenv > /dev/null 2>&1
> into all my batch jobs.
>
> This works for me.
> HTH,
> John
>
> -----Original Message-----
> Sent: Tuesday, March 25, 2003 9:29 AM
> To: Multiple recipients of list ORACLE-L
>
> Greetings Everyone!
>
> I have a LOGIN.SQL script that I've customized to fit my
> preferences. However, when I use SQLPLUS /NOLOG, it fails
> miserably since there is no connection to the database.
>
> Is there a way - other than undefining ORACLE_PATH - that the
> LOGIN.SQL script can be skipped or ignored when using the
> /NOLOG parameter?
>
> Thanks,
> Mike
>
> ---
> ===========================================================================
> Michael P. Vergara
> Oracle DBA
> Guidant Corporation
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Vergara, Michael (TEM)
> INET: mvergara_at_guidant.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: John Carlson
> INET: jcarlson_at_cj.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: joan.hsieh_at_tufts.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).