Upgrade From 7.3.1.5 To 12.2.7.1 Fails due to mismatch between oracle client and database version (Doc ID 2442764.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

On : 12.2.7.1 version, Upgrade

When attempting to upgrade demantra from version 7.3.1.5 to version 12.2.7.1,
the following error occurs.

ERROR
-----------------------

From upgrade log file:

2018-08-22 18:12:07,452 [DEBUG] - STDERR> Import: Release 12.2.0.1.0 - Production on Wed Aug 22 18:12:07 2018
2018-08-22 18:12:07,452 [DEBUG] - STDERR>
2018-08-22 18:12:07,452 [DEBUG] - STDERR> Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.
2018-08-22 18:12:07,452 [DEBUG] - STDERR>
2018-08-22 18:12:07,858 [DEBUG] - STDERR>
2018-08-22 18:12:07,858 [DEBUG] - STDERR> Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
2018-08-22 18:12:07,858 [DEBUG] - STDERR> With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
2018-08-22 18:12:07,858 [DEBUG] - STDERR> Advanced Analytics and Real Applicat
2018-08-22 18:12:07,890 [DEBUG] - STDERR>
2018-08-22 18:12:07,890 [DEBUG] - STDERR> Export file created by EXPORT:V11.02.00 via conventional path
2018-08-22 18:12:07,890 [DEBUG] - STDERR>
2018-08-22 18:12:07,890 [DEBUG] - STDERR> Warning: the objects were exported by BAL_1227, not by you
2018-08-22 18:12:07,890 [DEBUG] - STDERR>
2018-08-22 18:12:07,890 [DEBUG] - STDERR> import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
2018-08-22 18:12:07,921 [DEBUG] - STDERR> import server uses UTF8 character set (possible charset conversion)
2018-08-22 18:12:07,921 [DEBUG] - STDERR> IMP-00003: ORACLE error 942 encountered
2018-08-22 18:12:07,921 [DEBUG] - STDERR> ORA-00942: table or view does not exist
2018-08-22 18:12:07,921 [DEBUG] - STDERR> IMP-00023: Import views not installed, please notify your DBA
2018-08-22 18:12:07,921 [DEBUG] - STDERR> IMP-00000: Import terminated unsuccessfully
2018-08-22 18:12:07,984 [DEBUG] - exitCode = proc.exitValue(): 1
...
2018-08-22 18:12:08,077 [DEBUG] - Executing: {call GET_SEQ_NEXTVAL_NO_OUT ('BAL_LIST', 'ID', 'BAL_LIST_SEQ')}
2018-08-22 18:12:08,327 [DEBUG] - Executing: insert into BAL_LIST (ID, SCHEMA_NAME, USER_NAME)
..
2018-08-22 18:12:08,499 [DEBUG] - Executing: SELECT GET_SEQ_NEXTVAL_FNC ('BAL_LIST', 'ID') FROM DUAL
2018-08-22 18:12:08,515 [DEBUG] - Executing: alter table BAL_HASH_LIST_ rename to BAL_HASH_LIST_8
2018-08-22 18:12:08,546 [ERROR] - Failed to copy repository.
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

..
2018-08-22 18:56:15,495 [DEBUG] - xmxValue -Xmx8192M
2018-08-22 18:56:15,495 [DEBUG] - Source Schema Alias AS_V1227_20180822_181206
2018-08-22 18:56:15,495 [DEBUG] - Target Schema Alias null
2018-08-22 18:56:15,495 [DEBUG] - Is Manual Upgrade from Installer TRUE
2018-08-22 18:56:15,510 [ERROR] - Execute blocking method encountered errors.
com.demantra.BAL.exceptions.BALException: java.lang.NullPointerException
at com.demantra.BAL.gui.BALMain.createProcessAtInstallation(Unknown Source)
at com.demantra.BAL.gui.BALMain.createDifferencePackage(Unknown Source)
at com.demantra.panels.ManualUpgradePanel.executeMethod(ManualUpgradePanel.java:151)
at com.demantra.panels.ExecuteBlockingMethodCallPanel$Worker.construct(ExecuteBlockingMethodCallPanel.java:520)
at com.demantra.infra.SwingWorker$2.run(SwingWorker.java:162)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException
at java.lang.ProcessBuilder.start(Unknown Source)
... 6 more
2018-08-22 18:56:15,542 [DEBUG] - Blocking Method error: java.lang.NullPointerException
2018-08-22 18:56:15,542 [ERROR] - BAL had encountered errors: java.lang.NullPointerException



From bal_log

----- Rebuilding : Preparing Upgrade...
Current JVM is 64
RamSize 8
SHUTDOWN REQUESTED
(X) commiting registry

REGISTRY ALREADY STORED!

(X) shutting down service manager
(X) cleaning up temporary directories
Exiting with exit code: 1000
I/O error occured writing additional files list
java.io.FileNotFoundException: null\removablesList.txt (The system cannot find the path specified)
at java.io.FileOutputStream.open0(Native Method)
at java.io.FileOutputStream.open(Unknown Source)
at java.io.FileOutputStream.(Unknown Source)
at java.io.FileWriter.(Unknown Source)
at com.zerog.ia.installer.LifeCycleManager.cr(Unknown Source)
at com.zerog.ia.installer.LifeCycleManager.cf(Unknown Source)
at com.zerog.ia.installer.LifeCycleManager.ab(Unknown Source)
at com.zerog.ia.installer.LifeCycleManager$5.aa(Unknown Source)
at com.zerog.ia.installer.Installer.bq(Unknown Source)
at com.zerog.ia.installer.Installer.exit(Unknown Source)
at com.zerog.ia.installer.actions.ShowDialogAction.installSelf(Unknown Source)
at com.zerog.ia.installer.AAMgr.a5(Unknown Source)
at com.zerog.ia.installer.AAMgr.ac(Unknown Source)
at com.zerog.ia.installer.AAMgrBase.am(Unknown Source)
at com.zerog.ia.installer.AAMgrBase.runNextInstallPiece(Unknown Source)
at com.zerog.ia.installer.AAMgr.clickNextButton(Unknown Source)
at Flexeraacx.goNext(Unknown Source)
at com.demantra.panels.AutomaticUpgradePanel$UpgradeWorker.finished(AutomaticUpgradePanel.java:774)
..





STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Clone EBS environement
2. Upgrade demantra from version 7.3.1.5 to version 12.2.7.1
3. It fails

Changes

Cause

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