| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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-----
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 <DWILLIAMS_at_LIFETOUCH.COM>:Received on Fri Dec 20 2002 - 12:55:30 CST
> 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.
> dwilliams_at_lifetouch.com
>
>
> -----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: ltiu_at_alumni.sfu.ca
>
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.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).
>
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: ltiu_at_alumni.sfu.ca 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: Lisa.Koivu_at_efairfield.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).
 |
 |