Issue with multiple databases in AppHA Oracle Service Group
Created: 15 Jun 2012 | 2 comments
Hi,
I am facing the problem in which I have two databases in the single service group under AppHA.
In case of schedule maintenance of one of the Database I use to freeze the service group and shutting down the database,, at the same time my 2nd database also went down.
In the same ref. I have other server in which it is working fine with multi instance databse.
Please suggest what I need to compare in the server having issue with the server in which there is no issue.
Please suggest.
Discussion Filed Under:
Comments 2 Comments • Jump to latest comment
What exactly is the configuration difference between your two servers, where on one the multiple instances behave fine and other causes the issue? The SID should be unique for the multiple instances which I suppose must be the case. However please do check, your SID, Oracle owners, Home attributes. In case you start just the one instance, and then probe another (without starting second instance) check the behaviuor , whether VCS reports both of them ONLINE ? When you say your 2nd Database instance goes down, does it get offline'd or reported as FAULTED in VCS?
Hi Ranjan,
It would help if you could share main.cf contents.
--
regards,
Prasanna
Would you like to reply?
Login or Register to post your comment.