ORA-00603: ORACLE server session terminated by fatal error

[Former Member]

Hi ,

I am installing ECC6 and i am stuck in the import ABAP phase.

The error is:

ERROR 2007-02-12 10:00:01

CJS-30022 Program 'Migration Monitor' exits with error code 103. For details see log file(s) import_monitor.java.log, import_monitor.log.

ERROR 2007-02-12 10:00:01

FCO-00011 The step runMigrationMonitor with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Doublestack_OneHost|ind|ind|ind|ind|3|0|NW_ABAP_Import_Dialog|ind|ind|ind|ind|11|0|NW_ABAP_Import|ind|ind|ind|ind|0|0|runMigrationMonitor was executed with status ERROR .

In the log file the error is traced like follow:

(DB) ERROR: DDL statement failed

(CREATE INDEX "N1PRLEM~7" ON "N1PRLEM" ( "MANDT" , "TMNID" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 16384 NEXT 0000000040K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )

DbSlExecute: rc = 99

(SQL error 603)

error message returned by DbSl:

ORA-00603: ORACLE server session terminated by fatal error

(DB) INFO: disconnected from DB

Please any help with this problem,

Regards.

---Kad

[Former Member]

Hi,

Thre is no required momory in SGA to satisfy the user request.

ORA-04031 occurs if no associated memory is available in the shared pool to fulfill a memory request

Try to restart the session(oracle).

Please refer sap note no 1013391.

Additional info about error ORA-04031 , refer note no 869006

Regards

Upender Reddy

[Former Member]

Hi peter ,

The OS is windows server 2003 and Oracle is 10.1 for windows

I cheked in the logs and i found this. I hope it is useful to resolve the problem.

Did Not dump SGA Heap desc=02F07188

Current time: 02/10/2007 02:26:49

Last SGA heap dump at 02/10/2007 02:14:07

SGA Heap Dump Count = 1

===============================

End 4031 Diagnostic Information

===============================

kgefec: fatal error 0

• 2007-02-10 02:26:52.282

ksedmp: internal or fatal error

ORA-00603: ORACLE server session terminated by fatal error

ORA-00604: error occurred at recursive SQL level 2

ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","select /*+ rule */ bucket, e...","Typecheck heap","kgghteInit")

ORA-00604: error occurred at recursive SQL level 3

ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","Typecheck heap","kgghteInit")

Current SQL statement for this session:

CREATE INDEX "CGPL_RELATION~P" ON "CGPL_RELATION" ( "PREDEC_PROJECT" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 16384 NEXT 0000000640K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 )

Thank you very much for your help.

Best regards

Kaddour

[Former Member]

would be very usefull to have some more information about platform and Oracle version you are using.

may be you will find more information in the alert log file.

peter