Grokbase › Groups › Oracle › oracle-l › October 2002
FAQ
Hi!

I was wondering what

sqlplus /nolog

actually does on Unix? Is it only used for not listing username/password
when doing a ps ? Or anything else?

This is 8.1.7 on Sun Solaris.

Thanks,
Helmut

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Daiminger, Helmut
INET: Helmut.Daiminger_at_KirchGruppe.de

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).

Search Discussions

  • Rodd Holman at Oct 29, 2002 at 2:54 pm ⇧
    It opens up a sqlplus session session/shell on the server without
    logging into a database. The 9i version of sqlplus does not allow for a
    command line: sqlplus / as sysdba command. You have to login to sqlplus
    and when prompted for the username then add / as sysdba. The /nolog
    allows you to script running sqlplus and then having the connect / as
    sysdba as the first line in your sqlscript ie: sqlplus /nolog
    @myscript.sql

    myscript.sql:

    connect / as sysdba
    select name from v$database;
    ....

    Rodd

    On Tue, 2002-10-29 at 07:29, Daiminger, Helmut wrote:

    Hi!


    I was wondering what


    sqlplus /nolog


    actually does on Unix? Is it only used for not listing
    username/password when doing a ps ? Or anything else?


    This is 8.1.7 on Sun Solaris.


    Thanks,
    Helmut


    --
    Rodd Holman
    Enterprise Data Systems Engineer
    LodgeNet Entertainment Corporation
    roddholman_at_HotPOP.com

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Rodd Holman
    INET: roddholman_at_HotPOP.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).
  • Mercadante, Thomas F at Oct 29, 2002 at 2:58 pm ⇧
    Helmut,


    It makes sqlplus act like svrmgrl.


    I use sqlplus this way, followed internally by a connect as sysdba command
    to start and shutdown the database on 9i.


    Tom Mercadante
    Oracle Certified Professional

    -----Original Message-----
    Sent: Tuesday, October 29, 2002 8:29 AM
    To: Multiple recipients of list ORACLE-L

    Hi!

    I was wondering what

    sqlplus /nolog

    actually does on Unix? Is it only used for not listing username/password
    when doing a ps ? Or anything else?

    This is 8.1.7 on Sun Solaris.

    Thanks,
    Helmut

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Mercadante, Thomas F
    INET: NDATFM_at_labor.state.ny.us

    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).
  • Gogala, Mladen at Oct 29, 2002 at 2:58 pm ⇧
    It originates from the wonderful OS that used to have commands like "SET
    DEF", "MONITOR MODES",

    "BACKUP/IGNORE=INTERLOCK SYS$ORACLE:[....]*.* MU:" and alike. There is also
    an abomination
    of this OS created by David Cuttler.


    -----Original Message-----
    Sent: Tuesday, October 29, 2002 8:29 AM
    To: Multiple recipients of list ORACLE-L

    Hi!

    I was wondering what

    sqlplus /nolog

    actually does on Unix? Is it only used for not listing username/password
    when doing a ps ? Or anything else?

    This is 8.1.7 on Sun Solaris.

    Thanks,
    Helmut

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Gogala, Mladen
    INET: MGogala_at_oxhp.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).
  • Chao_ping at Oct 29, 2002 at 3:08 pm ⇧
    This is a multi-part message in MIME format.

    --=====002_Dragon805267761306_=====
    Content-Type: text/plain;

    charset="GB2312"
    Content-Transfer-Encoding: quoted-printable

    Daiminger, Helmut=A3=AC=C4=FA=BA=C3=A3=A1

    =A1=A1=A1=A1It is used when you want to do it in your shell script, or

    $sqlplus /nolog
    SQL>conn / as sysdba

    =3D=3D=3D=3D=3D=3D=3D=3D 2002-10-29 05:29:00 =C4=FA=D4=DA=C0=B4=D0=C5=D6=D0=D0=B4=B5=C0=A3=BA =3D=3D=3D=3D=3D=3D=3D=3D

    Hi!
    I was wondering what
    sqlplus /nolog
    actually does on Unix? Is it only used for not listing=
    username/password when doing a ps ? Or anything else?
    This is 8.1.7 on Sun Solaris.
    Thanks,
    Helmut

    =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D
    =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=D6=C2
    =C0=F1=A3=A1

    =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1chao_ping

    =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1chao_ping_at_vip.163.com
    =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A12002-10-29

    --=====002_Dragon805267761306_=====
    Content-Type: text/html;

    charset="GB2312"
    Content-Transfer-Encoding: quoted-printable

    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

    Daiminger,=
    Helmut=A3=AC=C4=FA=BA=C3=A3=A1

    &nbsp;
    =A1=A1=A1=A1It is used when you want to do it=
    in your shell
    script, or
    &nbsp;
    $sqlplus /nolog
    SQL&gt;conn / as sysdba
    &nbsp;
    &nbsp;
    =3D=3D=3D=3D=3D=3D=3D=3D=
    2002-10-29&nbsp;05:29:00&nbsp;=C4=FA=D4=DA=C0=B4=D0=C5=D6=D0=D0=B4=B5=C0=A3=BA
    =3D=3D=3D=3D=3D=3D=3D=3D
    &nbsp;





    Hi!
    I was wondering what
    sqlplus /nolog
    actually does on Unix?&nbsp; Is it only=
    used for not
    listing username/password when doing a ps ? Or anything=

    else?

    This is 8.1.7 on Sun Solaris.=


    Thanks, Helmut



    =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D=
    =3D =3D
    =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=D6=C2=C0=F1=A3=A1
    &nbsp;
    =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1chao_ping
    =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1chao_ping_at_vip.163.com
    =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A12002-10-29=

    &nbsp;

    --=====002_Dragon805267761306_=====--

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: chao_ping
    INET: chao_ping_at_vip.163.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).
  • Magaliff, Bill at Oct 29, 2002 at 3:14 pm ⇧
    it starts sqlplus without logging in to a database -

    -----Original Message-----
    Sent: Tuesday, October 29, 2002 8:29 AM
    To: Multiple recipients of list ORACLE-L

    Hi!

    I was wondering what

    sqlplus /nolog

    actually does on Unix? Is it only used for not listing username/password
    when doing a ps ? Or anything else?

    This is 8.1.7 on Sun Solaris.

    Thanks,
    Helmut

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Magaliff, Bill
    INET: Bill.Magaliff_at_lendware.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).
  • Philip Douglass at Oct 29, 2002 at 3:40 pm ⇧
    sqlplus /nologsqlplus /nolog starts sqlplus, but does not connect you to any database, nor does it prompt you for a username/password.

    Original Message -----
    From: Daiminger, Helmut
    To: Multiple recipients of list ORACLE-L
    Sent: Tuesday, October 29, 2002 8:29 AM
    Subject: sqlplus /nolog

    Hi!

    I was wondering what

    sqlplus /nolog

    actually does on Unix? Is it only used for not listing username/password when doing a ps ? Or anything else?

    This is 8.1.7 on Sun Solaris.

    Thanks,
    Helmut

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Philip Douglass
    INET: philipd_at_sirs.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).
  • Toepke, Kevin M at Oct 29, 2002 at 3:49 pm ⇧
    It doesn't?


    $ sqlplus "/ as sysdba"


    SQL*Plus: Release 9.2.0.1.0 - Production on Tue Oct 29 10:39:53 2002


    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining
    options
    JServer Release 9.2.0.1.0 - Production


    SYS_at_hydra@fins SQL>

    -----Original Message-----
    Sent: Tuesday, October 29, 2002 9:54 AM
    To: Multiple recipients of list ORACLE-L

    It opens up a sqlplus session session/shell on the server without logging
    into a database. The 9i version of sqlplus does not allow for a command
    line: sqlplus / as sysdba command. You have to login to sqlplus and when
    prompted for the username then add / as sysdba. The /nolog allows you to
    script running sqlplus and then having the connect / as sysdba as the first
    line in your sqlscript ie: sqlplus /nolog @myscript.sql

    myscript.sql:

    connect / as sysdba
    select name from v$database;
    ....

    Rodd

    On Tue, 2002-10-29 at 07:29, Daiminger, Helmut wrote:

    Hi!

    I was wondering what

    sqlplus /nolog

    actually does on Unix? Is it only used for not listing username/password
    when doing a ps ? Or anything else?

    This is 8.1.7 on Sun Solaris.

    Thanks,
    Helmut

    --

    Rodd Holman

    Enterprise Data Systems Engineer

    LodgeNet Entertainment Corporation

    roddholman_at_HotPOP.com

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Toepke, Kevin M
    INET: ktoepke_at_trilegiant.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).
  • Ray Stell at Oct 29, 2002 at 4:44 pm ⇧

    On Tue, Oct 29, 2002 at 06:58:49AM -0800, Gogala, Mladen wrote:
    It originates from the wonderful OS that used to have commands like "SET
    DEF", "MONITOR MODES",
    "BACKUP/IGNORE=INTERLOCK SYS$ORACLE:[....]*.* MU:" and alike. There is also
    an abomination
    of this OS created by David Cuttler.
    Cutler

    Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Ray Stell
    INET: stellr_at_cns.vt.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).
  • Reginald.W.Bailey_at_jpmorgan.com at Oct 29, 2002 at 5:48 pm ⇧
    I beg to differ Mr. Holman. The sqlplus command should work if the "/ as
    sysdba" is enclosed in quotes. So, the command would be
    sqlplus "/ as sysdba" . This works in Oracle9i on Unix and Windows NT/2000
    environmnents. At least it does so in my environments.

    RWB

    Rodd Holman @fatcity.com on 10/29/2002 08:54:00 AM

    Please respond to ORACLE-L_at_fatcity.com

    Sent by: root_at_fatcity.com

    To: Multiple recipients of list ORACLE-L
    cc:

    It opens up a sqlplus session session/shell on the server without logging
    into a database.  The 9i version of sqlplus does not allow for a command
    line: sqlplus / as sysdba command.  You have to login to sqlplus and when
    prompted for the username then add / as sysdba.  The /nolog allows you to
    script running sqlplus and then having the connect / as sysdba as the first
    line in your sqlscript ie:  sqlplus /nolog @myscript.sql

    myscript.sql:
    connect / as sysdba
    select name from v$database;
    ....

    Rodd

    On Tue, 2002-10-29 at 07:29, Daiminger, Helmut wrote: Hi!

    I was wondering what

    sqlplus /nolog

    actually does on Unix?  Is it only used for not listing username/password
    when doing a ps ? Or anything else?

    This is 8.1.7 on Sun Solaris.

    Thanks,
    Helmut

    --
    Rodd Holman
    Enterprise Data Systems Engineer
    LodgeNet Entertainment Corporation
    roddholman_at_HotPOP.com

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author:
    INET: Reginald.W.Bailey_at_jpmorgan.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).
  • Rodd Holman at Oct 29, 2002 at 6:13 pm ⇧
    Ah ha. It's the double quotes you use. These were not necessary with
    svrmgrl

    Rodd

    On Tue, 2002-10-29 at 09:49, Toepke, Kevin M wrote:

    It doesn't?


    $ sqlplus "/ as sysdba"


    SQL*Plus: Release 9.2.0.1.0 - Production on Tue Oct 29 10:39:53 2002


    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the Partitioning, Oracle Label Security, OLAP and Oracle Data
    Mining options
    JServer Release 9.2.0.1.0 - Production


    SYS_at_hydra@fins SQL>


    -----Original Message-----
    From: Rodd Holman
    Sent: Tuesday, October 29, 2002 9:54 AM
    To: Multiple recipients of list ORACLE-L
    Subject: Re: sqlplus /nolog

    It opens up a sqlplus session session/shell on the server
    without logging into a database. The 9i version of sqlplus does
    not allow for a command line: sqlplus / as sysdba command. You
    have to login to sqlplus and when prompted for the username then
    add / as sysdba. The /nolog allows you to script running
    sqlplus and then having the connect / as sysdba as the first
    line in your sqlscript ie: sqlplus /nolog @myscript.sql

    myscript.sql:
    connect / as sysdba
    select name from v$database;
    ....

    Rodd

    On Tue, 2002-10-29 at 07:29, Daiminger, Helmut wrote:

    Hi!

    I was wondering what

    sqlplus /nolog

    actually does on Unix? Is it only used for not listing
    username/password when doing a ps ? Or anything else?

    This is 8.1.7 on Sun Solaris.

    Thanks,
    Helmut

    --
    Rodd Holman
    Enterprise Data Systems Engineer
    LodgeNet Entertainment Corporation
    roddholman_at_HotPOP.com

    --
    Rodd Holman
    Enterprise Data Systems Engineer
    LodgeNet Entertainment Corporation
    roddholman_at_HotPOP.com

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Rodd Holman
    INET: roddholman_at_HotPOP.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).
  • DENNIS WILLIAMS at Oct 30, 2002 at 5:09 am ⇧
    To me, the key point is that sqlplus will log you on the database. If the
    database is down, this will fail, so you must use the /nolog option in order
    to access the database so you can start it.
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: DENNIS WILLIAMS
    INET: DWILLIAMS_at_LIFETOUCH.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).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 29, '02 at 1:29p
activeOct 30, '02 at 5:09a
posts12
users11
websiteoracle.com

11 users in discussion

Rodd Holman: 2 posts Mercadante, Thomas F: 1 post Reginald.W.Bailey_at_jpmorgan.com: 1 post Philip Douglass: 1 post DENNIS WILLIAMS: 1 post Toepke, Kevin M: 1 post Gogala, Mladen: 1 post Ray Stell: 1 post Magaliff, Bill: 1 post Chao_ping: 1 post Daiminger, Helmut: 1 post

Content

People

Support

Translate

site design / logo © 2022 Grokbase