- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: DB Farm (DB Consolidation) Possible on RAC or ...
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
тАО10-02-2007 07:43 AM
тАО10-02-2007 07:43 AM
DB Farm (DB Consolidation) Possible on RAC or SGeRAC?
My proposal is to house some 7-9 large DB instances (3-5 TB each) onto a clustered rx8640 pair (or trio). Each DB instance will have dedicated FC Channels and network connectivity to the Apps nodes, etc. willbe via trunked network (4x1GB).
My question is .. CAn Oracle RAC or SGeRAC support multiple DB's ? Is this even a viable ? ANy words of advice?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-08-2007 01:24 AM
тАО10-08-2007 01:24 AM
Re: DB Farm (DB Consolidation) Possible on RAC or SGeRAC?
My Question is simply -- CAn Oracle RAC or SGeRAC support multiple DB instances? Or is it recommended to just have one DB instance per cluster?
Thanks a Mil!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-08-2007 04:25 AM
тАО10-08-2007 04:25 AM
Re: DB Farm (DB Consolidation) Possible on RAC or SGeRAC?
Yes SGeRAC and/or RAC can support multiple DB instances... the real decision here is what your Oracle stack looks like - i.e. all Oracle clusterware (using ASM), or SGeRAC, and if SGeRAC, then using SLVM, ASM over SLVM, CVM, or CFS over CVM.
You mentioned vPars in the mix there. Be aware that currently Oracle RAC is not qualified in a 'dynamic' vPars configuration (i.e. one where the number of CPU cores changes whils RAC/clusterware is up).
HTH
Duncan
I am an HPE Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-08-2007 04:31 AM
тАО10-08-2007 04:31 AM
Re: DB Farm (DB Consolidation) Possible on RAC or SGeRAC?
Thanks and exactly the answer I was looking for. You mentioned RAC (and SGeRAC?) is currently not supported within Dynamic CPU environments (i.e. vPars) - can you pls. point me to a document stating so?
We've not yet decided whether to use just RAC (and Oracle's ClusterWare_ or even SGeRAC but it will most likely be CFS of CVM if I loose out on the RAW versus Cooked Battle.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-08-2007 05:37 AM
тАО10-08-2007 05:37 AM
Re: DB Farm (DB Consolidation) Possible on RAC or SGeRAC?
Of course Oracle RAC or RAC with SG can support multiple DB's. Factors to check:
1) Adequate memory on active node for all simultaneously open instances.
2) Adequate disk space.
3) Adequate I/O bandwidth
4) Have a plan for distributing I/O evently.
5) Does the application support active-active database if you want this feature.
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
тАО10-08-2007 05:38 AM
тАО10-08-2007 05:38 AM
Re: DB Farm (DB Consolidation) Possible on RAC or SGeRAC?
Of course Oracle RAC or RAC with SG can support multiple DB's. Factors to check:
1) Adequate memory on active node for all simultaneously open instances.
2) Adequate disk space.
3) Adequate I/O bandwidth
4) Have a plan for distributing I/O evently.
5) Does the application support active-active database if you want this feature.
6) Kernel configuration correct for a new higher high water mark on critical parameters (test well to get this right).
SEP
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
тАО10-08-2007 06:14 AM
тАО10-08-2007 06:14 AM
Re: DB Farm (DB Consolidation) Possible on RAC or SGeRAC?
It's not very explicit, but its mentioned here:
http://www.oracle.com/technology/products/database/clustering/certify/tech_generic_unix_new.html
Note it states 'static vPars' are supported.
WRT to CFS vs. raw - I take it you've seen the whitepaper here which compares raw vs. CFS with ODM:
http://h71028.www7.hp.com/ERC/downloads/4AA1-2527ENW.pdf
HTH
Duncan
I am an HPE Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-08-2007 06:19 AM
тАО10-08-2007 06:19 AM
Re: DB Farm (DB Consolidation) Possible on RAC or SGeRAC?
I would add that the lack of support for dynamic vPars is a qualification thing (i.e. the HP and Oracle teams haven't done the tests yet), rather than a 'doesn't work' thing. As I understand it, qualification will be forthcoming early next year..
HTH
Duncan
I am an HPE Employee