Solution for oracle Database not opened, oracle Database

Solution for oracle Database not opened, oracle Database
Microsoft Windows [version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C: \ Users \ Administrator>
C: \ Users \ Administrator> sqlplus/as sysdba;

SQL * Plus: Release 11.2.0.1.0 Production on Wednesday October 29 09:50:55 2014

Copyright (c) 1982,201 0, Oracle. All rights reserved.


Connect:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Producti
With the Partitioning, OLAP, Data Mining and Real Application Testing opti

SQL> show user;
USER is "SYS"
SQL> conn scott/tiger;
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 serial number: 0


Warning: you are no longer connected to ORACLE.
SQL> alter user scott account unlock identified by tiger;
SP2-0640: not connected
SQL> conn/as sysdba;
Connected.
SQL> show user;
USER is "SYS"
SQL> alter user scott account unlock identified by tiger;
Alter user scott account unlock identified by tiger
*
Row 3 has an error:
ORA-01109: the database is not open


SQL> show user;
USER is "SYS"
SQL> startup
ORA-01081: unable to start ORACLE that is already running-Close it first
SQL> exit;
From Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Produ
With the Partitioning, OLAP, Data Mining and Real Application Testing opti

C: \ Users \ Administrator> sqlplus/nolog

SQL * Plus: Release 11.2.0.1.0 Production on Wednesday October 29 09:52:45 2014

Copyright (c) 1982,201 0, Oracle. All rights reserved.

SQL> startup
ORA-01031: insufficient privileges
SQL> show user;
The USER is ""
SQL> exit

C: \ Users \ Administrator> sqlplus/as sysdba;

SQL * Plus: Release 11.2.0.1.0 Production on Wednesday October 29 09:53:34 2014

Copyright (c) 1982,201 0, Oracle. All rights reserved.


Connect:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Producti
With the Partitioning, OLAP, Data Mining and Real Application Testing opti

SQL> show user;
USER is "SYS"
SQL> conn scott/tiger;
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 serial number: 0


Warning: you are no longer connected to ORACLE.
SQL> conn/as sysdba;
Connected.
SQL> select 4 + 5 form dual;
Select 4 + 5 form dual
*
Row 3 has an error:
ORA-00923: the requested FROM keyword not found


SQL> select 4 + 5 from dual;

4 + 5
----------
9

SQL> select * from tab;
Select * from tab
*
Row 3 has an error:
ORA-01219: Database not open: Allow queries only in fixed tables/Views


SQL> startup mount
ORA-01081: unable to start ORACLE that is already running-Close it first
SQL> shoutdown immediate
SP2-0734: Unknown command starting with "shoutdown..."-ignore the remaining lines.
SQL> shutdown immediate;
ORA-01109: the database is not open


The database has been detached.
The ORACLE routine has been disabled.
SQL> startup mount;
The ORACLE routine has been started.

Total System Global Area 1670221824 bytes
Fixed Size 2176328 bytes
Variable Size 1174407864 bytes
Database Buffers 486539264 bytes
Redo Buffers 7098368 bytes
The database has been loaded.
SQL> alter database open;
Alter database open
*
Row 3 has an error:
ORA-01157: unable to identify/lock data file 7-see DBWR trace file
ORA-01110: data file 7: 'e: \ mytbs1.dbf'


SQL> alter database datafile 'e: \ mytbs1.dbf' offline drop
2;

The database has been changed.

SQL> alter database open;
Alter database open
*
Row 3 has an error:
ORA-01157: unable to identify/lock data file 8-see DBWR trace file
ORA-01110: Data File 8: 'f: \ mytbs2.dbf'


SQL> shutdown immediate;
ORA-01109: the database is not open


The database has been detached.
The ORACLE routine has been disabled.
SQL> startup mount;
The ORACLE routine has been started.

Total System Global Area 1670221824 bytes
Fixed Size 2176328 bytes
Variable Size 1174407864 bytes
Database Buffers 486539264 bytes
Redo Buffers 7098368 bytes
The database has been loaded.
SQL> alter database open;
Alter database open
*
Row 3 has an error:
ORA-01157: unable to identify/lock data file 8-see DBWR trace file
ORA-01110: Data File 8: 'f: \ mytbs2.dbf'


SQL> alter database datafile 'f: \ mytbs2.dbf' offline drop
2;

The database has been changed.

SQL> shutdown immediate;
ORA-01109: the database is not open


The database has been detached.
The ORACLE routine has been disabled.
SQL> startup mount;
The ORACLE routine has been started.

Total System Global Area 1670221824 bytes
Fixed Size 2176328 bytes
Variable Size 1174407864 bytes
Database Buffers 486539264 bytes
Redo Buffers 7098368 bytes
The database has been loaded.
SQL> alter database open;

The database has been changed.

SQL> conn scott/tiger;
ERROR:
ORA-28002: the password will expire within 7 days


Connected.
SQL> alter user scott account unlock identified by tiger;

The user has changed.

SQL> conn scott/tiger;
Connected.
SQL> show user;
The USER is SCOTT"
SQL> select ename from enp;
Select ename from enp
*
Row 3 has an error:
ORA-00942: Table or view does not exist


SQL> select ename from emp;

ENAME
----------
SMITH
ALLEN
WARD
JONES
MARTIN
BLAKE
CLARK
KING
TURNER
JAMES
FORD

ENAME
----------
MILLER

12 rows have been selected.

SQL>