Re: lock_sga parameter on win2k

I did not worked for Amdocs.
I work in Mehish Computer Services since 1983 - Twenty years next August (WOW). Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Monday, April 07, 2003 2:08 PM

> Hello Yechiel
>
> Thanx for testing. Looks like it won't work.
> By the way: if you get 27100 - shared memory realm already exist, you
don't
> have to reboot your computer. Just restart the oracle service (net stop
> OracleServiceBlah, net start OracleServiceBlah).
>
> PS: Did you possibly work for Amdocs (Isreal) before ? Your name sounds
> familiar somehow.
>
> Regards,
> Stefan
>
> 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.
>
>
> -----Ursprüngliche Nachricht-----
> Von: Yechiel Adar [mailto:adar76_at_inter.net.il]
> Gesendet: Montag, 7. April 2003 13:19
> An: Multiple recipients of list ORACLE-L
> Betreff: 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).
>
>
>
> --
> 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).