My Oracle Support Banner

EM 13c : Always-On Monitoring Sync Failing With ORA-00933: SQL Command Not Properly Ended (Doc ID 2280970.1)

Last updated on NOVEMBER 16, 2022

Applies to:

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

Symptoms

Trying to sync AOM(EMS) is failing with:

[oracle@myaomhost scripts]$ ./emsctl sync
Oracle Enterprise Manager Cloud Control 13c Release 2
Copyright (c) 2015, 2016, Oracle Corporation. All rights reserved.
------------------------------------------------------------------
 Connecting to Always-On Monitoring Repository.
Starting synchronization with Enterprise Manager.
Synchronizing with Enterprise Manager repository: SYSMAN@<REPHOST>:<PORT>:<REPO_DB_NAME>
Error: Error during sync: ORA-00933: SQL command not properly ended
, see the Always-On Monitoring logs for more information.

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
References


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