Ora-01033:oracle initialization or shutdown in progress solution

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

Two days before doing a test database, because too lazy to guide DMP, so we modelled path formal library created a same Sid library, and then the formal database files are copied, results in after the service is started, ora-01033:oracle initialization or shutdown connection when prompted in progress, thought lost your copy of the file? And then from the new copy, so is the. Because the source data file is to help colleagues copy back, so I can't see whether complete copy. Then only you toss. It pays off to everyone. I was still. Ha-ha~~

Open the sqlplus.

Log in as DBA, the command is
sqlplus /NOLOG
SQL>connect sys/Test as sysdba
Tip: successfully

SQL>shutdown normal
Tip: database closed
Has been uninstalled database
ORACLE routines have been closed

SQL>startup mount
Tip: ORACLE routines have been launched
Total System Global Area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 82886080 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes
Database mounted

SQL>alter database open;
Prompt:
The first line error:
ORA-01157: cannot identify / lock data file 19 - please see the DBWR trace file
The ORA-01110: data file 19: ''''D:\oracle\product\10.2.0\oradata\TEST\BJ.ORA''
This suggests that part of the file according to the different situation of each person is different.

Continue to enter
SQL>alter database datafile 19 offline drop;
Tip: the database has changed.

Recycling of last two steps, until alter database open; when no error, "database has changed".
Then input
SQL>shutdown normal
Tip: database closed
Has been uninstalled database
ORACLE routines have been closed

SQL>startup
Tip: ORACLE routines have been launched
Total System Global Area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 82886080 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes
Database mounted

Thus, to connect again, OK, can be normal use.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download

Posted by Hamiltion at December 12, 2013 - 10:54 AM