Re: SYS login possible in sqlplus, but not in Enterprise Manager
Date: Mon, 30 Nov 2009 12:55:15 +0100
"Mark D Powell" <Mark.Powell2_at_hp.com> schrieb im Newsbeitrag
On Nov 27, 7:48 am, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
> On Nov 27, 5:59 am, "Dave Yoda" <da..._at_pleasdontpm.me> wrote:
> > Hi everybody!
> > After restoring a RMAN backup to another machine (database and
> > applikation
> > running fine with no probs) I'm experiencing the following problem:
> > I can logon using sqlplus and login SYS or SYSTEM. Not problems here,
> > but I
> > can't login (using the same credentials) via Enterprise Manager (neither
> > on
> > the same machine nor remote).
> > I can login to sqlplus (SYS as sysdba), create a new user with
> > dba-rights
> > and use this new user to login via em, but SYS and SYSTEM do not work.
> > One hint: EM has not been installed by default, but I had to install it
> > (by
> > using emca and using the same credentials here) after I restored the
> > database. Might the problem result from this?
> > What and where can I check what's going wrog here?
> > Cheers,
> > Dave.
> Typically after moving a database to another machine I rip out em and
> recreate the repository etc ...- Hide quoted text -
> - Show quoted text -
>Dave, did you restore or re-create the password file?
Password-file? I used "emca -repos create" for creating a new repository and "emca -config dbcontrol db" Received on Mon Nov 30 2009 - 05:55:15 CST