RE: ora 1115 error

From: <DGoodson_at_SolanoCounty.com>
Date: Mon, 16 Aug 2004 12:13:40 -0700
Message-ID: <1F6322C3C71883408E4495E822F3AB1607EEB395@excff04.solano.sol>

Looks like the drive crashed. Did not think about the obvious.

Thanks again,
Doris

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of DENNIS WILLIAMS Sent: Monday, August 16, 2004 11:56 AM
To: 'oracle-l_at_freelists.org'
Subject: RE: ora 1115 error

Doris

You might make a quick check of your disk drives, make sure one hasn't been removed or is otherwise unavailable.

Dennis Williams
DBA
Lifetouch, Inc.

"We all want progress, but if you're on the wrong road, progress means doing an about-turn and walking back to the right road; in that case, the man who turns back soonest is the most progressive."
-- C.S. Lewis

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of DGoodson_at_SolanoCounty.com
Sent: Monday, August 16, 2004 1:38 PM
To: oracle-l_at_freelists.org
Subject: ora 1115 error

Hi List,

When I startup database, I am getting the following error:

ORA-01110: data file 4: '/u11/oradata/htmp88/amapp.dbf'
ORA-01115: IO error reading block from file 4 (block # 1)
ORA-27063: skgfospo: number of bytes read/written is incorrect

IBM AIX RISC System/6000 Error: 5: I/O error Additional information: -1
Additional information: 8192

What is the best way to correct this error? The error says that the tablespace is possibly offline, but I cannot open the database to find out.

This is a development database and not in archive mode. Database version 9.2.0.2.0 and operation system AIX 5.1.

Thanks,
Doris

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Mon Aug 16 2004 - 14:14:53 CDT