1. 查看数据库为Mount状态
SYS@LHR11G> select status from v$instance;
STATUS
------------------------
MOUNTED
2. 开启后问题依旧
SYS@LHR11G> alter database open;
Database altered.
SYS@LHR11G> desc dba_talbespaces;
ERROR:
ORA-04043: object dba_talbespaces does not exist
3. 关闭数据库再次开启
SYS@LHR11G> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@LHR11G> startup
ORACLE instance started.
Total System Global Area 1670221824 bytes
Fixed Size 2253824 bytes
Variable Size 1593838592 bytes
Database Buffers 67108864 bytes
Redo Buffers 7020544 bytes
Database mounted.
Database opened.