Installation error IDES on Windows server 2003

[Former Member]

Hi all,

I am trying to install SAP IDES ERP 2005 sr2 on Windows server 2003. I use oracle 10.2.0. By the installation I got the following error:

ORA-00604: error occurred at recursive SQL level 3

ORA-04031: unable to allocate 4108 bytes of shared memory ("shared pool","select pos#,intcol#,col#,spa...","Typecheck","seg:kggfaAllocSeg")

Can you help me to solve it?

Thank you,

Maria

[ddimitrov]

Hi,

I got the same problem but when I don't know how to log on into Oracle, what is the password for id: sysdba ? I didn't set password anywhere during oracle installation? Could you help me please

Thanks in advance

[Former Member]

Hi,

first check Note 1013391 - IDES ERP 2005 ECC 6.0 SR2

As a solution try 'Retry', or better restart Oracle ('shutdown immediate' and 'startup') first and then 'Retry'. Restarting of Oracle will work always.

if not work then

check Note 1120481 - ORA-4031 - memory allocation errors for object-level stat

as alternative try to increase the size of your SGA and also check that hard disk is not full

regards,

kaushal

Edited by: kaushal malavia on May 21, 2008 5:53 PM

[markus_doehr2]

Execute

sqlplus / as sysdba
alter system set shared_memory_pool 400000;
shutdown immediate
startup

Then repeat the installation phase.

Markus

[andreas_herzog]

> alter system set shared_memory_pool 400000;

how about appending SCOPE to the statement?

> alter system set shared_memory_pool 400000 SCOPE=BOTH;

or

> alter system set shared_memory_pool 400000 SCOPE=SPFILE;

GreetZ, AH

[markus_doehr2]

Hi Andreas,

alter system set shared_memory_pool 400000;

how about appending SCOPE to the statement?

I´m not sure if at that time the scope file is already there - I think it´s created after the data load and after the system is switched to archivelog mode.

Markus