Microsoft Windows [version 6.1.7601]
Copyright (c) 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, Oracle. All rights reserved.
Connect to:
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;
is connected.
Sql> Show user;
USER is "SYS"
sql> alter user Scott account unlock identified by Tiger;
Alter user Scott account unlock identified by tiger
*
An error occurred on line 1th:
ORA-01109: Database is not open
Sql> Show user;
USER is "SYS"
Sql> Startup
ORA-01081: Unable to start ORACLE that is already running-please 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, Oracle. All rights reserved.
Sql> Startup
Ora-01031:insufficient Privileges
Sql> Show user;
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, Oracle. All rights reserved.
Connect to:
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;
is connected.
Sql> select 4+5 form dual;
Select 4+5 Form Dual
*
An error occurred on line 1th:
ORA-00923: Requested from keyword not found
Sql> select 4+5 from dual;
4+5
----------
9
Sql> select * from tab;
SELECT * FROM tab
*
An error occurred on line 1th:
ORA-01219: Database not open: Only allow queries in fixed tables/views
Sql> Startup Mount
ORA-01081: Unable to start ORACLE that is already running-please close it first
Sql> Shoutdown Immediate
sp2-0734: Unknown command at the beginning of "Shoutdown ..."-ignores the remaining rows.
sql> shutdown immediate;
ORA-01109: Database is not open
The database has been uninstalled.
The ORACLE routine has been closed.
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 is loaded.
sql> ALTER DATABASE open;
ALTER DATABASE Open
*
An error occurred on line 1th:
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 changed.
sql> ALTER DATABASE open;
ALTER DATABASE Open
*
An error occurred on line 1th:
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: Database is not open
The database has been uninstalled.
The ORACLE routine has been closed.
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 is loaded.
sql> ALTER DATABASE open;
ALTER DATABASE Open
*
An error occurred on line 1th:
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 changed.
sql> shutdown immediate;
ORA-01109: Database is not open
The database has been uninstalled.
The ORACLE routine has been closed.
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 is loaded.
sql> ALTER DATABASE open;
The database has changed.
Sql> Conn Scott/tiger;
ERROR:
Ora-28002:the password'll expire within 7 days
is connected.
sql> alter user Scott account unlock identified by Tiger;
The user has changed.
Sql> Conn Scott/tiger;
is connected.
Sql> Show user;
USER is "SCOTT"
Sql> select ename from ENP;
Select ename from ENP
*
An error occurred on line 1th:
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>
The Oracle database does not open the workaround
