How to Copy / Move/ Migrate Oracle Net Service Names(TNS entries) from one OID OracleContext to a New OID OracleContext
(Doc ID 232930.1)
Last updated on MARCH 14, 2025
Applies to:
Oracle Net Services - Version 8.1.7.0 to 11.2.0.4 [Release 8.1.7 to 11.2]Oracle Internet Directory - Version 9.0.4 to 10.1.4.3 [Release 10gR1 to 10gR3]
Net Manager - NetMgr - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Information in this document applies to any platform.
Oracle Internet Directory - Version: 2.1.1 to 10.1.4.3
Goal
This article is for DBAs using LDAP for Oracle Net service naming, but not particularly familiar with Oracle Internet Directory (OID) and the tools to manage LDAP directory entries.
It describes the steps to create a new OracleContext under a new Directory Information Tree (DIT) or subscriber DN and copy the Oracle Net service names from the old DIT to the new DIT.
Slight variations on this technique can be used to backup Oracle Net Service names or to migrate them from one server to another.
Warning: This technique does not take into account the sub-entries which if not present will cause NetManager to fail if used to manage the entries.
See <Note 359545.1> and for a solution see <note 859716.1>
See <Note 359545.1> and for a solution see <note 859716.1>
Solution
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
| Goal |
| Solution |
| 1. Export the existing Oracle Net Service names from the current OracleContext. |
| 2. Create the new subscriber DN or DIT where the context is to be created. |
| 3. Create a new OracleContext under this DIT. |
| 4. Edit the LDIF file(s). |
| 5. Load the Oracle Net service names from the LDIF files to the new DIT. |
| References |