ORA-604 occurred when executing SQL stmt

[Former Member]

I am having following error while installing ABAP and Java on NW7 at ABAP load step in import_monitor.log and 'SAPAPPL2.log

*importmonitor.log :-*_

ERROR: 2009-01-25 17:03:42 com.sap.inst.migmon.LoadTask run

Loading of 'SAPAPPL2' import package is interrupted with R3load error.

Process 'C:\usr\sap\ID1\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL2.cmd -dbcodepage 4103 -l SAPAPPL2.log -stop_on_error' exited with return code 2.

For mode details see 'SAPAPPL2.log' file.

Standard error output:

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

__in 'SAPAPPL2.log I have following error log__

DbSl Trace: Error 604 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-604 occurred when executing SQL stmt (parse error offset=36)

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "RSTHEMES~0" ON "RSTHEMES" ( "THEME", "OBJVERS" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 16384 NEXT 0000000040K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )

DbSlExecute: rc = 99

(SQL error 604)

error message returned by DbSl:

ORA-00604: error occurred at recursive SQL level 2

ORA-04031: unable to allocate 4108 bytes of shared memory ("shared pool","select i.obj#,i.ts#,i.file#,...","Typecheck","seg:kggfaAllocSeg")

(DB) INFO: disconnected from DB

C:\usr\sap\ID1\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)

C:\usr\sap\ID1\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20090125170342

DbSl Trace: Error 604 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-604 occurred when executing SQL stmt (parse error offset=36)

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "RSTHEMES~0" ON "RSTHEMES" ( "THEME", "OBJVERS" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 16384 NEXT 0000000040K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )

DbSlExecute: rc = 99

(SQL error 604)

error message returned by DbSl:

ORA-00604: error occurred at recursive SQL level 2

ORA-04031: unable to allocate 4108 bytes of shared memory ("shared pool","select i.obj#,i.ts#,i.file#,...","Typecheck","seg:kggfaAllocSeg")

(DB) INFO: disconnected from DB

C:\usr\sap\ID1\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)

C:\usr\sap\ID1\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20090125170342

[Former Member · Accepted solution]

Hai,

1) First try to restart Oracle if this does not solve the problem then go for the second option.

2) Try this; in file init<SID>.ora, increase value of shared_pool_size. Restart Oracle and

continue to install.

Regards,

Yoganand.V

Edited by: Yoganand Vedagiri on Jan 26, 2009 11:42 AM

Edited by: Yoganand Vedagiri on Jan 26, 2009 11:43 AM

Edited by: Yoganand Vedagiri on Jan 26, 2009 11:45 AM

[Former Member · Accepted solution]

Hi Yoganand,

Thanks for your reply , after increasing the shared_pool_size , it is working now,

it is appreciated,

Good Luck,

[salah_zinet]

Hi All,

I had a similar problem, and this thread :

resolved my issue.

Regards.

[Former Member]

i am getting the same error when i am installing ECC 6.0 on Win 2003 with 2 gb ram....

i check the SHARED_POOL_SIZE parameter

then it is showing 144 MB,

hope it is enough...

if i have to alter this then how much should i ?

please suggest

regard

anuj

[Former Member]

I had increase SHARED_POOL _SIZE upto 536870912 meann 512 mb

when i am checking though SQLPLUS as sysdba

it is showing me 512 m

that's ok....

but after restarting when i contuni the installation it is showing me error ..

in the same way that SAPAPPL2_3

SAPAPPL2_2

SAPAPPL0_2

are failed when i check the log file then it is showing....me

OCI-CALL OCIServerAttach failed: rc = 12541

connect failed with sql error '12541'

DbslErrorMsg rc=99

so what will be that error

please suggest