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.

OBIEE 11g Purge Cache Automatically

Open the OBIEE rpd and create a new Database in Physical Layer

(Right click on Physical Layer - > New Database)

Enter Database Name, Type and check Allow direct database requests by default

And Click OK

Create Connection Pool for the database

(Right Click on Database -> New Object -> Connection Pool)

 Enter Details of the Connection Pool
Enter Name,Call Interface Type and select Datasource Name from the drop down (appropriate ODBC) 

And Save the rpd

Log Into OBIEE Presentation and create a new Analysis to purge OBIEE cache

 Click on create Direct Database Request

 Enter "Database"."Connection Pool Name" and "Call SapurgeAllCache(); " in the SQL Statement box.

 Click on Results. Report results shows that Cache has been Successfully purged.

 And Save the analysis "Cache Purge".Select the report in catalog and click more and click Schedule

 Provide the details of the scheduler to schedule the report to execute. Whenever the scheduler executes the report then cache will be purged automatically.