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

Well it is working if you set so :-)

check pfile if "connect / as sysdba" doesn't work and remote_login_passwordfile=exclusive
os_authent_prefix = ""
and don't foget ORACLE_SID=YOUR_SID; export ORACLE_SID

also you could open session (in an other window), run you imp, and change password back in your session window. It should work

Cheers,

"Rick Wessman" <rwessman_at_rochester.rr.com> wrote in message news:m3zo0vtfa8.fsf_at_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 - 13:20:44 CST