Change SAPINST settings for SAP ERP on Oracle

[Former Member]

Hi!

I successfully installed SAP ERP (Win X86, 64 Bit) with Oracle 10.2.0.4 via system copy.

So I installed the SAP system with SAPINST and with their typical recommended settings.

As result some tablespaces have up to 27 directories (SR3_01.. SR_27) and the maximum growth of all the tablespaces is 2GB.

Question:

1) Can I change this Tablespaces settings in order to have less ammount of tablespaces with tablespaces growth of 1o GB?

2) The autoextend of Tablespaces is "on". Should I change this?

3) What are other recommended settings for Oracle that should be changed after SAPINST?

Thank you very much!

regards

Jürgen

[former_member204746]

with SAPINST, go in advanced DB configuration and change settings to whatever you want.

[stefan_koehler]

Hello Jürgen,

1) Can I change this Tablespaces settings in order to have less ammount of tablespaces with tablespaces growth of 1o GB?

You can not change the "amount" of tablespaces. But i think you mean if you can change the amount of data files within a tablespace - and here the answer is "yes you can". We also have all data files with auto extend to a max size of 10 GB.

2) The autoextend of Tablespaces is "on". Should I change this?

Why should you do that (beside of sizing it manually). Just let it auto extend.

3) What are other recommended settings for Oracle that should be changed after SAPINST?

SAPnote #830576 - Parameter recommendations for Oracle 10g

SAPnote #974781 - Oracle database 10g: Internal maintenance jobs

SAPnote #838725 - Oracle Database 10g: New database statistics

Regards

Stefan

[former_member204746]

1) yes, and you should

2) leave it at ON

3) it all depends on your company's choices.

[Former Member]

Hi!

Many thanks for the response.

Question:

what is the easiest way to resize the tablespaces from 2 GB to 10 GB?

Is there a SQL-skript therefore?

Thank you!

[Former Member]

You can generate the sql for the resize with this sql:

select 'alter database datafile '''||file_name||''' resize 10g;'
from dba_data_files;

Do not forget about the tempfile, just substitute data with temp everywhere. You might want to disable autoextend afterwards. Taken from here:

Best regards, Michael