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: 26
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: 8919
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: 26
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: 8919
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: 26
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 messageGo to next message
John Watson
Messages: 8919
Registered: January 2010
Location: Global Village
Senior Member
Chapter 9, http://docs.oracle.com/cd/E11882_01/network.112/e36292/toc.htm
Re: BI server is down [message #634987 is a reply to message #601356] Wed, 18 March 2015 11:52 Go to previous message
darshan30589
Messages: 3
Registered: October 2012
Location: Ahmedabad
Junior Member
Hi,

I have face same issue, Go to Database of that domain.

1)select username,account_status from dba_users where username like '%DEV%';

2) alter user DEV_BIPLATFORM identified by YOUR_PASSWORD account Unlock;

Then Start you BI Server1.
Previous Topic: Obiee with teradata parallel connection
Next Topic: Oracle Data Integrator, Customised Delete Operation
Goto Forum:
  


Current Time: Tue Mar 19 05:18:03 CDT 2024