Help! Tue SGA_MAX too large! Database cannot start!
l...@tech-trans.com
I tuned the SGA_MAX to 3G. Then, the database could not startup!
How can I do now! Help!
Ming
bdbafh
If that is Oracle XE (you have posted regarding that edition on other
posts) that value is not permitted.
Its covered in the docs.
You might want to post OS and database server software environment
information if you want an answer that is other than an uninformed
guess.
-bdbafh
l...@tech-trans.com
It is Oracle 10g database server with patch 10.2.0.2.0 under Windows
envrionment. I have learned create spfile from pfile. However, it
did not work! Thx!
Ming
ora...@msn.com
On Jul 14, 10:57 am, l...@tech-trans.com wrote:
> Hi!,
>
> I tuned the SGA_MAX to 3G.
No, you've set sga_max_size to 3G. Had you actually tuned this value
your database would have started, I expect.
> Then, the database could not startup!
How much RAM do you have installed on that Windows server? Is this a
64-bit version of Windows? And, if so, are you starting that Windows
operating system with the proper switches to allow access to memory
beyond 2G?
http://www.brianmadden.com/content/article/The-4GB-Windows-Memory-Limit-What-does-it-really-mean-
> How can I do now! Help!
>
Stop expecting a 32-bit operating system to behave as though it were
64-bit?
> Ming
David Fitzjarrell
Charles Hooper
If you have a good copy of the init.ora (pfile) file (named correctly
of course), place the file in the same folder location as the spfile.
Fix the init.ora file so that it does not specify memory settings that
when combined exceed 2GB, then rename the current spfile to something
else. The database instance will automatically read the init.ora if
the spfile is not found where expected, when it is started. Once the
database is up, execute a command to create a new spfile from the
pfile.
Always keep a good up to date init.ora (pfile).
Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.
Maxim Demenko
> Charles Hooper
> IT Manager/Oracle DBA
> K&M Machine-Fabricating, Inc.
Iirc, instance doesn't have to be started for create pfile from spfile
(at least on newer oracle versions).
Best regards
Maxim
sybr...@hccnet.nl
wrote:
In 9i, startup nomount is sufficient.
--
Sybrand Bakker
Senior Oracle DBA
Maxim Demenko
Thank you for pointer, i neither have an oracle on windows to test, nor
any earlier version than 9.2.0.8, but with latter on linux that seems to
work:
sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.8.0 - Production on Mon Jul 14 21:27:05 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> !echo $ORACLE_SID
ORA92
SQL> !ls -l *ORA92.ora
-rw-r----- 1 oracle dba 3584 Feb 4 23:20 spfileORA92.ora
SQL> create pfile from spfile;
File created.
SQL> !ls -l *ORA92.ora
-rw-r--r-- 1 oracle dba 1347 Jul 14 21:27 initORA92.ora
-rw-r----- 1 oracle dba 3584 Feb 4 23:20 spfileORA92.ora
SQL> startup
ORACLE instance started.
Total System Global Area 253301172 bytes
Fixed Size 450996 bytes
Variable Size 100663296 bytes
Database Buffers 150994944 bytes
Redo Buffers 1191936 bytes
Database mounted.
Database opened.
SQL> select * from v$version where rownum=1;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
Best regards
Maxim
Charles Hooper
> Charles Hooper schrieb:
>
> > On Jul 14, 12:34 pm, l...@tech-trans.com wrote:
> > Once the
> > database is up, execute a command to create a new spfile from the
> > pfile.
>
> (at least on newer oracle versions).
>
> Best regards
>
> Maxim
Maxim and Sybrand, thanks for the additional information.