Ask Your Question
1

mco query service doesn't work for oracle

asked 2014-08-18 03:40:59 -0500

dmo54 gravatar image

updated 2014-08-18 12:13:17 -0500

ramindk gravatar image

Hi guys, I' am trying to make mco query to find the servers running Oracle and I've noticed that it doesn't work, see below the outputs I've received :

First, you can notice that Oracle is running on server "officecentral :

[root@officecentral ~]# chkconfig --list | grep ora
oracle          0:arrêt 1:arrêt 2:**marche**    3**:marche**    4:arrêt 5:**marche**    6:arrêt

It is also visible through the puppet console TAB "Live management" " "browse resources" "service"

Whereas when we make the mco query it is not detected :

[peadmin@puppet root]$ mco service oracle status

 * [ =======================================================> ] 4 / 4

  clientdebian.ntdev.devatiss.fr: Could not find init script for 'oracle'
  clientcentos.ntdev.devatiss.fr: stopped
  puppet.ntdev.devatiss.fr: stopped
  officecentral.ntdev.devatiss.fr: stopped  ---> **should have status "running"**

Summary of Service Status:
   stopped = 3
   unknown = 1

If I try with another service it runs so it is not a matter of reaching the server "officecentral"

[peadmin@puppet root]$ mco service pe-puppet status -F kernel=Linux

 * [ =======================================================> ] 4 / 4

   puppet.ntdev.devatiss.fr: running
   clientcentos.ntdev.devatiss.fr: running
   clientdebian.ntdev.devatiss.fr: running
   officecentral.ntdev.devatiss.fr: running

Summary of Service Status:

   running = 4

Is it a known bug ? or Do we have to use another command/syntax to check whether oracle is running ?

Thanks in advance for your support.

cheers
Denis

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2014-08-18 12:21:52 -0500

ramindk gravatar image

Does /etc/init.d/oracle status work on the machine in question? All mco does is check the service via a status call. You can actually see what it's doing with strace though you may need to install that package.

On your officecentral server run this

sudo strace -p `pgrep mco` -f -o test.log

Then run your mco command as normal. Once you get a response back crtl+c the strace and then look at the log it generated. It'll be large and confusing, but you can search for oracle which should should you the actual commands mco ran.

edit flag offensive delete link more

Comments

You're right, the command "service oracle status" failed. I had a problem with the listener but as I'm not an Oracle specialist, I didn't have the right clue. I just trust the puppet console "Live management" "browse resources" "service" that even found the service "oracle" on the server. Thanks a lot

dmo54 gravatar imagedmo54 ( 2014-08-19 04:06:06 -0500 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower

Stats

Asked: 2014-08-18 03:40:59 -0500

Seen: 156 times

Last updated: Aug 18 '14