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: RE: Logging on to SQLPLUS

Re: RE: Logging on to SQLPLUS

From: <jtesta_at_the-testas.net>
Date: Mon, 12 Nov 2001 10:31:44 -0800
Message-ID: <F001.003C2A1B.20011112102032@fatcity.com>

no password required, although you need a password file and have been granted sysdba role.

check out the concept of password files and get one setup for your database.

joe



Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) IM: JoeN8XCT or N8XCTHOME

What do I use for the password for sysdba? I don't see it in the list of Oracle list of user names / passwords? Or, do I even need a password?

TIA,
Ken

 -----Original Message-----
Sent: Monday, November 12, 2001 11:34 AM

To:     ken.janusz_at_sufsys.com
Cc:     oracle-l_at_fatcity.com
Subject:        Re: Logging on to SQLPLUS

$ sqlplus /nolog
connect / as sysdba
startup || shutdown etc

previous was brought to you by 9i the new way to shutdown/startup a database since svrmgrl is gone.

joe



Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) IM: JoeN8XCT or N8XCTHOME

I would like to know how I go about logging on as: SQLPLUS /nolog? Is this at the initial logon or after I have logged on at the command line?

Thanks,

Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, Inc.
Minneapolis, MN

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ken Janusz
  INET: ken.janusz_at_sufsys.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)

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: jtesta_at_the-testas.net

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). Received on Mon Nov 12 2001 - 12:31:44 CST

Original text of this message

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