I am running a Unicode conversion of an existing ECC6 ABAP-only system.
I have exported the data OK, uninstalled the non-Unicode system, and am now running the install/import of the UNICODE system.
The issue I have is that on the 'import ABAP' phase (there are 151 jobs to run) I am experiencing multiple job failures because of a shortage of Oracle sessions.
The number of sessions/processes is of course defined in the initSID.ora file. When I look at this, it is set to the default values. Because these values are not high enough, I have to wait for the jobs to fail (which takes a number of hours) before I can change the value and restart the database.
Because there is no interruption in the install/reload phases between when the database is built and when the ABAP import starts, I believe that I need to be able to set the number of sessions to a higher value when the initSID.ora file is built.
My question is: *where does the initSID.ora file get these values from?* I thought it would be the control.xml file, but the only reference I can find in there are to the variables @SESSIONS@ and @PROCESSES@ and I have been unable to find where the actual values for these are defined.
Anyone have any ideas?
TIA.
Cheers....John