Hi!,

I tuned the SGA_MAX to 3G. Then, the database could not startup!
How can I do now! Help!

Ming

On Jul 14, 11:57 am, l...@tech-trans.com wrote:
> Hi!,
>
> I tuned the SGA_MAX to 3G. Then, the database could not startup!
> How can I do now! Help!
>
> Ming

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

On 7$B7n(B15$BF|(B, $B>e8a(B12$B;~(B07$BJ,(B, bdbafh <bdb...@gmail.com> wrote:
> On Jul 14, 11:57 am, l...@tech-trans.com wrote:
>
> > Hi!,
>
> > I tuned the SGA_MAX to 3G. Then, the database could not startup!
> > How can I do now! Help!
>
> > Ming
>
> 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

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

Comments embedded.

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.mydatabasesupport.com/for...ws-32-bit.html

http://www.brianmadden.com/content/a...t-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

On Jul 14, 12:34 pm, l...@tech-trans.com wrote:
> On 7$B7n(B15$BF|(B, $B>e8a(B12$B;~(B07$BJ,(B, bdbafh <bdb...@gmail.com> wrote:
> > On Jul 14, 11:57 am, l...@tech-trans.com wrote:
>
> > > Hi!,
>
> > > I tuned the SGA_MAX to 3G. Then, the database could not startup!
> > > How can I do now! Help!
>
> > > Ming
>
> > 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
>
> 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

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.

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.

> 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

On Mon, 14 Jul 2008 20:41:53 +0200, Maxim Demenko <mdemenko@gmail.com>
wrote:

>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.
>
>> 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


In 9i, startup nomount is sufficient.

--
Sybrand Bakker
Senior Oracle DBA

sybrandb@hccnet.nl schrieb:
> On Mon, 14 Jul 2008 20:41:53 +0200, Maxim Demenko <mdemenko@gmail.com>
> wrote:
>
>> 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.
>>> 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
>
>
> In 9i, startup nomount is sufficient.
>

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

On Jul 14, 2:41*pm, Maxim Demenko <mdeme...@gmail.com> wrote:
> 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.
>
> Iirc, instance doesn't have to be started for create pfile from spfile
> (at least on newer oracle versions).
>
> Best regards
>
> Maxim

Maxim and Sybrand, thanks for the additional information.

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.