----------------------------------------------------------------
Configuration:
EM12c platform:
Oracle Enterprise Linux 6.2(x86_64)
Oracle Enterprise Database 11.2.0.3 (x86_64)
Enterprise Manager Cloud Control 12c Release 1 (12.1.0.1) (x86_64)
Microsoft SQL Server Plug-In 12.1.0.2.0 deployed in the Management Server
Target:
Windows Server 2003 Standard Edition Service Pack 2 (32-bit)
SQL Server 2005 SP2 (Standard Edition) (32-bit)
Microsoft SQL Server Plug-In 12.1.0.2.0 deployed in the Management Agent
----------------------------------------------------------------
Problem:
EM12C: Targets > Databases
The SQL Server 32-bit target shows "Status Pending"
Verified the Target Agent Logs and found.
D:\oracle\Middleware\agent_inst\sysman\log\gcagent.log
2012-09-20 17:36:25,833 [14939:C578F997] INFO - Adding a new target [microsoft_sqlserver_database.mssql_peregrine.esri.com]
2012-09-20 17:36:28,271 [15029:7DDB51EF:GC.DPExecutor2.57 (CDProps:microsoft_sqlserver_database.mssql_peregrine.esri.com:agent_host)] WARN - Found a row with more columns than declared for the metric for TargetID = mssql_peregrine.esri.com, Metric =
OSType_Agent_DynamicProperty
Row = Microsoft Windows Server 2003 Standard Edition,,C:\\WINDOWS,\\Device\\Harddisk0\\Partition2
2012-09-20 17:36:28,583 [15031:1C41A703:GC.DPExecutor2.58 (CDProps:microsoft_sqlserver_database.mssql_peregrine.esri.com:win_host_name)] WARN - Found a row with more columns than declared for the metric for TargetID = mssql_peregrine.esri.com, Metric =
OSType_TargetHost_DynamicProperty
Row = Microsoft Windows Server 2003 Standard Edition,,,C:\\WINDOWS,\\Device\\Harddisk0\\Partition2
2012-09-20 17:36:28,755 [15073:9240A7B9:GC.DPExecutor.27 (CDynamic:microsoft_sqlserver_database.mssql_peregrine.esri.com)] INFO - Target: [microsoft_sqlserver_database.mssql_peregrine.esri.com] is broken: Dynamic Category property error
2012-09-20 17:36:28,755 [15073:9240A7B9] INFO - Target: [microsoft_sqlserver_database.mssql_peregrine.esri.com] is broken: Dynamic Category property error,Get dynamic property error
2012-09-20 17:36:29,286 [15073:9240A7B9] INFO - Starting collection for target: [microsoft_sqlserver_database.mssql_peregrine.esri.com$12]
2012-09-20 17:36:29,286 [14939:C578F997] INFO - >>> Reporting response: AddTargetsResponse (request id 1) <<<
2012-09-20 17:36:29,286 [14939:C578F997] INFO - (end processing requests for OMS@9151@mcsoracloud.esri.com=>[134818747370001])
----------------------------------------------------------------
Tried the following without success:
- remove target and add target again
Database Username (Required for SQL Authentication): sa
Password of Database User (Required for SQL Authentication): ****
Role (Optional)
System Password (Needed when SQLServer is at remote location): <empty>
System Username (Needed when SQLServer is at remote location): <empty>
Connect Using Windows Integrated Authentication (Yes/No): No
JDBC Driver (Optional): com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC URL (Example : jdbc:sqlserver://<host>:<port>): jdbc:sqlserver://peregrine.esri.com:1433
- Add Target don't let me fill the System Password and System Username, get message that says is not required.
- Configure target, usernames/passwords are set correctly, it let me fill the System Password and System Username, but the Target still shows "Pending Status".
- Oracle support: EM12C : Agents Show As Status Pending After Fresh Install [ID 1478880.1]
EM12c: Agents > peregrine.esri.com:3872 > Agent > Resynchronization
Still Target shows "Pending Status"
----------------------------------------------------------------
Have you seen this problem before? Any suggestions?
Thanks,
Marcelo Marques
Esri-Technical Manager