ORA-1017 error invalid username or password

Products

• CA Business Service Insight

Issue/Introduction

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.

Environment

Release:8.3.5

Component: OBLCRE

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;

Another important account to check is the application account related to the service

To verify this, Right click one of the BSI Services and click the Log On tab. 

You can see the user that needs to be verified

You can update the password on this screen if the service is logging in with a different user.