I am having issues with OBIEE 11g while running suddenly users are not able to login to the application. when i investigated and search the web i found that my BIPLATFORM user account was locked. so i unlocked it and then i have to reboot the machine to have clean start of my environment. It is my dev environment the specifications of my laptop is
RAM: 8GB, harddisk: 250gb, Windows 7 professional, RCU DB is Oracle 11. I want to know what is the root cause and i want to fix it please help me with this. This is repeating every other or 2 days.
You need to make that schema owner have a non-expiring password in the database (DEV_BIPLATFORM or Prefix_BIPLATFORM depending on what you prefixed it with). It shouldn't get locked on it's own unless there's a default setting for the same in the database.
Thanks for taking time and replaying.
I checked that DEV_BIPLATFORM owner has non -expiring password. When i queried for the account status it givens the account_status as "locked (timeout)" in the database. This is happening randomly i am not sure where i can find what is the root cause of the account is getting locked.
Any help on finding which log file i need to refer.