-
Catpatch.sql Error
Hi, I am implemting oracle wearhouse builder and when installing the runtime assistance I am getting an java error.
java.sql.SQLException: ORA-01919: role 'JAVADEBUGPRIV' does not exist.
I did a tar and they are tellingme to run the catpatch.sql file.
I upgraded oracle from 8.17.0 to 8.1.7.4 and created the database.
I do not see catpatch.sql file. I guess it is in 9i.
Kindly help me out to figure out how can i go further.
Thanks
-
it's located in
$ORACLE_HOME/rdbms/admin
-
catpatch is only available for 9i. You might try to run catalog.sql and catproc.sql (9i catpatch.sql runs the new patchset versions of catalog.sql and catproc.sql and calls the component patch scripts.)
HTH
Sanjay