topic Re: EMS /rdbms not avilable error in Operating System - HP-UX

EMS /rdbms not avilable error

jayachandran.g — Mon, 27 Mar 2006 02:45:37 GMT

Hi All

When I tried to add a monitoring request to EMS in GUI it is giving error
"Resource /rdbms not available"

I want to add monitoring requests only to LAN card not to any oracle then too I’m getting this error.

In the web I found that this error would appear when the database is not running

"Monitor the resource for changes only. Since the value represents the time an application server was started, a change to this value is a valid indication that the server was restarted."

Where or how to check the above process are running or not...

#ps -af | grep -i ems is giving the output
" root 1113 1 0 Mar 7 ? 0:00 /etc/opt/resmon/lbin/emsagent"

It seems that I'm in the middle of the sea
and as far I see I found no light house... to call me ....

help me... !!!!!!!

Re: EMS /rdbms not avilable error

Robert-Jan Goossens — Mon, 27 Mar 2006 03:14:10 GMT

Hi,

Could you post your HPUX version ?

Is snmpdm running ?

# ps -ef | grep snmp
root 1327 1 0 Oct 14 ? 0:00 /usr/sbin/snmpdm
root 279 24547 0 10:12:22 pts/ta 0:00 grep snmp

Regards,
Robert-Jan

Re: EMS /rdbms not avilable error

jayachandran.g — Mon, 27 Mar 2006 05:13:33 GMT

Hi Robert

My HPUX version is

HP-UX B.11.00 U 9000/800 139454651

SNMP output

root 940 1 0 Mar 7 ? 0:55 /usr/sbin/snmpdm
root 975 1 0 Mar 7 ? 0:00 /usr/lbin/cmsnmpd

Here is something that I have understood/observed

Iâ m opening my EMS and adding a monitor request, EMS is connecting to "resource class" (may be this is considred as database) Which is having tree like architecture that it can monitor like
/net --> /interfaces --> /lan --> /status
-->lan Name.

The problem is connection to resource class is failing it seems. This is what I have understood from the docs... may be wrong....

Re: EMS /rdbms not avilable error

Robert-Jan Goossens — Mon, 27 Mar 2006 06:20:38 GMT

could you check if patch PHSS_27858 is installed ?

# swlist -l patch | grep PHSS_27858

Robert-Jan

Re: EMS /rdbms not avilable error

jayachandran.g — Mon, 27 Mar 2006 09:33:46 GMT

Hi Robert

swlist -l patch | grep PHSS_27858

PHSS_27858 Patch is not installed.

Re: EMS /rdbms not avilable error

Robert-Jan Goossens — Mon, 27 Mar 2006 09:57:52 GMT

Hi,

Just for my curiosity, are you monitoring a database with ems ?

Try to use the command interface.

# /etc/opt/resmon/lbin/monconfig

Regards,
Robert-Jan

Re: EMS /rdbms not avilable error

jayachandran.g — Tue, 28 Mar 2006 03:05:08 GMT

Hi Robert-Jan

I'm not sure on enablening the monior to lan cards using monconfig. Because the outout of config server

One thing that is found is in the all the monitor demons are not up and running.

only 7 or 9 is upand running. even registar demon is down.

Re: EMS /rdbms not avilable error

jayachandran.g — Tue, 28 Mar 2006 03:06:26 GMT

Hi Robert-Jan

I'm not sure on enablening the monior to lan cards using monconfig. I'm working on it.

One thing that is found is that all the monitor demons are not up and running.

only 7 or 9 is upand running. even registar demon is down.

Re: EMS /rdbms not avilable error

RAC_1 — Tue, 28 Mar 2006 03:08:07 GMT

Restart EMS and try.

/sbin/init.d/diagnostics stop
/sbin/init.d/diagnostics start

Re: EMS /rdbms not avilable error

Andrew Merritt_2 — Tue, 28 Mar 2006 05:10:32 GMT

Don't get confused between the Event Monitoring Service, which is what you are configuring through the SAM gui under Resource Management, and the EMS Hardware Monitors, which is what monconfig lists.

What does 'emscli -l' show?

If you already have requests to monitor an Oracle db, but it's not running, that would explain what you are seeing.

What version of EMS are you running? "swlist -l product|grep EMS-Core" will show this.

Andrew

Re: EMS /rdbms not avilable error

jayachandran.g — Tue, 28 Mar 2006 05:30:39 GMT

Hi Rober-Jan/ RCA

When I start the diagonistic not all my monitor demons are not running. It is starting and getting killed in few seconds.....

Re: EMS /rdbms not avilable error

jayachandran.g — Tue, 28 Mar 2006 10:22:29 GMT

Hi All

I'm talking about "Event Monitoring System"
which is accessed through SAM --> Resource Management --> Event monitoring System.

EMS core version is A.03.20.
emscli -l "cmd not found"

Re: EMS /rdbms not avilable error

Andrew Merritt_2 — Thu, 30 Mar 2006 04:50:06 GMT

