记录一次Oracle sysdba 连接不上的问题
2019-02-25 本文已影响0人
只想做个俗人_贪财_好色
$ sqlplus /nolog
SQL> conn /as sysdba
输出:Connected to an idle instance
SQL> startup
输出:
ORA-01012: not logged on Process ID: 0 Session ID: 0 Serial number: 0
SQL> shutdown
输出:
ORA-01089: immediate shutdown or close in progress - no operations are permitted
强制关闭数据库
SQL> shutdown abort;
输出:ORACLE instance shut down.
使用startup force打开数据库
SQL> startup force;
输出:
ORACLE instance started.
Total System Global Area 849530880 bytes
Fixed Size 1339824 bytes
Variable Size 641732176 bytes
Database Buffers 201326592 bytes
Redo Buffers 5132288 bytes
Database mounted.
Database opened.
SQL> conn /as sysdba
输出:Connected. 连接成功
突然感觉没有什么比重启更好使的了 如果有哪就是强制重启