Oracle-L: Re: sqlplus /nolog

From: <Reginald.W.Bailey_at_jpmorgan.com>
Date: Tue, 29 Oct 2002 09:48:54 -0800
Message-ID: <F001.004F68A1.20021029094854@fatcity.com>

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 <roddholman_at_hotpop.com>@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 <ORACLE-L_at_fatcity.com> 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).

Received on Tue Oct 29 2002 - 11:48:54 CST