After Upgrading 11g EUS Databases (e.g., 126.96.36.199 to 188.8.131.52) 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 OCTOBER 31, 2019
Applies to:Oracle Unified Directory - Version 184.108.40.206.0 and later
Advanced Networking Option - Version 220.127.116.11 and later
Information in this document applies to any platform.
Upgraded several Oracle databases (DBs), e.g. from 18.104.22.168 to 22.214.171.124, that were registered in Oracle Unified Directory (OUD).
In Oracle Directory Services Manager (ODSM), the orcloraclehome attribute for these DBs had the previous 126.96.36.199 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 188.8.131.52 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 184.108.40.206 to 220.127.116.11, is it ok to edit the orcloraclehome value in OUD and change the home to the 18.104.22.168 home?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document