Need to move the OID metadata, schemas from one database to another database.

Folks,

We are running OID 11.1.1.9.0 against Oracle db 12.1.0.1.

Our OID is part of our SSO mechanism, along with OAM, to provide SSO access to EBS 12.2

We also use the DIP sync process to , to pull use information from AD into OID.

Use orcl_guild to authenticate users into EBS.

This all works fine.

We need to move the OID database, that is storing the OID metadata, from server A to server B.

The OID db SID and Service name will change , along with the Server.

--

Approach that I am thinking is to stop OID process, first, do a database export of all the OID schemas from the source database to the target database..