Friday

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/txkrun.pl -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:

weblogic.application.ModuleException:
        at weblogic.jdbc.module.JDBCModule.prepare(JDBCModule.java:302)
        at weblogic.application.internal.flow.ModuleListenerInvoker.prepare(ModuleListenerInvoker.java:199)
        at weblogic.application.internal.flow.DeploymentCallbackFlow$1.next(DeploymentCallbackFlow.java:517)
        at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
        at weblogic.application.internal.flow.DeploymentCallbackFlow.prepare(DeploymentCallbackFlow.java:159)
        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.





36 comments:

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...

ORACLE APPS R12 VIDEOS

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...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +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: iwebworldinfo@gmail.com

Iwebworld Info said...

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

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.

Lathika Honey said...

This Blog Provides Very Useful and Important Information Digital Transformation Consulting Thanks for sharing.

Nadeem Malik said...

hello sir,
thanks for giving that type of information. digital marketing company in delhi

Vikash Kumar said...

Epoxy Grout manufacturer in delhi

Akash Thakur said...

nice work keep it up thanks for sharing the knowledge.Thanks for sharing this type of information, it is so useful. Laminated Doors manufacturer in hubli

Amase LED Lighting said...

hi, nice information is given in this blog. Thanks for sharing this type of information, it is so useful for me. nice work keep it up. led lawn lights in delhi

Mobile app development company in Canada said...

A Professional mobile app development Canada company offering Android & iOS app development services. I like its sharing. Thanks you

Pooja Rao said...

website designing company in Gurgaon
ppc services in gurgaon
PPC Expert For Technical Support

Pooja Rao said...

Namkeen Pouch Manufacturers
Rice Bags Manufacturers
Pouch Manufacturers

مروة محمد said...

شركة تنظيف بالدمام

Nadeem Malik said...
This comment has been removed by the author.
Digital Planner said...

pouch manufacturers
wall putty bag manufacturers

Digital Planner said...

Bosch Fridge Repair in Noida
Godrej Fridge Repair in Noida
whirlpool Fridge Repair in Noida
videocon Fridge Repair in Noida
Samsung Fridge Repair in Noida
Lg Fridge Repair in Noida
Haier Fridge Repair in Noida

anirudh said...


I like your post very much. It is very much useful for my research. I hope you to share more info about this. Keep posting!!
Best DevOps Training Institute