Re: corrupted database
John. Our current problem has been narrowed down to two possabile troubles. 1 is the PERC controller card. The sysadmin missed the message that the battery needed to be reconditioned a week or so ago. They reconditioned the battery and the errror messages stopped and the connect time improved some what to about 10 - 15 seconds. The other possability is that our connections have been increasing lately and there is a memory problem that only show up when there is larger than normal connections. will keep you posted. Ron [EMAIL PROTECTED] 12/20/02 03:44PM If you ever find out the problem please post your findings - I'm going thru a similar issue (9.2.0.2) [EMAIL PROTECTED] 12/20/02 01:50PM Lindon, We have had a controller card go intermittently hay-wire and corrupted the database. It even caused corruption to read-only tablespaces. It is quite possible to corrupt Oracle read-only files with an os or hardware problem. A good backup procedure was the saving grace for that one. Currently I am attempting to diagnose slowdowns in logging into the database. Normal connect time is 3 seconds. During slow downs connect 60 seconds. All indication so far point to memory problems or controller problems. Difficult to trouble shoot without tools built for the os. (Novell). It takes a lot of paging through the os displays before and after the trouble occurs. A reboot of the system clears the trouble for a week or so. Ron [EMAIL PROTECTED] 12/20/02 01:55PM Yes. Twice. First time - bad controller. It wrote CRAP in random spots throughout the database. We had to recover after the hardware was replaced. Second time - no idea. Oracle Support said they'd need mounds of info from the o/s and even then they may not be able to explain it. Since I didn't have the time to gather all the necessary info we let it go. What a lovely thought for a Friday afternoon. At least my databases aren't corrupted. Lisa Koivu Oracle Datababy Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- Sent: Friday, December 20, 2002 1:35 PM To: Multiple recipients of list ORACLE-L connecti The reason I ask is because people around me always blame Oracle when things stop working. Anyways, the problem was traced to a corrupted Oracle database (as to whether the tables or the data file got corrupted. how and why - a $$$ consultant is trying to find out). How could an Oracle database get corruppted in the first place? Anyone here with an experience of their Oracle database getting corrupted and what caused it and what was done to fix it? -- Lyndon Tiu Quoting DENNIS WILLIAMS [EMAIL PROTECTED]: Lyndon I would look at the wait statistics to see what is happening inside Oracle. I would also look at the O.S. performance statistics to see what is happening underneath Oracle. Don't make any rash assumptions. Also, are any error messages or trace files generated? For me the funny story was a misunderstanding of the Unix nice value for an unfamiliar platform. Long story short, we wound up with batch running at a higher priority than interactive users. New users were shut out. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 20, 2002 9:45 AM To: Multiple recipients of list ORACLE-L connections Hello, Just in time for the Holidays. Oracle stops accepting connections. I am wondering if people here can give me their horror stories when Oracle stops accepting new connections or stops accepting connections altogether? Scalability problems when you've got around 5,000 concurrent connections? MTS/Shared server configurations enabled or disabled? It could be an Oracle problem or the application that's trying to connect's fault. Any tips and insights into what caused your horror story and how it was fixed. Thanks. Have a Happy Holidays everybody. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
corrupted database
Title: corrupted database Yes. Twice. First time - bad controller. It wrote CRAP in random spots throughout the database. We had to recover after the hardware was replaced. Second time - no idea. Oracle Support said they'd need mounds of info from the o/s and even then they may not be able to explain it. Since I didn't have the time to gather all the necessary info we let it go. What a lovely thought for a Friday afternoon. At least my databases aren't corrupted. Lisa Koivu Oracle Datababy Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Lyndon Tiu [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 1:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle connection/listener/dispatcher stops allowing connecti The reason I ask is because people around me always blame Oracle when things stop working. Anyways, the problem was traced to a corrupted Oracle database (as to whether the tables or the data file got corrupted. how and why - a $$$ consultant is trying to find out). How could an Oracle database get corruppted in the first place? Anyone here with an experience of their Oracle database getting corrupted and what caused it and what was done to fix it? -- Lyndon Tiu Quoting DENNIS WILLIAMS [EMAIL PROTECTED]: Lyndon I would look at the wait statistics to see what is happening inside Oracle. I would also look at the O.S. performance statistics to see what is happening underneath Oracle. Don't make any rash assumptions. Also, are any error messages or trace files generated? For me the funny story was a misunderstanding of the Unix nice value for an unfamiliar platform. Long story short, we wound up with batch running at a higher priority than interactive users. New users were shut out. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 20, 2002 9:45 AM To: Multiple recipients of list ORACLE-L connections Hello, Just in time for the Holidays. Oracle stops accepting connections. I am wondering if people here can give me their horror stories when Oracle stops accepting new connections or stops accepting connections altogether? Scalability problems when you've got around 5,000 concurrent connections? MTS/Shared server configurations enabled or disabled? It could be an Oracle problem or the application that's trying to connect's fault. Any tips and insights into what caused your horror story and how it was fixed. Thanks. Have a Happy Holidays everybody. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu 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: DENNIS WILLIAMS 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: Lyndon Tiu 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: corrupted database
Lindon, We have had a controller card go intermittently hay-wire and corrupted the database. It even caused corruption to read-only tablespaces. It is quite possible to corrupt Oracle read-only files with an os or hardware problem. A good backup procedure was the saving grace for that one. Currently I am attempting to diagnose slowdowns in logging into the database. Normal connect time is 3 seconds. During slow downs connect 60 seconds. All indication so far point to memory problems or controller problems. Difficult to trouble shoot without tools built for the os. (Novell). It takes a lot of paging through the os displays before and after the trouble occurs. A reboot of the system clears the trouble for a week or so. Ron [EMAIL PROTECTED] 12/20/02 01:55PM Yes. Twice. First time - bad controller. It wrote CRAP in random spots throughout the database. We had to recover after the hardware was replaced. Second time - no idea. Oracle Support said they'd need mounds of info from the o/s and even then they may not be able to explain it. Since I didn't have the time to gather all the necessary info we let it go. What a lovely thought for a Friday afternoon. At least my databases aren't corrupted. Lisa Koivu Oracle Datababy Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- Sent: Friday, December 20, 2002 1:35 PM To: Multiple recipients of list ORACLE-L connecti The reason I ask is because people around me always blame Oracle when things stop working. Anyways, the problem was traced to a corrupted Oracle database (as to whether the tables or the data file got corrupted. how and why - a $$$ consultant is trying to find out). How could an Oracle database get corruppted in the first place? Anyone here with an experience of their Oracle database getting corrupted and what caused it and what was done to fix it? -- Lyndon Tiu Quoting DENNIS WILLIAMS [EMAIL PROTECTED]: Lyndon I would look at the wait statistics to see what is happening inside Oracle. I would also look at the O.S. performance statistics to see what is happening underneath Oracle. Don't make any rash assumptions. Also, are any error messages or trace files generated? For me the funny story was a misunderstanding of the Unix nice value for an unfamiliar platform. Long story short, we wound up with batch running at a higher priority than interactive users. New users were shut out. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 20, 2002 9:45 AM To: Multiple recipients of list ORACLE-L connections Hello, Just in time for the Holidays. Oracle stops accepting connections. I am wondering if people here can give me their horror stories when Oracle stops accepting new connections or stops accepting connections altogether? Scalability problems when you've got around 5,000 concurrent connections? MTS/Shared server configurations enabled or disabled? It could be an Oracle problem or the application that's trying to connect's fault. Any tips and insights into what caused your horror story and how it was fixed. Thanks. Have a Happy Holidays everybody. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu 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: DENNIS WILLIAMS 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: Lyndon Tiu 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
RE: corrupted database
Title: corrupted database We had a situation where the filesystems were cross mounted. You know /ora1234 mapped to the same physical disks on the EMC array as /ora3253 filesystem! Luckily we weren't in production! -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Friday, December 20, 2002 1:55 PMTo: Multiple recipients of list ORACLE-LSubject: corrupted database Yes. Twice. First time - bad controller. It wrote CRAP in random spots throughout the database. We had to recover after the hardware was replaced. Second time - no idea. Oracle Support said they'd need mounds of info from the o/s and even then they may not be able to explain it. Since I didn't have the time to gather all the necessary info we let it go. What a lovely thought for a Friday afternoon. At least my databases aren't corrupted. Lisa Koivu Oracle Datababy Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Lyndon Tiu [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 1:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle connection/listener/dispatcher stops allowing connecti The reason I ask is because people around me always blame Oracle when things stop working. Anyways, the problem was traced to a corrupted Oracle database (as to whether the tables or the data file got corrupted. how and why - a $$$ consultant is trying to find out). How could an Oracle database get corruppted in the first place? Anyone here with an experience of their Oracle database getting corrupted and what caused it and what was done to fix it? -- Lyndon Tiu Quoting DENNIS WILLIAMS [EMAIL PROTECTED]: Lyndon I would look at the wait statistics to see what is happening inside Oracle. I would also look at the O.S. performance statistics to see what is happening underneath Oracle. Don't make any rash assumptions. Also, are any error messages or trace files generated? For me the funny story was a misunderstanding of the Unix "nice" value for an unfamiliar platform. Long story short, we wound up with batch running at a higher priority than interactive users. New users were shut out. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 20, 2002 9:45 AM To: Multiple recipients of list ORACLE-L connections Hello, Just in time for the Holidays. Oracle stops accepting connections. I am wondering if people here can give me their horror stories when Oracle stops accepting new connections or stops accepting connections altogether? Scalability problems when you've got around 5,000 concurrent connections? MTS/Shared server configurations enabled or disabled? It could be an Oracle problem or the application that's trying to connect's fault. Any tips and insights into what caused your horror story and how it was fixed. Thanks. Have a Happy Holidays everybody. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu 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: DENNIS WILLIAMS 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: Lyndon Tiu 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 EXAC
Re: corrupted database
If you ever findout the problemplease post your findings - I'm going thru a similar issue (9.2.0.2) [EMAIL PROTECTED] 12/20/02 01:50PM Lindon,We have had a controller card go intermittently hay-wire and corruptedthe database. It even caused corruption to read-only tablespaces. It isquite possible to corrupt Oracle read-only files with an os or hardwareproblem. A good backup procedure was the saving grace for that one. Currently I am attempting to diagnose slowdowns in logging into thedatabase. Normal connect time is 3 seconds. During slow downs connect 60 seconds. All indication so far point to memory problems orcontroller problems. Difficult to trouble shoot without tools built forthe os. (Novell). It takes a lot of paging through the os displaysbefore and after the trouble occurs. A reboot of the system clears thetrouble for a week or so.Ron [EMAIL PROTECTED] 12/20/02 01:55PM Yes. Twice. First time - bad controller. It wrote CRAP in random spots throughoutthedatabase. We had to recover after the hardware was replaced. Second time - no idea. Oracle Support said they'd need mounds of infofromthe o/s and even then they may not be able to explain it. Since Ididn'thave the time to gather all the necessary info we let it go. What a lovely thought for a Friday afternoon. At least my databasesaren'tcorrupted. Lisa KoivuOracle Datababy AdministratorFairfield Resorts, Inc.5259 Coconut Creek ParkwayFt. Lauderdale, FL, USA 33063-Original Message-Sent: Friday, December 20, 2002 1:35 PMTo: Multiple recipients of list ORACLE-LconnectiThe reason I ask is because people around me always blame Oracle whenthingsstop working.Anyways, the problem was traced to a corrupted Oracle database (as towhetherthe tables or the data file got corrupted. how and why - a $$$consultant istrying to find out).How could an Oracle database get corruppted in the first place? Anyoneherewithan experience of their Oracle database getting corrupted and whatcaused itandwhat was done to fix it?-- Lyndon TiuQuoting DENNIS WILLIAMS [EMAIL PROTECTED]: Lyndon I would look at the wait statistics to see what is happeninginside Oracle. I would also look at the O.S. performance statistics to seewhatis happening underneath Oracle. Don't make any rash assumptions. Also,areany error messages or trace files generated? For me the funny story was a misunderstanding of the Unix "nice"value for an unfamiliar platform. Long story short, we wound up with batch running at a higher priority than interactive users. New users were shutout. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED]-Original Message- Sent: Friday, December 20, 2002 9:45 AM To: Multiple recipients of list ORACLE-L connections Hello, Just in time for the Holidays. Oracle stops accepting connections. I am wondering if people here can give me their horror stories whenOracle stops accepting new connections or stops accepting connections altogether? Scalability problems when you've got around 5,000 concurrent connections?MTS/Shared server configurations enabled or disabled? It could be an Oracle problem or the application that's trying toconnect's fault. Any tips and insights into what caused your horror story and how itwas fixed. Thanks. Have a Happy Holidays everybody. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hostingservices- 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hostingservices- 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: Lyndon Tiu 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
Re: corrupted database
My main production DB in the past would get EXCURCIATINGLY slow during normal business hours. It would slow down so much that the customer service folks would revert to hand writing orders on paper. We could never identify any pattern or any culprit until I got the book Oracle Performance Tuning 101 (ISBN 0-07-213145-4) got to attend a seminar presented by a couple of the authors. Based upon this new found knowledge understanding of Wait States I was able to write a PL/SQL package which monitored the Wait States sent me email when specific thresholds were exceeded. The code allowed me to identify the culprits with 100% accuracy. One fix was simply procedural. The other two problems involved POORLY written PL/SQL; which just so happened would get invoked only about once a month; but would wreak havoc with other sessions within this DB. The code is available upon a direct request to me (and NOT back to this list). It is fairly well self-contained, but will require some customization to work for you. John Shaw John.Shaw@correctioTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] nscorp.com cc: Sent by:Subject: Re: corrupted database [EMAIL PROTECTED] 12/20/2002 12:44 PM Please respond to ORACLE-L If you ever find out the problem please post your findings - I'm going thru a similar issue (9.2.0.2) [EMAIL PROTECTED] 12/20/02 01:50PM Lindon, We have had a controller card go intermittently hay-wire and corrupted the database. It even caused corruption to read-only tablespaces. It is quite possible to corrupt Oracle read-only files with an os or hardware problem. A good backup procedure was the saving grace for that one. Currently I am attempting to diagnose slowdowns in logging into the database. Normal connect time is 3 seconds. During slow downs connect 60 seconds. All indication so far point to memory problems or controller problems. Difficult to trouble shoot without tools built for the os. (Novell). It takes a lot of paging through the os displays before and after the trouble occurs. A reboot of the system clears the trouble for a week or so. Ron [EMAIL PROTECTED] 12/20/02 01:55PM Yes. Twice. First time - bad controller. It wrote CRAP in random spots throughout the database. We had to recover after the hardware was replaced. Second time - no idea. Oracle Support said they'd need mounds of info from the o/s and even then they may not be able to explain it. Since I didn't have the time to gather all the necessary info we let it go. What a lovely thought for a Friday afternoon. At least my databases aren't corrupted. Lisa Koivu Oracle Datababy Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- Sent: Friday, December 20, 2002 1:35 PM To: Multiple recipients of list ORACLE-L connecti The reason I ask is because people around me always blame Oracle when things stop working. Anyways, the problem was traced to a corrupted Oracle database (as to whether the tables or the data file got corrupted. how and why - a $$$ consultant is trying to find out). How could an Oracle database get corruppted in the first place? Anyone here with an experience of their Oracle database getting corrupted and what caused it and what was done to fix it? -- Lyndon Tiu Quoting DENNIS WILLIAMS [EMAIL PROTECTED]: Lyndon I would look at the wait statistics to see what is happening inside Oracle. I would also look at the O.S