Ah, emscli is new with the A.04.00 version of EMS, which is for 11.11 and later. Sorry, I forgot that.

Restarting the diagnostics will have no effect on what you are trying to do, though I'm curious as to what you mean about monitor demons dying.

When you open the "Event Monitoring System" window, are there any existing requests shown? If so, what are they?

Andrew

Re: EMS /rdbms not avilable error

Robert-Jan Goossens — Thu, 30 Mar 2006 04:56:05 GMT

Hi,

Could you check the registrar log file.

# tail /etc/opt/resmon/log/registrar.log

Regards,
Robert-Jan

Re: EMS /rdbms not avilable error

jayachandran.g — Thu, 30 Mar 2006 07:47:08 GMT

Hi Andrew/Rober-Jan

Check the outputs

HPSVR:root> resls /net/interfaces/lan/status
Contacting Registrar on HPSVR

NAME: /net/interfaces/lan/status
DESCRIPTION: None
TYPE: /net/interfaces/lan/status is not a valid resource name

and in registar.log
-------------------Start Event---------------
Event 1447 occurred at Wed Mar 29 17:55:01.720369 2006
Process ID: 13181 (/etc/opt/resmon/lbin/registrar) Log Level: Error
send_error_reply: Cannot send error reply to the client:
error code = 15: An error occurred while attempting to send a message: Broken pipe
-------------------End Event-----------------

Hrere are teh process that are running
-------------------Start Event---------------
Event 1447 occurred at Wed Mar 29 17:55:01.720369 2006
Process ID: 13181 (/etc/opt/resmon/lbin/registrar) Log Level: Error
send_error_reply: Cannot send error reply to the client:
error code = 15: An error occurred while attempting to send a message: Broken pipe
-------------------End Event-----------------

and abouth the monitoring demons

Thes are my demons rnning iw wqorking server ...

HP:root> ps -eaf | grep -i /opt/resmon
root 1355 1 0 Feb 6 ? 2:11 /etc/opt/resmon/lbin/pkgmond
root 1156 1 0 Feb 6 ? 9:06 /etc/opt/resmon/lbin/p_client
root 11411 6953 0 Mar 28 ? 0:00 /etc/opt/resmon/lbin/registrar
root 1184 1 0 Feb 6 ? 0:37 /etc/opt/resmon/lbin/clustermon
root 12534 1 0 Mar 28 ? 0:00 /etc/opt/resmon/lbin/emsagent
root 13417 1 0 Mar 28 ? 0:41 /etc/opt/resmon/lbin/lanmond

but these demons are not working running in the server which is haveing problem.....

HPSVR1:root>ps -eaf | grep -i /opt/resmon
root 1156 1 0 Feb 6 ? 9:06 /etc/opt/resmon/lbin/p_client
root 1355 1 0 Feb 6 ? 2:11 /etc/opt/resmon/lbin/registrar

Re: EMS /rdbms not avilable error

Robert-Jan Goossens — Thu, 30 Mar 2006 08:15:55 GMT

Could you post the output of

# swlist -l product | grep EMS

Re: EMS /rdbms not avilable error

jayachandran.g — Thu, 30 Mar 2006 08:32:03 GMT

HI

here is the output

EMS-Config A.03.20 EMS Config
EMS-Core A.03.20 EMS Core Product
EMS-DiskMonitor A.03.20 EMS Disk Resource Monitor
EMS-KRMonitor A.11.00.04 EMS Kernel Resource Monitor
EMS-MIBMonitor A.03.20 EMS MIB Resource Monitor Product
EMS-RdbmsMon A.03.20 EMS Database Monitor
PHCO_16280 1.0 du(1) value for non-HP NFS systems incorr
ect
PHCO_17867 1.0 ioinitrc, assign ttys for B,C class syste
ms
PHCO_18901 1.0 extendfs_hfs fix for large file systems
PHKL_22771 1.0 fix device and file system swap problems
PHKL_24905 1.0 VxFS mount/unmount problems.
PHSS_26871 1.0 EMS (A.03.20) & HA Monitors (A.03.20) pat
ch
Sup-Tool-Mgr B.11.00.26.07 Support Tools Manager for HPUX systems

Re: EMS /rdbms not avilable error

Robert-Jan Goossens — Thu, 30 Mar 2006 09:05:03 GMT

# swlist -a state -l fileset | grep EMS

all configured ?

if you have lsof installed check if tcp port 1712 is in use ?

Robert-Jan

Re: EMS /rdbms not avilable error

jayachandran.g — Thu, 30 Mar 2006 09:21:26 GMT

Yes It was checked already and found that the port was in use...

When I stoppe all the process it was in Time_Wait status...

Re: EMS /rdbms not avilable error

jayachandran.g — Fri, 31 Mar 2006 11:03:06 GMT

In some cases I have found that once we edit the snmpd.conf after installing the EMS.. then we may require to reinstall the EMS is it true..