EM12c/EM13c: Authentication failed. If problem persists, contact your system administrator. ORA-01950: no privileges on tablespace 'MGMT_TABLESPACE'
(Doc ID 2176249.1)
Last updated on NOVEMBER 16, 2019
Applies to:
Enterprise Manager Base Platform - Version 12.1.0.4.0 and laterInformation in this document applies to any platform.
Symptoms
Unable to login to the Cloud Control after fixing the disk crash issues.
Login fails with :
Authentication failed. If problem persists, contact your system administrator.
2016-08-25 15:11:44,004 [[ACTIVE] ExecuteThread: '12' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG auth.EMLoginService _performLogin.1263 - Error
java.sql.SQLSyntaxErrorException: ORA-01950: no privileges on tablespace 'MGMT_TABLESPACE'
ORA-06512: at "SYSMAN.MGMT_AUDIT", line 918
ORA-06512: at "SYSMAN.MGMT_AUDIT", line 417
ORA-06512: at "SYSMAN.EM_USER_MODEL_UI", line 1683
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
Non Debug emoms.trc
2016-08-25 12:08:33,126 [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] WARN auth.EMRepLoginFilter doFilter.450 - InvalidEMUserException caught in EMRepLoginFilter: Failed to login using repository authentication for user: SYSMAN
oracle.sysman.emSDK.sec.auth.InvalidEMUserException: Failed to login using repository authentication for user: SYSMAN
at oracle.sysman.emSDK.sec.auth.EMLoginService._performLogin(EMLoginService.java:1289)
at oracle.sysman.emSDK.sec.auth.EMLoginService._doEMLogin(EMLoginService.java:710)
at oracle.sysman.emSDK.sec.auth.EMLoginService.doEMLogin(EMLoginService.java:640)
at oracle.sysman.emSDK.sec.auth.EMLoginService.doLogin(EMLoginService.java:215)
at oracle.sysman.emSDK.sec.auth.EMLoginService.doLogin(EMLoginService.java:261)
at oracle.sysman.emSDK.sec.auth.EMLoginService.doLogin(EMLoginService.java:268)
at oracle.sysman.eml.app.EMRepLoginFilter.doFilter(EMRepLoginFilter.java:427)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.sysman.eml.app.MBeanServerConnFilter.doFilter(MBeanServerConnFilter.java:43)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.sysman.eml.app.BrowserVersionFilter.doFilter(BrowserVersionFilter.java:122)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.sysman.emSDK.svlt.EMRedirectFilter.doFilter(EMRedirectFilter.java:102)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.adf.library.webapp.LibraryFilter.doFilter(LibraryFilter.java:180)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:561)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.adfinternal.view.faces.caching.filter.AdfFacesCachingFilter.doFilter(AdfFacesCachingFilter.java:137)
SQL Trace for ORA-01950 shows:
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=3, mask=0x0)
----- Error Stack Dump -----
ORA-01950: no privileges on tablespace 'MGMT_TABLESPACE'
----- Current SQL Statement for this session (sql_id=3b2ksgqgvk2rb) -----
INSERT INTO EM_JOB_METRICS (SOURCE, LOG_TIMESTAMP, METRIC_QUALIFIER, METRIC_NAME, METRIC_VALUE) VALUES (:B5 , :B4 , :B3 , :B2 , :B1 )
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x1d3be3b58 157 package body SYSMAN.EM_JOB_METRIC
0x1d3be3b58 163 package body SYSMAN.EM_JOB_METRIC
0x1d3be3b58 715 package body SYSMAN.EM_JOB_METRIC
0x1d47424e0 1 anonymous block
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 |