Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Upgrading to Oracle 9.2.0.4 - Any pitfalls?

Re: Upgrading to Oracle 9.2.0.4 - Any pitfalls?

From: zhu chao <chao_ping_at_vip.163.com>
Date: Sun, 21 Dec 2003 22:49:27 -0800
Message-ID: <F001.005DA975.20031221224927@fatcity.com>


At lease 9.2.0.5 will be released by oracle. I have seen some note talking about 9.2.0.5 patchset.

>
> 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 <ORACLE-L_at_fatcity.com>
> <richard.jones.1@ cc:
> aramco.com> Subject: Upgrading to Oracle 9.2.0.4 - Any pitfalls?
> Sent by:
> ml-errors_at_fatcity
> .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: Brian_P_MacLean_at_eFunds.Com
>
> 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: zhu chao
  INET: chao_ping_at_vip.163.com

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).
Received on Mon Dec 22 2003 - 00:49:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US