RE: sysdba

 I know sqlplus "/ as sysdba" works on the host... No problem.. But remote connection is what I am looking for.. Niall, what area has to be worked on with trusting the remote connection?

Brian

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield
Sent: Monday, July 12, 2004 9:56 AM
To: oracle-l_at_freelists.org
Subject: Re: sysdba

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
-----------------------------------------------------------------

----------------------------------------------------------------
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
-----------------------------------------------------------------