My Oracle Support Banner

Running Emcli Execute_sql Failing With ORA-12547 (Doc ID 2603942.1)

Last updated on JANUARY 18, 2023

Applies to:

Enterprise Manager for Oracle Database - Version 13.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Running a simple "emcli execute_sql" command will fail with:

******************************************************************************
* Target: orcl:oracle_database
* Execution Status: Failed
*******************************************************************************
ERROR:
ORA-12547: TNS:lost contact


SP2-0584: EXIT variable "SQLCODE" was non-numeric
Usage: { EXIT | QUIT }  [ SUCCESS | FAILURE | WARNING | n |
      <variable> | :<bindvariable> ]  [ COMMIT | ROLLBACK ]
Process returned : 1.

*******************************************************************************
* Execution Summary
*     Targets Succeeded: 0
*     Targets Failed: 1
*         orcl:oracle_database
*******************************************************************************

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.