| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Is it possible to not to use the glogin.sql just for a partic
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFB5DA.0BBC79A4
Content-Type: text/plain;
charset="windows-1252"
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...
> -----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 ? > >-- > >Author: ALEMU Abiy > > INET: abiy.alemu_at_criltechnology.com >
-- Author: Deshpande, Kirti INET: Kirti.Deshpande_at_gtedc.gte.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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). ------_=_NextPart_001_01BFB5DA.0BBC79A4 Content-Type: text/html; charset="windows-1252" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1252"> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2448.0"> <TITLE>RE: Is it possible to not to use the glogin.sql just for a partic</TITLE> </HEAD> <BODY> <P><FONT SIZE=2>It always runs on our version. What version are you testing with?</FONT> <BR><FONT SIZE=2> </FONT> <BR><FONT SIZE=2>$ cat glogin.sql</FONT> <BR><FONT SIZE=2>prompt running glogin.sql</FONT> <BR><FONT SIZE=2>$ </FONT> <BR><FONT SIZE=2>$ sqlplus /nologin</FONT> <BR><FONT SIZE=2>SQL*Plus: Release 8.1.5.0.0 - Production on Thu May 4 07:50:01 2000</FONT> <BR><FONT SIZE=2>(c) Copyright 1999 Oracle Corporation. All rights reserved.</FONT> <BR><FONT SIZE=2>running glogin.sql</FONT> <BR><FONT SIZE=2>SQL> exit</FONT> <BR><FONT SIZE=2>13743:oracle_at_dev1> sqlplus -s /nologin</FONT> <BR><FONT SIZE=2>running glogin.sql</FONT> <BR><FONT SIZE=2>exit</FONT> <BR><FONT SIZE=2>$</FONT> </P> <BR> <BR> <P><FONT SIZE=2>-----Original Message-----</FONT> <BR><FONT SIZE=2>From: Deshpande, Kirti [<A HREF="mailto:Kirti.Deshpande_at_gtedc.gte.com">mailto:Kirti.Deshpande_at_gtedc.gte.com</A>]</FONT> <BR><FONT SIZE=2>Sent: Wednesday, May 03, 2000 5:45 PM</FONT> <BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=2>Subject: RE: Is it possible to not to use the glogin.sql just for a</FONT> <BR><FONT SIZE=2>partic</FONT> </P> <BR> <P><FONT SIZE=2>I am sorry but that is not a correct answer...</FONT> <BR><FONT SIZE=2>You can avoid running glogin.sql by starting your session with 'sqlplus</FONT> <BR><FONT SIZE=2>/nologin' command and then issuing 'connect user/password' command. </FONT> <BR><FONT SIZE=2>I encourage you to try it and post again if that does not work...</FONT> </P> <P><FONT SIZE=2>- Kirti</FONT> </P> <BR> <P><FONT SIZE=2>> -----Original Message-----</FONT> <BR><FONT SIZE=2>> From: Quamrul Polash [SMTP:quapol_at_hotmail.com]</FONT> <BR><FONT SIZE=2>> Sent: Wednesday, May 03, 2000 11:59 AM</FONT> <BR><FONT SIZE=2>> To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=2>> Subject: Re: Is it possible to not to use the glogin.sql just for a</FONT> <BR><FONT SIZE=2>> particular</FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> Hi,</FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> There is no way you can avoid executing glogin.sql when you start up your </FONT> <BR><FONT SIZE=2>> SQL*Plus session. You can customize the session parameters through</FONT> <BR><FONT SIZE=2>> login.sql </FONT> <BR><FONT SIZE=2>> file for a particular session/user.</FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> regards,</FONT> <BR><FONT SIZE=2>> Quamrul</FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> >From: ALEMU Abiy <abiy.alemu_at_criltechnology.com></FONT> <BR><FONT SIZE=2>> >Reply-To: ORACLE-L_at_fatcity.com</FONT> <BR><FONT SIZE=2>> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=2>> >Subject: Is it possible to not to use the glogin.sql just for a</FONT> <BR><FONT SIZE=2>> particular</FONT> <BR><FONT SIZE=2>> >Date: Wed, 03 May 2000 06:58:02 -0800</FONT> <BR><FONT SIZE=2>> ></FONT> <BR><FONT SIZE=2>> >Is it possible to not to use the glogin.sql just for a particular session</FONT> <BR><FONT SIZE=2>> >without deleting the file ?</FONT> <BR><FONT SIZE=2>> >--</FONT> <BR><FONT SIZE=2>> >Author: ALEMU Abiy</FONT> <BR><FONT SIZE=2>> > INET: abiy.alemu_at_criltechnology.com</FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>-- </FONT> <BR><FONT SIZE=2>Author: Deshpande, Kirti</FONT> <BR><FONT SIZE=2> INET: Kirti.Deshpande_at_gtedc.gte.com</FONT> </P> <P><FONT SIZE=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT SIZE=2>--------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=2>(or the name of mailing list you want to be removed from). You may</FONT>Received on Thu May 04 2000 - 10:04:29 CDT
 |
 |