13 Replies Latest reply: Jul 24, 2013 12:58 AM by Djay-OC RSS

    Front end page not opening for R12 on Windows

    Djay-OC

      Hi ,

       

      Front end page not opening for R12(R12.1.3) on Windows server 2003.

       

      opmn services running and no error in opmn log. Whereas when checked applicaiton.log of oacore find below. Please help as im not able to interpret the errors.


      Caused by: java.io.FileNotFoundException: E:oracleORADBinstappsORADB_server1 fnd12.0.0secure\E:oracleORADBinstappsORADB_server1 fnd12.0.0secureORADB.dbc (The filename, directory name, or volume label syntax is incorrect)

      at java.io.FileInputStream.open(Native Method)

      at java.io.FileInputStream.<init>(FileInputStream.java:106)

      at java.io.FileInputStream.<init>(FileInputStream.java:66)

      at oracle.apps.fnd.common.GenericEnvironmentStore.load(GenericEnvironmentStore.java:177)

      at oracle.apps.fnd.common.AppsEnvironmentStore.load(AppsEnvironmentStore.java:400)

      at oracle.apps.fnd.common.AppsEnvironmentStore.loadDbcFile(AppsEnvironmentStore.java:488)

      at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:527)

      ... 24 more

      13/07/18 16:21:07.834 html: Servlet error

      java.lang.ExceptionInInitializerError

      at oracle.apps.fnd.sso.Utils.<clinit>(Utils.java:674)

      at oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:221)

      at oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:287)

      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.PoolException: Not able to create new database connection.

      at oracle.apps.fnd.security.DBConnObj.<init>(DBConnObj.java:250)

      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:330)

      at oracle.apps.fnd.common.Context.borrowConnection(Context.java:1719)

      at oracle.apps.fnd.common.AppsContext.getPrivateConnectionFinal(AppsContext.java:2314)

      at oracle.apps.fnd.common.AppsContext.getPrivateConnection(AppsContext.java:2251)

      at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2108)

      at oracle.apps.fnd.common.AppsContext.getLocalJDBCConnection(AppsContext.java:2490)

      at oracle.apps.fnd.common.AppsContext.getLocalJDBCConnection(AppsContext.java:2425)

      at oracle.apps.fnd.common.AppsContext.getLocalJDBCConnection(AppsContext.java:2406)

      at oracle.apps.fnd.common.NativeProfileStore.getInstanceName(NativeProfileStore.java:1020)

      at oracle.apps.fnd.common.NativeProfileStore.<init>(NativeProfileStore.java:159)

      at oracle.apps.fnd.common.AppsContext.instantiateProfileStore(AppsContext.java:3991)

      at oracle.apps.fnd.common.AppsContext.makeProfileStore(AppsContext.java:789)

      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:573)

      at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:533)

      at oracle.apps.fnd.common.AppsContext.<init>(AppsContext.java:301)

      at oracle.apps.fnd.common.WebAppsContext.<init>(WebAppsContext.java:1147)

      at oracle.apps.fnd.sso.Utils.getAppsContext(Utils.java:549)

      at oracle.apps.fnd.sso.SessionMgr.loadInstalledLanguages(SessionMgr.java:4058)

      at oracle.apps.fnd.sso.SessionMgr.getInstalledLanguages(SessionMgr.java:3852)

      at oracle.apps.fnd.sso.Utils.getBaseInstalledLangCode(Utils.java:1490)

      at oracle.apps.fnd.sso.Authenticator.<clinit>(Authenticator.java:45)

      ... 17 more

      Caused by: java.io.FileNotFoundException: E:oracleORADBinstappsORADB_server1 fnd12.0.0secure\E:oracleORADBinstappsORADB_server1 fnd12.0.0secureORADB.dbc (The filename, directory name, or volume label syntax is incorrect)

      at java.io.FileInputStream.open(Native Method)

      at java.io.FileInputStream.<init>(FileInputStream.java:106)

      at java.io.FileInputStream.<init>(FileInputStream.java:66)

      at oracle.apps.fnd.common.GenericEnvironmentStore.load(GenericEnvironmentStore.java:177)

      at oracle.apps.fnd.common.AppsEnvironmentStore.load(AppsEnvironmentStore.java:400)

      at oracle.apps.fnd.common.AppsEnvironmentStore.loadDbcFile(AppsEnvironmentStore.java:488)

      at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:527)

      ... 24 more

      13/07/18 16:21:17.783 html: Error initializing servlet

      java.lang.NoClassDefFoundError: Could not initialize class oracle.apps.fnd.sso.Utils

      at oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:221)

      at oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:287)

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

      13/07/18 16:21:17.783 html: Servlet error

      java.lang.NoClassDefFoundError: Could not initialize class oracle.apps.fnd.sso.Utils

      at oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:221)

      at oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:287)

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


      Regards,

        • 1. Re: Front end page not opening for R12 on Windows
          Helios-GunesEROL

          Hi;

          Please review:

          ojspCompile failed with 'data corrupt over child pipe' and 'java.io.IOException: The filename, directory name, or volume label syntax is incorrect' [ID 457042.1]

           

          Regard
          Helios

          • 2. Re: Front end page not opening for R12 on Windows
            Djay-OC

            Hi Helios,

             

            Thanks for reply.

            The sqlnet_ifile.ora is empty whereas sqlnet.ora contents are below.

            Please suggest if i can put entry in sqlnet_ifile.ora as per note id 457042.1 ?


            NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)

            SQLNET.EXPIRE_TIME= 30

            sqlnet.authentication_services= (NTS)

            SQLNET.INBOUND_CONNECT_TIMEOUT =120

            DIAG_ADR_ENABLED=ON

            ADR_BASE=E:\oracle\db\tech_st\11.1.0\admin\CONTEXT_NAME

            SEC_USER_AUDIT_ACTION_BANNER = E:\oracle\db\tech_st\11.1.0/appsutil/template/txkDBSecUserAuditActionBanner.txt

             

            IFILE=E:\oracle\db\tech_st\11.1.0\network\admin\ORADB_server2\sqlnet_ifile.ora

            Regards,

            • 3. Re: Front end page not opening for R12 on Windows
              Djay-OC

              Hi Helios,

               

              Update the sqlnet.ora as in note id and reloaded the listeneres, But issue seems to be not solved. Below is the error.

               

              13/07/18 19:00:52.116 html: Error initializing servlet

              java.lang.NoClassDefFoundError: Could not initialize class oracle.apps.fnd.sso.Utils

              at oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:221)

              at oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:287)

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

              13/07/18 19:00:52.116 html: Servlet error

              java.lang.NoClassDefFoundError: Could not initialize class oracle.apps.fnd.sso.Utils

              at oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:221)

              at oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:287)

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

              13/07/18 19:01:24.10 html: Error initializing servlet

              java.lang.NoClassDefFoundError: Could not initialize class oracle.apps.fnd.sso.Utils

              at oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:221)

              at oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:287)

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

              13/07/18 19:01:24.10 html: Servlet error

              java.lang.NoClassDefFoundError: Could not initialize class oracle.apps.fnd.sso.Utils

              at oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:221)

              at oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:287)

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

               

              Regards,

              • 4. Re: Front end page not opening for R12 on Windows
                Djay-OC

                Hi Helios,

                 

                Executed ojspComplile.pl


                perl -x ojspCompile.pl --compile --flush    ----It got completed successfully, But still issue was same. No login paged error 500


                again as per note id 457042.1 executed perl /ojspCompile.pl --compile --flush -p 2 . However the ojpcompile version is 120.10

                And it hanged with below.


                starting...(compiling all)

                using 45i+ internal ojsp ver: 45

                synchronizing dependency file:

                  loading deplist...8095

                  enumerating jsps...8095

                  updating dependency...0

                initializing compilation:

                  eliminating children...6024 (-2071)

                translating and compiling:

                  translating jsps...

                data corrupt over child pipe: -7748 MORE


                ojsp logfile


                synchronizing dependency file:

                  loading deplist...8095

                  enumerating jsps...8095

                  updating dependency...0

                initializing compilation:

                  eliminating children...6024 (-2071)

                translating and compiling:

                COMMAND: java oracle.jsp.tools.Jspc -forgiveDupDirAttr -extraImports java.util.*,java.io.*,java.lang.reflect.*,java.beans.* -extraImports "java.util.*" -noCompile -appRoot "\oracle\apps\apps_st\comn\webapps\oacore\html" -d "\oracle\apps\apps_st\comn\_pages" -srcdir "\oracle\apps\apps_st\comn\_pages" -packageName "" <file>

                PARALLEL COMPILATION: 2

                data corrupt over child pipe: -7748 MORE

                4020 FINISHING Thu Jul 18 20:34:29 2013

                 

                Regards,

                • 5. Re: Front end page not opening for R12 on Windows
                  Hussein Sawwan-Oracle
                  Caused by: java.io.FileNotFoundException: E:oracleORADBinstappsORADB_server1 fnd12.0.0secure\E:oracleORADBinstappsORADB_server1 fnd12.0.0secureORADB.dbc (The filename, directory name, or volume label syntax is incorrect)

                   

                  Your DBC seems to be missing to corrupted, so please run AutoConfig to recreate the file, bounce the services and check then.

                   

                  Thanks,

                  Hussein

                  • 6. Re: Front end page not opening for R12 on Windows
                    Djay-OC

                    Hi Hussein,

                     

                    Thanks, Autoconfig failed with error exit code 5. Mayi restart APPS_ORADB. and execute autoconfig ?

                    or is it a bug as per

                     

                    Meanwhile  apps listener manually and executed the command manually txkSetPathSep.pl but seems to be in hang state.

                     

                    [AutoConfig Error Report]
                    The following report lists errors AutoConfig encountered during each
                    phase of its execution.  Errors are grouped by directory and phase.
                    The report format is:
                          <filename>  <phase>  <return code where appropriate>

                      [SETUP PHASE]
                      AutoConfig could not successfully execute the following scripts:
                        Directory: E:\oracle\apps\tech_st\10.1.3\perl\5.8.3\bin\MSWin32-x86-multi-thread\perl.exe -I E:\oracle\apps\tech_st\10.1.3\perl\5.8.3\lib\MSWin32-x86-multi-thread -I E:\oracle\apps\tech_st\10.1.3\perl\5.8.3\lib -I E:\oracle\apps\tech_st\10.1.3\perl\site\5.8.3\lib\MSWin32-x86-multi-thread -I E:\oracle\apps\tech_st\10.1.3\perl\site\5.8.3\lib -I E:\oracle\apps\apps_st\appl\au\12.0.0\perl -I E:\oracle\apps\tech_st\10.1.3\Apache\Apache\mod_perl\site\5.8.3\lib\MSWin32-x86-multi-thread E:\oracle\inst\apps\ORADB_server1\admin\install
                          txkSetPathSep.pl        INSTE8_SETUP       -1

                      [APPLY PHASE]
                      AutoConfig could not successfully execute the following scripts:
                        Directory: E:\oracle\apps\tech_st\10.1.3\perl\5.8.3\bin\MSWin32-x86-multi-thread\perl.exe -I E:\oracle\apps\tech_st\10.1.3\perl\5.8.3\lib\MSWin32-x86-multi-thread -I E:\oracle\apps\tech_st\10.1.3\perl\5.8.3\lib -I E:\oracle\apps\tech_st\10.1.3\perl\site\5.8.3\lib\MSWin32-x86-multi-thread -I E:\oracle\apps\tech_st\10.1.3\perl\site\5.8.3\lib -I E:\oracle\apps\apps_st\appl\au\12.0.0\perl -I E:\oracle\apps\tech_st\10.1.3\Apache\Apache\mod_perl\site\5.8.3\lib\MSWin32-x86-multi-thread E:\oracle\inst\apps\ORADB_server1\admin\install
                          txkMapViewerDataMerge.pl    INSTE8_APPLY       -1
                          txkSystemJAZNDataMerge.pl    INSTE8_APPLY       -1

                        Directory: E:\oracle\inst\apps\ORADB_server1\admin\install
                          adsvalsn.cmd            INSTE8_APPLY       -1
                          adsvopmn.cmd            INSTE8_APPLY       -1

                     

                    Checked adconfig.log and found below.

                     

                    Executing script in InstantiateFile:
                    E:\oracle\inst\apps\ORADB_server1\admin\install\adsvalsn.cmd
                    script returned:
                    ****************************************************
                    Timed out( 3750000 ): Interrupted Exception
                    ECHO is off.
                    Fri 07/19/2013 02:38 PM
                    ECHO is off.
                    The log information will be written to
                    "E:\oracle\inst\apps\ORADB_server1\admin\log\adsvalsn.txt"
                    ECHO is off.
                    Fri 07/19/2013 02:39 PM
                    ECHO is off.
                    The environment settings are as follows ...
                    ECHO is off.
                           ORACLE_HOME : E:\oracle\apps\tech_st\10.1.2
                                 LOCAL : ORADB
                            ORACLE_SID :
                                  PATH : E:\oracle\apps\tech_st\10.1.2\bin;E:\oracle\apps\tech_st\10.1.3\appsutil\jdk\bin;E:\oracle\apps\tech_st\10.1.3\appsutil\jdk\jre\bin;E:\oracle\apps\tech_st\10.1.3\perl\5.8.3\bin\MSWin32-x86-multi-thread\perl.exe;C:\MSVS\Common7\IDE;C:\MSVS\VC\BIN;C:\MSVS\Common7\Tools;C:\MSVS\Common7\Tools\bin;C:\MSVS\VC\PlatformSDK\bin;C:\MSVS\SDK\v2.0\bin;C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727;C:\MSVS\VC\VCPackages;E:\oracle\inst\apps\ORADB_server1\admin\scripts;E:\oracle\apps\apps_st\appl\au\12.0.0\bin;E:\oracle\apps\apps_st\appl\fnd\12.0.0\bin;E:\oracle\apps\apps_st\appl\ad\12.0.0\bin;E:\oracle\apps\tech_st\10.1.3\appsutil\jdk\jre\bin;E:\oracle\apps\tech_st\10.1.3\perl\5.8.3\bin\MSWin32-x86-multi-thread\;E:\oracle\apps\tech_st\10.1.3\appsutil\jdk\bin;E:\oracle\apps\tech_st\10.1.2\bin;E:\oracle\apps\tech_st\10.1.3\appsutil\jdk\bin;E:\oracle\apps\tech_st\10.1.3\appsutil\jdk\jre\bin;C:\cygwin\bin;C:\WINDOWS;C:\WINDOWS\system32;E:\oracle\apps\tech_st\10.1.2\OPatch;E:\oracle\apps\tech_st\10.1.3\ant\bin;;E:\oracle\apps\tech_st\10.1.2\OPatch
                       LD_LIBRARY_PATH : E:\oracle\apps\tech_st\10.1.2\lib
                    ECHO is off.
                    ECHO is off.
                    Starting listener process "APPS_ORADB" ...
                    ECHO is off.

                    LSNRCTL for 32-bit Windows: Version 10.1.0.5.0 - Production on 19-JUL-2013 15:29:51

                    Copyright (c) 1991, 2004, Oracle.  All rights reserved.

                    Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=vhydessoltel-18)(Port=1626))
                    TNS-12541: TNS:no listener
                    TNS-12560: TNS:protocol adapter error
                      TNS-00511: No listener
                       32-bit Windows Error: 61: Unknown error

                    LSNRCTL for 32-bit Windows: Version 10.1.0.5.0 - Production on 19-JUL-2013 15:30:21

                    Copyright (c) 1991, 2004, Oracle.  All rights reserved.

                    Starting tnslsnr: please wait...

                    ****************************************************


                    Executing script in InstantiateFile:
                    E:\oracle\apps\tech_st\10.1.3\perl\5.8.3\bin\MSWin32-x86-multi-thread\perl.exe -I E:\oracle\apps\tech_st\10.1.3\perl\5.8.3\lib\MSWin32-x86-multi-thread -I E:\oracle\apps\tech_st\10.1.3\perl\5.8.3\lib -I E:\oracle\apps\tech_st\10.1.3\perl\site\5.8.3\lib\MSWin32-x86-multi-thread -I E:\oracle\apps\tech_st\10.1.3\perl\site\5.8.3\lib -I E:\oracle\apps\apps_st\appl\au\12.0.0\perl -I E:\oracle\apps\tech_st\10.1.3\Apache\Apache\mod_perl\site\5.8.3\lib\MSWin32-x86-multi-thread E:\oracle\inst\apps\ORADB_server1\admin\install\txkMapViewerDataMerge.pl
                    script returned:
                    ****************************************************
                    Timed out( 3750000 ): Interrupted Exception
                    Refer log file E:\oracle\inst\apps\ORADB_server1\logs\appl\rgf\TXK\txkMapViewerDataMerge_Fri_Jul_19_14_38_40_2013\txkMapViewerDataMerge_Fri_Jul_19_14_38_40_2013.log for details


                    Script Name    : txkMapViewerDataMerge.pl
                    Script Version : 120.0.12010000.4
                    ****************************************************


                    Executing script in InstantiateFile:
                    E:\oracle\inst\apps\ORADB_server1\admin\install\adsvopmn.cmd
                    script returned:
                    ****************************************************
                    Timed out( 3750000 ): Interrupted Exception
                    Setting environment for using Microsoft Visual Studio 2005 x86 tools.
                    APPSORA.cmd exiting with status 0
                    ****************************************************

                    Executing script in InstantiateFile:
                    E:\oracle\apps\tech_st\10.1.3\perl\5.8.3\bin\MSWin32-x86-multi-thread\perl.exe -I E:\oracle\apps\tech_st\10.1.3\perl\5.8.3\lib\MSWin32-x86-multi-thread -I E:\oracle\apps\tech_st\10.1.3\perl\5.8.3\lib -I E:\oracle\apps\tech_st\10.1.3\perl\site\5.8.3\lib\MSWin32-x86-multi-thread -I E:\oracle\apps\tech_st\10.1.3\perl\site\5.8.3\lib -I E:\oracle\apps\apps_st\appl\au\12.0.0\perl -I E:\oracle\apps\tech_st\10.1.3\Apache\Apache\mod_perl\site\5.8.3\lib\MSWin32-x86-multi-thread E:\oracle\inst\apps\ORADB_server1\admin\install\txkSystemJAZNDataMerge.pl
                    script returned:
                    ****************************************************
                    Timed out( 3750000 ): Interrupted Exception
                    Refer log file E:\oracle\inst\apps\ORADB_server1\logs\appl\rgf\TXK\txkSystemJAZNDataMerge_Fri_Jul_19_14_38_34_2013\txkSystemJAZNDataMerge_Fri_Jul_19_14_38_34_2013.log for details


                    Script Name    : txkSystemJAZNDataMerge.pl
                    Script Version : 120.0.12010000.6
                    ****************************************************

                     

                    Regards,

                    Jay

                    • 7. Re: Front end page not opening for R12 on Windows
                      Hussein Sawwan-Oracle

                      Use the workaround mentioned in the doc and see if it helps.

                       

                      Was the DBC file created this time? If yes, do you still get the same error?

                       

                      Thanks,

                      Hussein

                      • 8. Re: Front end page not opening for R12 on Windows
                        Djay-OC

                        The workaround is for 11i does it apply for R12 also ?

                        • 9. Re: Front end page not opening for R12 on Windows
                          Hussein Sawwan-Oracle

                          Yes.

                           

                          Thanks,

                          Hussein

                          • 10. Re: Front end page not opening for R12 on Windows
                            Djay-OC

                            Hi Hussein,

                             

                            Earlier DBC got created. But noticed lots of back salshes (\) like below. Is it anything to do with \ ?

                            [APPS_JDBC_URL=jdbc\:oracle\:thin\:@(DESCRIPTION\=(ADDRESS_LIST\=(LOAD_BALANCE\=YES)(FAILOVER\=YES)(ADDRESS\=(PROTOCOL\=tcp)(HOST\=server1-oradb.ad.sys.com)(PORT\=1521)))(CONNECT_DATA\=(SERVICE_NAME\=ORADB)))]

                             

                            Followed the solution and autoconfig is now running.

                             

                            Regards,

                            Jay

                            • 11. Re: Front end page not opening for R12 on Windows
                              Djay-OC

                              Hi Hussein,

                              This time during autoconfig apps listener started properly but again connection timed out error occured as below and autoconfig failed with exit code 5.

                               

                              [AutoConfig Error Report]

                                [SETUP PHASE]
                                AutoConfig could not successfully execute the following scripts:
                                  Directory: E:\oracle\ORADB\apps\tech_st\10.1.3\perl\5.8.3\bin\MSWin32-x86-multi-thread\perl.exe -I E:\oracle\ORADB\apps\tech_st\10.1.3\perl\5.8.3\lib\MSWin32-x86-multi-thread -I E:\oracle\ORADB\apps\tech_st\10.1.3\perl\5.8.3\lib -I E:\oracle\ORADB\apps\tech_st\10.1.3\perl\site\5.8.3\lib\MSWin32-x86-multi-thread -I E:\oracle\ORADB\apps\tech_st\10.1.3\perl\site\5.8.3\lib -I E:\oracle\ORADB\apps\apps_st\appl\au\12.0.0\perl -I E:\oracle\ORADB\apps\tech_st\10.1.3\Apache\Apache\mod_perl\site\5.8.3\lib\MSWin32-x86-multi-thread E:\oracle\ORADB\inst\apps\ORADB_server1\admin\install
                                    txkSetPathSep.pl        INSTE8_SETUP       -1

                                  Directory: E:\oracle\ORADB\inst\apps\ORADB_server1\admin\install
                                    appsinf.cmd             INSTE8_SETUP       -1

                                  Directory: E:\oracle\ORADB\inst\apps\ORADB_server1\ora\10.1.3
                                    adoraias.cmd            INSTE8_SETUP       -1

                                [APPLY PHASE]
                                AutoConfig could not successfully execute the following scripts:
                                  Directory: E:\oracle\ORADB\apps\tech_st\10.1.3\perl\5.8.3\bin\MSWin32-x86-multi-thread\perl.exe -I E:\oracle\ORADB\apps\tech_st\10.1.3\perl\5.8.3\lib\MSWin32-x86-multi-thread -I E:\oracle\ORADB\apps\tech_st\10.1.3\perl\5.8.3\lib -I E:\oracle\ORADB\apps\tech_st\10.1.3\perl\site\5.8.3\lib\MSWin32-x86-multi-thread -I E:\oracle\ORADB\apps\tech_st\10.1.3\perl\site\5.8.3\lib -I E:\oracle\ORADB\apps\apps_st\appl\au\12.0.0\perl -I E:\oracle\ORADB\apps\tech_st\10.1.3\Apache\Apache\mod_perl\site\5.8.3\lib\MSWin32-x86-multi-thread E:\oracle\ORADB\inst\apps\ORADB_server1\admin\install
                                    txkMapViewerDataMerge.pl    INSTE8_APPLY       -1
                                    txkSystemJAZNDataMerge.pl    INSTE8_APPLY       -1

                              AutoConfig is exiting with status 5

                               

                              >>>>>>> Timed out( 3750000 ): Interrupted Exception Refer log file (for all the 5 scripts)

                              >>>>>>> Is this because dbc file contains backslashes ?

                               

                              Regards,
                              Jay

                              • 12. Re: Front end page not opening for R12 on Windows
                                Hussein Sawwan-Oracle

                                Jay,

                                 

                                Please search AutoConfig log file for those files and you should find more details about the error around the file names -- Please post the complete/exact error message here.

                                 

                                Thanks,

                                Hussein

                                • 13. Re: Front end page not opening for R12 on Windows
                                  Djay-OC

                                  Hi Hussein,

                                   

                                  As mentioned earlier all the scripts were errored out with error  Timed out( 3750000 ): Interrupted Exception during autoconfig.

                                  The issue got resolved as i forget to mention there was resource contention on apps server in which grep.exe (almost 10/12 processes) were consuming most of the cpu and memory. Had to reboot the server to get rid of that processes. Once done there was no contention and autoconfig completed successfully. Thereafter compiled jsp's and started the services. Got the login page and working fine now. Thanks for your help. Good day . . .