Re: Root to connect as system

From: Scott Shafer <sknd100_at_yahoo.com>
Date: Mon, 29 Oct 2001 19:58:13 -0800
Message-ID: <F001.003B7DFC.20011029200037@fatcity.com>

First, make root a member of the "dba" unix group. You will then be able to "connect internal" or "/as sysdba". This is a bad idea. Second, at the command line, logged in as root, type:

. ~oracle/.profile

Make sure your ORACLE_SID is set properly and fire away. This is still a bad idea.

It would be better for root to "su" to oracle and do anything it needs to do as the oracle user, i.e.,

su - oracle

As root, no password will be required on most *nix flavors.

Happy "su"'ing,

Scott Shafer
San Antonio, TX

Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, October 29, 2001 6:40 PM

> Hi,
>
> How can I allow root to connect to the database as system. At the moment
> when I try this, I keep getting a ORA-01034: Oracle not available error,
> even though the database is up and running fine.
>
> Regards,
>
> Sujatha

Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Shafer
  INET: sknd100_at_yahoo.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).

Received on Mon Oct 29 2001 - 21:58:13 CST