Regenerating the OWB "rtrepos.properties" File by Running the Script "reset_repository.sql" Fails With ORA-29532
(Doc ID 578740.1)
Last updated on JULY 12, 2018
Oracle Warehouse Builder - Version 10.2 and later Information in this document applies to any platform.
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
To view full details, 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 a vibrant support community of peers and Oracle experts.