RE: sysdba

From: <J.Velikanovs_at_alise.lv>
Date: Mon, 12 Jul 2004 16:45:24 +0300
Message-ID: <OF004B8C67.BE9D499E-ONC2256ECF.004B71CD-C2256ECF.004C4546@alise.lv>

idle> conn sys/s_at_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_at_cerebrussolutions.com> Sent by: oracle-l-bounce_at_freelists.org
12.07.2004 16:52
Please respond to oracle-l

        To:     <oracle-l_at_freelists.org>
        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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Spears, Brian Sent: 12 July 2004 14:47
To: oracle-l_at_freelists.org
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_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

Received on Mon Jul 12 2004 - 09:05:17 CDT