RE: sysdba

From: J.Velikanovs@xxxxxxxx
To: oracle-l@xxxxxxxxxxxxx
Date: Mon, 12 Jul 2004 16:45:24 +0300
idle> conn sys/s@jozh as sysdba
Connected.
SYS:jozh> @par
Parameters vai dala no ta :password
NAME                                     VALUE
---------------------------------------- --------------------------------
remote_login_passwordfile                EXCLUSIVE

SYS:jozh> @ver

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
PL/SQL Release 9.2.0.4.0 - Production
CORE    9.2.0.3.0       Production
TNS for 32-bit Windows: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production

5 rows selected.

SYS:jozh>

I would suggest to look on password file (seach key word orapwd) and 
remote_login_passwordfile parameter.

Jurijs
9268222
============================================
http://otn.oracle.com/ocm/jvelikanovs.html






"David Sharples" <dsharples@xxxxxxxxxxxxxxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
12.07.2004 16:52
Please respond to oracle-l
 
        To:     <oracle-l@xxxxxxxxxxxxx>
        cc: 
        Subject:        RE: sysdba


Course it is allowed (how else are you going to connect?)

Sqlplus "/ as sysdba" works just fine

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Spears, Brian
Sent: 12 July 2004 14:47
To: oracle-l@xxxxxxxxxxxxx
Subject: sysdba


 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. Is this a
security
consideration... And/or does anyone have a workaround?

Thanks
Brian

----------------------------------------------------------------
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
-----------------------------------------------------------------
References:
- RE: sysdba
  - From: David Sharples
RE: sysdba

Other related posts:
