Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Concurrency Viloation question

Created: 30 Mar 2014 • Updated: 28 Apr 2014 | 4 comments
mokkan's picture
This issue has been solved. See solution.

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 already there

Operating Systems:
Discussion Filed Under:

Comments 4 CommentsJump to latest comment

mokkan's picture

The reason why I am asking that, everytime we reboot the second node, we get concurrent violation issue. I thought it would have been configured in /etc/oratab file. It is set it as now. We are running AIX. Do I need to check any other file to make sure that database is not starting in boot up.

apachedb1:/opt/app/oracle/product/11.2.0.2:N

Clifford Barcliff's picture

Hi.  Please share with us the version of VCS, Oracle, and AIX. 

Are you using the VCS Oracle Agent to manage Oracle?

Cheers

Clifford Barcliff

My customers spend the weekend with family, not in the datacenter.

mokkan's picture

yes, VCS 6.01 and AIX 7.1 and we are using oracle Agnet to manage.  Does  oracle agent look for PID file and monitor the resource?

Gaurav Sangamnerkar's picture

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

PS: If you are happy with the answer provided, please mark the post as solution. You can do so by clicking link "Mark as Solution" below the answer provided.
 

SOLUTION