Error upgrading repository from 11.2.0.1 to 11.2.0.3 ORA-29532 + ORA-06512
Hi,
Trying to upgrade repository to 11.2.0.3 following upgrade of database to 11.2.0.3.
New ORACLE_HOME for the 11.2.0.3 so using upgarde instrauctions for this as per upgrade guide.
Getting messgae below when run
reset_repository.sql
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
java.sql.SQLException: The file
/oracle/BIP/db11g/product/11.2.0/dbhome_1/owb/bin/admin/rtrepos.properties
cannot be accessed or has not been properly created on the server prdbus01. If
the file does not exist or if the database owner (normally user 'oracle') does
not have the required file permissions or if the file has not been properly
created then the file can be recreated by running the SQL*Plus script
/oracle/BIP/db11g/product/11.2.0/dbhome_1/owb/rtp/sql/reset_repository.sql (in
a RAC environment the file must be manually copied to each server which is used
for OWB). Otherwise if using a 10.2 database instance, then please run the
SQL*Plus script
/oracle/BIP/db11g/product/11.2.0/dbhome_1/owb/UnifiedRepos/reset_owbcc_home.sql.
The exception which caused this failure is
'java.security.AccessControlException(the Permission (java.io.FilePermission
/oracle/BIP/db11g/product/11.2.0/dbhome_1/owb/bin/admin/rtrepos.properties
write) has not been granted to OWBSYS. The PL/SQL to grant this
ORA-06512: at "OWBSYS.WB_RTI_UTIL", line 287
ORA-06512: at "OWBSYS.WB_RT_SCRIPT_UTIL", line 885
ORA-06512: at line 4