A user just got this error when trying to login to a database using his enterprise user account...
$ sqlplus matt/password@pcmsndt2
ERROR:
ORA-28043: invalid bind credentials for DB-OID connection
and then this paragraph
ORA-28043: Invalid bind credentials for DB/OID connection
Cause: The database directory password no longer synchronizes with the directory.
Action: Use the Regenerate Password button in Database Configuration Assistant to generate a new directory password for the database, synchronize it with the directory, and store it in the database wallet.
We'd recently added another Oracle Database into the existing OID host and during that process have reset the Wallet Password, so the new database connects ok, but the old one now sees the error.
So to get the old database working again I need to reset the Wallet password so that is resyncs the Database to OID.
on the host run up DBCA, choose the old database, the option to configure the database and then the option to Regenerate the Password
once this was done the sqlplus connection was ok once more.
Checking the wallet password
=========================
On the database host
cd $ORACLE_HOME/bin/
./mkstore -wrl /u01/app/oracle/admin/<SID>/wallet -viewEntry ORACLE.SECURITY.DN
At “Enter wallet password” type in <OID/wallet password>
Should get response like:
ORACLE.SECURITY.DN = cn=<SID>,cn=OracleContext,dc=pcms,dc=internal
./mkstore -wrl /u01/app/oracle/admin/<SID>/wallet -viewEntry ORACLE.SECURITY.PASSWORD
At “Enter wallet password” type in <OID/wallet password>
Should get response like:
ORACLE.SECURITY.PASSWORD = <EncryptedPassword>
./ldapbind -h <OIDHost> -p <OIDPort> -D "<ORACLE.SECURITY.DN>" -w <EncryptedPassword>
Should get response like:
Bind Successful
