EM Cloud Control 12c - Plugin Microsoft SQLServer Database Problem
Hello,The versions used for EM Cloud is 12.1.0.3.0 and the plugin Microsoft SQLServer Database 12.1.0.3.0
The deployment on Windows Server 2008 R2 Standard 64 bits works fine.
The DLL file sqljdbc_auth.dll (version 4.0) was copied to the location <agent home>\plugins\oracle.em.smss.agent.plugin_12.1.0.3.0\dependencies\oracle.em.smss\jdbcdriver.
Now when creating a new target (Microsoft SQL Server), the connection test gives the following output in debugging mode:
[145:C2024341] DEBUG - Adding plugin environment properties to target microsoft_sqlserver_database.SQLSERVER\INSTANCE$2: {PLUGIN_ROOT=C:\Oracle\Agent\plugins\oracle.em.smss.agent.plugin_12.1.0.3.0, SNMO_PERL5LIB=C:\Oracle\Agent\plugins\oracle.em.smss.agent.plugin_12.1.0.3.0\scripts;c:/Oracle/Agent\core\12.1.0.3.0\\perl\bin;c:/Oracle/Agent\core\12.1.0.3.0\perl\lib;c:/Oracle/Agent\core\12.1.0.3.0\perl\lib\site_perl;c:/Oracle/Agent\core\12.1.0.3.0\perl\site\lib;c:/Oracle/Agent\core\12.1.0.3.0\sysman\admin\scripts;c:/Oracle/Agent\core\12.1.0.3.0\sysman\admin\scripts\Net-DNS-0.48\lib;c:/Oracle/Agent\core\12.1.0.3.0\bin;c:/Oracle/Agent\core\12.1.0.3.0\bin;c:/Oracle/Agent\core\12.1.0.3.0\sysman\admin\scripts\libnet-1.19, PERL5LIB=C:\Oracle\Agent\plugins\oracle.em.smss.agent.plugin_12.1.0.3.0\scripts;c:/Oracle/Agent\core\12.1.0.3.0\\perl\bin;c:/Oracle/Agent\core\12.1.0.3.0\perl\lib;c:/Oracle/Agent\core\12.1.0.3.0\perl\lib\site_perl;c:/Oracle/Agent\core\12.1.0.3.0\perl\site\lib;c:/Oracle/Agent\core\12.1.0.3.0\sysman\admin\scripts;c:/Oracle/Agent\core\12.1.0.3.0\sysman\admin\scripts\Net-DNS-0.48\lib;c:/Oracle/Agent\core\12.1.0.3.0\bin;c:/Oracle/Agent\core\12.1.0.3.0\bin;c:/Oracle/Agent\core\12.1.0.3.0\sysman\admin\scripts\libnet-1.19}
The deployment on Windows Server 2008 R2 Standard 64 bits works fine.
The DLL file sqljdbc_auth.dll (version 4.0) was copied to the location <agent home>\plugins\oracle.em.smss.agent.plugin_12.1.0.3.0\dependencies\oracle.em.smss\jdbcdriver.
Now when creating a new target (Microsoft SQL Server), the connection test gives the following output in debugging mode:
[145:C2024341] DEBUG - Adding plugin environment properties to target microsoft_sqlserver_database.SQLSERVER\INSTANCE$2: {PLUGIN_ROOT=C:\Oracle\Agent\plugins\oracle.em.smss.agent.plugin_12.1.0.3.0, SNMO_PERL5LIB=C:\Oracle\Agent\plugins\oracle.em.smss.agent.plugin_12.1.0.3.0\scripts;c:/Oracle/Agent\core\12.1.0.3.0\\perl\bin;c:/Oracle/Agent\core\12.1.0.3.0\perl\lib;c:/Oracle/Agent\core\12.1.0.3.0\perl\lib\site_perl;c:/Oracle/Agent\core\12.1.0.3.0\perl\site\lib;c:/Oracle/Agent\core\12.1.0.3.0\sysman\admin\scripts;c:/Oracle/Agent\core\12.1.0.3.0\sysman\admin\scripts\Net-DNS-0.48\lib;c:/Oracle/Agent\core\12.1.0.3.0\bin;c:/Oracle/Agent\core\12.1.0.3.0\bin;c:/Oracle/Agent\core\12.1.0.3.0\sysman\admin\scripts\libnet-1.19, PERL5LIB=C:\Oracle\Agent\plugins\oracle.em.smss.agent.plugin_12.1.0.3.0\scripts;c:/Oracle/Agent\core\12.1.0.3.0\\perl\bin;c:/Oracle/Agent\core\12.1.0.3.0\perl\lib;c:/Oracle/Agent\core\12.1.0.3.0\perl\lib\site_perl;c:/Oracle/Agent\core\12.1.0.3.0\perl\site\lib;c:/Oracle/Agent\core\12.1.0.3.0\sysman\admin\scripts;c:/Oracle/Agent\core\12.1.0.3.0\sysman\admin\scripts\Net-DNS-0.48\lib;c:/Oracle/Agent\core\12.1.0.3.0\bin;c:/Oracle/Agent\core\12.1.0.3.0\bin;c:/Oracle/Agent\core\12.1.0.3.0\sysman\admin\scripts\libnet-1.19}
0