Re: Error when startup database

From: Howard J. Rogers <howardjr_at_www.com>
Date: Mon, 13 Aug 2001 15:56:32 +1000
Message-ID: <3b776b3b@usenet.per.paradox.net.au>

There seems to be a problem with it not being able to find or access the system data file. Is it still physically in the directory where the error message says it should be? (A quick ls will sort that out).

If it's not, you're in to recovery.

If it is, check that the file permissions are set properly (I tend to chmod 777 just in case, and sort it out more properly if that resolves the issue later on).

If permissions aren't the issue, then it could be file corruption. To check that, you could run dbv against that named datafile, and see what it reports. If it's corruption, then you're in to recovery.

Regards
HJR "JK Yao" <jkyf0131_at_hotmail.com> wrote in message news:93f65984.0108122025.5b14f71b_at_posting.google.com...
> dear all,
>
> When I startup my Oracle8.1.6 database, there are following msg.
> Anyone know how to solve this problems? Please help.
> Thanks in advance,
>
> JK
>
>
> *******************
> ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
> ORA-01110: data file 1: '/data2/P8/system01.dbf'
Received on Mon Aug 13 2001 - 00:56:32 CDT