2 Replies Latest reply: May 17, 2013 11:29 AM by 986917 RSS

    Failed to create 11.2.0.1 repository. Please Help :)

    986917
      Hi,

      I installed Oracle Database 11g R2 (11.2.0.1) 32 bit. on 32 bit xp virtual machine.
      I wanted to use warehouse builder tools that comes with the installation. I open sql developer and connected to sys user and unlock the OWBSYS and OWBSYS_AUDIT accounts.

      1.When i try to build a new repository via design center;
      The Warehouse Builder workspace owner installation failed on user OWBSYS. Exception occured in 'processLoadJavaToken' oracle.ide.ExitNotAllowedException
      occurs.

      2.When i try to build a new repository via repository assistant;
      The Warehouse Builder workspace owner installation failed on user OWBSYS java.sql.SQLException: ORA-06550:
      PLS:00103: "end of file" error occurs.

      When i exemined the log files i released some packages or tables in owbsys user doesnot exists like wb_rt_script_util. I run clean_owbsys, cat_owb, reset_owbcc.sql files but nothing changed. For almost a week i am trying different things to solve this problem i deinstalled and installed oracle many time. I googled and tried solutions to similar problems but it does not work.

      Please Help Me

      Thanks :)