ORA-1017 error invalid username or password

Document ID : KB000109288
Last Modified Date : 02/08/2018
Show Technical Document Details
Issue:
Getting an ORA-1017 error: invalid username/password.
This could happen at different points. It could happen when you login or you may be able to login fine but face the error while metric registration. When we click on 'Add New' button . it's throwing error not able to connect to database.
The error may be a pop-up or it may show up in the system log.
Cause:
This is caused by an invalid username or password for Oracle.
BSI uses several different Oracle logins, so some things might work while others don't.
Out of the box Oracle sets up user account passwords to expire after 30 days. So this is often caused by expired passwords.
Resolution:
One of the Oracle logins you are using is not valid.
Run (as administrator) the utility %OG_HOME%\utilties\passupdate\passupdate.exe
This will show you all of the Oracle logins that BSI uses. Each one is used for different things.
Try logging on through sqlplus with each of them. When you find the invalid ones, have the DBA correct them.
If he resets the password then you can put the new password in this utility screen.
If the APP and WEB are on separate boxes then please do this on each box.

If this was caused by the password expiring and you want to prevent this from happening again,
the following commands (run as SYS) will both change the default profile and reset all of the passwords to defaults.
I suggest running each one at a time to make sure they each work:

alter profile DEFAULT limit password_life_time UNLIMITED;
ALTER USER OBLICORE ACCOUNT UNLOCK;
ALTER USER USRSLA ACCOUNT UNLOCK;
ALTER USER USRMTN ACCOUNT UNLOCK;
ALTER USER USRCSL ACCOUNT UNLOCK;
ALTER USER USREDR ACCOUNT UNLOCK;
ALTER USER USRPSL ACCOUNT UNLOCK;
ALTER USER USRRPT ACCOUNT UNLOCK;
ALTER USER USRDASH ACCOUNT UNLOCK;
ALTER USER USRINSIGHT ACCOUNT UNLOCK;
ALTER USER OBLICORE identified by oblicore;
ALTER USER USRSLA identified by usrsla;
ALTER USER USRMTN identified by usrmtn;
ALTER USER USRCSL identified by usrcsl;
ALTER USER USREDR identified by usredr;
ALTER USER USRPSL identified by usrpsl;
ALTER USER USRRPT identified by usrrpt;
ALTER USER USRDASH identified by usrdash;
ALTER USER USRINSIGHT identified by usrinsight;