Search This Blog

Tuesday, July 26, 2011

ORA-27001 on Database Startup, Machines Resources are Fine

Oracle Certification - Tips

DBA Preparation - Tips

Practical DBA - Tips

Database: / Win2003Sp1 standard edition

We have total 7 gb ram on server , but PAE (physical address extention) is not enabled so i can't increase our SGA memory size more than ONE gb. when ever i try to increase i am getting "O/S Error: (OS 8) Not enough storage is available to process this command "

So I followed the below suggested solution and our db got up :)

Metalink Note:
Doc ID:

fact: Oracle Server - Enterprise Edition
fact: MS Windows Platform
symptom: Database startup fails
symptom: ORA-27100: shared memory realm already exists
symptom: DB_BLOCK_BUFFERS parameter is not set too high for the machine resources


Operating system has a duplicate Oracle memory segment still in memory.


Stop and start the database service. If this does not help, then a re-boot of the server will flush the memory

Check this metalink note also:
Doc ID:

How to enable PAE on windows platform

Windows 2003 service pack1 standard edition


1. open boot.ini file ( location: c:\ drive (it is hidden system file)

2. add the "/PAE /3GB" lines as following format

[boot loader]timeout=30default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS[operating systems]multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Standard" /noexecute=optout /fastdetect /PAE /3GB

3. restart the windows server

4. after restarting you can see the following line in the my computer properties.

No comments: