OraFAQ Forum: RAC & Failsafe » services management

Home » Server Options » RAC & Failsafe » services management (11.2.0.2.0 )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

services management [message #563857]

Fri, 17 August 2012 10:11

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Hello Expert,

We have 5 node RAC database. I want to user 2 node for OLTP and 3 for DSS system. Please guide now to create service for the requirement.

Thanks in advance.

Report message to a moderator

Re: services management [message #563859 is a reply to message #563857]

Fri, 17 August 2012 10:15

John Watson
Messages: 8963
Registered: January 2010
Location: Global Village

Senior Member

That would depend on whether your database is policy managed or administrator managed. And on your requirements for high availability, fault tolerance, load balancing.

Report message to a moderator

Re: services management [message #563860 is a reply to message #563859]

Fri, 17 August 2012 10:30

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Right John,

Can we manage our requirement if we have administrator managed database.? Or only way is to create a policy managed services.

Report message to a moderator

Re: services management [message #563862 is a reply to message #563860]

Fri, 17 August 2012 10:46

John Watson
Messages: 8963
Registered: January 2010
Location: Global Village

Senior Member

Possibly. I don't know what your requirements are.

Report message to a moderator

Re: services management [message #563870 is a reply to message #563862]

Fri, 17 August 2012 11:31

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

It is same to use 2 node for OLTP and 3 for DSS system from % node RAC database. System we not yet built, we are in planning phase to built the system.

Report message to a moderator

Re: services management [message #563873 is a reply to message #563870]

Fri, 17 August 2012 11:36

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

so set up a 2 node RAC & a 3 node RAC

Report message to a moderator

Re: services management [message #563875 is a reply to message #563870]

Fri, 17 August 2012 11:40

John Watson
Messages: 8963
Registered: January 2010
Location: Global Village

Senior Member

How many databases? How many nodes in the cluster? What should happen if nodes fail? Are instances permitted to share nodes?

Report message to a moderator

Re: services management [message #563877 is a reply to message #563875]

Fri, 17 August 2012 11:54

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

I apologize, it seems i have wrongly put the question.

1 Database
5 nodes(servers), each node will have 1 instance. Total 5 instance.

We have to plan to give 2 instance for OLTP, so in case anyone fails, it will be managed by another one. Same for next 3 instances which will be used by DSS and will be permitted to share the instance in-between.

Report message to a moderator

Re: services management [message #563878 is a reply to message #563877]

Fri, 17 August 2012 11:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://docs.oracle.com/cd/E11882_01/server.112/e25789/glossary.htm#CNCPT2076

for some, many, most folks the OLTP is a separate database from the Data Warehouse database.

[Updated on: Fri, 17 August 2012 12:02]

Report message to a moderator

Re: services management [message #563880 is a reply to message #563877]

Fri, 17 August 2012 12:10

John Watson
Messages: 8963
Registered: January 2010
Location: Global Village

Senior Member

So that is simple enough: administrator managed, and set up two services with preferred and available instances accordingly.
You might want to consider why you are using RAC, though. Is it for performance? Scalability? Fault tolerance? Don't just say "all three", that will indicate that you haven't thought it through. Many RAC isntallations fail, because the expectations were not set correctly. You need to be absolutely clear on why you are using it, and how your chosen topology will meet that objective.

Report message to a moderator

Re: services management [message #563970 is a reply to message #563880]

Sun, 19 August 2012 06:13

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Thanks John Watson & other experts.

Report message to a moderator

Previous Topic:	Interface eth0 checked failed (host=rac1)
Next Topic:	Failed to upgrade Oracle Cluster Registry configuration

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 19 23:01:54 CST 2025