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