Skip to Content
0
Former Member
Feb 24, 2009 at 01:01 AM

Unicode conversion - import failing due to insufficient Oracle sessions

21 Views

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