Today's study of Oracle encountered this problem ora-01033:oracle initialization or shutdown in progress, after the analysis of the study finally solved, write down a memorial. My library is Oracle 9i, specifically 90.
First of all: the cause of the problem, this error occurs because I oracle\oradata\oradb a file under the wrong deletion after the appearance.
Second, the phenomenon: Sql*plus can not connect, the following error is displayed: Ora-01033:oracle initialization or shutdown in progress, Enterprise Manager console is the same error.
Third, analysis: it should be Oracle after startup, the user is logged in to the original configuration information loaded into the scenario, the loading process encountered the original file specified location is not found, so the error is reported.
Iv. Process of Settlement:
1, I in the solution because anxious use, then uses the Database Configuration Assistant tool to recreate a new library, temporarily solves the urgent problem, simultaneously also to the late solves the ora-01033 problem to bury the hidden danger.
2, in 9i is no SVRMGRL command, to use Sqlplus.
3, first run cmd under Windows, enter the DOS environment.
4. Log in as DBA user, the specific command is
Sqlplus/nolog
Sql>connect Sys/change_on_install as Sysdba
Tip: Successfully
Sql>shutdown Normal
Tip: The database is closed
Database has been uninstalled
ORACLE routines are closed
Sql>startup Mount
Tip: Oracle routines are started
Total System Global area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 82886080 bytes
Database buffers 33554432 bytes
Redo buffers 532480 bytes
Database loading complete
Sql>alter database open;
Tips:
An error occurred on line 1th:
ORA-01157: Unable to identify/lock data file 19-see DBWR trace file
ORA-01110: Data file: "' C:\oracle\oradata\oradb\FYGL. ORA '
This hint file section is somewhat different depending on the circumstances of each person.
Continue Typing
Sql>alter database datafile offline drop;
Tip: The database has changed.
The loop uses the last two steps until the ALTER database open; no longer prompts for an error, and a "db changed" appears.
And then you can enter it.
Sql>shutdown Normal
Tip: The database is closed
Database has been uninstalled
ORACLE routines are closed
Sql>startup
Tip: Oracle routines are started
Total System Global area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 82886080 bytes
Database buffers 33554432 bytes
Redo buffers 532480 bytes
Database loading complete
It can be solved.
5, finally say, the first mention of the hidden trouble, because the creation of a new library, Oracle_sid also has changed, in the user login when there will be a ORA-12560 error, to solve this problem is the system registry hkey_local_machine\software\ ORACLE\HOME0 \oracle_sid
The key value is changed to the previous SID, the user can also be able to log on the normal
Ora-01033:oracle initialization or shutdown in progress workaround