Regenerating The OWB "rtrepos.properties" File By Running The Script "reset_repository.sql" Fails With ORA-29532

(Doc ID 578740.1)

Last updated on SEPTEMBER 22, 2017

Applies to:

Oracle Warehouse Builder - Version 10.2 and later
Information in this document applies to any platform.





Symptoms

Regeneration of the rtrepos.properties file by running the script $OWB_HOME/owb/rtp/sql/reset_repository.sql fails with the following:

SQL> @reset_repository.sql <password>
Enter value for repos_password: <password>
old   2:   wb_rti_util.reset('&REPOS_PASSWORD.');
new   2:   wb_rti_util.reset('<password>');
begin
*
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
oracle.jdbc.driver.OracleSQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_RANDOM' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "<REPOSITORY_OWNER>.WB_RTI_UTIL", line 29
ORA-06512: at "<REPOSITORY_OWNER>.WB_RTI_UTIL", line 93
ORA-06512: at line 2

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms