This discussion is archived
3 Replies Latest reply: Jan 9, 2013 6:37 PM by Subha4mOra RSS

SQL Server monitoring with 12c Grid control

SatishKumarSadhu Newbie
Currently Being Moderated
Dear Gurus

I want to add my sql server databases in 12c Grid control. for this i have deployed the sql server plugin in 12c grid control but i am unable to add the sql server databases/ servers in 12c grid control.

Could you please help me in deploying the sql server servers in 12c grid control.

Thanks & Regards,
Satish Kumar Sadhu
  • 1. Re: SQL Server monitoring with 12c Grid control
    jstem1177 Explorer
    Currently Being Moderated
    Hello,

    Here is a fairly good tutorial from Gavin. This should get you started. Its for an older version of Cloud 12c but is still applicable.

    [12c Plugin for Microsoft SQL Server|http://gavinsoorma.com/2012/06/installing-the-12c-cloud-control-plug-in-for-microsoft-sql-server-database/]

    Jan S.
  • 2. Re: SQL Server monitoring with 12c Grid control
    SatishKumarSadhu Newbie
    Currently Being Moderated
    Dear Jan,

    Already I have added the plugin but while adding the target i am getting below error. Can u please give some idea on this

    Test Connection failed: [_WinAuthDLLToLoadDynamicProp;em_error=DLL file 'D:\12c_agent\plugins\oracle.em.smss.agent.plugin_12.1.0.2.0\scripts\emx\microsoft_sqlserver_database..\..\..\..\dependencies\oracle.em.smss\jdbcdriver\sqljdbc_auth.dll' is found missing or not was never copied manually. Please copy amd64 version of sqljdbc_auth.dll at the above location and re-try, MSSQL_NumClusterNodes;Can't resolve a non-optional query descriptor property [dllFile] (dllFile), WbemRemote_Determination_DynamicProperty;Can't resolve a non-optional query descriptor property [dllFile] (dllFile), MSSQLInstance_TestMetric_DynamicProperty;Can't resolve a non-optional query descriptor property [dllFile] (dllFile), OSType_TargetHost_DynamicProperty;Can't resolve a non-optional query descriptor property [STDINWBEM_HOST] (ms_sqlserver_host), MSSQL_NumClusterNodes;Can't resolve a non-optional query descriptor property [dllFile] (dllFile)]
  • 3. Re: SQL Server monitoring with 12c Grid control
    Subha4mOra Newbie
    Currently Being Moderated
    Perform the solution plan as outlined in My Oracle Support portal Doc ID 1472806.1

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points