Re: lock_sga parameter on win2k

Tested this now with Oracle 9.2.0.3 on win2000 server.

1. The error still exist.
2. If you changed it in the spfile you are in trouble and need to recreate the spfile from the pfile again before you can startup the database again. Alter system set does not work because the instance does not exist so you can not change the spfile.
3. After you get the error you can not restart the database. You get 27100 - shared memory realm already exist. You need to boot the computer.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Monday, April 07, 2003 10:18 AM

> Hi list
>
> I'm trying to pin the sga using the lock_sga=true option. Unfortunately, I
> keep getting the following error on win2k:
>
> ORA-27102: out of memory
> OSD-00025: Message 25 not found; product=RDBMS; facility=SOSD
>
> O/S-Error: (OS 8) F|r diesen Befehl ist nicht gen|gend Speicher verf|gbar.
> => which means: Not enough memory to execute this command successfully.
>
> This happens everytime I try to startup the instance. I'm on Oracle
> 9.2.0.1.0.
> The only interesting thing I found on Metalink is the following:
>
> "The ability to lock the SGA in memory is provided by Oracle on a number
of
> platforms with the LOCK_SGA and LOCK_SGA_AREAS (obsolete in 8.1) init.ora
> parameters, do you have LOCK_SGA set? If so, this is not available on
> Windows and will cause startup to return ORA-27102, this is documented in
> BUG:642267 with Abstract: LOCK_SGA=TRUE RESULTS IN ORA-27102: OUT OF
MEMORY
> that is fixed in Oracle9.2
>
> Although the following article reads as WIN NT it applies to WIN 2000 as
> well:
> 46001.1 Oracle Database and the Windows NT memory architecture, Technical
> Bulletin
> 46053.1 Windows NT Memory Architecture Overview
>
> Thanks!
> Kalpana
> Oracle Technical Support "
>
> Looks like lock_sga doesn't even work on Win2k, but I'm not quite sure
about
> that. Anyway, I shouldn't get an ORA-27102 at all, even with the parameter
> set. Any ideas ? Apply patch set 3 ? I couldn't find any e
>
> Regards
>
> Stefan Jahnke
> Consultant
> BOV Aktiengesellschaft
> Voice: +49 201 - 4513-298
> Fax: +49 201 - 4513-149
> mailto: stefan.jahnke_at_nospam.bov.de
> Please remove nospam to contact me via email.
>
> visit our website: http://www.bov.de
> subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp
>
> Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen!
> Weitere Informationen unter +49 201/45 13-240 oder E-Mail an
> mailto:andrea.palluck_at_bov.de.
>
> Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter
> fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten
> wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die
> rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen
> ausschliessen.
>
> As you are probably aware, e-mails sent via the Internet can easily be
> copied or manipulated by third parties. For this reason we would ask for
> your understanding that, for your own protection and ours, we must decline
> all legal responsibility for the validity of the statements and comments
> given above.
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stefan Jahnke
> INET: Stefan.Jahnke_at_bov.de
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Yechiel Adar
  INET: adar76_at_inter.net.il

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).