Re: Upgrading to Oracle 9.2.0.4 - Any pitfalls?

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).