Incorrect solutions for ORA-01122, ORA-01110, ORA-01203, ora-01122ora-01110
Go to PL/SQL Developer to report ora-01033: oracle initializationg or shutdown in progress, the application system cannot connect to the Oracle service.
1. Execute export ORACLE_SID = orcl to ensure that the connection is correct;
2. Run sqlplus "/as sysdba"
SQL> shutdown immediate ORA-01109: the database is not open and has been detached.
The ORACLE routine has been disabled. SQL> startup mount; the ORACLE routine has been started. Total System Global Area 171966464 bytes Fixed Size 787988 bytes Variable Size 145750508 bytes Database Buffers 25165824 bytes Redo Buffers 262144 bytes Database load is complete. SQL> alter database open; alter database open * 1st row error: ORA-01122: database file 11 Verification Failed ORA-01110: Data File 11: */APP \ DATABASE \ STU_DB.DBF 'ORA-01203: Prototype error for this file-create SCN error SQL> alter database open resetlogs; alter database open resetlogs * 1st row error: ORA-01139: RESETLOGS option valid only after Incomplete database recovery> alter database datafile 11 offline drop; // (here "11" is the previous "database file 11") (then use alter database datafile *******/or Acle \ product \ 10.2.0 \ db_1 \ database \ data file name 'offline drop; if drop is omitted, A ora-01145 may occur: offline error is not allowed unless media recovery is enabled .) The database has been changed. SQL> alter database open resetlogs; alter database open resetlogs * row 1st error: ORA-01139: RESETLOGS option valid only after Incomplete database recovery> alter database open; database changed. SQL> shutdown normal; the database has been closed. The database has been detached. The ORACLE routine has been disabled.
The SQL> startup ORACLE routine has been started. Total System Global Area 171966464 bytes Fixed Size 787988 bytes Variable Size 145750508 bytes Database Buffers 25165824 bytes Redo Buffers 262144 bytes Database load is complete. At this point, the problem is solved.