The database load would fail when loading newer version of database save to a lower database version

Article Id: 49219

Status: Published

Updated On: 21-03-2018 07:17

Legacy Id: TEC581913

Products:

EHEALTH - MISC , CA eHealth Performance Management - Data Polling , CA eHealth Performance Management - Usage and Administration , DEVELOPER PROG , REMOTE POLLER

Issue/Introduction:

Description:

When transferring a database from one machine to another, you may mistakenly try to load a newer version of the database to an older version of eHealth/Oracle. For example, you attempt to load a 6.3.0 database save to an 6.2.2 eHealth installation. Below is a typical error you may receive.

/ehealth_bin/bin/nhLoadDb -p
/Oracle_ASCII/backup.tdb
The database you chose to load is from
Machine name: blnmtdc3sveha.int.bresnan.net
Machine type: server
 
Do you want to load the database? [n]
y
See log file /ehealth_bin//log/load.log for details...
Begin processing 09/24/2012 21:07:18.
09/24/2012 21:07:19 - Load DB path: /Oracle_ASCII/backup.tdb/oracle_rman
09/24/2012 21:07:19 - Performing initial checks ...
Cleaning out old files (09/24/2012 21:07:19).
Copying relevant files (09/24/2012 21:07:19).
ERROR: SQLCODE=-3114 SQLTEXT=ORA-03114: not connected to ORACLE
 
could not get oracle revision number
Error: Database error: nhiLoadDb.
Error: The program nhiLoadDb failed.
Error: nhiLoadDb failed.
Load failed with status: 1

Solution:

Upgrade eHealth to a version that is equal to or is newer than the database you will load from.

Environment:

Release: LHDEVC99000-6.3-eHealth-Live Health Upgrade Elements
Component: