Oracle 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

 

Mehmet Salih Deveci

I am Founder of IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience. I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource. I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks. I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients. If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com. -                                                                                                                                                                                                                                                 - Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

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

  • May 12, 2019 at 7:08 am
    Permalink

    Hey There. I found your blog using msn. This is a really well written article. I’ll be sure to bookmark it and return to read more of your useful info. Thanks for the post. I’ll definitely return.|

    Reply
  • May 21, 2019 at 7:31 am
    Permalink

    What’s up, the whole thing is going fine here and ofcourse every one is sharing information, that’s really fine, keep up writing.|

    Reply
  • May 21, 2019 at 7:31 am
    Permalink

    Thanks for a marvelous posting! I seriously enjoyed reading it, you will be a great author.I will remember to bookmark your blog and will come back later on. I want to encourage you continue your great posts, have a nice afternoon!|

    Reply