RE: sysdba

I would only add that you have to give the number of entries as well as the filename and password. The number of entries probably should be more than one if you have sys logged on anywhere.

HTH,
Ruth

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mercadante, Thomas F Sent: Monday, July 12, 2004 10:22 AM
To: 'oracle-l_at_freelists.org'
Subject: 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_at_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_at_Limitedbrands.com] Sent: Monday, July 12, 2004 10:16 AM
To: oracle-l_at_freelists.org
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_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
-----------------------------------------------------------------
----------------------------------------------------------------
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
-----------------------------------------------------------------