Database Software

Hello, on running the repository assistant I get an error:

Error : java.sql.SQLException: ORA-29532: Java call terminated by uncaught Java exception: java.sql.SQLException: OWBSYS is not granted access to

c:\oracle11\product\11.1.0\db_1/owb/bin/admin/rtrepos.properties:

Please run UnifiedRepos/reset_owbcc_home.sql specifiying the path of the Oracle Home from which the Control Center Service is being run.


Taking the message's advice I

// change to the following directory
cd C:\oracle11\product\11.1.0\db_1\owb\UnifiedRepos

// login with the sys account as sysdba
sqlplus sys/ as sysdba

// run the clean script which deletes everything to do with owbsys
@clean_owbsys.sql

// now run the create owbsys script
@cat_owb.sql users

// and then I reset the home
@reset_owbcc_home C:/oracle11/product/11.1.0/db_1

// unlock the account and change the password

ALTER USER owbsys ACCOUNT UNLOCK;
Alter user owbsys IDENTIFIED BY password;

// and for extra measure
GRANT DBA TO OWBSYS;

I then run it again and get the same error.

I have tried various soultions which include modifying the 'reset_owbcc_home.sql'

--------------

set verify off
prompt Enter the full path of the Oracle home for the OWB Control Center install:
set termout off
define cc_path = &1
set termout on
Rem Grant file permissions using the new path
declare
path varchar2(500) := '&cc_path';
unix_path varchar(500);
begin
unix_path := replace(path, '\', '/');
dbms_java.grant_permission('OWBSYS','java.io.FilePermission', unix_path||'/owb/bin/admin/rtrepos.properties', 'read,write');
dbms_java.grant_permission('OWBSYS','java.io.FilePermission', path||'/owb/bin/unix/run_service.sh', 'read,execute');
dbms_java.grant_permission('OWBSYS','java.io.FilePermission', path||'\owb\bin\win32\run_service.bat', 'read,execute');
dbms_java.grant_permission('OWBSYS','java.io.FilePermission', path||'\owb\bin\admintrepos.properties','read,write');
end;

-------------------

I have also tried deleting the:

C:\oracle11\product\11.1.0\db_1\owb\bin\admin\rtrepos.properties

but I still get the same problem.

Any advice would be much appreciated.

TIA.