| ORA-01157: cannot identify/lock data file 12 - see DBWR trace file [message #356670] |
Fri, 31 October 2008 16:45  |
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  |
ThomasG
Messages: 3212
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
