Forum Discussion

mokkan's avatar
mokkan
Level 6
11 years ago

Concurrency Viloation question

Hello, If we setup oracle database and if the startup script is configured through  init  script and VCS, when we boot up the server, would it cause concurrencey vilation?  Because pid file is alr...
  • Gaurav_S's avatar
    11 years ago

    Hello,

    First need to understand what is concurrency violation, lets say if you have oracle already started via init scripts on a node (lets say node A), once VCS starts, it will detect resource already online, This is not a concurrency violation. Concurrency violation comes when VCS on other node starts, it tries to online the same Oracle resource (as per configuration it is suppose to start on B), then VCS will report a concurrency violation stating it is trying to online a resource or already onlined however found the same resource online on other node of the cluster. In this case, VCS will report concurrency violation & immediately offline the resource from node where it came online last.

    So in your setup, if you start database on node A using init scripts (ideally I would recommend to give complete control to cluster), make sure the cluster config is correct & no other manual /init scripts on node B tries to online same database outside of cluster.

    For your second question, yes Oracle agent is capable to look for PID to monitor the resource.

     

    G