ORACLE 12的ORA-01033问题操作过程

家资是何物,积帙列梁梠。这篇文章主要讲述ORACLE 12的ORA-01033问题操作过程相关的知识,希望能为你提供帮助。

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on 星期五 11月 29 18:23:54 2019

Copyright (c) 1982, 2016, Oracle.All rights reserved.


连接到:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> shutdown abort
ORACLE 例程已经关闭。
SQL> startup mount
ORACLE 例程已经启动。

Total System Global Area 4.0400E+10 bytes
Fixed Size30036832 bytes
Variable Size1.0603E+10 bytes
Database Buffers2.9662E+10 bytes
Redo Buffers104177664 bytes
数据库装载完毕。
SQL> alter database open;

数据库已更改。

SQL> exit
从 Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production 断开
[oracle@localhost ~]$ sqlplus web_user/web_user@21026BDB

SQL*Plus: Release 12.2.0.1.0 Production on 星期五 11月 29 18:25:28 2019

Copyright (c) 1982, 2016, Oracle.All rights reserved.

ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
进程 ID: 0
会话 ID: 0 序列号: 0


请输入用户名:^[[A
输入口令:
[oracle@localhost ~]$ oerr ora 01033
01033, 00000, "ORACLE initialization or shutdown in progress"
// *Cause: An attempt was made to log on while Oracle is being started up
//or shutdown.
// *Action: Wait a few minutes. Then retry the operation.

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on 星期五 11月 29 18:28:44 2019

Copyright (c) 1982, 2016, Oracle.All rights reserved.


连接到:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> show pdbs;

CON_ID CON_NAMEOPEN MODERESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEEDREAD ONLYNO
3 GODDBMOUNTED
SQL> alter pluggable database GODDB open;

插接式数据库已变更。

SQL> show pdbs;

CON_ID CON_NAMEOPEN MODERESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEEDREAD ONLYNO
3 GODDBREAD WRITE NO
SQL>

操作之后验证:
[oracle@localhost ~]$ sqlplus web_user/web_user@21026BDB

SQL*Plus: Release 12.2.0.1.0 Production on 星期五 11月 29 18:52:29 2019

Copyright (c) 1982, 2016, Oracle.All rights reserved.

上次成功登录时间: 星期五 11月 29 2019 18:40:57 +08:00

连接到:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL>

 
【ORACLE 12的ORA-01033问题操作过程】


    推荐阅读