reset a parameter if db fails

[Former Member]

Hello

I am pritty new in  oracle. I wander if I change an parameter with e.g

ALTER SYSTEM SET "_gby_hash_aggregation_enabled" = FALSE scope=both;

how can I then change parameter if db does not start

Thank you in advance

[Former Member]

Hi,

before changing any parameter, you better take a copy of the profile.

Once you changed it and if DB fails then you can revert it as said by steve SOUMAH.

Regards,

Venkata S Pagolu.

[volker_borowski2]

Hi,

this parameter will not cause the db to fail starting.

To take it back,

ALTER SYSTEM RESET "_gby_hash_aggregation_enabled" scope=spfile;

should do the job.

Volker

[former_member182307]

Hello,

What you should do is :

stop the db

rename the spfile currently in use to somtehing like spfile.old.

use your latest initfile ( initSID.ora ) and remove the wrong parameter from it.

Then :

sqlplus "/ as sysdba"

create spfile from pfile;

startup;

The DB should then start.

Cheers. Steve.