My Oracle Support Banner

EM 13c: emctl Commands Succeed, but Sysman Login to Enterprise Manager 13c Cloud Control Console Fails with Error: java.sql.SQLException: ORA-01658: unable to create INITIAL extent for segment in tablespace SYSAUX (Doc ID 2835267.1)

Last updated on JULY 07, 2023

Applies to:

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

Symptoms

In Enterprise Manager (EM) 13.4 Cloud Control, resetting the sysman password succeeds, but still does not allow console login.

1. The following emctl command was used, showing successful sysman access:

$ emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd <OLD_PWD> -new_pwd <NEW_PWD>
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved.

Changing passwords in backend ...
Passwords changed in backend successfully.
Updating repository password in Credential Store...
Successfully updated Repository password in Credential Store.
Restart all the OMSs using 'emctl stop oms -all' and 'emctl start oms'.
Successfully changed repository password.

 

2. The following stack is found in the <EM_INSTANCE_BASE>/gc_inst/em/EMGC_OMS1/sysman/log/emoms.log file:

2022-01-20 07:11:07,124 [RJob Step 468092] ERROR commands.MdaAnalysisCommand logp.251 - [MDA_ACTIVITY_ID=3ab695e3-a275-4479-a98a-71bdce1de3cc]Error occurred during invoke of MDA Analysis Command - executeCommand() Error in notifyForAnalysis():ORA-01658: unable to create INITIAL extent for segment in tablespace SYSAUX
ORA-06512: at "SYSMAN.MDA_FINDINGS_FRAMEWORK", line 2175
ORA-06512: at line 1
: ORA-01658: unable to create INITIAL extent for segment in tablespace SYSAUX
ORA-06512: at "SYSMAN.MDA_FINDINGS_FRAMEWORK", line 2175
ORA-06512: at line 1

oracle.sysman.emInternalSDK.sdkas.mda.MdaException: Error in notifyForAnalysis():ORA-01658: unable to create INITIAL extent for segment in tablespace SYSAUX
ORA-06512: at "SYSMAN.MDA_FINDINGS_FRAMEWORK", line 2175
ORA-06512: at line 1
: ORA-01658: unable to create INITIAL extent for segment in tablespace SYSAUX
ORA-06512: at "SYSMAN.MDA_FINDINGS_FRAMEWORK", line 2175
ORA-06512: at line 1

at oracle.sysman.emInternalSDK.sdkas.mda.MdaException.processThrowable(MdaException.java:105)
<TRUNCATED>
at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)
Caused by: java.sql.SQLException: ORA-01658: unable to create INITIAL extent for segment in tablespace SYSAUX
ORA-06512: at "SYSMAN.MDA_FINDINGS_FRAMEWORK", line 2175
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:495)
<TRUNCATED>
at oracle.sysman.sdkImpl.sdkas.mda.fwk.jobs.MdaJobUtil.notifyForAnalysis(MdaJobUtil.java:275)
... 89 more

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.