Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Is it possible to not to use the glogin.sql just for a partic

RE: Is it possible to not to use the glogin.sql just for a partic

From: Brian MacLean <bmaclean_at_homebid.com>
Date: Thu, 4 May 2000 08:04:29 -0700
Message-Id: <10487.104933@fatcity.com>


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.&nbsp; What version are you testing with?</FONT>
<BR><FONT SIZE=2>&nbsp;</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.&nbsp; All rights reserved.</FONT>
<BR><FONT SIZE=2>running glogin.sql</FONT>
<BR><FONT SIZE=2>SQL&gt; exit</FONT>
<BR><FONT SIZE=2>13743:oracle_at_dev1&gt; 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>&gt; -----Original Message-----</FONT>
<BR><FONT SIZE=2>&gt; From: Quamrul Polash [SMTP:quapol_at_hotmail.com]</FONT>
<BR><FONT SIZE=2>&gt; Sent: Wednesday, May 03, 2000 11:59 AM</FONT>
<BR><FONT SIZE=2>&gt; To:&nbsp;&nbsp; Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>&gt; Subject:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Re: Is it possible to not to use the glogin.sql just for a</FONT>
<BR><FONT SIZE=2>&gt; particular</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; Hi,</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; There is no way you can avoid executing glogin.sql when you start up your </FONT>
<BR><FONT SIZE=2>&gt; SQL*Plus session. You can customize the session parameters through</FONT>
<BR><FONT SIZE=2>&gt; login.sql </FONT>
<BR><FONT SIZE=2>&gt; file for a particular session/user.</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; regards,</FONT>
<BR><FONT SIZE=2>&gt; Quamrul</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; &gt;From: ALEMU Abiy &lt;abiy.alemu_at_criltechnology.com&gt;</FONT>
<BR><FONT SIZE=2>&gt; &gt;Reply-To: ORACLE-L_at_fatcity.com</FONT>
<BR><FONT SIZE=2>&gt; &gt;To: Multiple recipients of list ORACLE-L &lt;ORACLE-L_at_fatcity.com&gt;</FONT>
<BR><FONT SIZE=2>&gt; &gt;Subject: Is it possible to not to use the glogin.sql just for a</FONT>
<BR><FONT SIZE=2>&gt; particular</FONT>
<BR><FONT SIZE=2>&gt; &gt;Date: Wed, 03 May 2000 06:58:02 -0800</FONT>
<BR><FONT SIZE=2>&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt; &gt;Is it possible to not to use the glogin.sql just for a particular session</FONT>
<BR><FONT SIZE=2>&gt; &gt;without deleting the file ?</FONT>
<BR><FONT SIZE=2>&gt; &gt;--</FONT>
<BR><FONT SIZE=2>&gt; &gt;Author: ALEMU Abiy</FONT>
<BR><FONT SIZE=2>&gt; &gt;&nbsp;&nbsp; INET: abiy.alemu_at_criltechnology.com</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: Deshpande, Kirti</FONT>
<BR><FONT SIZE=2>&nbsp; INET: Kirti.Deshpande_at_gtedc.gte.com</FONT>
</P>

<P><FONT SIZE=2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- 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).&nbsp; You may</FONT>
Received on Thu May 04 2000 - 10:04:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US