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
