Operating System - HP-UX
1748169 Members
4457 Online
108758 Solutions
New Discussion юеВ

11.23 + SGeRac 11.18 + asm + 10g + multiple instances

 
likid0
Honored Contributor

11.23 + SGeRac 11.18 + asm + 10g + multiple instances

Hi,

I have a question, if anyone has done this before , and how you have done it.

We are runing a two rac service guard cluster, with one package(on instance database).

Now we wan't to run 3 db instances. So the problem is if only one ASM instance is supported in rac enviroments, how can I make separate packages for each DB instance.

My solution is:

1 package for the oracle clusterware(CRS,ASM)
1 package for each DB instance I have

And then set a dependency between the DB packages and the clusterware package.

I have read this doc, that suggests more or less the same:

http://www.docs.hp.com/en/8987/Use-of-SGeRAC.pdf

any of you have done something similar?, any ideas?

Thnx!
Windows?, no thanks
6 REPLIES 6
Steven E. Protter
Exalted Contributor

Re: 11.23 + SGeRac 11.18 + asm + 10g + multiple instances

Shalom,

I've not done anything similar. Tried to stay away from ASM because it adds complexity.

I think however your plan is good and should be tried in a lab.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
likid0
Honored Contributor

Re: 11.23 + SGeRac 11.18 + asm + 10g + multiple instances

Thnx Steven, I am totally with you, ASM is a pain in the ..

I prefer the old .dbf file style(or raw), and leave the storage part to people that know how its done.

But ASM (for me) is a single point of failure black box.

But ASM is what our DB admins are using, so it must have something good :?.
Windows?, no thanks
RC Park
Frequent Advisor

Re: 11.23 + SGeRac 11.18 + asm + 10g + multiple instances

I implemented a 2-node SGeRAC cluster and forced the hand of the DBA to dump ASM in favor of the relatively new Veritas CFS (Clusterd File System). It's awesome, and in my mind BETTER than ASM. Here's my short list:

1. CFS file systems mount each FS as a package
2. CFS FS's are active-active on both nodes, in other words, both servers have read/write capability so that the Database runs and instance for the db on each node, but there's only really ONE db. GREAT for HA, as you're able to independently bring down a node, but the DB stays up.
3. CFS FS's are above ground. They look just like any other standard LVM/vxfs mount point, BUT they must be created and managed using Veritas tools.

I could go on, but FYI, I did a presentation at the '08 Tech forum on this topic, so I believe I know something 'bout this one :) and can share more if needed.

RCP
RC Park
Frequent Advisor

Re: 11.23 + SGeRac 11.18 + asm + 10g + multiple instances

Sorry. Should have mentioned that you have to get extra licensing for this product and it ain't cheap, but well worth it, IMHO.

RCP
likid0
Honored Contributor

Re: 11.23 + SGeRac 11.18 + asm + 10g + multiple instances

Thnx, Rc park

We have CFS working on two tibco EMS active-active clusters, and as you say it works just fine.

If you nice insight docs or presentantions on cfs it would be great if you shared them.

The docs about CFS on docs.hp.com are ok, but it's allways nice to geat some extra info
Windows?, no thanks
RC Park
Frequent Advisor

Re: 11.23 + SGeRac 11.18 + asm + 10g + multiple instances

Don't close the thread (or assign points to this answer) - I just took a new job, and need to figure out what I did with all my stuff, including the files you're requesting. Soon as I can locate, I'll post.

-RCP