OAM and EBS Breaks after Cloning

We are in the process of integrating E-Business Suite with Oracle Access Manager (OAM). Its setup in DEV and TEST but not in PROD yet.    There was a requirement to reclone DEV and as a result the integration with OAM broke.

We ran all the configuration steps on the EBS side, such as:

  • $FND_TOP/bin/ -script=SetSSOReg -registerinstance=yes
  • Verifying ASADMIN was active and the correct password.
  • Profile options to configure authentation:
    • Applications SSO Type
    • Applications SSO Login types
    • etc...
  • Business Events to make sure account creation and modifications synchronizes correctly.
  • We skipped all of the tasks to be performed on the OAM side since they were already done.

However, when restarting Access Gate we would see the following error in the logs:

        at weblogic.jdbc.module.JDBCModule.prepare(
        at weblogic.application.internal.flow.ModuleListenerInvoker.prepare(
        at weblogic.application.internal.flow.DeploymentCallbackFlow$
        at weblogic.application.utils.StateMachineDriver.nextState(
        at weblogic.application.internal.flow.DeploymentCallbackFlow.prepare(
        Truncated. see log file for complete stacktrace
Caused By: weblogic.common.resourcepool.ResourceSystemException:
Could not connect to 'oracle.apps.fnd.ext.jdbc.datasource.AppsDataSource'.

The returned message is: ORA-01017: invalid username/password; logon denied

We triple checked the datasource credentials defined in the Access Gate server but still nothing worked.  It turns one of the steps to deploy Access Gate was to copy the dbc file from $FND_SECURE over to the $MW_HOME/appsutil/accessgate/dev directory.   Since DEV was recloned the APPL_SERVER_ID value had changed.    We re-copied this file, bounced the Access Gate server and everything started working again.

Since we don't have EBS integrated with OAM in PROD yet i'm not sure if we will need to do any additional steps after a clone.   I'm thinking all the steps above will apply except for maybe business events as they will already be configured properly in PROD.   I'll update this post if I have to do anything else.


Anonymous said...

thanks for share..

Oracle Applications said...

I used keyword "Oracle application" to search the best Post, found your blog...

thanks for sharing...

Nagendra Reddy B K said...


Cub Training said...

this is very nice article and very good information for Oracle ADF Learners. our Cubtraining also provide all Oracle Courses

Sekhar Byna said...

Very nice Article
you can also visit
Oracle apps blogs

johnson said...

Nice article.Thank you for sharing this.We provide Best Oracle Apps DBA Online Training. ORACLE APPS DBA ONLINE TRAINING

Venkata Reddy said...

nice blog
Oracle Apps DBA Online Training

John Nash said...

Thx a lot For sharing such a nice information on
Oracle 11g DBA Online Training

Oracle Apps Technical Online Training said...

I don't know how the people are more crazy about this technologies....
For best Oracle Apps Technical Online Training

Tableau Training said...

I need to thank you for this great read!! I definitely loved every little bit's of this web page.I've got you saved as a favorite to look at new stuff you post…
Tableau Online Training

Angularjs Training said...

Hi, very thank i've to just searching for this web page and all concepts or really well.I want to just been searching for this subject for a long time and yours is the greatest I've found out till now
Angularjs Online Training

Sridevi Koduru said...

Sridevi Koduru (Senior Oracle Apps Trainer
LinkedIn profile -
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at | +91 - 9581017828.

Priya Sethuraman said...

Truely a very good article on how to handle the future technology. After reading your post,thanks for taking the time to discuss this, I feel happy about and I love learning more about this topic. keep sharing your information regularly for my future reference. This content creates a new hope and inspiration with in me. Thanks for sharing article like this. The way you have stated everything above is quite awesome. Keep blogging like this. Thanks.
Hadoop Training in Chennai
Hadoop Training
Best Hadoop Training in Chennai
Best Hadoop Training Institute in Chennai

Praveen Kumar said...

Valuable information thanks for sharing Oracle APPS DBA Online Training

PlSQL Online Trainings said...

It fun to have a content like this really worth to read it
PlSQL Training

Sindhuja Ravi said...

Truly a very good article on how to handle the future technology. After reading your post,thanks for taking the time to discuss this, I feel happy about and I love learning more about this topic
SEO Company in Chennai

Abiya Carol said...

Great site for these post and i am seeing the most of contents have useful for my Carrier.Thanks to such a useful information.Any information are commands like to share him.

Digital Marketing Course in Channai

ramana said...

thank you for posting this blog, this is usefull to me oracle apps online training in hyderabad

Iwebworld Info said...

this blog providing good information To learn NodeJS AngularJS MongoDB Training contact:

Iwebworld Info said...

this blog providing good information To learn NodeJS AngularJS MongoDB Training contact:

Ancy merina said...

Thanks for sharing this beautiful article keep sharing.
Web development company in bangalore
Outsource magento ecommerce services india
ECommerce Website developers in bangalore

Nicholas de said...

Nice blog has been shared by you. before i read this blog i didn't have any knowledge about this but now i got some knowledge so keep on sharing such kind of an interesting blogs.

Weblogic Server 12cR2 Training

Peter Johnson said...

Very Helpful Post And Explained Very Clearly About All the things.Very Helpful. Coming To Our Self We Provide Food Service Parts Through Out US At Very Affordable Prices And Also We Offer Same Day Shipping In US.We Offer Only Genuine Products.Really Thanks For Sharing Such An Valuable Info.