After Upgrading 11g EUS Databases (e.g., 18.104.22.168 to 22.214.171.124) 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?
Last updated on MAY 04, 2016
Applies to:Oracle Unified Directory - Version 126.96.36.199.0 and later
Advanced Networking Option - Version 188.8.131.52 and later
Information in this document applies to any platform.
Upgraded several Oracle databases (DBs), e.g. from 184.108.40.206 to 220.127.116.11, that were registered in Oracle Unified Directory (OUD).
In Oracle Directory Services Manager (ODSM), the orcloraclehome attribute for these DBs had the previous 18.104.22.168 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 22.214.171.124 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 126.96.36.199 to 188.8.131.52, is it ok to edit the orcloraclehome value in OUD and change the home to the 184.108.40.206 home?
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