My Oracle Support Banner

Error Upgrading To TRC3.1 During (Doc ID 2210492.1)

Last updated on OCTOBER 08, 2019

Applies to:

Oracle Healthcare Translational Research - Version 3.1 and later
Information in this document applies to any platform.


On : 3.1 version, Installation

When attempting to upgrade to TRC 3.1 from TRC using the following command line:
sh ./ -cdm_schema cdm -odb_schema odb -app_schema apps -enterprise_schema ent -db_conn <SERVICE_NAME> -cdm_indx_tablespace cdm_index_ts -index_tablespace odb_index_ts -lob_tablespace odb_lob_ts -promoter_offset 1000 -flanking_offset 1000 -partition_mode study -db_platform exadata -job_schema joben -job_store jobstore -job_index_tbs JOB_INDEX_TS -dbfs_tbs DBFS_DATA_TS -dbfs_lob_tbs DBFS_LOB_TS -max_parallel_degree 8

the following error occurs.

Line 55: FAIL 53: 'ORA-20001: There are 1 sessions connected to schemas that need to be upgraded', Rule 'pragma err forever ^ORA-.*'

Customer find out that he had the wrong password for the jobs user (joben). It is giving a somewhat different message now indicating "no privileges on tablespace 'USERS""

QL>Disconnected from Oracle Database 11g Enterprise Edition Release - 64bit Production

Line 1243: FAIL 84: 'ORA-06512: at line 25', Rule 'pragma err forever ^ORA-.*'
old 17: from &ODB_SCHEMA..w_eha_product_version';
new 17: from odb.w_eha_product_version';
old 32: and owner = upper('&ODB_SCHEMA');
new 32: and owner = upper('odb');
old 43: from &ODB_SCHEMA..w_eha_product_profile';
new 43: from odb.w_eha_product_profile';
ERROR at line 1:
ORA-01950: no privileges on tablespace 'USERS'
ORA-06512: at line 25




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.