My Oracle Support Banner

How to Copy Users and Groups from One OracleAS Infrastructure to Another (Doc ID 251776.1)

Last updated on OCTOBER 03, 2019

Applies to:

Portal - Version 9.0.4 to [Release 10g to 10gR2]
Oracle Internet Directory - Version 9.0.4 and later
Portal - Version to [Release 10gR2]
Information in this document applies to any platform.


Explain how to copy Single Sign-On (SSO) users from one Oracle9iAS version 9.0.2 infrastructure Oracle Internet Directory (OID) to another and to explain some of the additional considerations for OracleAS 10g 9.0.4 and above. In fact these steps can also be applied to moving any user and group entries from one OID to another, for example for Enterprise User Security (EUS) RDBMS use.

For migrating Portal from one infrastructure to another see the Oracle Application Server Administrator's Guide 10g Release 2 (10.1.2) Chapter 11 Staging a Test Environment from a Production Environment.

For older versions of Portal see Doc ID 228516.1 - How to copy (export/import) Portal database schemas of IAS 9.0.2 to another database - Step 6 deals with moving users and groups.

Scope & Application
This is aimed at Oracle9iAS/OracleAS 10g and OID administrators who simply need to move SSO users from one system to another. To some extent Portal groups are taken into account, though these may not always be present.

This approach can also be used as a general reference to loading SSO users and groups from LDIF files, as well as for adding EUS users into OID.

When moving to Portal version 9.0.4 or above there will be new Portal groups already present in the target infrastructure of the format portal.<6 digit number>.<4 digit number>. It is likely that one would wish to populate some or all of the users to the "uniquemember" attribute of these groups to assign appropriate privileges. This is outside the scope of this note.

Note that this note does not take into account moving Forms or Reports resources. See Doc ID 244526.1 How To Create and Copy SSO User Resources ( RADs )



To view full details, 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 a vibrant support community of peers and Oracle experts.