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