11.23 + SGeRac 11.18 + asm + 10g + multiple instances (77 Views)
Reply
Honored Contributor
likid0
Posts: 981
Registered: ‎03-01-2005
Message 1 of 7 (77 Views)

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
Exalted Contributor
Steven E. Protter
Posts: 33,806
Registered: ‎08-15-2002
Message 2 of 7 (77 Views)

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
Honored Contributor
likid0
Posts: 981
Registered: ‎03-01-2005
Message 3 of 7 (77 Views)

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
Frequent Advisor
RC Park
Posts: 38
Registered: ‎01-27-2010
Message 4 of 7 (77 Views)

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
Frequent Advisor
RC Park
Posts: 38
Registered: ‎01-27-2010
Message 5 of 7 (77 Views)

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
Honored Contributor
likid0
Posts: 981
Registered: ‎03-01-2005
Message 6 of 7 (77 Views)

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
Frequent Advisor
RC Park
Posts: 38
Registered: ‎01-27-2010
Message 7 of 7 (77 Views)

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
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.