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 <[EMAIL PROTECTED]>@fatcity.com on 10/29/2002 08:54:00 AM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
