Skip to Content
0
Jun 08, 2020 at 08:18 AM

374487 / 2020 For input string: "SP" during Oracle 112c pre upgrade Phase

204 Views Last edit Jun 08, 2020 at 08:20 AM 2 rev

Hello Everyone;

We are upgrading from 11204 to 12c and we reached the pre upgrade phase where we want to create sql files with the below command:


%ORACLE_HOME%\jdk\bin\java -jar D:\oracle\AQA\12201\rdbms\admin\preupgrade.jar DIR D:\tmp\ora_pre_upgrade

The expected results would be having the three below files:
1- preupgrade.log
2- preupgrade_fixups.sql
3- postupgrade_fixups.sql


But the error we are getting is:
For input string: "SP"
[Loaded java.lang.Shutdown from D:\oracle\AQA\11204\jdk\jre\lib\rt.jar]
[Loaded java.lang.Shutdown$Lock from D:\oracle\AQA\11204\jdk\jre\lib\rt.jar]


I tried another command to get the required files:
%ORACLE_HOME%\jdk\bin\java -verbose -jar D:\oracle\AQA\12201\rdbms\admin\preupgrade.jar DIR D:\tmp\ora_pre_upgrade

But I got the same error.

Kindly check the attached images to get the issue in a better way.

Kindly help us as a very important testing is needed to push to fix an issue on production.

Best Regards

Amal Aloun