Setting values for sga_max_size, db_cache_size, if Oracle is down

[Former Member]

Hello!

I am facing with the problem to set the values for sga_max_size, db_cache_size.

My problem is the oracle db is down and cannot be started.

It means the ALTER commandos cannot be executed

My qusetions are:

<b>- what is the configuration file that I can change the values of sga_max_size, db_cache_size and that will be read by executing the comand >startup?

Is that init<SID>.ora?

- how can I start after this oracle (just with >startup or >startup pfile...)?</b>

Thank you very much!

regards

Thom

[Former Member]

Hello Thom,

see the section "SPFILE - Restoring an Inconsistent SPFILE" of note 601157.

Regards

Martin

[Former Member]

Hello Martin,

Can I execute by ORA-27102 the following commandos in order to set and use the values of sga_max_size immediately?

Variant 1)

>sqlplus /nolog

>connect / as sysdba

> startup nomout

> ALTER SYSTEM SET SGA_MAX_SIZE= ’value’ SCOPE=pfile;

> shutdown immediate

> startup

Variant 2)

Changing the values of sga_max_size, etc. in init<DBSID>.ora

>sqlplus /nolog

>connect / as sysdba

> startup from pfile = /oracle/<SID>/dbs/ init<DBSID>.ora;

Thank you very much!

regards

Thom

[Former Member]

Hello Thom,

I don't know what you mean exactly with the ORA-27102, but usually you should be able to change SPFILE entries without getting an error like ORA-27102.

Why don't you want to follow just note 601157? This should be the easiest solution for the problems.

Regards

Martin