Accelerate Your Identity

3... 2... 1...

oidpasswd connect=orcl unlock_su_acct=true

Missing tnsnames.ora
When trying to unlock the orcladmin account, in a Windows environment, we found that the tnsnames.ora file was not on the system (the database is on a separate machine). Because the tnsnames.ora file is not present then the unlock command will fail with a tns error. To work-around this you can create the tnsnames.ora file and then create an environment called TNS_ADMIN and point it to the directory where sqlnet.ora and tnsnames.ora reside. This will allow the unlock process to work.

One thought on “oidpasswd connect=orcl unlock_su_acct=true

  1. There is tnsnames.ora in OID 11g but under $ORACLE_INSTANCE/config/tnsnames.ora

    default tns alias is OIDDB

    export ORACLE_INSTANCE=/u01/oracle/fmw11g/oid1
    export ORACLE_HOME=/u01/oracle/fmw11g/Oracle_IDM1
    $ORACLE_HOME/ldap/bin/oidpasswd connect=[tns_alias] unlock_su_acct=true

    Here is full link


Leave a Reply