Oracle Technology‎ > ‎OID‎ > ‎

OID Notes

Upgrading OID to 11.1.1.5.0

posted 25 Nov 2011, 02:15 by Alan Nolan-Davies   [ updated 28 Nov 2011, 03:53 ]

to upgrade OID to 11.1.1.5.0 from OID 11.1.1.2.0 we need to do this in a couple of steps.

ODSM 11.1.1.5.0

  1. upgrade OID software using runInstaller
  2. upgrade OID schema using psa (patch set assistant)
  • set ORACLE_HOME to ORACLE_IDM1 in our case use .oraenv and specify #oim
  • cd $ORACLE_HOME/bin
  • ./psa -dbConnectString nd1has01:1521/POID -dbaUserName sys -schemaUserName ODS
for HP-UX the following files were used.

ofm_idm_hp_itanium_11.1.1.2.0_64_disk1_1of1.zip - 1.9GB'ish = downloaded from OTN
V26678-01_OIM_HPIA64_111500.zip - 1.6GB'ish = downloaded from The Oracle Software Delivery Cloud (Edelivery.oracle.com)

ORA-28043: invalid bind credentials for DB-OID connection

posted 22 Jul 2011, 06:35 by Alan Nolan-Davies   [ updated 23 Dec 2011, 03:43 ]

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

using our trusty friend Google I found this page http://download.oracle.com/docs/cd/B19306_01/network.102/b14269/configur.htm 

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

1-2 of 2