Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DBA access after import (SYS and SYSTEM passwords)

Re: DBA access after import (SYS and SYSTEM passwords)

From: Rick Wessman <rwessman_at_rochester.rr.com>
Date: 26 Mar 2002 12:22:39 -0500
Message-ID: <m3zo0vtfa8.fsf@RICK.local>


Well, it used to always work. :-)

In 9i, connect internal has been desupported. The correct syntax is now:

    connect / as sysdba

                                       Rick

tripf_at_vertis.nl (Frans Trip) writes:

> svrmgrl
> connect internal
> alter user system identified by password
>
> works always !!!
> There is no real problem, just normal Oracle.
>
> Frans Trip
> The Netherlands
>
>
> On 12 Mar 2002 08:56:49 -0800, noelp1_at_hotmail.com (Noel P) wrote:
>
> >Hi,
> >
> >I have a dump of a database on which I only have a user level access
> >but no DBA access. I create a new database and have the SYS and SYSTEM
> >access.
> >However, once I import the dump of the other database, I can't login
> >as SYS or SYSTEM because it changes the SYSTEM and SYS passwords.
> >
> >How can I overcome this, so that after the import, I still have SYSTEM
> >and SYS passwords.
> >
> >Can I create a an account with DBA privilages before the import, and
> >login using that DBA after the import and change the SYS and SYSTEM
> >passwords?
> >
> >Your help is very much appreciated.
> >
> >Thanks
> >
> >-Noel
Received on Tue Mar 26 2002 - 11:22:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US