opa_settings error during OC 5.2 database upgrade

(Doc ID 2384397.1)

Last updated on APRIL 10, 2018

Applies to:

Oracle Clinical - Version 5.2.0 to 5.2.0 [Release 5.2.0]
Information in this document applies to any platform.

Symptoms

When upgrading the OC 5.1 database to 5.2, and after putting in the database service name "ocval" the error messages below appear in the file: installActions<Date Time>.log

--
append = false
INFO: Query Returned: true
SEVERE: opa_settings is not correctly configured for ocval database.
INFO: User Selected: Yes/OK
--

Below are the opa_settings:

opa_home:/local/home/opapps
oratab_filespec:/etc/oratab
tnsnames_filespec:/app/oracle/product/dbhome/12.1.0/network/admin/tnsnames.ora
db_env_setting:_DEFAULT_:NLS_DATE_FORMAT:DD-MON-RRRR
db_env_setting:_DEFAULT_:NLS_LANG:american_america.utf8
db_env_setting:_DEFAULT_:RXC_BATCH_QUEUE:a
db_env_setting:_DEFAULT_:RXC_IMMED_QUEUE:a
db_env_setting:_DEFAULT_:RXC_MAA_TAB_SPACE:TEMP1
db_env_setting:_DEFAULT_:RXC_NOW_STRING:now
db_env_setting:_DEFAULT_:RXC_SAS_BATCH_QUEUE:a
db_env_setting:_DEFAULT_:RXC_USER:/local/home/opapps
db_env_setting:_DEFAULT_:SASORA:V9
code_environment:52:/local/home/opapps/oc/52
db_code_pair:ocval:52

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