RE: sysdba

Brian,

The only connection as SYSDBA allowed from a remote device is via the Oracle
password file.  On the database server, type the following:

Orapwd file=orapw(ora_sid) password=(password).

This will create the file named orapw(ora_sid) within the $ORACLE_HOME/dbs
directory.  You can type orapwd for help.  

Make sure that the remote_login_password param = exclusive.

You will then be able to connect remotely as sys/pw@remotesid as sysdba;

Read up on Orapwd and remote_Login_password in the Oracle docs.

Good Luck.

Tom Mercadante
Oracle Certified Professional


-----Original Message-----
From: Spears, Brian [mailto:BSpears@xxxxxxxxxxxxxxxxx] 
Sent: Monday, July 12, 2004 10:16 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Niall Litchfield
Sent: Monday, July 12, 2004 9:56 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: sysdba


On Mon, 12 Jul 2004 09:46:31 -0400, Spears, Brian
<bspears@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx 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@xxxxxxxxxxxxx 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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: