ldifwrite Fails With "Invalid Password" (Doc ID 444846.1)

Last updated on AUGUST 30, 2023

Applies to:

Symptoms

• ldifwrite fails with:

  ldifwrite -c <OID_DB_SID> -b "cn=groups,dc=<COMPANY>,dc=com" -f groups.ldif
  Invalid password for OiD

• $ORACLE_HOME/network/admin/sqlnet.ora correctly points to tnsnames *first*:

  names.directory_path = tnsnames, ...

• $ORACLE_HOME/network/admin/tnsnames.ora file has an entry for the connect string used in the ldifwrite command
• the correct password for the ODS schema is being used when prompted by ldifwrite:

  sqlplus ods/<pwd>@<OID_DB_SID>

  The user is connected to the database
• neither upper nor lower case passwords work in the ldifwrite command
• resetting the ODS password to the OID database via sqlplus, to be assured that the correct password is in use, made no difference:

  alter user ods identified by ODS

• The wallets were backed up and then removed from the OID $ORACLE_HOME/ldap/admin directory: :

  oidpwdlldap1
  oidpwdr<OID_DB_SID>

  then recreated:

  oidpasswd connect=<OID_DB_SID> change_oiddb_pwd=true
  oidpasswd connect=<OID_DB_SID> create_wallet=true

  but this didn't help

• setting the ODS and orcladmin passwords to be the same as the ias_admin password didn't help
• environment variables are set correctly:

  $ORACLE_SID=<OID_DB_SID>
  $ORACLE_HOME=<ORACLE_HOME_PATH>
  $PATH --> set PATH to have the $ORACLE_HOME/bin first

• the correct ldifwrite is in use:

  [oracle@whqwebdev4 ~]$ which ldifwrite
  /wd4001/app/oracle/product/10.1.0t/bin/ldifwrite

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.