Ora-01017: invalid username/password: logon denied Options

[Oraclelearner]

Hello,

I am having a problem logging in to one of my databases as the SYS user. I have reset my password for this account in OEM. However, when I try to login to this account, I am getting the following error:

ora-01017: invalid username/password: logon denied.

Can anyone tell me how to resolve this error even after resetting the SYS password?

Thank you,
OracleLearner

[dave]

being flippant - but put the right person in

What you set it to either isnt what you think it was or you are in a completely different database

[burleson]

>> resolve this error even after resetting the SYS password?

You won't get this error if you use the correct password.

http://www.dba-oracle.com/t_ora_01017.htm

Checklist for ORA-01017 errors:

- Check that user ID exists

- Check grants

- Check your environmental parameters ($ORACLE_SID), e.g.:

- If using external authentication (ops$) verify that os_authent_prefix=ops$ and remote_os_authent=true your initialization/spfile.

- Check tnsnames.ora to ensure the the service name points to the correct server and instance name.

[Jac]

Hello,

I am having a problem logging in to one of my databases as the SYS user. I have reset my password for this account in OEM. However, when I try to login to this account, I am getting the following error:

ora-01017: invalid username/password: logon denied.

Can anyone tell me how to resolve this error even after resetting the SYS password?

Thank you,
OracleLearner

did you use orapwd or you used alter user command? check oracle sid is set properly.

[Madrid]

Are you providing the SYSDBA role at connection time? Do you have your oracle password file configured? And are you referring to the 10g EM DB Control or to the 9i OEM? There are differences between them.