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/