My Oracle Support Banner

13c EM: 'emctl start oms' Command Failed With "java.sql.SQLException: ORA-01109: database not open" (Doc ID 2780589.1)

Last updated on MAY 31, 2021

Applies to:

Enterprise Manager Base Platform - Version 13.2.0.0.0 to 13.5.1.0.0 [Release 13c]
Information in this document applies to any platform.

Symptoms

OMS fails to start with the following error:

$<OMS_HOME>/bin>./emctl start oms

Oracle Enterprise Manager Cloud Control 13c Release 5

Copyright (c) 1996, 2021 Oracle Corporation. All rights reserved.

Starting Oracle Management Server...

WebTier Successfully Started

Oracle Management Server Could Not Be Started

Check EM Server log file for details: /../gc_inst/user_projects/domains/GCDomain/servers/EMGC_OMS1/logs/EMGC_OMS1.out

AdminServer Could Not Be Started

Check Admin Server log file for details: /../gc_inst/user_projects/domains/GCDomain/servers/EMGC_ADMINSERVER/logs/EMGC_ADMINSERVER.out

Oracle Management Server is Down

JVMD Engine is Down

../gc_inst/user_projects/domains/GCDomain/servers/EMGC_OMS1/logs/EMGC_OMS1.out has below errors.

Caused by: oracle.security.jps.service.policystore.PolicyStoreException: Can not connect DB with URL [jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<HOST_NAME>)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=<SERVICE NAME>)))]

at oracle.security.jps.internal.policystore.util.JpsDataManagerUtil.getDBConnection(JpsDataManagerUtil.java:412)

at oracle.security.jps.internal.policystore.util.JpsDataManagerUtil.isNewSchema(JpsDataManagerUtil.java:246)

Caused by: java.sql.SQLException: ORA-01109: database not open

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:510)

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:457)

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:452)

at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:549)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:551) 

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.