From: Gene Sais (Gsais@CO.PALM-BEACH.FL.US)
Date: Tue Sep 10 2002 - 15:24:54 EDT
more info:
banp sp2f1n03:/oracle3/home/local/cfg>oerr ora 1157
01157, 00000, "cannot identify/lock data file %s - see DBWR trace file"
// *Cause: The background process was either unable to find one of the data
// files or failed to lock it because the file was already in use.
// The database will prohibit access to this file but other files will
// be unaffected. However the first instance to open the database will
// need to access all online data files. Accompanying error from the
// operating system describes why the file could not be identified.
// *Action: Have operating system make file available to database. Then either
// open the database or do ALTER SYSTEM CHECK DATAFILES.
banp sp2f1n03:/oracle3/home/local/cfg>
also, search metalink.oracle.com.
hth,
gene
>>> Dave.Miller@BHS.ORG 09/10/02 03:06PM >>>
check the ownership and permissions of /home/oracle and make sure the user
you started oracle as the appropiate access to it.
-----Original Message-----
From: justin.bleistein@SUNGARD.COM [mailto:justin.bleistein@SUNGARD.COM]
Sent: Tuesday, September 10, 2002 12:35 PM
To: aix-l@Princeton.EDU
Subject: oracle db
Ok Oracle Buffs,
I'm just learning oracle db and I have the oracle code which comes
with AIX4.3 installed on my h80. I get the following error when trying to
create the following tablespace:
SQL> create tablespace payroll datafile '/home/oracle/testdatafile' size
3M;
create tablespace payroll datafile '/home/oracle/testdatafile' size 3M
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: '/home/oracle/testdatafile'
Does anyone know how to correct this? It would be appreciated thanks!.
--Justin Richard Bleistein
Sungard
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:12 EDT