Tag Archives: ORA-01033ORACLE initialization or shutdown in …

ORA-01033:ORACLE initialization or shutdown in …

JavaScript implementation: how to write beautiful conditional expression>>>

Oracle-01033: Oracle initialization or shutdown in progress solution

Today, Oracle encountered this problem, ora-01033: Oracle initialization or shutdown in progress, which was finally solved through analysis and research. My library is Oracle 11g

1、 First of all: the cause of the problem, this error is because I deleted a file under Oracle/oradata/oradb by mistake
2. Phenomenon: SQL * Plus is unable to connect, and the following error is displayed: ora-01033: Oracle initialization or shutdown in progress, which is the same error in enterprise manager console

3、 Analysis: it should be that after Oracle is started, the user logs in to load the original configuration information of the scheme. During the loading process, the original file is not found in the specified location, so an error is reported log in as a DBA user, and the specific command is
C: \ \ users \ \ administrator > Sqlplus/as SYSDBA// enter database as super administrator

SQL> Shutdown normal
prompt: database has been closed
database has been unloaded
Oracle routine has been closed

sql > Startup mount
prompt: Oracle routine has been started
total system global area 118255568 bytes
fixed size 282576 bytes
variable size 82886080 bytes
database buffers 33554432 bytes
redo buffers 532480 bytes
the database is loaded

sql > alter database open;<
prompt:
error in line 1:
ora-01157: unable to identify/lock data file 19 – please refer to dbwr tracking file
ora-01110: data file 19 ” “C:: (Oracle/oradata/oradb/fygl. Ora ”
the part of this prompt file is a little different according to different situations of each person

continue to input
sql > alter database datafile 19 offline drop;
prompt: the database has changed

in the last two steps of recycling, if the data file 19 cannot be identified/locked, the number of alter database datafile files will be offline dropped until the alter database is open; After that, the error will not be prompted again, and “database changed” will appear
and then enter
sql > Shutdown normal
prompt: database has been closed
database has been unloaded
Oracle routine has been closed

sql > Startup
prompt: Oracle routine has been started
total system global area 118255568 bytes
fixed size 282576 bytes
variable size 82886080 bytes
database buffers 33554432 bytes
redo buffers 532480 bytes
after the database is loaded
it can be solved
just restart the service

SQL> Shutdown normal
prompt: the database has been closed
the database has been unloaded
the Oracle routine has been closed