Upgrading to Oracle 9.2.0.4 - Any pitfalls?

From: Jones, Richard O. <richard.jones.1_at_aramco.com>
Date: Sun, 21 Dec 2003 20:29:26 -0800
Message-ID: <F001.005DA971.20031221202926@fatcity.com>

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: Jones, Richard O.
  INET: richard.jones.1_at_aramco.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 Sun Dec 21 2003 - 22:29:26 CST