Thanks for the feedback from everyone. I'll probably upgrade to 9.2.0.4
unless there is a pressing reason to upgrade to 9.2.0.4.5 and when it
becomes available.
Apparently bug no 2921201 is showing as fixed in 9.2.0.5 in Metalink but
Oracle support gave me a date of March at the earliest for its release.
Richard Jones
-----Original Message-----
Tony Johnson
Sent: Monday, December 22, 2003 7:29 PM
To: Multiple recipients of list ORACLE-L
pitfalls? - Found word(s) to be removed remove list error e-mail in the
Text body.
Last month Oracle Support said there would be a 92045 in Janauary 2004
.....
-----Original Message-----
zhu chao
Sent: Sunday, December 21, 2003 11:49 PM
To: Multiple recipients of list ORACLE-L
- Found word(s) to be removed remove list error e-mail in the Text body.
At lease 9.2.0.5 will be released by oracle.
I have seen some note talking about 9.2.0.5 patchset.
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, December 22, 2003 12:49 PM
>
> I have said it on this list before, and I will say it again. With
Oracle,
> quality ends with in 4.
>
> 7.3.4
> 8.1.7.4
> 9.2.0.4
>
> Oracle v9.2.0.4 is fairly stable. I have had to apply only 1, one-off
> patch related to having 1000's of partitions. You may also want to
add the
> following to your init.ora to prevent a few known bug's
>
> serial_reuse = disable
> event = "10235 trace name context forever, level 2"
>
>
>
>
>
> "Jones, Richard
> O." To: Multiple
recipients of list ORACLE-L <[EMAIL PROTECTED]>
> <richard.jones.1@ cc:
> aramco.com> Subject: Upgrading to
Oracle 9.2.0.4 - Any pitfalls?
> Sent by:
> [EMAIL PROTECTED]
> .com
>
>
> 12/21/2003 09:29
> PM
> Please respond to
> ORACLE-L
>
>
>
>
>
>
> Hi,
>
>
> Our main production database was upgraded to Oracle 9.2.0.3 (64 bit)
at the
> end of September 2003. Platform Solaris 64bit 5.8.
>
>
> Since then the database has "hanged" and had to be manually shutdown
by
> killing processes and re-started: -
>
>
> (1) The first one involved the production of numerous:
> ORA-04031: unable to allocate 26168 bytes of shared memory ("shared
> pool","unknown object","sga heap(1,0)","session param values") ,
> errors when users were logging and was linked by Oracle Support with
bug
> number 2921201
>
>
> (2) Secondly, the database raised an ORA-600 to the alert file:
> ORA-00600: internal error code, arguments: [510], [0x380068B30],
[shared
> pool], [], [], [], [], [] ,
> followed by numerous messages:
> PMON failed to acquire latch, see PMON dump ?
>
>
> (3) Thirdly, an:
> ORA-04031: unable to allocate 16384 bytes of shared memory ("shared
> pool","unknown object","sga heap(1,0)","trace buffer")
> was raised apparently caused by an Oracle background processes dieing
> unexpectedly.
>
>
>
>
>
> Should I upgrade to 9.2.0.4? None of the above problems seem to be
fixed in
> 9.2.0.4!!!
>
>
> Our database is a hybrid between OLTP and Decision-Support with a
> relatively light load.
>
>
> Anyone out there with an unstable 9i database (we were more stable
under
> 8.1.7)? Am I alone??
>
>
> Many Thanks
>
>
> Richard Jones, DBA
>
>
>
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: zhu chao
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Tony Johnson
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Richard Oliver Jones
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
