EM 12c, 13c: Enterprise Manager OMS Startup Fails if the SYSMAN Account is Locked in the Repository Database (Doc ID 1395399.1)

Last updated on APRIL 19, 2017

Applies to:

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

Symptoms

12c OMS startup fails with the following:

emctl start oms
Oracle Enterprise Manager Cloud Control 12c Release 12xxx
Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.
Starting WebTier...
WebTier Successfully Started
Starting Oracle Management Server...
Oracle Management Server is Down

-  The <EM_INSTANCE_BASE>/em/EMGC_OMS1/sysman/log/emctl.log has these entries at the end of the startup operation:

2012-01-17 13:36:55,185 [main] DEBUG oms.StatusOMSCmd processStatusOMS.239 - console page status code is 404
2012-01-17 13:36:56,271 [main] DEBUG oms.StatusOMSCmd processStatusOMS.241 - pbs page status code is 500
2012-01-17 13:36:56,271 [main] DEBUG oms.StatusOMSCmd processStatusOMS.244 - console header is null
2012-01-17 13:36:56,271 [main] DEBUG oms.StatusOMSCmd processStatusOMS.246 - pbs header is null
2012-01-17 13:36:56,271 [main] DEBUG oms.StatusOMSCmd processStatusOMS.284 - Both Console and PBS are down. Status codes are: Console - 404 and PBS - 500
2012-01-17 13:36:56,272 [main] INFO oms.StatusOMSCmd processStatusOMS.293 - Failed to connect to em login page
2012-01-17 13:36:56,272 [main] INFO oms.StatusOMSCmd processStatusOMS.294 - Encountered error while hitting page. Status codes are 404 for console and 500 for PBS
2012-01-17 13:36:56,272 [main] INFO oms.StatusOMSCmd processStatusOMS.295 - Connection exception when trying to hit OMS page. OMS is down
2012-01-17 13:36:56,299 [main] INFO wls.OMSController statusOMS.1354 - statusOMS finished with result: 8

-  The <EM_INSTANCE_BASE>/user_projects/domains/GCDomain/servers/EMGC_ADMINSERVER/logs/EMGC_ADMINSERVER.out shows:

<Jan 17, 2012 1:27:02 PM IST> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "sysman-opss-ds": ORA-28000: the account is locked
>
[EL Severe]: 2012-01-17 13:27:03.705--ServerSession(434635502)--Local Exception Stack:
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.3.v20110304-r9073): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: weblogic.jdbc.extensions.ConnectionDeadSQLException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: ORA-28000: the account is locked
.......
2012-Jan-17 13:27:55 : Failed to get repository details from credstore
INFO: Found persistence provider "org.eclipse.persistence.jpa.PersistenceProvider". OpenJPA will not be used.
INFO: Found persistence provider "org.eclipse.persistence.jpa.PersistenceProvider". OpenJPA will not be used.
[EL Info]: 2012-01-17 13:27:55.357--ServerSession(582574721)--EclipseLink, version: Eclipse Persistence Services - 2.1.3.v20110304-r9073
<Jan 17, 2012 1:27:55 PM IST> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "sysman-opss-ds": ORA-28000: the account is locked
>
........
Exception caught while getting credentials access denied (oracle.security.jps.service.credstore.CredentialAccessPermission context=SYSTEM,mapName=EM,keyName=REPOS_DETAILS read)
java.security.AccessControlException: access denied (oracle.security.jps.service.credstore.CredentialAccessPermission context=SYSTEM,mapName=EM,keyName=REPOS_DETAILS read)

-  The <EM_INSTANCE_BASE>/user_projects/domains/GCDomain/servers/EMGC_OMS1/logs/EMGC_OMS1.out shows:

<Jan 17, 2012 1:41:55 PM IST> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "sysman-opss-ds": ORA-28000: the account is locked
>
......
Error Code: 0
at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:417)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:164)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:221)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:209)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.init(JpsDBDataManager.java:417)
Truncated. see log file for complete stacktrace
Caused By: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.3.v20110304-r9073): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: weblogic.jdbc.extensions.ConnectionDeadSQLException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: ORA-28000: the account is locked

 -  In the Repository database, the sysman_opss account is locked:

 

This can happen also if other SYSMAN_ accounts are locked.

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