Last updated on MARCH 08, 2017
Applies to:Oracle Life Sciences Data Hub - Version 2.2.3 and later
Information in this document applies to any platform.
OWB service is hitting below errors when trying to execute @service_doctor.sql. As consequence, all the jobs are failing .
>>>>>> There are errors in one or more PL/SQL packages and functions
Platform properties have been loaded correctly
Platform location has been seeded correctly
NLS messages have been loaded correctly
>>>>>> The platform service is not available
Service script is accessible to the database server
>>>>>> There is a problem with the repository connection information used to start the service
>>>>>> Here is the detailed error message which contains the connection information passed to the service:-
>>>>>> Cannot access the repository owner password from within the database server
>>>>>> Please verify that this information is accurate
>>>>>> If this information is correct, then please use the
'set_repository_password.sql' script to reset the stored password
The start_owb.sql also results on below error:
service startup failure reason ORA-29532: Java call terminated by uncaught Java exception: java.lang.ExceptionInInitializerError. Please invoke [owbhome]/owb/rtp/sql/service_doctor.sql for more information.
STEPS TO REPRODUCE
Execute the script:
No changes were done at database level or in the OS server level. Got pings from end users that the Work area installations started failing. Decided to restart OWB services and then, trying to start them up hit this issue and OWB is not longer starting up
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms