2 Replies Latest reply on Jan 11, 2012 5:20 AM by Nitin J

    User can not login EBS, blank page.

    Jackie Han-Oracle
      EBS version:11.5.10.2
      OS Platform:Linux x86
      DB version:10.2.0.1

      User can not login EBS homepage, got blank page.
      Run autoconfig on DB tier, got following error:
      -----------------------------------------------------------------Autoconfig log on DB Tier----------------------------------------------------------------
      ---------------------------------------------------------------
      ADX Database Utility
      ---------------------------------------------------------------

      getConnectionUsingAppsJDBCConnector() -->
      APPS_JDBC_URL='null'
      Trying to get connection using SID based connect descriptor
      getConnection() -->
      sDbHost : ERPPROD
      sDbDomain : aiptek.com.tw
      sDbPort : 1521
      sDbSid : PROD
      sDbUser : apps
      Trying to connect using SID...
      getConnectionUsingSID() -->
      JDBC URL: jdbc:oracle:thin:@ERPPROD.aiptek.com.tw:1521:PROD
      Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
      Trying to connect using SID as ServiceName
      getConnectionUsingServiceName() -->
      JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ERPPROD.aiptek.com.tw)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD)))
      Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
      Trying to connect using SID as ServiceName.DomainName
      getConnectionUsingServiceName() -->
      JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ERPPROD.aiptek.com.tw)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD.aiptek.com.tw)))
      Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
      Connection could not be obtained; returning null

      -------------------ADX Database Utility Finished---------------

      Connection could not be obtained using s_dbhost
      Trying to connect using s_hostname
      getConnection() -->
      sDbHost : erpprod
      sDbDomain : aiptek.com.tw
      sDbPort : 1521
      sDbSid : PROD
      sDbUser : apps
      Trying to connect using SID...
      getConnectionUsingSID() -->
      JDBC URL: jdbc:oracle:thin:@erpprod.aiptek.com.tw:1521:PROD
      Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
      Trying to connect using SID as ServiceName
      getConnectionUsingServiceName() -->
      JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erpprod.aiptek.com.tw)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD)))
      Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
      Trying to connect using SID as ServiceName.DomainName
      getConnectionUsingServiceName() -->
      JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erpprod.aiptek.com.tw)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD.aiptek.com.tw)))
      Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
      Connection could not be obtained; returning null

      -------------------ADX Database Utility Finished---------------

      Result : Failed to upload the Context file to the DataBase
      ----------------------------------------------------------------

           Uploading Context file and its templates to the database...FAILED


      StackTrace:
      java.lang.Exception: oracle.apps.ad.autoconfig.oam.InDbCtxFileException: Exception : Unable to connect to database; refer to the log file details.
           at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBCtx(FileSysDBCtxMerge.java:685)
           at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBFiles(FileSysDBCtxMerge.java:222)
           at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1658)
           at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:709)
      -----------------------------------------------------------------Autoconfig log on DB Tier----------------------------------------------------------------

      Run adpatch, got following error:
      -----------------------------------------------------------------Adpatch Error----------------------------------------------------------------
      You are about to apply a patch to the installation of Oracle Applications
      in your ORACLE database 'PROD'
      using ORACLE executables in '/u01/PROD/prodora/8.0.6'.

      Is this the correct database [Yes] ?

      AutoPatch needs the password for your 'SYSTEM' ORACLE schema
      in order to determine your installation configuration.

      Enter the password for your 'SYSTEM' ORACLE schema:


      The ORACLE username specified below for Application Object Library
      uniquely identifies your existing product group: APPLSYS

      Enter the ORACLE password of Application Object Library [APPS] :

      AutoPatch is verifying your username/password....Unable to connect.

      Error: The given ORACLE password is not the correct password.
      Please re-enter the ORACLE username and password.

      Enter the ORACLE password of Application Object Library [APPS] :
      -----------------------------------------------------------------Adpatch Error----------------------------------------------------------------

      mon_jserv.log

      [09/01/2012 10:25:18:621] (ERROR) ajp12: Servlet Error: java.lang.NoClassDefFoundError: null
      [09/01/2012 10:25:18:621] (ERROR) an error returned handling request via protocol "ajpv12"
      [09/01/2012 10:25:18:621] (ERROR) balance: 32266 internal servlet error in server erpprod.aiptek.com.tw:16000
      [09/01/2012 10:25:18:621] (ERROR) an error returned handling request via protocol "balance"
      [09/01/2012 10:25:20:976] (ERROR) ajp12: Servlet Error: java.lang.NoClassDefFoundError: null
      [09/01/2012 10:25:20:976] (ERROR) an error returned handling request via protocol "ajpv12"
      [09/01/2012 10:25:20:976] (ERROR) balance: 32267 internal servlet error in server erpprod.aiptek.com.tw:16000


      OACoreGroup.0.stderr

      -----------------------------------------------------------------OACoreGroup.0.stderr----------------------------------------------------------------
      -------------------------------
      Mon Jan 9 09:06:08 CST 2012
      -------------------------------
      Exception in static block of jtf.cache.appsimpl.AppsCacheLogger. Stack trace is: 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:210)
           at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfile(ExtendedProfileStore.java:169)
           at oracle.apps.fnd.profiles.ExtendedProfileStore.getProfile(ExtendedProfileStore.java:148)
           at oracle.apps.fnd.common.logging.DebugEventManager.configureUsingDatabaseValues(DebugEventManager.java:1201)
           at oracle.apps.fnd.common.logging.DebugEventManager.configureLogging(DebugEventManager.java:1044)
           at oracle.apps.fnd.common.logging.DebugEventManager.internalReinit(DebugEventManager.java:1013)
           at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:980)
           at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:967)
           at oracle.apps.fnd.common.AppsLog.reInitialize(AppsLog.java:570)
           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:1119)
           at oracle.apps.jtf.cache.ArchitectureWrapper.createAppsContextWithDBCFile(ArchitectureWrapper.java:143)
           at oracle.apps.jtf.cache.ArchitectureWrapper.createDefaultAppsContext(ArchitectureWrapper.java:107)
           at oracle.apps.jtf.cache.ArchitectureWrapper.createAppsContext(ArchitectureWrapper.java:96)
           at oracle.apps.jtf.cache.appsimpl.AppsCacheLogger.<clinit>(AppsCacheLogger.java:43)
           at oracle.apps.jtf.cache.appsimpl.AppsCacheEnvironment.getCacheLogger(AppsCacheEnvironment.java:67)
           at oracle.apps.jtf.cache.CacheManager.initCache(CacheManager.java:711)
           at oracle.apps.jtf.cache.CacheManager.<clinit>(CacheManager.java:378)
           at oracle.apps.fnd.cache.Cache.setCacheFullName(Cache.java:228)
           at oracle.apps.fnd.cache.Cache.initCache(Cache.java:114)
           at oracle.apps.fnd.cache.Cache.<init>(Cache.java:89)
           at oracle.apps.fnd.cache.AppsCache.<init>(AppsCache.java:86)
           at oracle.apps.fnd.cache.AolCaches.getCache(AolCaches.java:155)
           at oracle.apps.fnd.profiles.Profiles.<clinit>(Profiles.java:241)
           at oracle.apps.fnd.profiles.ExtendedProfileStore.init(ExtendedProfileStore.java:498)
           at oracle.apps.fnd.profiles.ExtendedProfileStore.<init>(ExtendedProfileStore.java:119)
           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:274)
           at oracle.apps.fnd.common.AppsContext.instantiateProfileStore(AppsContext.java:3959)
           at oracle.apps.fnd.common.AppsContext.makeProfileStore(AppsContext.java:780)
           at oracle.apps.fnd.common.Context.setProfileStore(Context.java:767)
           at oracle.apps.fnd.common.Context.setProfileStore(Context.java:749)
           at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:564)
           at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:524)
           at oracle.apps.fnd.common.AppsContext.<init>(AppsContext.java:292)
           at oracle.apps.mwa.container.ApplicationsObjectLibrary.AOLInit(ApplicationsObjectLibrary.java:174)
           at oracle.apps.mwa.container.ApplicationsObjectLibrary.<init>(ApplicationsObjectLibrary.java:78)
           at oracle.apps.mwa.container.MWALib.setObjectLibrary(MWALib.java:339)
           at oracle.apps.mwa.wap.engine.WapServlet.init(WapServlet.java:158)
           at org.apache.jserv.JServServletManager.load_init(JServServletManager.java:755)
           at org.apache.jserv.JServServletManager.loadServlet(JServServletManager.java:659)
           at org.apache.jserv.JServServletManager.loadStartupServlets(JServServletManager.java:789)
           at org.apache.jserv.JServServletManager.init(JServServletManager.java:447)
           at org.apache.jserv.JServ.start(JServ.java:625)
           at org.apache.jserv.JServ.main(JServ.java:234)
      Caused by: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
           at oracle.apps.fnd.common.Pool.createObject(Pool.java:1321)
           at oracle.apps.fnd.common.Pool.borrowObject(Pool.java:1062)
           at oracle.apps.fnd.security.DBConnObjPool.borrowObject(DBConnObjPool.java:585)
           at oracle.apps.fnd.security.AppsConnectionManager.borrowConnection(AppsConnectionManager.java:301)
           at oracle.apps.fnd.common.Context.borrowConnection(Context.java:1720)
           at oracle.apps.fnd.common.AppsContext.getPrivateConnectionFinal(AppsContext.java:2306)
           at oracle.apps.fnd.common.AppsContext.getPrivateConnection(AppsContext.java:2243)
           at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2101)
           at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1910)
           at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1754)
           at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1767)
           at oracle.apps.fnd.common.Context.getJDBCConnection(Context.java:1453)
           at oracle.apps.fnd.cache.GenericCacheLoader.load(GenericCacheLoader.java:168)
           at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1500)
           ... 51 more
      Caused by: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.AppsException: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
           at oracle.apps.fnd.security.AppsConnectionManager.makeGwyuidConn(AppsConnectionManager.java:907)
           at oracle.apps.fnd.security.AppsConnectionManager.getGwyuidConn(AppsConnectionManager.java:986)
           at oracle.apps.fnd.security.AppsConnectionManager.makeGuestConnection(AppsConnectionManager.java:784)
           at oracle.apps.fnd.security.DBConnObj.<init>(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:274)
           at oracle.apps.fnd.common.Pool.createObject(Pool.java:1308)
           ... 64 more
      Caused by: oracle.apps.fnd.common.AppsException: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
           at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1422)
           at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1325)
           at oracle.apps.fnd.security.AppsConnectionManager.makeGwyuidConn(AppsConnectionManager.java:889)
           ... 72 more
      Caused by: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
           at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
           at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
           at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
           at oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3668)
           at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:353)
           at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:371)
           at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:551)
           at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:351)
           at java.sql.DriverManager.getConnection(DriverManager.java:512)
           at java.sql.DriverManager.getConnection(DriverManager.java:140)
           at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1409)
           ... 74 more

      Exception in static block of jtf.cache.CacheManager. Stack trace is: oracle.apps.jtf.base.resources.FrameworkException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
           at oracle.apps.jtf.cache.CacheManager.initCache(CacheManager.java:718)
           at oracle.apps.jtf.cache.CacheManager.<clinit>(CacheManager.java:378)
           at oracle.apps.fnd.cache.Cache.setCacheFullName(Cache.java:228)
           at oracle.apps.fnd.cache.Cache.initCache(Cache.java:114)
           at oracle.apps.fnd.cache.Cache.<init>(Cache.java:89)
           at oracle.apps.fnd.cache.AppsCache.<init>(AppsCache.java:86)
           at oracle.apps.fnd.cache.AolCaches.getCache(AolCaches.java:155)
           at oracle.apps.fnd.profiles.Profiles.<clinit>(Profiles.java:241)
           at oracle.apps.fnd.profiles.ExtendedProfileStore.init(ExtendedProfileStore.java:498)
           at oracle.apps.fnd.profiles.ExtendedProfileStore.<init>(ExtendedProfileStore.java:119)
           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:274)
           at oracle.apps.fnd.common.AppsContext.instantiateProfileStore(AppsContext.java:3959)
           at oracle.apps.fnd.common.AppsContext.makeProfileStore(AppsContext.java:780)
           at oracle.apps.fnd.common.Context.setProfileStore(Context.java:767)
           at oracle.apps.fnd.common.Context.setProfileStore(Context.java:749)
           at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:564)
           at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:524)
           at oracle.apps.fnd.common.AppsContext.<init>(AppsContext.java:292)
           at oracle.apps.mwa.container.ApplicationsObjectLibrary.AOLInit(ApplicationsObjectLibrary.java:174)
           at oracle.apps.mwa.container.ApplicationsObjectLibrary.<init>(ApplicationsObjectLibrary.java:78)
           at oracle.apps.mwa.container.MWALib.setObjectLibrary(MWALib.java:339)
           at oracle.apps.mwa.wap.engine.WapServlet.init(WapServlet.java:158)
           at org.apache.jserv.JServServletManager.load_init(JServServletManager.java:755)
           at org.apache.jserv.JServServletManager.loadServlet(JServServletManager.java:659)
           at org.apache.jserv.JServServletManager.loadStartupServlets(JServServletManager.java:789)
           at org.apache.jserv.JServServletManager.init(JServServletManager.java:447)
           at org.apache.jserv.JServ.start(JServ.java:625)
           at org.apache.jserv.JServ.main(JServ.java:234)
      Caused by: oracle.apps.jtf.base.resources.FrameworkException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
           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)
           ... 31 more

      java.lang.NoClassDefFoundError
           at org.apache.jserv.JServConnection.processRequest(JServConnection.java:462)
           at org.apache.jserv.JServConnection.run(JServConnection.java:294)
           at java.lang.Thread.run(Thread.java:534)
      java.lang.NoClassDefFoundError
           at org.apache.jserv.JServConnection.processRequest(JServConnection.java:462)
           at org.apache.jserv.JServConnection.run(JServConnection.java:294)
           at java.lang.Thread.run(Thread.java:534)
      java.lang.NoClassDefFoundError
           at org.apache.jserv.JServConnection.processRequest(JServConnection.java:462)
           at org.apache.jserv.JServConnection.run(JServConnection.java:294)
           at java.lang.Thread.run(Thread.java:534)
      java.lang.NoClassDefFoundError
           at org.apache.jserv.JServConnection.processRequest(JServConnection.java:462)
           at org.apache.jserv.JServConnection.run(JServConnection.java:294)
           at java.lang.Thread.run(Thread.java:534)
      java.lang.NoClassDefFoundError
           at org.apache.jserv.JServConnection.processRequest(JServConnection.java:462)
           at org.apache.jserv.JServConnection.run(JServConnection.java:294)
           at java.lang.Thread.run(Thread.java:534)
      java.lang.NoClassDefFoundError
           at org.apache.jserv.JServConnection.processRequest(JServConnection.java:462)
           at org.apache.jserv.JServConnection.run(JServConnection.java:294)
           at java.lang.Thread.run(Thread.java:534)
      -----------------------------------------------------------------OACoreGroup.0.stderr----------------------------------------------------------------

      Executed following notes, but does't help:
      Note 260887.1: How to Clean Nonexistent Nodes or IP Addresses From FND_NODES (Doc ID 260887.1)
      Note 1299429.1: ' adcfgclone dbTier' fails with error 'RC-00118' Error occurred during creation of database - 'Raised by oracle.apps.ad.clone.ApplyDatabase' (Doc ID 1299429.1)

      Also, can not do AOLJTEST, once input aoljtest: http://erpprod.aiptek.com.tw:8000/OA_HTML/jsp/fnd/aoljtest.jsp
      IE reports: 'Internet Explorer can not display web page'

      Please HELP, it's URGENT~~~

      Thanks,
      Jackie
        • 1. Re: User can not login EBS, blank page.
          Hussein Sawwan-Oracle
          Jackie,
          Run autoconfig on DB tier, got following error:
          -----------------------------------------------------------------Autoconfig log on DB Tier----------------------------------------------------------------
          ---------------------------------------------------------------
          ADX Database Utility
          ---------------------------------------------------------------

          getConnectionUsingAppsJDBCConnector() -->
          APPS_JDBC_URL='null'
          Trying to get connection using SID based connect descriptor
          getConnection() -->
          sDbHost : ERPPROD
          sDbDomain : aiptek.com.tw
          sDbPort : 1521
          sDbSid : PROD
          sDbUser : apps
          Trying to connect using SID...
          getConnectionUsingSID() -->
          JDBC URL: jdbc:oracle:thin:@ERPPROD.aiptek.com.tw:1521:PROD
          Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
          Trying to connect using SID as ServiceName
          getConnectionUsingServiceName() -->
          JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ERPPROD.aiptek.com.tw)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD)))
          Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
          Trying to connect using SID as ServiceName.DomainName
          getConnectionUsingServiceName() -->
          JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ERPPROD.aiptek.com.tw)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD.aiptek.com.tw)))
          Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
          Connection could not be obtained; returning null

          -------------------ADX Database Utility Finished---------------
          Before you start the application services, you need to make sure that the database and the database listener are up and running. So, please check the database log file and verify that you have no errors reported in the database alert file.

          Thanks,
          Hussein
          • 2. Re: User can not login EBS, blank page.
            Nitin J
            Hi,
            Before running autoconfig please check entries in /etc/hosts file. Also try tnsping from apps server to db server.
            Thanks,
            Nitin