ORA-01033: ORACLE 正在初始化或关闭
命令行内进行操作：
C:\Users\EDY>sqlplus system/sys as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on 星期五 4月 22 09:30:58 2022
Copyright (c) 1982, 2016, Oracle. All rights reserved.
连接到:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> startup mount
ORA-01081: 无法启动已在运行的 ORACLE - 请先将其关闭
SQL> shutdown immediate
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup mount
ORACLE 例程已经启动。
Total System Global Area 5133828096 bytes
Fixed Size 8929544 bytes
Variable Size 1207963384 bytes
Database Buffers 3909091328 bytes
Redo Buffers 7843840 bytes
数据库装载完毕。
SQL> alter database open;
数据库已更改。ORA-01219: 数据库或可插入数据库未打开: 仅允许在固定表或视图中查询
C:\Users\EDY>sqlplus system/sys as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on 星期五 4月 22 09:35:27 2022
Copyright (c) 1982, 2016, Oracle. All rights reserved.
连接到:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
SQL> alter database open;
alter database open
*
第 1 行出现错误:
ORA-01531: 实例已打开数据库
SQL> select con_id,dbid,NAME,OPEN_MODE from v$pdbs;
CON_ID DBID
---------- ----------
NAME
--------------------------------------------------------------------------------
OPEN_MODE
----------
2 238991313
PDB$SEED
READ ONLY
3 3248774260
ORCLPDB
MOUNTED
CON_ID DBID
---------- ----------
NAME
--------------------------------------------------------------------------------
OPEN_MODE
----------
SQL> alter pluggable database itest5 open;
插接式数据库已变更。
SQL> alter session set container=itest5;
会话已更改。