Re: Q: why are these logons different?

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Mon, 27 Feb 2006 22:37:49 +0100
Message-ID: <dtvrf3$m92$00$1@news.t-online.com>

Vince Laurent schrieb:
> I can connect to as database from the SQL prompt like:
>
> SQL> connect sys/****** as sysdba
>
> but cannot from OEM or the Data Guard interface?
> The login screen says to connect as sysdba. Why
> doesn't sys work in this case?
>
> Side note: should I create a new user account to manage the DG
> interface? What is recommended?
>
> Thanks!
> Vince
> -----------------------------------------------------
> Come race with us!
> http://www.mgpmrc.org

You most likely connect using os authentification. In that case, password which you provide in sqlplus will not be evaluated. You can try to connect with sys/blabla - should work. On another side, OEM connects over Net8, so to connect as sysdba you should create password file , set required initialization parameter and bounce the instance.

Best regards

Maxim Received on Mon Feb 27 2006 - 15:37:49 CST