EM 12c : Unable to Discover Database Plugin Targets After applying 12.1.0.8.160930 Discovery Patch 24610055 (Doc ID 2203250.1)

Last updated on NOVEMBER 20, 2016

Applies to:

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

Symptoms

Using 12.1.0.5 agent with 12.1.0.8 Database Plugin.
Attempting to discover new databases on the target server using the below methods do not list any targets:

1. Auto discovery method.
2. Add target manually via guided process

- The 12.1.0.8.160930 agent-side Discovery <Patch 24610055> has been applied recently to the Database Plugin home at this agent.

- With DEBUG level logging, the <AGENT_INST>/sysman/log/gcagent.log shows the below entries:

2016-10-11 14:58:34,018 [1033:FD98A2F4] DEBUG - pluginId=oracle.sysman.db,scriptName=discover/oracledb.pl
2016-10-11 14:58:34,018 [1033:FD98A2F4] DEBUG - OSChannel:
[/u01/app/oracle/product/12.1.0/agent12c/core/12.1.0.5.0/perl/bin/perl
/u01/app/oracle/product/12.1.0/agent12c/plugins/oracle.sysman.db.discovery.plugin_12.1.0.8.0/discover/oracledb.pl
/u01/app/oracle/product/12.1.0/agent12c/core/12.1.0.5.0 agenthost.domain] STDIN={}
2016-10-11 14:58:34,018 [1033:FD98A2F4] DEBUG - OSChannel executing id=Unknown@1476161914018_269: Command(/u01/app/oracle/product/12.1.0/agent12c/core/12.1.0.5.0/perl/bin/perl)

The oracledb.pl script is getting called at 2016-10-11 14:58:34. However, the emagent_perl.trc shows no entries for the oracledb.pl script when the Database discovery is run, even when the DEBUG level tracing is enabled for PERL modules. 

-  Attempting to execute the <AGENT_BASE_DIR>/plugins/oracle.sysman.db.discovery.plugin_12.1.0.8.0/discover/oracledb.pl script manually fails with:

$ perl oracledb.pl 'hostname'
Global symbol "$hostMatchFound" requires explicit package name at oracledb.pl
line 1500.
Execution of oracledb.pl aborted due to compilation errors.

Cause

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