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.