Re: sysdba

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Mon, 12 Jul 2004 14:55:49 +0100
Message-ID: <7765c8970407120655bdce086@mail.gmail.com>

On Mon, 12 Jul 2004 09:46:31 -0400, Spears, Brian <bspears_at_limitedbrands.com> wrote:
>
> Someone was telling me connecting as sysdba from sqlplus is not allowed in
> 9i. I tried and found it did seem to not be available.

Do you mean *only* connecting to SYS as sysdba? If so then yes it is entirely a security mechanism. If you are talking about remote connection then there is some work to be done to trust the remote connection, but

set oracle_sid=<blah>
(make sure the env var applies )
sqlplus "/ as sysdba" will work fine. Even on windows, which is nice.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Jul 12 2004 - 08:52:35 CDT