- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - Linux
- >
- Oracle and four node cluster
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-22-2006 02:18 AM
тАО05-22-2006 02:18 AM
I do not have much experience with clustering on linux.
Requirement:
3 servers have to run one or two Oracle instances (not RAC). If one node fails, 4th server has to take over the instance(s) of failed one.
Any suggestion how to make it would be welcome.
Is it possible to make active/active configuration, i.e. that every server run one instance and take over instance of failed server? If so, how?
Wcich cluster software to use?
Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-22-2006 02:52 AM
тАО05-22-2006 02:52 AM
Re: Oracle and four node cluster
Using this software, you can configure the Oracle as required for your installation. Every node can run an instance of oracle and if the node fails, another node can start both instances.
You need a shared disk storage for this (For example MSA, EVA, etc). It's also recommended that you use a fence device for maintaining data integrity. Check the Red Hat Cluster Suite documentation for detailed information. The fence device can be for example, HP RILO available on most servers or a Brocade SAN Switch used to connect the storages.
Every node has access to the shared disk storage. If a node fails, as the other nodes have access to the storage also, you can configure to start the failed oracle instance in any other node.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-22-2006 04:01 AM
тАО05-22-2006 04:01 AM
Re: Oracle and four node cluster
Active-Active is not possible without RAC. It would immediately corrupt the Oracle database on shared storage.
If the data was read only and hosted on local disk of each node, it would be possible to run oracle on all nodes. There would however be no failover under this scenario.
Red Hat Clustering or Service Guard for Linux can handle an active-backup clustering scenario for you.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-22-2006 07:34 AM
тАО05-22-2006 07:34 AM
Re: Oracle and four node cluster
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-22-2006 11:40 AM
тАО05-22-2006 11:40 AM
Re: Oracle and four node cluster
http://www.hp.com/go/sglx
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-22-2006 06:20 PM
тАО05-22-2006 06:20 PM
Re: Oracle and four node cluster
Looks like there is a good way to do it.
I have to replace TRU64 cluster with linux solution. With active/active I meant no dedicated standby server and cluster file system.
Can you post some links with documentation?
Which clustering software is better and which is cheaper?
Is there some "best practice" example?
Shared storage is EVA3000. Which Redhat distribution (or SUSE?) is the best choice?
Do I need secure path?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-22-2006 06:32 PM
тАО05-22-2006 06:32 PM
Re: Oracle and four node cluster
As for pricing, the list price is roughly $1300 per server, but check with your distributor or sales person for exact pricing. Various support options are available. The Oracle toolkit list is $995.
The latest full documentation is available as well:
http://docs.hp.com/en/ha.html#Serviceguard%20for%20Linux
or more specifiically:
http://docs.hp.com/en/B9903-90046/B9903-90046.pdf and
http://docs.hp.com/en/B9903-90048/B9903-90048.pdf
Hope this is a useful start
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-22-2006 11:07 PM
тАО05-22-2006 11:07 PM
Re: Oracle and four node cluster
I'll prefer RH Cluster Suite instead of SG because in this case you have one vendor and one support point == Red Hat. In addition SG uses (AFAIK) closed source kernel modules, so you cannot use the latest recommended kernel version, but must to wait when HP will release appropriate SG modules version.
As for securepath - you can use Qlogic driver failover.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-23-2006 12:45 AM
тАО05-23-2006 12:45 AM
Re: Oracle and four node cluster
Thanks for interesting data.
Vitaly and "Serviceguard for Linux", what are feature differences between RH cluster and HP Serviceguard cluster?
Also would like to use RedHat GFS. I have seen that it works OK with Serviceguard, so no problem with that.
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-23-2006 01:36 AM
тАО05-23-2006 01:36 AM
Re: Oracle and four node cluster
Serviceguard does not use closed sourse kernel components. We have had no issues with support from RedHat or Novell(Suse).
Customers can buy RedHat or (I believe) SUSE from HP and get support from HP.
Serviceguard for Linux is based on Serviceguard for HP-UX. That means it has a history greater than 10 years and we are constantly looking for improvements. One thing we focus on is no single point of failure in the cluster. For any cluster you should look at every component within that cluster and see if its failure can possibly take down the cluster or worse.