on 10-24-2008 12:40 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
db_block_buffers = 200 # INITIAL
db_block_buffers=100 #SMALL
db_block_buffers =550 # MEDIUM
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:
#
unit of shared_pool_size: bytes
unit of db_block_buffers: number of cached blocks
unit of log_buffer: bytes
shared_pool_size = 160903987
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, I did. My vitrual memory is 12GB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.