Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have 2 databases running on different virtual servers. I have some database processes running on one node. These processes connect to Database Gateway (PG4MQ) and process the messages.

I need to start the process manually. I need to write a script that will monitor the node on which the processes are running and if the node is down or not running then these process will automatically start on the other node.

Can someone tell me is this feasible or not, if feasible then how can this be achieved?

Databases installed on RHEL 5.8. OEM, Grid, DBCA and Oracle Net services are not available.

share|improve this question

migrated from stackoverflow.com May 26 '13 at 11:56

This question came from our site for professional and enthusiast programmers.

    
I'm not sure what you mean by "database processes". Could you elaborate on exactly what those are? –  Mat May 26 '13 at 13:09
    
The processes are application specific that runs on the database.It is the stored PL/SQL package in the database that is running in a sql session.These functions and procedures in the stored packages connect to PG4MQ and then to IBM webspehere MQ to read the messages o the queue. –  Harsh May 26 '13 at 14:30
add comment

1 Answer

Because both of them are virtual servers (you didn't mention the technology used (ESX/KVM...), you can try this:

** The more info you provide, the better solutions you'll get.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.