Fixing OBIEE 11g SampleAppV207 OID Password Expiration

It appears that the SampleAppV207 VM’s OID is setup with a fairly short Password Expiration Period!

Have you ever been unable to start BI Server?   Have you seen this error before? 

oracle.ods.virtualization.engine.util.DirectoryException: LDAP Error 49 : [LDAP: error code 49 - Password Policy Error :9000: GSL_PWDEXPIRED_EXCP :Your Password has expired. Please contact the Administrator to change your password.] 

If you have then you will need to be reset the password  and while you are at it modify the policy so that it expires a year from the reset. 

Here are the steps that need to be followed:

  1. Login to the VM using the Oracle account
  2. Open up Terminal
  3. Run the following commands: 

cd /home/oracle/oid/Oracle_IDM1/ldap/bin 

export ORACLE_HOME=/home/oracle/oid/Oracle_IDM1/

export ORACLE_INSTANCE=/home/oracle/oid/bioid2/

      4. The following command unlocks the super user account

./oidpasswd unlock_su_acct=true connect=OIDDB

      5.  Navigate to the Ldap folder:

cd /home/oracle/oid/Oracle_IDM1/bin

       6.     Enter these commands to create the following File:

              vi pwdreset.ldif

             Enter these lines:

             dn: cn=orcladmin,cn=Users,dc=us,dc=oracle,dc=com

             changetype: modify

             replace: userpassword

             userpassword: Admin123

          ESC

          CTRL-X   -- save the file

      7.   Execute the following to reset the password

./ldapmodify –h obieesampleapp.us.oracle.com –p 3060 –D cn=orcladmin –w Admin123 –f pwdreset.ldif

      8.  No to extend the  expire date to 1 year create the following File:  

vi pwdpolicy.ldif

        enter these lines:

dn: cn=default,cn=pwdPolicies,cn=Common,cn=Products,cn=OracleContext,dc=us,dc=oracle,dc=com

changetype: modify

replace: pwdmaxage

pwdmaxage: 3153600

      ESC

      CTL-X to save

    9.  Execute to extend the password expire time

./ldapmodify –h obieesampleapp.us.oracle.com –p 3060 –D cn=orcladmin –w Admin123 –f pwdpolicy.ldif