Re: Oracle 9i | login.sql does not run on login by default

Anoop wrote:
> You say at least on 10.2!
>
> Does anybody know if it is available on 9.2. I think the biggest
> benefit for me (if glogin is available) is that it will check when I
> reconnect and change teh sqlprompt appropriately... login.sql does not.
>
> Thanks,
> Anoop
>
> On Jan 10, 1:18 pm, Niall Litchfield <niall.litchfi..._at_dial.pipex.com>
> wrote:
> > Brian Peasland wrote:
> > > mai..._at_bmlam.de wrote:
> > >> In my experience, under Unix, Oracle looks for login.sql in your
> > >> current directory. If none is found, it looks for login.sql in $SQLPATH
> >
> > >> hth
> >
> > >> Bon-Minh Lam
> >
> > > The order for finding the login.sql script is:
> >
> > > 1) Your current directory
> > > 2) The directories listed (in order) in your SQLPATH environment variable
> > > 3) The ORACLE_HOME/sqlplus/admin directory
> >
> > > Finally, the contents of the ORACLE_HOME/sqlplus/admin/glogin.sql script
> > > are executed.
> >
> > > HTH,
> > > Brianglogin.sql is executed before login.sql rather than afterwards - at
> > least on 10.2. In addition option 3 isn't searched, at least in 10.2. I
> > don't know if this a change from previous releases - I'd be surprised.
> >
> > --
> > Niall Litchfield
> > Oracle DBAhttp://www.orawin.info/services

Please do not top post.

The login.sql script, as well as the glogin.sql script, execute when sqlplus is called from the command line; 'connect user/pass' does not cause either one to be run.

David Fitzjarrell Received on Wed Jan 10 2007 - 16:37:50 CST