Vo vremja instaljaciji ERP2005 na faze import ABAP 4 iz 38 packages viljetajut

OS: WIN2003
DB: ORA 10.2

Vsjo chto mog naiti iz probljem:

import_monitor.log:
ERROR: 2006-07-20 09:54:49 com.sap.inst.migmon.LoadTask run
Loading of 'SAPAPPL0_2' import package is interrupted with R3load error.
Process 'C:\usr\sap\RET\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL0_2.cmd -dbcodepage 4103 -l SAPAPPL0_2.log -stop_on_error' exited with return code 2.
For mode details see 'SAPAPPL0_2.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

SAPAPPL0_2.log:
DbSl Trace: Failed to register client info: orc=604
DbSl Trace: ORA-1403 when accessing table SAPUSER
DbSl Trace: Failed to register client info: orc=604

(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8
(DB) ERROR: DDL statement failed
(DROP TABLE "KNA1")
DbSlExecute: rc = 103
(SQL error 942)
error message returned by DbSl:
ORA-00942: table or view does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: ORA-604 occurred when executing SQL statement (parse error offset=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","select name,password,datats#...","Typecheck","kgghtInit")
(DB) INFO: disconnected from DB

V chom mozhet bitj probljema?

ORA-04031 unable to allocate string bytes of shared memory ("string","string","string","string")

Cause: More shared memory is needed than was allocated in the shared pool.

Action: If the shared pool is out of memory, either use the DBMS_SHARED_ POOL package to pin large packages, reduce your use of shared memory, or increase the amount of available shared memory by increasing the value of the initialization parameters SHARED_POOL_RESERVED_SIZE and SHARED_ POOL_SIZE. If the large pool is out of memory, increase the initialization parameter LARGE_POOL_SIZE.


ORA-00604 error occurred at recursive SQL level string

Cause: An error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables).

Action: If the situation described in the next error on the stack can be corrected, do so; otherwise contact Oracle Support Services.

с памятью проблем нет?

2 Gb

Proboval prodolzhatj instaljaciju poslje perezagruzki. Bez izmenenij.

Instaljacija povtornaja. Pervij raz instaljiroval ispoljzuja java 1.5.0 Viljetalji 8 packages s takimi zhe oshibkami.

Postavil java 1.4.2 i povtoril instaljaciju zanovo. Teperj viljetajut toljko 4 packages.

Платформа установки какая? Скорее всего Windows? 32,64bit ? Свопа хватает?

Windows Server 2003 R2 32bit
Swap: Paging file custom size: Initial 2046 Maximum 8000

А максимум 8 Gb это как? Вроде ограничение для 32 bit 4 Gb на один диск?
Поставьте fixed 4 Gb, возможно в этом проблема. Хотя всего желательно иметь 8 Gb. Но если нет второго, хотя бы логического диска, то придется обойтись 4-мя Gb. Должно хватить, хотя и в натяг.

при установке посмотри сколько всего памти съело (можно в таска манагере) да и поставь инишиал своп на 8 гигов.

pomenjal min 8000 max 8000
njepomoglo
v taskmanagere:
Physical memory
Total: 2094976
Available 1353608
PF usage 638 Mb

v alert_<SID>.log:
Errors in file c:\oracle\ret\saptrace\background\ret_m001_2204.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4108 bytes of shared memory ("shared pool","select ts#,file#,block#,nvl(...","Typecheck","kgghtInit")
ORA-06512: at "SYS.PRVT_HDM", line 49
ORA-06512: at "SYS.PRVT_HDM", line 66
ORA-06512: at line 1

Gde pomenjatj?

Oracle версии 10.2 ? Патчик ставили?

Nashol init<SID>.ora
sejchas stoit
SHARED_POOL_SIZE=160903987
SHARED_POOL_RESERVED_SIZE = 16090398

Njet. Skachal uzhe 10.2 ot SAPa.
Esho patch nuzhen?

В базовом комплекте сейчас поставляют патч до 10.2.0.2 и настойчиво говорят что он обязателен

Патч 10.2.0.2 ставить обязательно
а вот эти параметры должны быть не менее 400 метров (по гайду )
SHARED_POOL_SIZE=400000000
и соответственно
SHARED_POOL_RESERVED_SIZE = 40000000