After Upgrading 11g EUS Databases (e.g., 11.2.0.3 to 11.2.0.4) Registered with OUD, Their Orcloraclehome Values in OUD Do Not Reflect the New DB Version. Unregistering/Reregistering the DBs Lost All the Mappings. How to Align this Attribute Value in OUD? (Doc ID 2115444.1)

Last updated on MAY 04, 2016

Applies to:

Oracle Unified Directory - Version 11.1.2.0.0 and later
Advanced Networking Option - Version 11.2.0.3 and later
Information in this document applies to any platform.

Goal

Upgraded several Oracle databases (DBs), e.g. from 11.2.0.3 to 11.2.0.4, that were registered in Oracle Unified Directory (OUD).

In Oracle Directory Services Manager (ODSM), the orcloraclehome attribute for these DBs had the previous 11.2.0.3 home, so unregistered the databases before the upgrade and then registered them again after the upgrade (could not find documentation on how to update the orcloraclehome so assumed that this was what needed to be done).

Afterwards, the orcloraclehome now has the 11.2.0.4 Oracle home, but in doing this, lost all of the mappings in OUD. So re-mapping was required.

Is there a way to retain the mapping configuration after re-registering the databases (after the upgrade)?
 

Below is an example of the mappings that were setup:


After unregistered/registered the databases (as apart of the Database upgrade), had to rerun the createMapping and grantrole enterprise_role.

This is how EUS is deployed: A global user in each database with the naming convention of MY_dbname (MY_DBTEST). There are database global roles, OUD enterprise roles, and Microsoft Active Directory roles that map together with similar naming. The Oracle database service name is also similar. So below everything is related to the DEV database service.

Database global role - GR_DEV_RO
OUD enterprise role - DEV_RO
AD group - "CN=G-ORA-DEV_RO,OU=Groups,xxxxxx"

There are multiple apps in a database so there will be more than one global user in the database.

 

What is the difference in mapping to a database as opposed to a domain? What are the advantages/disadvantages to both mappings?


If upgrading a database that is registered in OUD from 11.2.0.3 to 11.2.0.4, is it ok to edit the orcloraclehome value in OUD and change the home to the 11.2.0.4 home?

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms