Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to clean up failed instance's SGA? ( ORA-27100 )

420265Sep 28 2004 — edited Sep 28 2004

Hello, (sorry for my poor english)

MS Windows 2000 SP4
Oracle Database 9.2.0.4

1. I did some expperiments with parameters in spfile (modify .ora file and create spfile from pfile).

2. Database start - failed with error Out Of Memory.

3. I correct invalid parameters and recreate spfile.

4. Database start - failed with ORA-27100 error: shared memory realm already exists

5. I was trying to restart DB instance service - the same error

6. hard restart of computer - the same error...

My question is:

How can I clean up failed instance's SGA (OS is Windows)

Thanks for your help.

DS

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 26 2004

Added on Sep 28 2004

#general-database-discussions

1 comment

586 views