This discussion is archived
10 Replies Latest reply: Feb 9, 2011 8:28 AM by Oleg RSS

Exception occured  when I create owb repository owner on AIX box

595925 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE Director
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    Check that on second db is installed components "Java VM" and "XML DB",
    for this check execute query
    select * from dba_registry

    Regards,
    Oleg

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points