VMware Cloud Community
nayyares
Contributor
Contributor

Oracle auto-discovery issue.

Hi Folks,

I am using Hyperic server 3.2 beta, on Solaris SPARC, my oracle server reside under Solaris 9 SPARC, the agent hyperic-hq-agent-3.2.3 is installed & it is able to monitor all services perfectly, when i try to auto-discover Oracle, it does register the auto-discovery request but unable to detect while does't throw any error/warning in agent-log.

could you please explain me how can i enable oracle 9i monitoring in hyperic 3.2?

Thanks
Reply
0 Kudos
5 Replies
excowboy
Virtuoso
Virtuoso

Hi,

my first question: is there any reason to run an old beta ?
Did you try to change the debuglevel

agent.logLevel=DEBUG

in your agent.properties file and restart your agent ?

Mirko
Reply
0 Kudos
nayyares
Contributor
Contributor

Hi excowboy,

I loaded now Hyperic-server 3.2.3 on solaris SPARC, & have raised the agent.log level as you said to DEBUG, here is what i am now seeing after initiating oracle 9i auto-discovery..

DEBUG [Thread-0] [FileScan] results.matches={org.hyperic.hq.plugin.oracle.OracleServerDetector@17f11fb=[/opt/oracle/pro
duct/oracle9i/bin/oracle, /opt/oracle/product/oracle9i/bin/oracle, /opt/oracle/product/oracle9i/ultrasearch/bin/oracle, /opt/oracle/product/ora
cle9i/ultrasearch/bin/oracle]}
2008-06-04 10:44:44,303 DEBUG [Thread-0] [FileScan] results.matches={org.hyperic.hq.plugin.oracle.OracleServerDetector@17f11fb=[/opt/oracle/pro
duct/oracle9i/bin/oracle, /opt/oracle/product/oracle9i/bin/oracle, /opt/oracle/product/oracle9i/ultrasearch/bin/oracle, /opt/oracle/product/ora
cle9i/ultrasearch/bin/oracle]}
2008-06-04 10:44:44,329 DEBUG [Thread-0] [AutoScan] Running AutoServerDetector for: Oracle 9i
2008-06-04 10:44:45,246 DEBUG [Thread-0] [AutoScan] Running AutoServerDetector for: Oracle 9i
2008-06-04 10:44:45,263 DEBUG [Thread-0] [AutoinventoryCommandsServer] Sending autoinventory report to server: [ScanState platform={agentToken=
null queueStatus=0 customProperties=[B@1c297a3 productConfig=null controlConfig=null measurementConfig=[B@717323 diff=0 ignored=false platformT
ypeName=Solaris lastApproved=null certdn=CAM-AGENT-1212561517097-9115804809062868987-6806864191376857497 fqdn=172.31.6.66 name=homsrv027
location=null description=Solaris 9 cpuCount=2 id=null mTime=1212568966481 cTime=1212568966481} ips={queueStatus=0 diff=0 ignored=false addres
s=172.31.6.66 mACAddress=00:03:BA:64:FD:0B netmask=255.255.255.240 id=null mTime=1212568966481 cTime=1212568966481},{queueStatus=0 diff=0 ignor
ed=false address=127.0.0.1 mACAddress=00:00:00:00:00:00 netmask=255.0.0.0 id=null mTime=1212568966481 cTime=1212568966481} serversIncluded=true
]
2008-06-04 10:44:47,566 INFO [Thread-0] [AutoinventoryCommandsServer] Autoinventory report successfully sent to server.


but still hyperic server is not receiving oracle detection... where i should put username/passwd for oracle user?

this might be annoying but a really newbie here...

thanks
Reply
0 Kudos
excowboy
Virtuoso
Virtuoso

Hi,

i guess you read the configuration help :

http://support.hyperic.com/confluence/display/hypcomm/Oracle+9i+server

Normally, HQ detects the software and offers it to add it to the inventory on the dashboard. The second step is to configure the new resource by the Configuration Properties on the resources page for example configuring username and password for the JDBC- user as described in the configuration help.

Mhh on the agent side everything looks great. Maybe you try to restart the server and agent once more if the resource doesn't appear in the Auto Discovery box on the Dashboard.

Mirko
Reply
0 Kudos
nayyares
Contributor
Contributor

Hi,

I did configure the JDBC user & have grant permission it requires, problem is that when i register autoscan for oracle 9i, as above mentioned log the agent sends report to hyperic-server, mean while i checked the server what it gets in log regarding agent's report i.e.

2008-06-04 14:22:02,621 INFO [Thread-49] [org.hyperic.hq.autoinventory.server.session.AutoinventoryManagerEJBImpl] Received auto-inventory report from 172.31.6.66 (6 servers)
2008-06-04 14:22:31,680 INFO [http-0.0.0.0-7080-1] [org.hyperic.hq.autoinventory.server.session.AutoinventoryManagerEJBImpl] AutoinventoryManager.getScanStatus called
2008-06-04 14:22:31,681 INFO [http-0.0.0.0-7080-1] [org.hyperic.hq.autoinventory.agent.client.AICommandsClient] CommandsClient.getScanStatus
2008-06-04 14:22:31,681 INFO [http-0.0.0.0-7080-1] [org.hyperic.hq.agent.client.AgentConnection] 172.31.6.66 -> autoinv:getScanStatus
2008-06-04 14:22:31,970 INFO [http-0.0.0.0-7080-1] [org.hyperic.hq.autoinventory.server.session.AutoinventoryManagerEJBImpl] AutoinventoryManager.getScanStatus called
2008-06-04 14:22:31,971 INFO [http-0.0.0.0-7080-1] [org.hyperic.hq.autoinventory.agent.client.AICommandsClient] CommandsClient.getScanStatus
2008-06-04 14:22:31,971 INFO [http-0.0.0.0-7080-1] [org.hyperic.hq.agent.client.AgentConnection] 172.31.6.66 -> autoinv:getScanStatus
2008-06-04 14:23:03,980 INFO [http-0.0.0.0-7080-1] [org.hyperic.hq.autoinventory.server.session.AIScheduleManagerEJBImpl] Scheduling job for immediate execution: JobDetail 'autoinventory.aiScan-10007-1-config-1951346979-1212582183958': jobClass: 'org.hyperic.hq.autoinventory.server.session.AIScanJob isStateful: false isVolatile: true isDurable: false requestsRecovers: false
2008-06-04 14:23:04,143 INFO [org.hyperic.hq.scheduler.server.mbean.SchedulerService_Worker-2] [org.hyperic.hq.autoinventory.agent.client.AICommandsClient] AICommandsClient.startScan for 172.31.6.66:2144
2008-06-04 14:23:04,143 INFO [org.hyperic.hq.scheduler.server.mbean.SchedulerService_Worker-2] [org.hyperic.hq.agent.client.AgentConnection] 172.31.6.66 -> autoinv:startScan
2008-06-04 14:24:22,877 INFO [Timer-3] [org.hibernate.cache.StandardQueryCache] starting query cache at region: DerivedMeasurement.findByCategory


but still nothing popup in inventorybox related oracle resource....this thing is getting me crazy 😞


I even restarted both agent & server still the same...

thanks

Message was edited by: nayyares
Reply
0 Kudos
nayyares
Contributor
Contributor

Hi,

Is it possible to add Oracle manually in inventory instead of auto-discovery, if yes, please point me to some howto/manual.

Thank you very much.
Reply
0 Kudos