Migrate Users to/from OID and Oracle Apps 11i/R12

Hey Atul,

Nice and to the point information. Gud work.

Cheers
Amit

Dear All,
we use oid 10.2.4 , we have problem in synchronizing data from oid to db. below lines are shown in the log file. Can any body help us?

Enabling API Debugging..
Initialization – Starting for Mode ChangeSync
Prov Reader – Initialize : Instantiating oracle.ldap.odip.prov.LDAPEventReader
LDAP URL : (srv-metasearc.padl.local:636 cn=odisrv+orclhostname=srv-metasearc,cn=registered instances,cn=directory integration platform,cn=products,cn=oraclecontext
Specifying binary attributes: mpegvideo objectguid objectsid guid usercertificate orclodipcondirlastappliedchgnum
Connecting in SSL
LDAP Connection success
Update search count = 100
Intialized the LDAP Reader.
Status Attribute orcluserapplnprovstatus;rasaApp_rasaappDefault Subscription Status Attribute:orcluserapplnprovstatus;rasaapp
Prov Reader – Initialized
Prov Writer – Initialize : Instantiating oracle.ldap.odip.prov.PLSQLEventWriter
[fine] PLSQLEventWriter : Connecting …
Loaded driver..: oracle.jdbc.OracleDriver
Using Service Name to connect – URL : jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=nlidb))),user : nashr
DataBase Connection Success
[fine] PLSQLEventWriter : Call Stmt Initialized successfully….
Writer : Last Applied Change Key : 3480
Prov Writer – Initialized ..
Initialization – Ending ..
Event Propagation – Begin..
Event Propagation – End ..
Updating the Status..
Setting Event Success Count : 0
Setting Event Failure Count : 0
Propagation Status : SUCCESS
Last change Key Set to:3480
Profile status Update – SUCCESS
Cleaned/Closed Readers and Writers
Initialization – Starting for Mode Bootstrap
Prov Reader – Initialize : Instantiating oracle.ldap.odip.prov.AppBootstrapEventReader
Provisioning Failure Retry Limit for App is : 1000
Status Attribute in OID:orcluserapplnprovstatus;rasaApp_rasaapp
Default Subscription Status Attribute:orcluserapplnprovstatus;rasaapp
Timestamp attribute 20080713064905z
LDAP URL : (srv-metasearc.padl.local:636 cn=odisrv+orclhostname=srv-metasearc,cn=registered instances,cn=directory integration platform,cn=products,cn=oraclecontext
Specifying binary attributes: mpegvideo objectguid objectsid guid usercertificate orclodipcondirlastappliedchgnum
Connecting in SSL
LDAP Connection success
AppBootstrap searchFilter : (&(objectclass=orcluserv2)(|(orcluserapplnprovstatus;rasaApp_rasaapp=PROVISIONING_FAILURE)(!(orcluserapplnprovstatus;rasaApp_rasaapp=*))))
Search Time : 16
App Bootstrap Search Successful for application : ‘null’
Intialized the App Bootstrap Event Reader.
Prov Reader – Initialized
Prov Writer – Initialize : Instantiating oracle.ldap.odip.prov.LDAPEventWriter
LDAP URL : (srv-metasearc.padl.local:636 cn=odisrv+orclhostname=srv-metasearc,cn=registered instances,cn=directory integration platform,cn=products,cn=oraclecontext
Specifying binary attributes: mpegvideo objectguid objectsid guid usercertificate orclodipcondirlastappliedchgnum
Connecting in SSL
LDAP Connection success
Retreived Factory from Profile..
Prov Writer – Initialized ..
Initialization – Ending ..
Event Propagation – Begin..
More Data Found..
Reader finds some data…
More Data Found..
Getting Users for the BootStrap cases..
More Data Found..
Processing User – cn=user2
UserCreateTimeStamp 20080714131248z
Application TimeStamp 20080713120917z
Upgrade Timestamp 20080713064905z
Current status : null
Current User FailCount : 0
[fine] Inside Generate Events..
[fine] Object Type identified as : USER
[fine] LDAP Changetype : ADD
[fine] getObjTypeRules:Processing Event Defn (0) – ,Object Type:ENTRY
[fine] getObjTypeRules:Processing Event Defn (1) – ,Object Type:USER
[fine] getObjTypeRules:Matched Object Type :USER
[fine] getObjTypeRules:# Event Rules:0
[fine] EventEngine: No ObjectType Rules for :USER – changeType : ADD
[fine] EventEngine: # Generated Events : 0

Events to write 0
Process Event Status for 0
Not calling status processor
Event Propagation – End ..
Updating the Status..
Cleaned/Closed Readers and Writers

Hi Sir,

This iS Ravi from UK. According the doc –Before MIgrating EBS users to OID, we have to set CLASSPATH env variable point to $APPL_TOP/java(in $APPL_TOP there is no java dir so how we can set CLASSPATH for the $APPL_TOP/java). OR the $JAVA_TOP is already pointing to CLASSPATH env variable so there is any java path has to add existing paths of CLASSPATH env variable in adovars.env ?

Please suggest me and guide.
Thanks in advance

Regards,
Ravi

$APPL_TOP/java should be in CLASSPATH before executing “java oracle.apps.fnd.oid.AppsUserExport” or “java oracle.apps.fnd.oid.LDAPUserImport”

Hi Sir,

This $APPL_TOP/java should be in CLASSPATH is temporary purpose (like export CLASSPATH=$APPL_TOP/java) or permannetly in adovars.env?
before executing “java oracle.apps.fnd.oid.AppsUserExport” or “java oracle.apps.fnd.oid.LDAPUserImport” .
Why CLASSPATH should be in $APPL_TOP/java?

Thanks for your support. Please

Regards,
Ravi

Hi Sir,

The $APPL_TOP/java(created java dir in $APPL_TOP) should be in CLASSPATH is temporary setting(like export CLASSAPTH=$APLL_TOP/java) or permanent setting in adovars.env ?

Please suggest for above.

Thanks,
Ravi

Hi,

The $APPL_TOP/java is sameas $JAVA_TOP….rite?

Hi Sir,

After implementing of Infrastructure 10.1.4 integration with EBS 11i .Canot open the Application home page through sso page but I can open EBS home page throug login of OracleAS10g Infra server console navigate :homepage> >SSO:orasso>Administer via SSO web Application.

Why EBS home page is not opening through http://server:port/oa_servlets/AppsLogin. of using SSO page ?

Any idea on it.
Waiting for your suggestion.
Thanks in advance.

Regards,
Ravi

Ravi,
Install IE http header (tool to enable debugging in browser which shows HTTP header)

Then try accessing apps url to check if this is forwarding request to SSO page or not.

Check in error_log & Jserv log of 11i to check issue

Hi Atul,

I have registered at http://www.teachmeoracle.com , but still my id has not been activated.

MY ICQ Number is : 0601
Username is: vivek_modi1

Please help me on this.

Thanks and Regards,
Vivek Modi.

Facing Issue:
~~~~~~~~~~~~~~~

When we are cloning an 111i Application, after DB recovery when we try to connect to DB from MT Node using below string, we are getting error as,

From MT Node: sqlplus apps/****@SID

SQL*Plus: Release 10.2.0.3.0 – Production on Fri Dec 26 22:55:13 2008

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

ERROR:
ORA-30006: resource busy; acquire with WAIT timeout expired

Any idea for this error.

This errror we are getting only for RAC Instances only and not for Single node DB.

Please advice.

Thanks

Hi Atul,

Please let me know how to restrict the same user connecting with multiple sessions in 11i
in profile option level

Thanks,
Rajesh

Hi!Atul..

I installed OIM11.1.1.3.0 and OER11.1.1.5.0 for Migration.
How to migrate UserData from OIM10g to OIM11g by using the OracleEnterpriseRepository.

Thanks&Regards,
Veeru

@ Veeru,
I am not clear with requirement, Do you want to use Enterprise Repository (OER) to migrate user data from OIM ? (never heard of OER to be used for this purpose)

Do you have any reference doc or any link which talks about using OER for user migration ?

Hi!
Thanks for your reply..
I followed below link for DataMigration.. ..http://www.techrepublic.com/article/migrating-user-files-and-settings/5090551..,in this link he gave this 11.1.1.x.x-OER-10gMigrate.zip file..when i search this zip file..i didnt get anywhere,then i approched the oracle Discussion forum,one of the reply, I got the zip file by using the OER111150_generic.jar..
then after I completed my Installation.then what should I do right now?

Thanks in Advanced,
Veeru

@ Veeru, I can’t find any thing in link which suggestes that this is for OIM (Oracle Identity Manager) or using OER

Thanks for your reply..
Is it use for Data Migration from OIM10g to OIM11g.
What should I do?Please let me know Which is the best option for DataMigration?

Regards,
Veeru

@ Veeru,
Do you have two OIM systems (OIM 10g & OIM 11g) across which you wish to replicate users

or

You have OIM 10g which you wish to upgrade to OIM 11g

OIM – Oracle Identity Manager

Hi!

Thanks for your reply,

Yes,I had two OIM systems(OIM 10g & OIM 11g).I have to Migrate the entire data from OIM10g to OIM11g.Please let me Know Which is the right way to get the Data.

I want to migrate.

Thanks in Advanced,
Veeru

Hi!

1. I’m beginner to OIM. I don’t know about OIM.

2. But,I have two OIM systems(OIM 10g & OIM 11g).

3. I have to Migrate the entire data from OIM10g to OIM11g.

Please let me Know Which is the right way to get the Data.

I want to migrate.

Thanks & Regards

Nagendra.

@ Nagendra,
What you need is a upgrade path from 10g OIM to 11g OIM (I was expecting OIM upgrade in OIM 11.1.1.5 but it looks like its not out yet)

Here is 11.1.1.5 IDAM upgrade guide (steps fro OIM upgrade are not yet in doc)
http://download.oracle.com/docs/cd/E21764_01/upgrade.1111/e10129/toc.htm

So for OIM 10g to OIM 11g will have upgrade scripts which will upgrade OIM schema from 10g OIM to 11g OIM.

Hi!AthulKumar,

Iam new beginer to OIM.now iam insatlling OER11g,but in which way i use the OER11g.Whats the main role and purpose of OER11g.Could you please give the details of OER11g??

Thanks & Regards,
Veeru

@ Veeru,

Check this post to know more about OER 11g http://onlineappsdba.com/index.php/2010/02/25/oracle-launches-soa-governance-11g-enterprise-repository-service-registry-soa-management-with-em-and-web-services-manager/

Hi!
Thanks for your reply,

But i want to see the entire picture for about OER11g.with screen shots. how to use am I?

Thanks & Regards,
veeru

Hi Atul,

I installed OID11.1.1.3 and E-Business Suite 12.1.1 on different machines.
Now I want to Register and integrate Oracle E-Business Suite instance with Oracle Internet Directory (OID).
How to set up user synchronization (provisioning) between Oracle E-Business Suite and OID and
how to Verify that user provisioning is working correctly before proceeding with the rest of this integration.

Thanks & Regars,

Nagendra.

@ Nagendra,

Use below command on EBS

$FND_TOP/bin/txkrun.pl \
-script=SetSSOReg \
-registeroid=yes \

Follow section 6 of doc 876539.1 – Using the Latest Oracle Internet Directory 11gR1 Patchset with Single Sign-on and Oracle E-Business Suite

and Appendix A, Section 1.2. Register Instance and Section 1.4: Register OID of

376811.1 Integrating Oracle E-Business Suite Release 12 with Oracle Internet Directory and Oracle Single Sign-On

Also follow my EBS – OID/SSO series at (ignore SSO piece from here).

I am going to cover step by step EBS R12 integration with OID 11.1.1.4 on this blog so stay tuned.

Hi Atul,

I want to integrate OAM 11g and EBS 12.1.1. For that it needs OID(11g).How can I set up and verify synchronization and provisioning of users between EBS and OID.

Thanks & Regards,
Narendra.Ch

Hi Atul,
I’ve been using LDAPUserImport to read a file generated by ldifwrite. It imports users into FND_USER but populates the customer_id column there.
When users are manually created in “Define User” that column is not populated. Is there a way to use LDAPUserImport without populating customer_id? I have already disabled various Business Events named “Cust%create” but no luck.

Thanks,

Hi,

We want to migrate only few users for OID login.
Is it possible other users can use the same URL that they were using earlier?
If yes, How can we achieve this goal?

Regards,
Chandan

Is there any way to migrate users from dba_users table to OID

@ karthiga,
Why would you do that ?

How many users do you have in dba_users table ?

We have nearly 150 users in dba_users, which we need to migrate to OID.

is there any utility to do this ?

I could see notes only for migrating from fnd_users to OID.

I tried using ‘UMU – user migration utility’

And it works well, with few limitations.

Regards,
Karthiga