Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBA access after import (SYS and SYSTEM passwords)
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