Facing problem: ORA-011033: ORACLE initialization or
shutdown in progress
SQL> connect sys/manager as sysdba
Connected.
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145750508 bytes
Database Buffers 25165824 bytes
Redo Buffers 262144 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: 'C:\ORADATA\PRODUCT_DAT1.DBF'
shutdown immediate; -- if you have trouble with that, run shutdown abort;
startup mount;
alter database datafile 6 offline;
alter database open;
Further if u get this problem:
While making a datafile offline, got below error.
SQL> ALTER database datafile ‘/export/home/oracle/user02.dbf’ offline;
ALTER database datafile ‘/export/home/oracle/user02.dbf’ offline
*
ERROR at line 1:
ORA-01145: offline immediate disallowed unless media recovery enabled
SQL> connect sys/manager as sysdba
Connected.
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145750508 bytes
Database Buffers 25165824 bytes
Redo Buffers 262144 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: 'C:\ORADATA\PRODUCT_DAT1.DBF'
Solution 1:
shutdown immediate; -- if you have trouble with that, run shutdown abort;
startup mount;
alter database datafile 6 offline;
alter database open;
Further if u get this problem:
While making a datafile offline, got below error.
SQL> ALTER database datafile ‘/export/home/oracle/user02.dbf’ offline;
ALTER database datafile ‘/export/home/oracle/user02.dbf’ offline
*
ERROR at line 1:
ORA-01145: offline immediate disallowed unless media recovery enabled
Solution 2:
To make a datafile offline, archive mode need to be enabled.
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /oracle/app/oracle/product/12.1.0.2/dbhome_1/dbs/arch
Oldest online log sequence 84
Current log sequence 85
Below are steps for enabling archive mode:
shutdown immediate;
startup mount
alter database archivelog;
alter database open;
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/app/oracle/product/12.1.0.2/dbhome_1/dbs/arch
Oldest online log sequence 84
Next log sequence to archive 85
Current log sequence 85
SQL>
Now try to make the datafile offline.
SQL> ALTER database datafile '/export/home/oracle/user02.dbf' offline;
Database altered.
ip addr shows you basic information about your network interfaces
The Public FTP directory containing the installation files for Fedora 21
After pressing F8, you’ll see this menu with only one option
The PXE Boot menu, please note that mine will look different as I have changed some of the values
Welcome to Fedora-Server 21!





