Re: Upgrading to Oracle 9.2.0.4 - Any pitfalls?
What's the bug relating to 1,000s of Partitions, was it the one to with monitoring, or something more interesting ? Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 22, 2003 4:49 AM 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis 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).
Re: Upgrading to Oracle 9.2.0.4 - Any pitfalls?
Title: Upgrading to Oracle 9.2.0.4 - Any pitfalls?
Jones,
ORA-04031 may arrise if
DB_CACHE_ADVICEparameter isON/REDDY , and SHARED POOL is unable to
allocate the memory required for the advisory. This may be resoleved by
increasing SHARED_POOL_SIZE or putting the DB_CACHE_ADVICE=OFF.
regards
navneet
- Original Message -
From:
Jones, Richard O.
To: Multiple recipients of list ORACLE-L
Sent: Monday, December 22, 2003 9:59
AM
Subject: Upgrading to Oracle 9.2.0.4 -
Any pitfalls?
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
RE: [***SPAM***] - Re: Upgrading to Oracle 9.2.0.4 - Any pitfalls? - Found word(s) to be removed remove list error e-mail in the Text body.
Last month Oracle Support said there would be a 92045 in Janauary 2004 . -Original Message- zhu chao Sent: Sunday, December 21, 2003 11:49 PM To: Multiple recipients of list ORACLE-L - Found word(s) to be removed remove list error e-mail in the Text body. At lease 9.2.0.5 will be released by oracle. I have seen some note talking about 9.2.0.5 patchset. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 22, 2003 12:49 PM 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
Re: Upgrading to Oracle 9.2.0.4 - Any pitfalls? - Found word(s) to be
Thanks for the feedback from everyone. I'll probably upgrade to 9.2.0.4 unless there is a pressing reason to upgrade to 9.2.0.4.5 and when it becomes available. Apparently bug no 2921201 is showing as fixed in 9.2.0.5 in Metalink but Oracle support gave me a date of March at the earliest for its release. Richard Jones -Original Message- Tony Johnson Sent: Monday, December 22, 2003 7:29 PM To: Multiple recipients of list ORACLE-L pitfalls? - Found word(s) to be removed remove list error e-mail in the Text body. Last month Oracle Support said there would be a 92045 in Janauary 2004 . -Original Message- zhu chao Sent: Sunday, December 21, 2003 11:49 PM To: Multiple recipients of list ORACLE-L - Found word(s) to be removed remove list error e-mail in the Text body. At lease 9.2.0.5 will be released by oracle. I have seen some note talking about 9.2.0.5 patchset. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 22, 2003 12:49 PM 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: zhu chao 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tony Johnson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web
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 [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).
Re: Upgrading to Oracle 9.2.0.4 - Any pitfalls?
At lease 9.2.0.5 will be released by oracle. I have seen some note talking about 9.2.0.5 patchset. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 22, 2003 12:49 PM 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: zhu chao INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San
