Oracle eBusiness Suite R12 - HDD Clone - 500 Internal Server Error

Hi,

We have an Oracle Production Environment of Oracle Release 12, with Oracle DB 10G running on Windows 2003, with Oracle RAC. I have two database servers connecting to a SAN, with an Oracle Application Server, all on Windows 2003. We have an identical Test Environment, which was corrupted due to a goof up of a Systems Admin. We're now attempting to clone the Production environment to the Test, with the Test on a separate offline switch. We've carried out a SAN to SAN HDD Clone (used Acronis 11.5 Disk Clone). We also clones the App Server and each of the DB Servers with the same Disk Cloning Method, using Acronis Boot Media Disk Clone option. All servers and the SAN are up and working fin, with the RAC instance running without any issues. The application server as well has come up with no issues other than the Oracle Fulfillment Server Service not starting up (FNDLIBR error). The default web page gives an error 500 Internal Server Error. I believe it has something to do with the Application Server ID, probably in the dbc file. The error is below. Any assistance to get this up will be really appreciated as we have a couple of urgent Oracle Patches related to Accounting and Social Security that need to be implemented at the earliest (we're already delayed by 2 months)

500 Internal Server Error
oracle.apps.fnd.cache.CacheException      at oracle.apps.fnd.cache.AppsCache.get(AppsCache.java:228)      at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1485)      at oracle.apps.fnd.profiles.Profiles.getProfile(Profiles.java:354)      at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfileFromDB(ExtendedProfileStore.java:211)      at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfile(ExtendedProfileStore.java:171)      at oracle.apps.fnd.profiles.ExtendedProfileStore.getProfile(ExtendedProfileStore.java:148)      at oracle.apps.fnd.common.logging.DebugEventManager.configureUsingDatabaseValues(DebugEventManager.java:1259)      at oracle.apps.fnd.common.logging.DebugEventManager.configureLogging(DebugEventManager.java:1114)      at oracle.apps.fnd.common.logging.DebugEventManager.internalReinit(DebugEventManager.java:1083)      at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1050)      at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1037)      at oracle.apps.fnd.common.AppsLog.reInitialize(AppsLog.java:595)      at oracle.apps.fnd.common.AppsContext.initLog(AppsContext.java:593)      at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:570)      at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:524)      at oracle.apps.fnd.common.AppsContext.<init>(AppsContext.java:292)      at oracle.apps.fnd.common.WebAppsContext.<init>(WebAppsContext.java:1081)      at oracle.apps.fnd.sso.Utils.getAppsContext(Utils.java:539)      at oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:120)      at oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:170)      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpApplication.loadServlet(HttpApplication.java:2231)      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpApplication.findServlet(HttpApplication.java:4617)      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpApplication.findServlet(HttpApplication.java:4541)      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpApplication.getRequestDispatcher(HttpApplication.java:2821)      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:740)      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)      at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)      at java.lang.Thread.run(Thread.java:595)Caused by: oracle.apps.jtf.base.resources.FrameworkException: Error in IAS Cache: oracle.apps.fnd.common.PoolException: Not able to create new database connection: FNDSECURITY_APPL_SERVER_ID      at oracle.apps.jtf.cache.IASCacheProvider.get(IASCacheProvider.java:833)      at oracle.apps.jtf.cache.CacheManager.getInternal(CacheManager.java:4802)      at oracle.apps.jtf.cache.CacheManager.get(CacheManager.java:4624)      at oracle.apps.fnd.cache.AppsCache.get(AppsCache.java:216)      ... 30 moreCaused by: oracle.apps.jtf.base.resources.FrameworkException:
An exception occurred in the method CacheAccess.get
null
The base exception is:
Not able to create new database connection: FNDSECURITY_APPL_SERVER_ID      at oracle.apps.jtf.base.resources.FrameworkException.convertException(FrameworkException.java:607)      at oracle.apps.jtf.base.resources.FrameworkException.addException(FrameworkException.java:585)      at oracle.apps.jtf.base.resources.FrameworkException.<init>(FrameworkException.java:66)      at oracle.apps.jtf.base.resources.FrameworkException.<init>(FrameworkException.java:88)      at oracle.apps.jtf.base.resources.FrameworkException.<init>(FrameworkException.java:202)      at oracle.apps.jtf.base.resources.FrameworkException.<init>(FrameworkException.java:218)      at oracle.apps.jtf.base.resources.FrameworkException.<init>(FrameworkException.java:249)      ... 34 more500-Internal-Server-Error.rtf
steven_jdAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Praveen Kumar ChandrashekatrDatabase Analysist Senior Commented:
>>Not able to create new database connection: FNDSECURITY_APPL_SERVER_ID <<
From the error we see that its not getting the application server id.
check this below doc for more info on this.

http://3qs.com/2012/05/02/ebs-http-500-secure-dbc/
0
steven_jdAuthor Commented:
Solved using AutoConfig
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
steven_jdAuthor Commented:
The only comment provided had an article that I had already looked up and didnt resolve the issue. Oracle support provided the recommendation to run AutoConfig.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.