Friday, October 18, 2013

DEV_BIPLATFORM and DEV_MDS passwords expired.


When verified the opmn services, scheduler is down and the log for the scheduler is 

[2013-10-17T10:27:11.000+05:30] [OracleBISchedulerComponent] [ERROR:1] [] [] [ecid: ] [tid: 23c4]  [68008] Scheduler Error:  [[
Current Table: S_NQ_JOB.
[nQSError: 17001] Oracle Error code: 1017, message: ORA-01017: invalid username/password; logon denied
 at OCI call OCISessionBegin.
Current Table: S_NQ_JOB_PARAM.
[nQSError: 17001] Oracle Error code: 1017, message: ORA-01017: invalid username/password; logon denied
 at OCI call OCISessionBegin.
Current Table: S_NQ_INSTANCE.
[nQSError: 17001] Oracle Error code: 1017, message: ORA-01017: invalid username/password; logon denied
 at OCI call OCISessionBegin.
Current Table: S_NQ_ERR_MSG.
[nQSError: 17001] Oracle Error code: 1017, message: ORA-01017: invalid username/password; logon denied
 at OCI call OCISessionBegin.. Errors were encountered while initializing Scheduler's backend database, check database configuration.


Both the passwords DEV_BIPLATFORM and DEV_MDS are expired, so we need to alter the user details with the previous passwords.

 Start the OBIEE domain again and it should work now.
If you don’t know the existing passwords of the users DEV_BIPLATFORM and DEV_MDS then reset the passwords in the database as shown above and also change the password in the following places

Log into console and go to datasources
 Click on the datasource name and then Connection Pool, Change the password to new password and save, Similarly change for all the 4 datasources and save.

Log into em-> Business Intelligence -> Coreapplication
Lock and edit Configuration and change the password
Then Restart the OBIEE domain and everything should work now.


3 comments: