ebs登录出错

linee1989

这个假期在win 2003 下搭建了r12的环境，但是登录时报错：Unable to generate forwarding URL. Exception: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
有什么办法 ？

pzh2010

请查看 OACORE application log

路径：$LOG_HOME/ora/10.1.3/j2ee/oacore 底下名为application.log的日志文件

看看错误发生时间是否有以下错误
============================
Caused by: oracle.net.ns.NetException: Socket read timed out
at oracle.net.ns.Packet.receive(Packet.java:320)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:286)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)
... 80 more
============================


2.请提供以下信息

2.1 /etc/resolve.conf的内容

2.2 在服务器和客户端分别运行以下命令
   nslookup <ip definition in /etc/resolve.conf file>

MyAngel

pzh2010 发表于 2012/10/8 14:33
请查看 OACORE application log

路径：$LOG_HOME/ora/10.1.3/j2ee/oacore 底下名为application.log的日志 ...

赞一个。。。。。。。。。。

linee1989

谢谢pzh2010，以及以上两位，由于现在没办法在自己测试机上查看，所以去metalink上找了一下，发现一个一样报错的，贴上来大家看看，随后再贴自己测试机上的问题

ID 1485112.1
Applies to:
Oracle Applications Technology Stack - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms
On : 12.1.3 version, Jserv, JDK, JVM, JRE

When attempting to login EBS, the following error occurs.

ERROR
-----------------------
Unable to generate forwarding URL. Exception: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login EBS
2. Error occurs

Also, Following error message can be found in OACORE application log:

......

Caused by: oracle.net.ns.NetException: Socket read timed out
at oracle.net.ns.Packet.receive(Packet.java:320)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:286)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)
... 80 more


Changes
This is a new cloned instance, and new deployed internal instance.

Cause
The issue caused by wrong setup of DNS server, and new cloned instance's information hasn't defined on DNS server.

The issue is justified by

a). Run on Server:
[root@ebs ~]#nslookup <ip definition in /etc/resolve.conf file>

e.g.
[root@ebs ~]# nslookup 172.16.200.4
Server: 202.96.209.133
Address: 202.96.209.133#53

** server can't find 4.200.16.172.in-addr.arpa.: NXDOMAIN

e.g.
[root@ebs ~]# nslookup <host definition in /etc/resolve.conf file>
;; connection timed out; no servers could be reached


b). Run on Client command windows:
C:\Users\xxx>nslookup 172.16.200.4

e.g.
DNS request timed out.
  timeout was 2 seconds.
Server: UnKnown
Address: 202.96.209.133

DNS request timed out.
  timeout was 2 seconds.
*** Request UnKnown timeout

Solution
Workaround:
--------------------------------------------------------

Comments out the definition in /etc/resolve.conf

e.g.

Before:

#search kkcl.com
nameserver 202.96.209.133
nameserver 202.96.209.133

After:


#search kkcl.com
#nameserver 202.96.209.133
#nameserver 202.96.209.133

linee1989

pzh2010 发表于 2012/10/8 14:33
请查看 OACORE application log

路径：$LOG_HOME/ora/10.1.3/j2ee/oacore 底下名为application.log的日志 ...

谢谢，看了下日志内容，是不是java的问题呢？
----------------------------------------------------------
12/10/08 01:44:57.718 10.1.3.4.0 Started
12/10/08 01:46:22.265 html: 10.1.3.4.0 Started
12/10/08 01:46:55.140 html: oracle.apps.fnd.security.LeakDetectionFilter.initialized:1349632015140
12/10/08 01:46:55.859 html: LeakSetting:
global:true,session:false,aggressive:false,stderr:false,appslog:false,corelog:false
ignoring:null
12/10/08 12:18:41.656 html: 10.1.3.4.0 Stopped
12/10/08 12:18:49.625 10.1.3.4.0 Started
12/10/08 12:18:59.15 html: 10.1.3.4.0 Started
12/10/08 12:19:09.593 html: 10.1.3.4.0 Stopped
12/10/08 12:19:27.406 10.1.3.4.0 Started
12/10/08 12:24:59.562 10.1.3.4.0 Started
12/10/08 12:27:44.359 html: 10.1.3.4.0 Started
12/10/08 12:28:17.375 html: oracle.apps.fnd.security.LeakDetectionFilter.initialized:1349670497375
12/10/08 12:28:17.390 html: LeakSetting:
global:true,session:false,aggressive:false,stderr:false,appslog:false,corelog:false
ignoring:null
12/10/08 12:53:51.359 html: 10.1.3.4.0 Stopped
12/10/08 12:53:59.843 10.1.3.4.0 Started
12/10/08 12:54:06.437 html: 10.1.3.4.0 Started
12/10/08 12:59:46.296 10.1.3.4.0 Started
12/10/08 13:02:48.234 html: 10.1.3.4.0 Started
12/10/08 13:03:57.531 html: Error initializing servlet
java.lang.ExceptionInInitializerError
at oracle.apps.fnd.sso.Utils.<clinit>(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.java: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(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:619)
Caused by: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
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.<init>(AppsContext.java:292)
at oracle.apps.fnd.common.WebAppsContext.<init>(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.<clinit>(Authenticator.java:45)
... 17 more