I created a plug-in with 2 metrics(Response and ResponseDb), i am getiing correct values in Response metric. .. but in ResponseDb metric it throws a metric collection error ...
Error Details on CONSOLE
***************************************
Target SQL_testing4
Type SQLtesting4
Metric ResponseDb
Collection Timestamp Apr 25, 2007 4:59:05 AM
Error Type Collection Failure
Message ORA-12157: TNS:internal network communication error
ResponseDb metric contains QueryDescriptor as
---------------------------------------------------------------------------------------------
<QueryDescriptor FETCHLET_ID="SQL">
<Property NAME="transpose" SCOPE="GLOBAL">TRUE</Property>
<Property NAME="STATEMENT" SCOPE="GLOBAL">
<![CDATA[SELECT 'McKesson' col from dual]]>
</Property>
<Property NAME="MachineName" SCOPE="INSTANCE">MachineName</Property>
<Property NAME="Port" SCOPE="INSTANCE">Port</Property>
<Property NAME="SID" SCOPE="INSTANCE" OPTIONAL="TRUE">SID</Property>
<Property NAME="UserName" SCOPE="INSTANCE">UserName</Property>
<Property NAME="password" SCOPE="INSTANCE">password</Property>
<Property NAME="ConnectDescriptor" SCOPE="GLOBAL">
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=%MachineName%)(Port=%Port%))(CONNECT_DATA=(SERVICE_NAME=%SID%)(INSTANCE_NAME=%SID%)(UR=A)))
</Property>
</QueryDescriptor>
--------------------------------------------------------------------------------------------
The expected flow should have been connecting to database and executing the query :---" SELECT 'McKesson' col from dual"
---------------------------------------------------------------------------------------------
BUT I GOT AN ERROR MESSAGE:
the error msg i got in "emagent.trc" is
--------------------------------------------------------------------
2007-04-25 07:49:05 Thread-614432774 WARN vpxoci: OCI Error -- ErrorCode(12157): ORA-12157: TNS:internal network communication error
SQL = " OCIServerAttach"...
LOGIN = sysman/<PW>@
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=democrat.clinicom.com)(Port=1521))(CONNECT_DATA=(SERVICE_NAME=gc)(INSTANCE_NAME=gc)(UR=A)))
2007-04-25 07:49:05 Thread-614432774 ERROR vpxoci: ORA-12157: TNS:internal network communication error
2007-04-25 07:49:05 Thread-614432774 WARN vpxoci: Login 0x90f6278 failed, error=ORA-12157: TNS:internal network communication error
2007-04-25 07:49:05 Thread-614432774 ERROR engine: [mck_svc_dbtest,SQL_testing4,ResponseDb] : nmeegd_GetMetricData failed : ORA-12157: TNS:internal network communication error
2007-04-25 07:49:05 Thread-614432774 WARN collector: <nmecmc.c> Error exit. Error message: ORA-12157: TNS:internal network communication error
-----------------------------------------------------------------------------------------------------------------------
COULD ANYONE PLEASE TELL ME WHAT'S THE PROBLEM WITH THE ABOVE CODE with apt solution