Home » Infrastructure » Unix » ORA-01157: cannot identify/lock data file 12 - see DBWR trace file (Oracle Version: SQL*Plus: Release 9.2.0.7.0 - Production)
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file [message #356670] Fri, 31 October 2008 16:45 Go to next message
tazz
Messages: 1
Registered: October 2008
Location: India
Junior Member

Hi,

I am using Oracle 9i, and I needed to try out the expansion of some existing database. To achieve this I would have to shutdown the database, then move the existing *.dbf files from the disk (/disk1, /disk2, /disk3, etc), to a new location. next I do a startup and then run the expansion scripts.

The steps I followed are;

sqlplus "$USER as sysdba"

SQL> shutdown;

SQL> exit;

bash$- move_script.sh

sqlplus "$USER as sysdba"
SQL> startup;

ORACLE instance started.

Total System Global Area 4.5436E+10 bytes
Fixed Size 795624 bytes
Variable Size 1023410176 bytes
Database Buffers 4.4359E+10 bytes
Redo Buffers 52715520 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: '/disk2/oradata/CDR02.dbf'

SQL>

Now if I even try to go to sql, I get the following;

ORA-01033: ORACLE initialization or shutdown in progress

Now I am really stuck and I need to get this over with to proceed.

I have already tried shutting down and re-starting the database again, but to no effect.

Can anyone help me out?

Regards

Tazz
Re: ORA-01157: cannot identify/lock data file 12 - see DBWR trace file [message #356673 is a reply to message #356670] Fri, 31 October 2008 17:20 Go to previous message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: '/disk2/oradata/CDR02.dbf'


You stuck already?

Have you at least read the error message, and then looked at the DBWR trace file as it is suggested there, and checked if /disk2/oradata/CDR02.dbf is still there?

Also, talk to the person who wrote move_script.sh.
Previous Topic: shell scripts to read data from a text file and to load it into a table
Next Topic: Connected to an idle instance
Goto Forum:
  


Current Time: Thu Mar 28 03:34:46 CDT 2024