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

From: Dave Yoda <david_at_pleasdontpm.me>
Date: Mon, 30 Nov 2009 12:55:15 +0100
Message-ID: <hf0br4$2u4j$1_at_adenine.netfront.net>


"Mark D Powell" <Mark.Powell2_at_hp.com> schrieb im Newsbeitrag news: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?

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

Original text of this message