Hi
So I was trying my first database upgrade from 11.2.0.4.0 to 12.1.0.2.0 (GI is already upgraded to 12.1.0.2.0)
Oracle linux 7.3
I have now tried several attempts, and it always dies in same place..
Looks like database was shut down, and after that it tries to run some query..
I also added trace.log file, upgrade failed about 2:45 - 2:50 PM
What I am seeing from trace.log, but when looking Oracle_Server.log (left most picture), then looks like these queries "select count(*) from v$instance" were ran before even starting database..
...........
...............
[Thread-186] [ 2017-04-07 14:49:51.868 EEST ] [SQLEngine.spoolOff:2124] Setting spool off = /oracle/11.2/base/cfgtoollogs/dbua/etmaster/upgrade5/Oracle_Server.log
[Thread-186] [ 2017-04-07 14:49:51.891 EEST ] [RDBMSUpgradeStep.executeStepImpl:554] Failed to start the RAC database exclusively in UPGRADE mode. The following error occurred:
ORA-03113: end-of-file on communication channel
oracle.sysman.assistants.dbma.backend.component.MigrateSidDirective.processDirective(MigrateSidDirective.java:1023)
oracle.sysman.assistants.dbma.backend.RDBMSUpgradeStep.executeStepImpl(RDBMSUpgradeStep.java:246)
oracle.sysman.assistants.dbma.backend.SummarizableStep.executeImpl(SummarizableStep.java:189)
oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:259)
oracle.sysman.assistants.util.step.Step.execute(Step.java:135)
oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2883)
java.lang.Thread.run(Thread.java:682)
[Thread-186] [ 2017-04-07 14:49:51.891 EEST ] [SummarizableStep$StepSummary.addDetail:783] Adding detail: Failed to start the RAC database exclusively in UPGRADE mode. The following error occurred:
ORA-03113: end-of-file on communication channel
[Thread-186] [ 2017-04-07 14:49:51.935 EEST ] [SummarizableStep.executeImpl:206] execute impl:RDBMS Upgrade = FAILED
[Thread-186] [ 2017-04-07 14:49:51.936 EEST ] [SummarizableStep.genSummary:273] Inside generate Post Upgrade Summary
..........
......
Any ideas..?
I would really appreciate.
E: Sometimes the dbua even gets killed. So looks like some hardware requirements issue, I have 10G allocated to each nodes, and database parameters sga_max_target and sga_target are both 6G (before were 8G, but I was wondering if oracle takes maybe too much memory from OS, and that's why dbua gets killed). But according to this "Document 1961997.1 Requirements for Installing Oracle Database 12.1 on RHEL7 or OL7 64-bit (x86-64)", minimum RAM is 1G
Kind regards
Raul