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
>
---------------------------------------------------------------------
>
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).
--
Please see the official ORACLE-L
FAQ: http://www.orafaq.net
--
Author:
Ron Rogers
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).
- corrupted database Koivu, Lisa
- Re: corrupted database Ron Rogers
- RE: corrupted database Toepke, Kevin M
- Re: corrupted database John Shaw
- Re: corrupted database Charlie_Mengler
- Re: corrupted database Ron Rogers