ORA-01033: ORACLE initialization or shutdown in progress Cloud Control 13c start AdminServer Could Not Be Started 

Hi,

You can get ” ORA-01033: ORACLE initialization or shutdown in progress ” error when you start Cloud Control 12c with emctl start oms command.

When you start Cloud Control 13c OMS ( Oracle Management Server ), you can get following error.

[oracle@CloudControl13c bin]$ ./emctl start oms
Oracle Enterprise Manager Cloud Control 13c Release 2 
Copyright (c) 1996, 2016 Oracle Corporation. All rights reserved.
Starting Oracle Management Server...

Oracle Management Server Successfully Started 
AdminServer Could Not Be Started 
Oracle Management Server is Up

/u01/app/oracle/gc_inst/user_projects/domains/GCDomain/servers/EMGC_ADMINSERVER/logs/EMGC_ADMINSERVER.out

When i look at the below EMGC_ADMINSERVER.out log, I have seen ” ORA-01033: ORACLE initialization or shutdown in progress ” error.

Database is already open, log says Oracle initialization or shutdown in progress. This error is caused because of Container and Pluggable database.

I have checked database container database ( CLOUDDB ) and Pluggable database ( PDBCLOUD ), they are open or not.

[oracle@CloudControl13c ~]$ sqlplus / as sysdba@CLOUDDB

SQL*Plus: Release 12.1.0.2.0 Production on Thu Mar 21 10:07:08 2019

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> show parameter name

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cell_offloadgroup_name string
db_file_name_convert string
db_name string CLOUDDB
db_unique_name string CLOUDDB
global_names boolean FALSE
instance_name string CLOUDDB
lock_name_space string
log_file_name_convert string
pdb_file_name_convert string
processor_group_name string
service_names string CLOUDDB
SQL> 
SQL> 
SQL> SHOW CON_NAME

CON_NAME
------------------------------
CDB$ROOT
SQL> 
SQL> 
SQL> SELECT name, pdb FROM v$services ORDER BY name; 2

NAME
----------------------------------------------------------------
PDB
------------------------------
CLOUDDB
CDB$ROOT

CLOUDDBXDB
CDB$ROOT

SYS$BACKGROUND
CDB$ROOT


NAME
----------------------------------------------------------------
PDB
------------------------------
SYS$USERS
CDB$ROOT

PDBCLOUD
PDBCLOUD

PDBCLOUD pluggable database is not open so i have open it.

SQL> ALTER PLUGGABLE DATABASE PDBCLOUD open read write;

Pluggable database altered.

SQL>

After pluggable database is opened, Enterprise manager Cloud control 13c is started like following.

[oracle@CloudControl13c bin]$ 
[oracle@CloudControl13c bin]$ ./emctl start oms
Oracle Enterprise Manager Cloud Control 13c Release 2 
Copyright (c) 1996, 2016 Oracle Corporation. All rights reserved.
Starting Oracle Management Server...
WebTier Successfully Started
Oracle Management Server Successfully Started
Oracle Management Server is Up
JVMD Engine is Up
Starting BI Publisher Server ...
BI Publisher Server Successfully Started
BI Publisher Server is Up

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/