Regarding Bigger SGA in ECC 6.0

[Former Member]

Hi All,

When installing SAP ECC 6.0/Oracle 10g on AIX 5.3, if i am modifing instance memory then installation giving me following error in catproc.sql running phase.

============ ERROR==== ========= ========= ========= =======

ERROR 2006-12-20 09:44:38

FCO-00011 The step runCatprocSql with step key

|NW_Onehost| ind|ind|ind| ind|0|0|NW_ Onehost_System| ind|ind|ind| ind|1|0|NW_ CreateDBandLoad| ind|ind|ind| ind|9|0|NW_ CreateDB| ind|ind|ind| ind|0|0|NW_ OraDBCheck| ind|ind|ind| ind|0|0|NW_ OraDBMain| ind|ind|ind| ind|0|0|NW_ OraDBStd| ind|ind|ind| ind|3|0|NW_ OraDbBuild| ind|ind|ind| ind|5|0|runCatpr ocSql

was executed with status ERROR .

ERROR 2006-12-20 09:44:38

CJS-00084 SQL statement or script

failed.<br>DIAGNOSI S: Error message: ORA-29809: cannot

drop an operator with dependent objects

============ ========= ========= ========= ========= =======

if i am not modifing the instance RAM(if using default value) then installation is working fine,

My Server RAM is 9 GB

When i am installing SAP/Oracle occpy 50% of total RAM, if i am modifing 6 GB RAM then it is not working and giving me error at catproc.sql phase.

My intention is that i want to create little bit bigger SGA greather then 1.7 GB.

I have following doubts, kindly provide guidance.

(1) Why should i cannot create more then 1.7 GB RAM?

(2) If i want to Create more then 1.7 GB RAM's SGA

then what should i have to do during installation?

(3) Which SAP Parameters i have to change to utilise maximum Memroy.

Waiting for your kind response.

Thanks and Regards

K R Singh

[Former Member · Accepted solution]

Check note# 617416 - Oracle9i: Dynamic SGA

[Former Member]

Hi Karmesh,

As a role of thumb, Oracle does not support any extended shared memory segments on IBM AIX. Please take a look OSS notes #105429, 123366.

Additionally, I would like to suggest that you use dynamic SGA that has been mentioned in OSS note #105429.

What kind of memory, you are talking about, in your last question? Oracle memory tuning or SAP memory tuning?

Regards,

Orkun Gedik

Senior SAP R/3 Basis and Development Consultant

ASTRON

[andreas_herzog]

-> OSS notes #105429, 123366

only valid for systems running on 32bit!!! which on the other hand is not vaild for any unix system as the sap availability on 32bit unix has been stopped years ago...

you'd better have a look at sapnotes 146.289 and 445.533 (which describes the sap parameters) which are both valid for 64bit unix systems...

GreetZ, AH