EM 13c: OMS Start Failed - JPS-00260: Database Access Error.
(Doc ID 3047427.1)
Last updated on SEPTEMBER 28, 2024
Applies to:
Enterprise Manager Base Platform - Version 13.5.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
OMS doesn't start. While attempting to start results failure and below errors are reported in the oms log:
<EM_INSTANCE_BASE>/em/EMGC_OMSn/sysman/log/emoms.log
Caused by: oracle.security.jps.service.credstore.CredStoreException: JPS-01055: Could not create credential store instance. Reason oracle.security.jps.JpsException: JPS-00260: Database access error. SQL state: 99999, error code: 28374.
at oracle.security.jps.internal.credstore.ldap.LdapCredentialStore.init(LdapCredentialStore.java:190)
at oracle.security.jps.internal.credstore.ldap.LdapCredentialStore.start(LdapCredentialStore.java:1021)
at oracle.security.opss.internal.runtime.ServiceContextImpl.start(ServiceContextImpl.java:220)
at oracle.security.opss.internal.runtime.ServiceContextManagerImpl.createDefaultContext(ServiceContextManagerImpl.java:325)
at oracle.security.opss.internal.runtime.ServiceContextManagerImpl.initialize(ServiceContextManagerImpl.java:242)
at oracle.security.jps.internal.config.OpssCommonStartup$1.run(OpssCommonStartup.java:167)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.internal.config.OpssCommonStartup.start(OpssCommonStartup.java:160)
... 27 more
Caused by: oracle.security.jps.JpsException: JPS-00260: Database access error. SQL state: 99999, error code: 28374.
at oracle.security.jps.internal.common.config.AbstractSecurityStore.getSecurityStoreVersion(AbstractSecurityStore.java:205)
at oracle.security.jps.internal.common.config.AbstractSecurityStore.getSecurityStoreVersionInternal(AbstractSecurityStore.java:168)
at oracle.security.jps.internal.common.config.AbstractSecurityStore.getSecurityStoreVersion(AbstractSecurityStore.java:146)
at oracle.security.jps.internal.credstore.ldap.LdapCredentialStore.init(LdapCredentialStore.java:186)
... 34 more
Caused by: oracle.security.jps.service.policystore.PolicyStoreException: JPS-00260: Database access error. SQL state: 99999, error code: 28374.
at oracle.security.jps.internal
at oracle.security.jps.internal.credstore.ldap.LdapCredentialStore.init(LdapCredentialStore.java:190)
at oracle.security.jps.internal.credstore.ldap.LdapCredentialStore.start(LdapCredentialStore.java:1021)
at oracle.security.opss.internal.runtime.ServiceContextImpl.start(ServiceContextImpl.java:220)
at oracle.security.opss.internal.runtime.ServiceContextManagerImpl.createDefaultContext(ServiceContextManagerImpl.java:325)
at oracle.security.opss.internal.runtime.ServiceContextManagerImpl.initialize(ServiceContextManagerImpl.java:242)
at oracle.security.jps.internal.config.OpssCommonStartup$1.run(OpssCommonStartup.java:167)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.internal.config.OpssCommonStartup.start(OpssCommonStartup.java:160)
... 27 more
Caused by: oracle.security.jps.JpsException: JPS-00260: Database access error. SQL state: 99999, error code: 28374.
at oracle.security.jps.internal.common.config.AbstractSecurityStore.getSecurityStoreVersion(AbstractSecurityStore.java:205)
at oracle.security.jps.internal.common.config.AbstractSecurityStore.getSecurityStoreVersionInternal(AbstractSecurityStore.java:168)
at oracle.security.jps.internal.common.config.AbstractSecurityStore.getSecurityStoreVersion(AbstractSecurityStore.java:146)
at oracle.security.jps.internal.credstore.ldap.LdapCredentialStore.init(LdapCredentialStore.java:186)
... 34 more
Caused by: oracle.security.jps.service.policystore.PolicyStoreException: JPS-00260: Database access error. SQL state: 99999, error code: 28374.
at oracle.security.jps.internal
EM Repository DB alert log reports below errors:
2024-09-11T05:05:02.230171+00:00
EMPDB(3):error 28374 happened for queue:SYSMAN.MGMT_ADMINMSG_BUS during timed act
EMPDB(3):error 28374 happened during Queue table repartitioning
2024-09-11T05:05:06.135709+00:00
Errors in file /u01/app/oracle/database/diag/rdbms/emrep/emrep/trace/emrep_dbw0_2977030.trc:
ORA-28374: typed master key not found in wallet
Errors in file /u01/app/oracle/database/diag/rdbms/emrep/emrep/trace/emrep_dbw0_2977030.trc (incident=132980) (PDBNAME=CDB$ROOT):
ORA-28374 [] [] [] [] [] [] [] [] [] [] [] []
Incident details in: /u01/app/oracle/database/diag/rdbms/emrep/emrep/incident/incdir_132980/emrep_dbw0_2977030_i132980.trc
2024-09-11T05:05:07.417089+00:00
DBW0 (ospid: 2977030): terminating the instance due to ORA error 28374
2024-09-11T05:05:07.459833+00:00
System state dump requested by (instance=1, osid=2977030 (DBW0)), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/database/diag/rdbms/emrep/emrep/trace/emrep_diag_2977011.trc
2024-09-11T05:05:10.250229+00:00
Dumping diagnostic data in directory=[cdmp_20240911050507], requested by (instance=1, osid=2977030 (DBW0)), summary=[abnormal instance termination].
2024-09-11T05:05:11.520897+00:00
Instance terminated by DBW0, pid = 2977030
EMPDB(3):error 28374 happened for queue:SYSMAN.MGMT_ADMINMSG_BUS during timed act
EMPDB(3):error 28374 happened during Queue table repartitioning
2024-09-11T05:05:06.135709+00:00
Errors in file /u01/app/oracle/database/diag/rdbms/emrep/emrep/trace/emrep_dbw0_2977030.trc:
ORA-28374: typed master key not found in wallet
Errors in file /u01/app/oracle/database/diag/rdbms/emrep/emrep/trace/emrep_dbw0_2977030.trc (incident=132980) (PDBNAME=CDB$ROOT):
ORA-28374 [] [] [] [] [] [] [] [] [] [] [] []
Incident details in: /u01/app/oracle/database/diag/rdbms/emrep/emrep/incident/incdir_132980/emrep_dbw0_2977030_i132980.trc
2024-09-11T05:05:07.417089+00:00
DBW0 (ospid: 2977030): terminating the instance due to ORA error 28374
2024-09-11T05:05:07.459833+00:00
System state dump requested by (instance=1, osid=2977030 (DBW0)), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/database/diag/rdbms/emrep/emrep/trace/emrep_diag_2977011.trc
2024-09-11T05:05:10.250229+00:00
Dumping diagnostic data in directory=[cdmp_20240911050507], requested by (instance=1, osid=2977030 (DBW0)), summary=[abnormal instance termination].
2024-09-11T05:05:11.520897+00:00
Instance terminated by DBW0, pid = 2977030
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 |
Cause |
Solution |
References |