10 Replies Latest reply: Feb 9, 2011 10:28 AM by Oleg RSS

    Exception occured  when I create owb repository owner on AIX box

    595925
      Does Anyone excounter the issue?


      bash-2.04$ uname -a
      AIX sdcb80a061 3 5 00046F0F4C00
      bash-2.04$ oslevel -r
      5300-08
      bash-2.04$

      main.TaskScheduler timer[5]20090428@23:56:09.009: 00> oracle.wh.service.impl.assistant.ProcessEngine.display(ProcessEngine.java:1572): wholeLine =../unix/jvm.sh -classpath ../../lib/ext/transx.zip:../../../lib/xschema.jar:../../../lib/xsu12.jar:../../../rdbms/jlib/xdb.jar:../../lib/int/rtpplatform.jar:../../lib/int/rtpcommon.jar:../../../jdbc/lib/ojdbc5.jar:../../../lib/xmlparserv2.jar:../../../sqlj/lib/runtime12.jar:../../../jdk/jre/lib/rt.jar oracle.xml.transx.loader (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=%host)(PORT=%port))(CONNECT_DATA=(SERVICE_NAME=%serviceName))) %user %password ../../browserasst/views/owb_uprop_nls.xml
      main.TaskScheduler timer[5]20090428@23:56:09.009: 00> oracle.wh.service.impl.assistant.DatabaseEngine.display(DatabaseEngine.java:453): Connection: host/port/serice_name = 64.181.226.163/1521/OLAP
      main.TaskScheduler timer[5]20090428@23:56:09.009: 00> oracle.wh.service.impl.assistant.DatabaseEngine.display(DatabaseEngine.java:453): url = (DESCRIPTION=(ADDRESS=(HOST=64.181.226.163)(PROTOCOL=tcp)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=OLAP)))
      main.TaskScheduler timer[5]20090428@23:56:09.009: 00> oracle.wh.service.impl.assistant.RuntimeInstaller.display(RuntimeInstaller.java:868): [RuntimeInstaller] connUser = OWBSYS
      main.TaskScheduler timer[5]20090428@23:56:09.009: 00> oracle.wh.service.impl.assistant.RuntimeInstaller.display(RuntimeInstaller.java:868): [RuntimeInstaller] ..2222 . try getConnection()...
      main.TaskScheduler timer[5]20090428@23:56:09.009: 00> oracle.wh.service.impl.assistant.DatabaseEngine.display(DatabaseEngine.java:453): [getConnection]....
      main.TaskScheduler timer[5]20090428@23:56:09.009: 00> oracle.wh.service.impl.assistant.ProcessEngine.display(ProcessEngine.java:1572): after executing the output
      main.TaskScheduler timer[5]20090428@23:56:17.017: 00> oracle.wh.service.impl.assistant.ProcessEngine.display(ProcessEngine.java:1572): (Spawn Token) Error loading Java into DB:
      main.TaskScheduler timer[5]20090428@23:56:17.017: 00> oracle.wh.service.impl.assistant.ProcessEngine.display(ProcessEngine.java:1572): Error occured in 'processSPAWN': java.io.BufferedInputStream@b920b92
      main.TaskScheduler timer[5]20090428@23:56:17.017: 00> oracle.wh.service.impl.assistant.ProcessEngine.processSPAWN(ProcessEngine.java:1013): java.lang.Exception: Error occured in 'processSPAWN': java.io.BufferedInputStream@b920b92
      main.TaskScheduler timer[5]20090428@23:56:17.017: 00> oracle.wh.service.impl.assistant.ProcessEngine.processSPAWN(ProcessEngine.java:1013)+> at oracle.wh.service.impl.assistant.ProcessEngine.processSPAWN(ProcessEngine.java:1009)
      main.TaskScheduler timer[5]20090428@23:56:17.017: 00> oracle.wh.service.impl.assistant.ProcessEngine.processSPAWN(ProcessEngine.java:1013)+> at oracle.wh.service.impl.assistant.ProcessEngine.processFileTokens(ProcessEngine.java:736)
      main.TaskScheduler timer[5]20090428@23:56:17.017: 00> oracle.wh.service.impl.assistant.ProcessEngine.processSPAWN(ProcessEngine.java:1013)+> at oracle.wh.service.impl.assistant.ProcessEngine.createOWBRepository(ProcessEngine.java:294)
      main.TaskScheduler timer[5]20090428@23:56:17.017: 00> oracle.wh.service.impl.assistant.ProcessEngine.processSPAWN(ProcessEngine.java:1013)+> at oracle.wh.ui.install.assistant.wizards.AssistantWizardDefinition$1.runTask(AssistantWizardDefinition.java:564)
      main.TaskScheduler timer[5]20090428@23:56:17.017: 00> oracle.wh.service.impl.assistant.ProcessEngine.processSPAWN(ProcessEngine.java:1013)+> at oracle.ewt.thread.TaskScheduler.runTask(Unknown Source)
      main.TaskScheduler timer[5]20090428@23:56:17.017: 00> oracle.wh.service.impl.assistant.ProcessEngine.processSPAWN(ProcessEngine.java:1013)+> at oracle.ewt.thread.TaskScheduler.processTask(Unknown Source)
      main.TaskScheduler timer[5]20090428@23:56:17.017: 00> oracle.wh.service.impl.assistant.ProcessEngine.processSPAWN(ProcessEngine.java:1013)+> at oracle.ewt.thread.TaskScheduler$TaskQueue.run(Unknown Source)
      main.TaskScheduler timer[5]20090428@23:56:17.017: 00> oracle.wh.service.impl.assistant.ProcessEngine.processSPAWN(ProcessEngine.java:1013)+> at oracle.ewt.timer.Timer.doRun(Unknown Source)
      main.TaskScheduler timer[5]20090428@23:56:17.017: 00> oracle.wh.service.impl.assistant.ProcessEngine.processSPAWN(ProcessEngine.java:1013)+> at oracle.ewt.timer.Timer.run(Unknown Source)
      main.TaskScheduler timer[5]20090428@23:56:17.017: 00> oracle.wh.service.impl.assistant.ProcessEngine.processSPAWN(ProcessEngine.java:1013)+> at java.lang.Thread.run(Thread.java:803)
      main.TaskScheduler timer[5]20090428@23:56:17.017: 00> oracle.wh.service.impl.assistant.ProcessEngine.display(ProcessEngine.java:1572): [processSPAWN]: A spawned program error. Exception = java.lang.Exception: Error occured in 'processSPAWN': java.io.BufferedInputStream@b920b92
      main.TaskScheduler timer[5]20090428@23:56:17.017: 00> oracle.wh.service.impl.assistant.ProcessEngine.display(ProcessEngine.java:1572): Get the error, stop processing other tokens...
      main.TaskScheduler timer[5]20090428@23:56:17.017: 00> oracle.wh.service.impl.assistant.ProcessEngine.display(ProcessEngine.java:1572): Exception = Exception occured in 'processSPAWN'. java.lang.Exception: Error occured in 'processSPAWN': java.io.BufferedInputStream@b920b92
      main.TaskScheduler timer[5]20090428@23:56:17.017: 00> oracle.wh.ui.install.assistant.wizards.AssistantWizardDefinition.display(AssistantWizardDefinition.java:788): [executeOwbReposOrRuntime]: Error occurred during Seed OWBSYS. Exception =java.lang.Exception: Exception occured in 'processSPAWN'. java.lang.Exception: Error occured in 'processSPAWN': java.io.BufferedInputStream@b920b92
      main.AWT-EventQueue-0[6]20090428@23:56:18.018: 00> oracle.wh.ui.jcommon.WhButton@22012201: WhButton setLabel rtsString = OK
        • 1. Re: Exception occured  when I create owb repository owner on AIX box
          595925
          When run the cat_owb.sql ,I encountered the following error.


          Grant succeeded.


          Grant succeeded.

          IF dbms_registry.status('OWB') = 'VALID' THEN
          *+
          ERROR at line 2:
          ORA-06550: line 2, column 24:
          PLS-00302: component 'STATUS' must be declared
          ORA-06550: line 2, column 7:
          PL/SQL: Statement ignored



          User altered.

          If you are NOT using an OWB installed in the Oracle database home, please now run reset_owbcc_home to ensure that the Control Center runs correctly in the specificed home. You are only likely to need to perform this step if you are installing OWB against a 10g database, or are not using the default 11g installation.
          • 2. Re: Exception occured  when I create owb repository owner on AIX box
            595925
            In metalink I clean up the owb schema via the following method and run repository assistant ,but still have the error above.

            Login to SQL Plus as a SYSDBA user and execute out the following steps:

            SQL>@/u01/oracle/product/11.1.0/owb/UnifiedRepos/clean_owbsys.sql
            SQL>@/u01/oracle/product/11.1.0/owb/UnifiedRepos/cat_owb.sql <tablespace name>
            SQL>@/oracle/bidb/product/db11g/owb/UnifiedRepos/reset_owbcc_home.sql (only
            need to run if not using the default 11g install)
            SQL>@/oracle/bidb/product/db11g/owb/UnifiedRepos/unlock_owbsys.sql
            SQL>@alter user owbsys identified by <password>;

            Confirm the PATH includes the ORACLE_HOME. Refer to /u01/oracle/product/11.1.
            0 and retry repository install.
            • 3. Re: Exception occured  when I create owb repository owner on AIX box
              595925
              When I run the cat_owb.sql I encountered the following error.

              grant execute on sys.interactionExecute to OWBSYS with grant option
              *
              ERROR at line 1:
              ORA-04042: procedure, function, package, or package body does not exist
              • 4. Re: Exception occured  when I create owb repository owner on AIX box
                595925
                reset the listener to support external programe and run the owb repository assist ,still have the following error.


                install.assistant.wizards.AssistantWizardDefinition.display(AssistantWizardDefinition.java:788): [executeOwbReposOrRuntime]: Error occurred during Seed OWBSYS. Exception =java.lang.Exception: Exception occured in 'processSPAWN'. java.lang.Exception: Error occured in 'processSPAWN': java.io.BufferedInputStream@1f5e1f5e
                • 5. Re: Exception occured  when I create owb repository owner on AIX box
                  595925
                  After I check the listener config and other cause,but still have the following error. you can find out before the database connection work fine from the log ,but "Error loading Java into DB:" always there

                  main.TaskScheduler timer[5]20090503@20:24:56.056: 00> oracle.wh.service.impl.assistant.ProcessEngine.display(ProcessEngine.java:1572): ... I am in processSPAWN ...
                  main.TaskScheduler timer[5]20090503@20:24:56.056: 00> oracle.wh.service.impl.assistant.ProcessEngine.display(ProcessEngine.java:1572): wholeLine =../unix/jvm.sh -classpath ../../lib/ext/transx.zip:../../../lib/xschema.jar:../../../lib/xsu12.jar:../../../rdbms/jlib/xdb.jar:../../lib/int/rtpplatform.jar:../../lib/int/rtpcommon.jar:../../../jdbc/lib/ojdbc5.jar:../../../lib/xmlparserv2.jar:../../../sqlj/lib/runtime12.jar:../../../jdk/jre/lib/rt.jar oracle.xml.transx.loader (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=%host)(PORT=%port))(CONNECT_DATA=(SERVICE_NAME=%serviceName))) %user %password ../../browserasst/views/owb_uprop_nls.xml
                  main.TaskScheduler timer[5]20090503@20:24:56.056: 00> oracle.wh.service.impl.assistant.DatabaseEngine.display(DatabaseEngine.java:453): Connection: host/port/serice_name = 64.181.226.163/1523/OLAP2
                  main.TaskScheduler timer[5]20090503@20:24:56.056: 00> oracle.wh.service.impl.assistant.DatabaseEngine.display(DatabaseEngine.java:453): url = (DESCRIPTION=(ADDRESS=(HOST=64.181.226.163)(PROTOCOL=tcp)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=OLAP2)))
                  main.TaskScheduler timer[5]20090503@20:24:56.056: 00> oracle.wh.service.impl.assistant.RuntimeInstaller.display(RuntimeInstaller.java:868): [RuntimeInstaller] connUser = OWBSYS
                  main.TaskScheduler timer[5]20090503@20:24:56.056: 00> oracle.wh.service.impl.assistant.RuntimeInstaller.display(RuntimeInstaller.java:868): [RuntimeInstaller] ..2222 . try getConnection()...
                  main.TaskScheduler timer[5]20090503@20:24:56.056: 00> oracle.wh.service.impl.assistant.DatabaseEngine.display(DatabaseEngine.java:453): [getConnection]....
                  main.TaskScheduler timer[5]20090503@20:24:56.056: 00> oracle.wh.service.impl.assistant.ProcessEngine.display(ProcessEngine.java:1572): after executing the output
                  main.TaskScheduler timer[5]20090503@20:25:04.004: 00> oracle.wh.service.impl.assistant.ProcessEngine.display(ProcessEngine.java:1572): (Spawn Token) Error loading Java into DB:
                  main.TaskScheduler timer[5]20090503@20:25:04.004: 00> oracle.wh.service.impl.assistant.ProcessEngine.display(ProcessEngine.java:1572): Error occured in 'processSPAWN': java.io.BufferedInputStream@569c569c
                  main.TaskScheduler timer[5]20090503@20:25:04.004: 00> oracle.wh.service.impl.assistant.ProcessEngine.processSPAWN(ProcessEngine.java:1013): java.lang.Exception: Error occured in 'processSPAWN': java.io.BufferedInputStream@569c569c
                  main.TaskScheduler timer[5]20090503@20:25:04.004: 00> oracle.wh.service.impl.assistant.ProcessEngine.processSPAWN(ProcessEngine.java:1013)+> at oracle.wh.service.impl.assistant.ProcessEngine.processSPAWN(ProcessEngine.java:1009)
                  main.TaskScheduler timer[5]20090503@20:25:04.004: 00> oracle.wh.service.impl.assistant.ProcessEngine.processSPAWN(ProcessEngine.java:1013)+> at oracle.wh.service.impl.assistant.ProcessEngine.processFileTokens(ProcessEngine.java:736)
                  main.TaskScheduler timer[5]20090503@20:25:04.004: 00> oracle.wh.service.impl.assistant.ProcessEngine.processSPAWN(ProcessEngine.java:1013)+> at oracle.wh.service.impl.assistant.ProcessEngine.createOWBRepository(ProcessEngine.java:294)
                  main.TaskScheduler timer[5]20090503@20:25:04.004: 00> oracle.wh.service.impl.assistant.ProcessEngine.processSPAWN(ProcessEngine.java:1013)+> at oracle.wh.ui.install.assistant.wizards.AssistantWizardDefinition$1.runTask(AssistantWizardDefinition.java:564)
                  main.TaskScheduler timer[5]20090503@20:25:04.004: 00> oracle.wh.service.impl.assistant.ProcessEngine.processSPAWN(ProcessEngine.java:1013)+> at oracle.ewt.thread.TaskScheduler.runTask(Unknown Source)
                  main.TaskScheduler timer[5]20090503@20:25:04.004: 00> oracle.wh.service.impl.assistant.ProcessEngine.processSPAWN(ProcessEngine.java:1013)+> at oracle.ewt.thread.TaskScheduler.processTask(Unknown Source)
                  main.TaskScheduler timer[5]20090503@20:25:04.004: 00> oracle.wh.service.impl.assistant.ProcessEngine.processSPAWN(ProcessEngine.java:1013)+> at oracle.ewt.thread.TaskScheduler$TaskQueue.run(Unknown Source)
                  main.TaskScheduler timer[5]20090503@20:25:04.004: 00> oracle.wh.service.impl.assistant.ProcessEngine.processSPAWN(ProcessEngine.java:1013)+> at oracle.ewt.timer.Timer.doRun(Unknown Source)
                  main.TaskScheduler timer[5]20090503@20:25:04.004: 00> oracle.wh.service.impl.assistant.ProcessEngine.processSPAWN(ProcessEngine.java:1013)+> at oracle.ewt.timer.Timer.run(Unknown Source)
                  main.TaskScheduler timer[5]20090503@20:25:04.004: 00> oracle.wh.service.impl.assistant.ProcessEngine.processSPAWN(ProcessEngine.java:1013)+> at java.lang.Thread.run(Thread.java:803)
                  main.TaskScheduler timer[5]20090503@20:25:04.004: 00> oracle.wh.service.impl.assistant.ProcessEngine.display(ProcessEngine.java:1572): [processSPAWN]: A spawned program error. Exception = java.lang.Exception: Error occured in 'processSPAWN': java.io.BufferedInputStream@569c569c
                  main.TaskScheduler timer[5]20090503@20:25:04.004: 00> oracle.wh.service.impl.assistant.ProcessEngine.display(ProcessEngine.java:1572): Get the error, stop processing other tokens...
                  main.TaskScheduler timer[5]20090503@20:25:04.004: 00> oracle.wh.service.impl.assistant.ProcessEngine.display(ProcessEngine.java:1572): Exception = Exception occured in 'processSPAWN'. java.lang.Exception: Error occured in 'processSPAWN': java.io.BufferedInputStream@569c569c
                  main.TaskScheduler timer[5]20090503@20:25:04.004: 00> oracle.wh.ui.install.assistant.wizards.AssistantWizardDefinition.display(AssistantWizardDefinition.java:788): [executeOwbReposOrRuntime]: Error occurred during Seed OWBSYS. Exception =java.lang.Exception: Exception occured in 'processSPAWN'. java.lang.Exception: Error occured in 'processSPAWN': java.io.BufferedInputStream@569c569c
                  main.AWT-EventQueue-0[6]20090503@20:25:06.006: 00> oracle.wh.ui.jcommon.WhButton@10521052: WhButton setLabel rtsString = OK
                  main.AWT-EventQueue-0[6]20090503@20:25:20.020: 00> oracle.wh.ui.install.assistant.wizards.AssistantWizardDefinition.display(AssistantWizardDefinition.java:788): before open 'UnSuccessDialog'
                  main.AWT-EventQueue-0[6]20090503@20:25:20.020: 00> oracle.wh.ui.install.assistant.wizards.AssistantWizardDefinition.display(AssistantWizardDefinition.java:788): Open UnSuccessDialog ...
                  main.AWT-EventQueue-0[6]20090503@20:25:20.020: 00> oracle.wh.ui.jcommon.WhButton@10521052: WhButton setLabel rtsString = OK
                  • 6. Re: Exception occured  when I create owb repository owner on AIX box
                    705207
                    I meet the error too.

                    Who can to resolve it?

                    Thank you!
                    • 7. Re: Exception occured  when I create owb repository owner on AIX box
                      Srini Chavali-Oracle
                      Pl see if MOS Doc 730998.1 (Reposinst Fails With Java Error : Io exception : The Network Adapter could not establish the connection) can help

                      HTH
                      Srini
                      • 8. Re: Exception occured  when I create owb repository owner on AIX box
                        user789205-Oracle
                        Regarding the issue:

                        grant execute on sys.interactionExecute to OWBSYS with grant option
                        *
                        ERROR at line 1:
                        ORA-04042: procedure, function, package, or package body does not exist

                        Under 11g, I don't believe this is an issue. I understand sys.interactionExecute is an OLAP option related function that existed under 10g but not under 11 - so failure in granting execute permission to it is not important. It is an inconsistency bug in OWB 11 that it attempts to refer to it.
                        • 9. Re: Exception occured  when I create owb repository owner on AIX box
                          838274
                          I also got the same error :

                          grant execute on sys.interactionExecute to OWBSYS with grant option
                          *
                          ERROR at line 1:
                          ORA-04042: procedure, function, package, or package body does not exist

                          ...yet I'm running Oracle 10gR2. I first ran the cat_owb script on a test-db (same version) and apparently there the function existed. But on the db where I'm currently working on it simply does not exist.
                          • 10. Re: Exception occured  when I create owb repository owner on AIX box
                            Oleg
                            Check that on second db is installed components "Java VM" and "XML DB",
                            for this check execute query
                            select * from dba_registry

                            Regards,
                            Oleg