Re: Inserting an Oracle Instance into Clustered Oracle

hebert.henry_at_eds.com (Hebert) wrote in message news:<5ee2b473.0403051559.4c408947_at_posting.google.com>...
> I am using Sun Cluster 2.20 and Solaris 2.8. Attempting to insert an
> additional instance "pndap" with the HAORACLE insert command, results
> in this error message: "Cannot determine host members." I am quite
> sure what it really means. Is there another way to accomplish the same
> thing manually. For your information, there is an instance "pnda" that
> is not being used. I would appreciate any suggestion.
>
> Thanks!

Did you make sure the cluster was setup correctly? Did you define an additional listener (running on a different port) for the new instance?
Do you have the instance defined on both nodes on the cluster? Do you have init.ora and the like on a *shared* disk (which will failover when necessary).
Just a few questions on information you didn't provide with your 'It doesn't work' type of request.

There is no way to accomplish this manually, or you must resort to hacking your way out.
BTW Sun has desupported Sun Cluster 2.2 quite a while ago, and Oracle likely won't support Suncluster configurations, so I guess you will be soon stuck.

Sybrand Bakker
Senior Oracle DBA Received on Mon Mar 08 2004 - 09:14:54 CET