Home » Fusion Middleware & Colab Suite » Business Intelligence » BI server is down (OBIEE 11g)
BI server is down [message #601356] Tue, 19 November 2013 23:40 Go to next message
mary.yujin
Messages: 25
Registered: June 2010
Junior Member
Hi,

Few days back i changed the password of DEV_BIPLATFORM through SQL editor. Then the same password is given in
http://localhost:7002/console --> Data Sources --> JDBC Connection for the following
aps_datasource
bip_datasource
calc_datasource
EPMSystemRegistry
raframework_datasource
rtd_datasource

After that i restarted the BI Server. Then when i come to http://localhost:7002/EM , It is not showing 100%. It shows one component is down. And found that

1) Essbase server is down.
2) Account is Locked for DEV_BIPLATFORM.

How to solve this issue. Please advise me.

Thanks
Re: BI server is down [message #601363 is a reply to message #601356] Wed, 20 November 2013 01:42 Go to previous messageGo to next message
John Watson
Messages: 4611
Registered: January 2010
Location: Global Village
Senior Member
If you unlock the account and it gets locked again, then some other process is attempting to connect, with the old password. Look at dba_audit_session, logon attempts are audited by default, and you should be able to find the culprit.
Re: BI server is down [message #601367 is a reply to message #601363] Wed, 20 November 2013 02:45 Go to previous messageGo to next message
mary.yujin
Messages: 25
Registered: June 2010
Junior Member
Thank you for your quick response. I checked the contents of dba_audit_session. But there is no records after 06th aug 2013. Please help me. My work got stuck

Mary.
Re: BI server is down [message #601369 is a reply to message #601367] Wed, 20 November 2013 03:03 Go to previous messageGo to next message
John Watson
Messages: 4611
Registered: January 2010
Location: Global Village
Senior Member
Show some initiative, Mary!
Enable the audit, which someone disabled back in August. Then unlock the account, again, and when it is locked lock at the audit records.
Re: BI server is down [message #601450 is a reply to message #601369] Thu, 21 November 2013 03:01 Go to previous messageGo to next message
mary.yujin
Messages: 25
Registered: June 2010
Junior Member
Please advise me how to enable the audit.

Thanks,
Mary
Re: BI server is down [message #601458 is a reply to message #601450] Thu, 21 November 2013 04:07 Go to previous message
John Watson
Messages: 4611
Registered: January 2010
Location: Global Village
Senior Member
Chapter 9, http://docs.oracle.com/cd/E11882_01/network.112/e36292/toc.htm
Previous Topic: BMM Layer
Next Topic: Can I force uppercase on dashboard prompt value entry?
Goto Forum:
  


Current Time: Thu Oct 02 02:10:49 CDT 2014

Total time taken to generate the page: 0.09803 seconds