Brian and all,
I was running it with 7.3.4.3.x on HP-UX 10.20.
Evidently the behaviour of 'nologin' changed in 8.x. I could not avoid
glogin.sql on 8.0.6 and 8.1.6.
My appologies to all for not testing it with 8.x prior to my reply.
However, from some of the Forum messges on Oracle Metalink, I gather this
may change again, due to the fact that the dbstart and dbshut scripts with
8.1.x use 'sqlplus /nolog' to connect internal. And I believe contents of
glogin.sql have a potential to affect the desired result of these scripts.
One more place to watch out for...
Again, sorry about the reply earlier...
- Kirti
> -----Original Message-----
> From: Brian MacLean [SMTP:bmaclean_at_homebid.com]
> Sent: Thursday, May 04, 2000 10:04 AM
> To: 'ORACLE-L_at_fatcity.com'
> Cc: 'Deshpande, Kirti'
> Subject: RE: Is it possible to not to use the glogin.sql just for a
> partic
>
> It always runs on our version. What version are you testing with?
>
> $ cat glogin.sql
> prompt running glogin.sql
> $
> $ sqlplus /nologin
> SQL*Plus: Release 8.1.5.0.0 - Production on Thu May 4 07:50:01 2000
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
> running glogin.sql
> SQL> exit
> 13743:oracle_at_dev1> sqlplus -s /nologin
> running glogin.sql
> exit
> $
>
>
>
> -----Original Message-----
> From: Deshpande, Kirti [ <mailto:Kirti.Deshpande_at_gtedc.gte.com>]
> Sent: Wednesday, May 03, 2000 5:45 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Is it possible to not to use the glogin.sql just for a
> partic
>
>
> I am sorry but that is not a correct answer...
> You can avoid running glogin.sql by starting your session with 'sqlplus
> /nologin' command and then issuing 'connect user/password' command.
> I encourage you to try it and post again if that does not work...
>
> - Kirti
>
>
> > -----Original Message-----
> > From: Quamrul Polash [SMTP:quapol_at_hotmail.com]
> > Sent: Wednesday, May 03, 2000 11:59 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Is it possible to not to use the glogin.sql just for a
>
> > particular
> >
> > Hi,
> >
> > There is no way you can avoid executing glogin.sql when you start up
> your
> > SQL*Plus session. You can customize the session parameters through
> > login.sql
> > file for a particular session/user.
> >
> > regards,
> > Quamrul
> >
> >
> > >From: ALEMU Abiy <abiy.alemu_at_criltechnology.com>
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > >Subject: Is it possible to not to use the glogin.sql just for a
> > particular
> > >Date: Wed, 03 May 2000 06:58:02 -0800
> > >
> > >Is it possible to not to use the glogin.sql just for a particular
> session
> > >without deleting the file ?
> > >--
Received on Thu May 04 2000 - 10:56:37 CDT
