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 MARCH 08, 2017

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.4.0 and later
Information 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.

Debug emoms.trc shows:

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

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