Re: SYS login possible in sqlplus, but not in Enterprise Manager

From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Fri, 27 Nov 2009 16:18:09 -0800 (PST)
Message-ID: <96e59a0f-6837-433e-ba5d-0afebee21617_at_e23g2000yqd.googlegroups.com>



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:
>
> snip
>
>
>
>
>
> > 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?

HTH -- Mark D Powell -- Received on Fri Nov 27 2009 - 18:18:09 CST

Original text of this message