EM 13c: Enterprise Manager 13c Cloud Control Installation Fails at Repository Configuration: ORA-01035: ORACLE ONLY AVAILABLE TO USERS WITH RESTRICTED SESSION PRIVILEGE
(Doc ID 2503367.1)
Last updated on DECEMBER 06, 2019
Applies to:
Enterprise Manager Base Platform - Version 13.1.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Enterprise Manager (EM) 13.2 Cloud Control installation fails at Repository Configuration with the following error logged in
<OMS ORACLE_HOME>/cfgtoollogs/cfgfw/oracle.sysman.top.oms_<TIMESTAMP>.log:
FATAL Configuration Exceptions
create connection exception
java.sql.SQLException: java.sql.SQLException: ORA-01035: ORACLE ONLY AVAILABLE TO USERS WITH RESTRICTED SESSION PRIVILEGE
The Connect Descriptor was (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<HOSTNAME>)(PORT=<PORT>)))(CONNECT_DATA=(SERVICE_NAME=<SERVICE_NAME>)))
at oracle.sysman.emdrep.config.EMSchemaConfiguration.getConnection(EMSchemaConfiguration.java:978)
at oracle.sysman.emdrep.config.EMSchemaConfiguration.isPluginDeployment(EMSchemaConfiguration.java:907)
at oracle.sysman.emdrep.config.EMSchemaConfiguration.perform(EMSchemaConfiguration.java:499)
... 10 more
Caused by: java.sql.SQLException: java.sql.SQLException:ORA-01035: ORACLE ONLY AVAILABLE TO USERS WITH RESTRICTED SESSION PRIVILEGE
:
create connection exception
java.sql.SQLException: java.sql.SQLException: ORA-01035: ORACLE ONLY AVAILABLE TO USERS WITH RESTRICTED SESSION PRIVILEGE
The Connect Descriptor was (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<HOSTNAME>)(PORT=<PORT>)))(CONNECT_DATA=(SERVICE_NAME=<SERVICE_NAME>)))
at oracle.sysman.emdrep.config.EMSchemaConfiguration.getConnection(EMSchemaConfiguration.java:978)
at oracle.sysman.emdrep.config.EMSchemaConfiguration.isPluginDeployment(EMSchemaConfiguration.java:907)
at oracle.sysman.emdrep.config.EMSchemaConfiguration.perform(EMSchemaConfiguration.java:499)
... 10 more
Caused by: java.sql.SQLException: java.sql.SQLException:ORA-01035: ORACLE ONLY AVAILABLE TO USERS WITH RESTRICTED SESSION PRIVILEGE
:
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 |