Monday, November 7, 2011

ORA-27102, ORA-27100 on startup in a Windows 32bit platform

We changed parameter SGA_MAX_SIZE to 2GB in the spfile and we shutdown the database.
When we tried to startup, we got the following errors:
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Nov 6 15:24:45 2011
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-27102: out of memory
OSD-00022: additional error information
O/S-Error: (OS 8) Not enough storage is available to process this command.
SQL> startup
ORA-27100: shared memory realm already exists

According to Oracle Note 1080317.1 "Summary of Causes for ORA-27102 on Startup":

    If oracle version is 32bit, the maximum SGA_TARGET / SGA_MAX_SIZE is 1.75gb

To start the database, we had to:
1. Start/stop oracle service.
2. Use an older pfile, where SGA_MAX_SIZE had a valid value.

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Nov 6 15:53:03 2011
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup pfile='E:\ORACLE\product\10.2.0\db_1\database\INIToblicore.ORA'
ORACLE instance started.
Total System Global Area 1258291200 bytes
Fixed Size                  1250572 bytes
Variable Size             419433204 bytes
Database Buffers          830472192 bytes
Redo Buffers                7135232 bytes
Database mounted.
Database opened.

SQL> create spfile='E:\ORACLE\product\10.2.0\db_1\database\SPFILEOBLICORE.ORA' from pfile;
File created.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.
Total System Global Area 1258291200 bytes
Fixed Size                  1250572 bytes
Variable Size             419433204 bytes
Database Buffers          830472192 bytes
Redo Buffers                7135232 bytes
Database mounted.
Database opened. 

No comments:

Post a Comment