Oracle-L: RE: sqlplus /nolog

From: Rodd Holman <roddholman_at_HotPOP.com>
Date: Tue, 29 Oct 2002 10:13:33 -0800
Message-ID: <F001.004F693A.20021029101333@fatcity.com>

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

    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 [mailto:roddholman_at_HotPOP.com]
        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). Received on Tue Oct 29 2002 - 12:13:33 CST