My Oracle Support Banner

EM 13c: Update OMS property value fail with error "EMS-06017: An error occurred while getting the property name -9,999 for the OMS with ID = {1}, because the SQL execution failed for the property" (Doc ID 2680659.1)

Last updated on JUNE 15, 2020

Applies to:

Enterprise Manager Base Platform - Version to [Release 13c]
Information in this document applies to any platform.


Update OMS property value in below command given error :

<OMS_HOME>/bin/emctl set property -name "" -value "<CONNECTION DESCRIPTOR>"
Oracle Enterprise Manager Cloud Control 13c Release 3
Copyright (c) 1996, 2018 Oracle Corporation. All rights reserved.
SYSMAN password:
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
ORA-06512: at "SYSMAN.EM_OMS_PROPERTIES", line 1018
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.processError(
at oracle.jdbc.driver.T4CTTIfun.receive(
at oracle.jdbc.driver.T4CTTIfun.doRPC(
at oracle.jdbc.driver.T4C8Oall.doOALL(
at oracle.jdbc.driver.T4CCallableStatement.doOall8(
at oracle.jdbc.driver.T4CCallableStatement.doOall8(
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
at oracle.jdbc.driver.OraclePreparedStatement.execute(
at oracle.jdbc.driver.OracleCallableStatement.execute(
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(
at oracle.sysman.emSDK.omsproperties.ManagePropertyInstance.getProperty(
at oracle.sysman.core.common.omsproperties.OMSPropertyUtil.executeJavaValidators(
at oracle.sysman.emSDK.omsproperties.ManagePropertyInstance.setProperty(
at oracle.sysman.emctl.config.oms.OMSConfigProperties.main(
Could not set property for oms All Management Servers. Error = EMS-06050:
The following error occurred while validating property value <CONNECTION_DESCRIPTOR> for the property name
Internal error : EMS-06017: An error occurred while getting the property name -9,999 for the OMS with ID = {1}, because the SQL execution failed for the property.


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

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