EBS, visit homepage, 500 Internal Server Error

restore a 11203 database backup, not change appl files.

visit the EBS login page
http://server:port/

500 Internal Server Error
Servlet error: An exception occurred. The current application deployment descriptors do not allow for including it in this response. Please consult the application log for details.

check $INST_TOP/logs/ora/10.1.3/j2ee/oacore/oacore_default_group_1/application.log
find following errors

12/05/02 00:04:26.497 html: Servlet error
java.lang.ExceptionInInitializerError
at oracle.apps.fnd.sso.Utils.(Utils.java:664)
at oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:116)
at oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:170)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpApplication.loadServlet(HttpApplication.java:2379)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpApplication.findServlet(HttpApplication.java:4830)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpApplication.findServlet(HttpApplication.java:4754)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpApplication.getRequestDispatcher(HttpApplication.java
:2978)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.ja
va:738)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java
:453)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)
at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)
at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResource
PooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:619)
Caused by: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Not able to create new database connection: FNDSECUR
ITY_APPL_SERVER_ID
at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1509)
at oracle.apps.fnd.profiles.Profiles.getProfile(Profiles.java:362)
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:1294)
at oracle.apps.fnd.common.logging.DebugEventManager.configureLogging(DebugEventManager.java:1149)
at oracle.apps.fnd.common.logging.DebugEventManager.internalReinit(DebugEventManager.java:1118)
at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1085)
at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1072)
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.(AppsContext.java:292)
at oracle.apps.fnd.common.WebAppsContext.(WebAppsContext.java:1095)
at oracle.apps.fnd.sso.Utils.getAppsContext(Utils.java:539)
at oracle.apps.fnd.sso.SessionMgr.loadInstalledLanguages(SessionMgr.java:3875)
at oracle.apps.fnd.sso.SessionMgr.getInstalledLanguages(SessionMgr.java:3693)
at oracle.apps.fnd.sso.Utils.getBaseInstalledLangCode(Utils.java:1476)
at oracle.apps.fnd.sso.Authenticator.(Authenticator.java:45)
… 17 more
Caused by: oracle.apps.fnd.common.PoolException: Not able to create new database connection: FNDSECURITY_APPL_SERVER_ID
at oracle.apps.fnd.security.DBConnObj.(DBConnObj.java:246)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at oracle.apps.fnd.common.Pool.createObject(Pool.java:1273)
at oracle.apps.fnd.common.Pool.borrowObject(Pool.java:1027)
at oracle.apps.fnd.security.DBConnObjPool.borrowObject(DBConnObjPool.java:584)
at oracle.apps.fnd.security.AppsConnectionManager.borrowConnection(AppsConnectionManager.java:301)
at oracle.apps.fnd.common.Context.borrowConnection(Context.java:1719)
at oracle.apps.fnd.common.AppsContext.getPrivateConnectionFinal(AppsContext.java:2266)
at oracle.apps.fnd.common.AppsContext.getPrivateConnection(AppsContext.java:2203)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2061)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1871)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1715)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1728)
at oracle.apps.fnd.common.Context.getJDBCConnection(Context.java:1453)
at oracle.apps.fnd.cache.GenericCacheLoader.load(GenericCacheLoader.java:170)
at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1500)
… 37 more

check db connection using sqlplus

$ sqlplus apps/apps@vis1

SQL*Plus: Release 10.1.0.5.0 – Production on Wed May 2 00:19:00 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Data Mining
and Real Application Testing options

SQL>
……..OK

check db connection using
http://host:port/OA_HTML/jsp/fnd/aolj_native_conn_test.jsp
….OK

search FNDSECURITY_APPL_SERVER_ID in metalink
find following notes
Cannot Complete Applications Logon Error When Trying to Access the Personal Home Page in 11.5.10 (Doc ID 297165.1)

check dbc file, in $INST_TOP/appl/fnd/12.0.0/secure

[apps@slcc01db01 secure]$ java oracle.apps.fnd.security.AdminAppServer apps/ STATUS DBC=$FND_TOP/secure/_.dbc

-bash: apps: No such file or directory
$ java oracle.apps.fnd.security.AdminAppServer apps/apps STATUS DBC=$INST_TOP/appl/fnd/12.0.0/secure/VIS.dbc

Database Server
—————
DATABASE_ID: VIS
AUTHENTICATION: SECURE

Application Server
——————
APPL_SERVER_STATUS: INVALID
APPL_SERVER_ID: BE55F0DAD9FD799AE0434840F20A504835206050571755234233375501553514

……INVALID

check VIS.dbc update date, is Apr-24, seems changed by newer version …

redo adconfig
$cd /apps/visappl/ad/12.0.0/bin
$./adconfig.sh contextfile=/apps/visinst/@@/appl/admin/@@.xml appspass=apps
$./adconfig.sh contextfile=/apps/visinst/@@/appl/admin/@@.xml appspass=apps

$ java oracle.apps.fnd.security.AdminAppServer apps/apps STATUS DBC=$INST_TOP/appl/fnd/12.0.0/secure/VIS.dbc

Database Server
—————
DATABASE_ID: VIS
AUTHENTICATION: SECURE

Application Server
——————
APPL_SERVER_STATUS: VALID
APPL_SERVER_ID: BF08D1A8342D3BA2E0434940F20AEDE731393517292025862455146256984412

http connect to login page , ok

发表评论

电子邮件地址不会被公开。 必填项已用*标注