Run_service.sh and/or Set_repository_password.sql Script Execution Fail With ORA-29532 And ORA-28239: no key provided
Last updated on MARCH 01, 2018
Applies to:Oracle Warehouse Builder - Version 10.2 and later
Information in this document applies to any platform.
The run_service.sh and/or the set_repository_password.sql script execution fail with:
oracle.jdbc.driver.OracleSQLException: ORA-28239: no key provided
Additional error :
- with OWB 10.2 : ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT_FFI", line 21
- with OWB 11G: ORA-06512: at "SYS.DBMS_CRYPTO_FFI", line 67
The database has been cloned - including the OWB repositories.
OWB tables have been manually updated to reflect the change of hostname/port/service name.
This is not a RAC configuration (refer to <Note 395037.1> in that case) unless there is a shared drive.
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