Re: ORA-01017: invalid username/password: Logon denied

HARI OM wrote:
> I am using Oracle 9.2.0.4 on IBM AIX 5.1L
> My ORACLE_HOME is /oracle/Oracle_Home2
> and the USER:GROUP is ORAUSR:ORAGRP
>
> I have one other OS User "larry" under group ORAGRP
> I created a new instance "LARRY" and am able to Log in to SQL Plus BUT
> when I try to log in to OEMAPP CONSOLE and enter same username/password
> (sys/***** as sysdba) it shows "ORA-01017: invalid username/password:
> Logon denied" BUT when I try SQL MOde it works just great:
> SQL> conn sys/***** as sysdba
> Connected.
>
> Can anyone tell me why I am able to LOG into SQL but NOT to Oracle
> Enterprise Manager (oemapp console)?
>
> THANKS!
>
> HARI OM
>

If you have O/S authentication set up, then typing

sqlplus "rkjhgfuysdbv894junkv/dsfkjhsisakjnfkjd AS SYSDBA"

...will get you successfully connected as SYS, so your test is not really testing anything.

Enterprise Manager is using the password file, so what was SYS's password set to there? If in doubt, log on as SYS in SQL*Plus, which you say you have no problems doing, and then

alter user sys identified by something;

Then you will be able to connect Enterprise Manager as sys/something as sysdba. The resetting of SYS's password in the data dictionary also causes it to be reset/re-synchronised in the password file.

Regards
HJR Received on Tue Dec 21 2004 - 14:52:39 CST