Re: Help! Tue SGA_MAX too large! Database cannot start!

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Mon, 14 Jul 2008 21:32:17 +0200
Message-ID: <487BA9C1.4040706@gmail.com>

sybrandb_at_hccnet.nl schrieb:
> On Mon, 14 Jul 2008 20:41:53 +0200, Maxim Demenko <mdemenko_at_gmail.com>
> wrote:
>

>> Charles Hooper schrieb:
>>> On Jul 14, 12:34 pm, l..._at_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 Received on Mon Jul 14 2008 - 14:32:17 CDT