Oracle ORA-01033 Wrong Solution __oracle

Problem Description: I used the C # program to manipulate the image data-a number of images to synthesize a picture, because the image is large, through the Oracle database to store, but because the program runs for a period of time after the system consumes too much resources, the results of the program in response, I will shut down the program As a result, the Oracle database collapsed.

By connecting to the database through ORACLE Enterprise Manager console, the Ora-01033:oracle initialization or shutdown in progress prompts are ejected.

(1) I found a dependent solution on the Internet, as follows

Client Oracle server enters Pl/sql developer times ora-01033:oracle Initializationg or shutdown in progress error prompts the application system cannot connect to Oracle services. Solve the problem by remote guidance. The process is as follows:

1, enter CMD, execute set ORACLE_SID=FBMS, make sure to connect to the correct SID;
2, run Sqlplus "/as sysdba"
Sql>shutdown Immediate Stop Service
Sql>startup Start Service, observe if there is no data file loading error at startup, and remember the error data file marking
Sql>shutdown Immediate Stop service again
Sql>startup Mount
sql> Recover datafile 2 Recovery error data file
Sql>shutdown Immediate Stop service again
Sql>startup start service, this time normal.
3, enter Pl/sql developer check, no further prompts error.

The results of the operation are as follows:

C:/Documents and settings/Jiangyi >set oracle_sid=supermapdb

C:/Documents and settings/Jiangyi >sqlplus "/as sysdba"

Sql*plus:release 10.2.0.1.0-production on Sunday September 26 20:06:13 2010

Copyright (c) 1982, +, Oracle. All rights reserved.

Connect to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production
With the partitioning, OLAP and Data Mining options

sql> shutdown Immediate
ORA-01109: Database not open

The database has been unloaded.
The ORACLE routine has been closed.
Sql> Startup
The ORACLE routine has started.

Total System Global area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 230689668 bytes
Database buffers 373293056 bytes
Redo buffers 7135232 bytes
Database loading complete.
ORA-01157: Unable to identify/lock data file 4-see DBWR trace file
ORA-01110: Data file 4:
' e:/database/oracle/product/10.2.0/oradata/supermapdb/. DBF '

sql> shutdown Immediate
ORA-01109: Database not open

The database has been unloaded.
The ORACLE routine has been closed.
Sql> Startup Mount
The ORACLE routine has started.

Total System Global area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 230689668 bytes
Database buffers 373293056 bytes
Redo buffers 7135232 bytes
Database loading complete.
sql> Recover datafile 4
ORA-00283: Recovery session canceled due to error
ORA-01110: Data file 4:
' e:/database/oracle/product/10.2.0/oradata/supermapdb/. DBF '
ORA-01157: Unable to identify/lock data file 4-see DBWR trace file
ORA-01110: Data file 4:
' e:/database/oracle/product/10.2.0/oradata/supermapdb/. DBF '

sql> shutdown Immediate
ORA-01109: Database not open

The database has been unloaded.
The ORACLE routine has been closed.
Sql> Startup
The ORACLE routine has started.

Total System Global area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 230689668 bytes
Database buffers 373293056 bytes
Redo buffers 7135232 bytes
Database loading complete.
ORA-01157: Unable to identify/lock data file 4-see DBWR trace file
ORA-01110: Data file 4:
' e:/database/oracle/product/10.2.0/oradata/supermapdb/. DBF '

Sql>

This shows that there is no way to solve the problem by his method.

As a result, I carefully discovered that the E:/database/oracle/product/10.2.0/oradata/supermapdb folder did not. DBF file. Only supermapdb. DBF file. I think this supermapdb.dbf might be. DBF file so I just changed the supermapdb.dbf file to. dbf. The above method was retried. The results showed ORA-16038, ORA-19809, ORA-00312 errors.

I also follow the following solution,

(2) Solving ORA-16038 ORA-19809 ORA-00312 method

Oracle 10g default archive logs are stored in Flash_recovery_area, and the interval is selected at the default installation 1G size
When the archive log exceeds 1G, there is not enough space to file, and the archive log file is deleted manually, and Oracle cannot recognize the release of the space. Causing the database to fail to start

Solution:
1. Mount Database
Sql> Startup Mount (Note that this will also cause an error, but you can change the system parameters)

2. Change system parameters
Sql> alter system set DB_RECOVERY_FILE_DEST_SIZE=2G Scope=spfile;

{or ALTER SYSTEM SET db_recovery_file_dest_size=4g Scope=both}
The value of the parameter db_recovery_file_dest_size is set based on the disk's remaining space size and actual needs.

3, open the database
Sql> ALTER DATABASE Open

4, delete the failed archive log.
Rman
Rman> Connect Target/
Rman> crosscheck Archivelog All;
rman> Delete expired Archivelog all;
Rman> exit

5. Restart the database

sql> shutdown Immediate
Sql> Startup

My supermapdb database is back up again.

OK, everything's fine. I'm so ashamed, thank you for your support and help.