| BI server is down [message #601356] |
Tue, 19 November 2013 23:40  |
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  |
John Watson
Messages: 8964
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 |
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 |
John Watson
Messages: 8964
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 #634987 is a reply to message #601356] |
Wed, 18 March 2015 11:52 |
 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
