OBIEE 11g BI Server not starting due to expired password

I installed sampleapp v207, and after few days, BIServer and Presentation Services do not start up. WLS Admin Server throws an error that password in expired. This really referrs to OID password, which needs to be changed.



This is a known bug for sampleapp v207. Issue is caused due to OID password expiry set to a default period of 120 days. In order to reset the default password and also set password expiry to never expire, do the follow.

Open a terminal inside SampleApp v207 image and execute the following commands. Then, restart opmn and all services should come up.

# Following commands resets password expiry parameter to 0 (never expire).
# It also sets passwords of orcladmin, oiduser1 & oiduser2 to default Admin123).

export ORACLE_HOME=/home/oracle/oid/Oracle_IDM1
export ORACLE_INSTANCE=/home/oracle/oid/bioid2
export LDAP_PRMS="dn: cn=default,cn=pwdPolicies,cn=Common,cn=Products,cn=OracleContext,dc=us,dc=oracle,dc=com\nchangetype: modify\nreplace: pwdmaxage\npwdmaxage: 0"
export LDAP_PWD="cn=Users,dc=us,dc=oracle,dc=com\nchangetype: modify\nreplace:userpassword\nuserpassword:Admin123"
cd /home/oracle/oid/Oracle_IDM1/
echo "Admin123" | ./ldap/bin/oidpasswd connect=OIDDB unlock_su_acct=true
echo -e $LDAP_PRMS | ./bin/ldapmodify -D cn=orcladmin -w Admin123 -h localhost -p 3060
echo -e "dn: cn=orcladmin,"$LDAP_PWD | ./bin/ldapmodify -D cn=orcladmin -w Admin123 -h localhost -p 3060
echo -e "dn: cn=oiduser1,"$LDAP_PWD | ./bin/ldapmodify -D cn=orcladmin -w Admin123 -h localhost -p 3060
echo -e "dn: cn=oiduser2,"$LDAP_PWD | ./bin/ldapmodify -D cn=orcladmin -w Admin123 -h localhost -p 3060
cd –

This solution does work..!!