Tuesday 24 July 2018

Error:-Bind Failed. Host='oiddomain.com' Details: [LDAP: error code 53 - Password Policy Error :9001: cn=orcladmin : Your account is locked. Contact your OID administrator.]

Error:-Bind Failed. Host='oiddomain.com'
Details: [LDAP: error code 53 - Password Policy Error :9001: cn=orcladmin : Your account is locked. Contact your OID administrator.]



Cause:-1.)If we used ldapsearch command with wrong password more than
                  allowed times
              2.)When accessing odsm console with orcladmin user with wrong password
                  more than allowed times
Solution:-

1.) export ORACLE_INSTANCE=/u01/Oracle_IDM1/asinst_1

     ./oidpasswd connect=OIDDB unlock_su_acct=true

      OID DB user password:

      [gsdsiConnect] Error Creating OCI Environment :-1

      ERROR * gsldpuUnlockSuAccount * ORA-0:▒▒▒▒ encountered

      OID super user account unlocked successfully.

      OIDDB is the TNS Connect string for your Repository database

      Login to the OID database via sqlplus as an user with DBA privileges
     (example. SYS or SYSTEM) and reset the ODS schema password:

     Connect to OIDDB database as SYS user and change ODS account password

     sqlplus

     SQL*Plus: Release 12.2.0.1.0 Production on Fri Jun 22 12:48:09 2018

    Copyright (c) 1982, 2016, Oracle.  All rights reserved.

    Enter user-name: sys as sysdba

    Enter password:XXXXX

   Connected to:

   Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

  SQL> alter user ods identified by xxxxx;

  User altered.

  SQL> exit

  Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

2.) Now we know  ODS password.Try to unlock the orcladmin account

    export ORACLE_INSTANCE=/u01/Oracle_IDM1/asinst_1

   ./oidpasswd connect=OIDDB reset_su_password=true

    Could not initialize oidldapd Server. Result code = %ld

    export ORACLE_HOME=/u01/Oracle_IDM1
   ./oidpasswd connect=OIDDB reset_su_password=true
   OID DB user password:XXXXX
   new password:XXXXX
   confirm password:XXXXX
   password set

3.)./oidpasswd connect=OIDDB unlock_su_acct=true
    OID DB user password:
    OID super user account unlocked successfully.

   You know the orcladmin password now !!!
   Start OID processes..
   cd /u01/Oracle_IDM1/asinst_1/bin
   opmnctl: starting opmn managed processes…

 Now, you can try to access odsm console and  rerun commands which 
 requires orcladmin  account  passwords




Thanks,
Aditya.

No comments:

Post a Comment