RE: sysdba

From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 12 Jul 2004 10:35:42 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Mercadante, Thomas F
Sent: Monday, July 12, 2004 10:22 AM
To: 'oracle-l@xxxxxxxxxxxxx'
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@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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Follow-Ups:
- Re: sysdba
  - From: Niall Litchfield
References:
- RE: sysdba
  - From: Mercadante, Thomas F
RE: sysdba

Other related posts:
