Oracle-L: RE: Oracle 9i and connect as sys

From: Rothouse, Michael <mrothouse_at_fcg.com>
Date: Sat, 16 Aug 2003 21:19:23 -0800
Message-ID: <F001.005CB24F.20030816211923@fatcity.com>

In Oracle9i, SYS requires connecting as a privileged user using the sysdba parameter. This is equivalent to "connect internal" in Oracle8i which is now obsolete in Oracle9i.

-----Original Message-----
Sent: Sunday, August 17, 2003 12:29 AM
To: Multiple recipients of list ORACLE-L

I have created my first 9i database on OS/390 v2.10.

On my Oracle 8i instance, I can connect to the database using:

sys/sys_password_at_the_instance

HOWEVER, In Oracle 9i, I cannot do this. I am FORCED

to connect using:

sys/password_from_orapwd_at_the_instance as sysdba

I was wondering if this was a new 9i "feature" or if it was configurable? Or just a weird thing because of the mainframe environment.

Comments please.

Thanks in Advance
- Babette
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Babette Turner-Underwood
INET: babette_at_rogers.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Rothouse, Michael
INET: mrothouse_at_fcg.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------