EM12c, EM13c : Oracle Management Server Fails To Start : ORA-01045: user SYSMAN_MDS lacks CREATE SESSION privilege

(Doc ID 2152088.1)

Last updated on JUNE 21, 2016

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.1.0 and later
Information in this document applies to any platform.

Symptoms

Trying to start the Enterprise Manager(EM) fails,

emctl start oms
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
Windows service OracleManagementServer_EMGC_OMS1_1 failed to be started
Oracle Management Server is Down
Please check c:/oracle/ppd/gc_inst/em/EMGC_OMS1\sysman\log\emctl.log for error details

Error stack observed from emoms.trc file:

Cannot obtain connection: driverURL = jdbc:weblogic:pool:mds-sysman_mds, props = {EmulateTwoPhaseCommit=false, connectionPoolID=mds-sysman_mds, jdbcTxDataSource=true, LoggingLastResource=false, dataSourceName=mds-sysman_mds}

at oracle.mds.config.PConfig.loadFromBean(PConfig.java:1019)
at oracle.mds.config.PConfig.<init>(PConfig.java:768)
at oracle.mds.config.MDSConfig.loadFromBean(MDSConfig.java:1151)
at oracle.mds.config.MDSConfig.loadFromElement(MDSConfig.java:1218)
at oracle.mds.config.MDSConfig.<init>(MDSConfig.java:781)
at oracle.mds.core.MDSInstance.getMDSConfigFromDocument(MDSInstance.java:2825)
at oracle.mds.core.MDSInstance.findAndStoreMDSInstanceWithCustConfig(MDSInstance.java:2658)
at oracle.mds.core.MDSInstance.getOrCreateInstanceInternal(MDSInstance.java:2131)
at oracle.mds.core.MDSInstance.getOrCreateInstance(MDSInstance.java:815)
at oracle.adf.share.config.ADFMDSConfig.parseADFConfiguration(ADFMDSConfig.java:146)
... 47 more
Caused by: oracle.mds.exception.MDSExceptionList: MDS-01329: unable to load element "persistence-config"
MDS-01370: MetadataStore configuration for metadata-store-usage "writeable" is invalid.
MDS-01376: Unable to get database connection from data source "mds-sysman_mds" configured with JNDI name "jdbc/mds/sysman_mds".
weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: ORA-01045: user SYSMAN_MDS lacks CREATE SESSION privilege; logon denied

Cannot obtain connection: driverURL = jdbc:weblogic:pool:mds-sysman_mds, props = {EmulateTwoPhaseCommit=false, connectionPoolID=mds-sysman_mds, jdbcTxDataSource=true, LoggingLastResource=false, dataSourceName=mds-sysman_mds}

at oracle.mds.config.PConfig.loadFromBean(PConfig.java:1013)
... 56 more

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms