cancel
Showing results for 
Search instead for 
Did you mean: 

Need a Help with instalation SAP IDES 2005 SR2

ddimitrov
Participant
0 Kudos

Hi All,

I'm trying to install SAP IDES 2005 SR2 on my notebook HP (2GB RAM, 120GB HDD, 700 HDD external, dual core procesor), Win Server 2003 Enterpise, Oracle 10g (patch 2), jave 1.4.2.13, I've downloaded all installation files DVDs from SAP Marketplace.

Everytime my installations stops on step 19 - Import ABAP, and I get message like this:

(DB) INFO: T76MGE_CGROUP~0 created #20081023222635

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=0)

(DB) ERROR: DDL statement failed

(CREATE TABLE "T76MGE_CKI" ( "MANDT" VARCHAR2(9) DEFAULT '000' NOT NULL , "CHKL_ITEM" VARCHAR2(12) DEFAULT ' ' NOT NULL , "TASK_FOR" VARCHAR2(12) DEFAULT ' ' NOT NULL , "START_DATE" VARCHAR2(6) DEFAULT ' ' NOT NULL , "POSS_DUR" VARCHAR2(12) DEFAULT '0000' NOT NULL , "PSDUR_T_UNIT" VARCHAR2(9) DEFAULT ' ' NOT NULL , "NEC_IT" VARCHAR2(3) DEFAULT ' ' NOT NULL , "IS_DOC" VARCHAR2(3) DEFAULT ' ' NOT NULL , "START_DIFF" NUMBER(4,0) DEFAULT 0 NOT NULL , "START_TUNIT" VARCHAR2(9) DEFAULT ' ' NOT NULL , "END_DATE" VARCHAR2(6) DEFAULT ' ' NOT NULL , "END_DIFF" NUMBER(4,0) DEFAULT 0 NOT NULL , "END_TUNIT" VARCHAR2(9) DEFAULT ' ' NOT NULL ) TABLESPACE PSAPSR3 STORAGE (INITIAL 16384 NEXT 0000000040K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )

DbSlExecute: rc = 99

(SQL error 604)

error message returned by DbSl:

ORA-00604: error occurred at recursive SQL level 1

ORA-04031: unable to allocate 4108 bytes of shared memory ("shared pool","update seg$ set type#=:4,blo...","Typecheck","seg:kggfaAllocSeg")

(DB) INFO: disconnected from DB

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

G:\usr\sap\IDE\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20081023222635

and also:

TRACE: 2008-10-23 22:22:48 com.sap.inst.migmon.LoadTask processPackage

Loading of 'SAPAPPL2' import package into database:

G:\usr\sap\IDE\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL2.cmd -dbcodepage 4103 -l SAPAPPL2.log -stop_on_error

ERROR: 2008-10-23 22:26:36 com.sap.inst.migmon.LoadTask run

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

Process 'G:\usr\sap\IDE\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

WARNING: 2008-10-23 22:26:48

Cannot start import of packages with views because not all import packages with tables are loaded successfully.

WARNING: 2008-10-23 22:26:48

1 error(s) during processing of packages.

INFO: 2008-10-23 22:26:48

Import Monitor is stopped.

Could anyone help me with this issue, what I am doing wrong?

I'll appreciete any help, cause I'm going crazy this is may be the 5th time that my installation stops on this stage.

Thanks in advance

Accepted Solutions (1)

Accepted Solutions (1)

lakshminarayanan_m
Contributor
0 Kudos

Hi,

For installing ERP2005 , minimum requirment of RAM is 4GB. in that 4gb - DB instance will consume 1800MB(physical mem).

According to your system total phy ram size is only 2gb.

So when u start installation , the system will ask how much memory should allocate for this installtion , default i will take 3/4 of the total size of your phy ram.

In your case you have to change the value and allocate 2048MB(ie full size of the phy mem).

I hope u understand my suggestion,

Regards

MLN

Answers (4)

Answers (4)

ddimitrov
Participant
0 Kudos

Hi Eric

These are values in init.ora:

#Transaction processing

#sort_area_size=524288

#Datawarehouse

sort_area_size=1048576

large_pool_size=1048576 #Transaction processing, Datawarehouse

db_cache_size=50331648 #Datawarehouse, Transaction processing

java_pool_size=67108864 #Datawarehouse, Transaction processing

  1. db_block_buffers = 200 # INITIAL

  2. db_block_buffers=100 #SMALL

  3. db_block_buffers =550 # MEDIUM

  4. db_block_buffers=3200 #LARGE

#shared_pool_size = 52428800 # INITIAL

shared_pool_size = 67108864 # datewarehouse, transaction processing

log_checkpoint_interval = 10000

How I have to chenge the values?

And in init<SID> values are:

#

  1. unit of shared_pool_size: bytes

  2. unit of db_block_buffers: number of cached blocks

  3. unit of log_buffer: bytes

shared_pool_size = 160903987

  1. 10% of shared_pool_size

shared_pool_reserved_size = 16090398

log_buffer = 1048576

Please, let me know what are the correct values?

Thank you in advance

former_member204746
Active Contributor
0 Kudos

as Per SAP note 830576, set shared_pool_size to 409600000 (which is about 400MB.)

ddimitrov
Participant
0 Kudos

Yes, I did. My vitrual memory is 12GB

former_member204746
Active Contributor
0 Kudos

Dimitar, have you read my previous response? increasing shared_pool_size WILL fix your issue.

Former Member
0 Kudos

Hi,

Did you set virtual memory or not. If not set the virtual memory to 3 times more of your physical RAM and restart the installation.

Rgds,

Suman

former_member204746
Active Contributor
0 Kudos

have you made some minimum research before posting?

increase value for shared_pool_size in file init[SID].ora, restart Oracle, restart installation.

problem fixed.