EM 12c: Cluster Databases Not Discovered With Unable to Read String Reader

(Doc ID 1506642.1)

Last updated on OCTOBER 21, 2016

Applies to:

Enterprise Manager for Oracle Database - Version to [Release 12.1]
Information in this document applies to any platform.


Newly created databases are not being discovered when performing a manual discovery in EM 12c. Or only some of the database instances for RAC are being discovered.

Steps attempted:

>Add Targets Manually
>Add Non-Host Targets Using Guided Process (Also Adds Related Targets)
>Oracle Database, Listener and Automatic Storage Management
>Add Using Guided Discovery
>Discovery on all hosts in the cluster

These steps give result:

The database discovery finished with some warnings.
Clicking on View Discovery Warnings shows:
    ... - unable to read string reader
    ... - unable to read string reader


Error from the emagent_perl.trc for the discovery process: 

oracledb.pl: Tue Oct 30 10:36:28 2012: ERROR:  initParameterFileUtl::convertSPFileToPFile: Failed to convert spfilea to pfile using sqlplus: Inappropriate ioctl for device 0 The output of sqlplus is "
SQL*Plus: Release Production on Tue Oct 30 10:36:28 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SP2-0640: Not connected

O/S Message: No such file or directory


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms