Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

Services in Oracle Database 10g - Run applications on a subset of Real Application Cluser (RAC) nodes using services.



Ryan said...

Your article on services is incorrect on several points with regards to their relationship to GSD.

Tim... said...

Quite right. I've removed the references to GSD.

Cheers

Tim...

Lionel said...

The syntax for creating services with srvctl is incorrect. The 2 lists in -a and -r options are exclusive.
Should be :
srvctl add service -d ORCL -s OLTP_SERVICE -r ORCL1,ORCL2 -a ORCL3
srvctl add service -d ORCL -s BATCH_SERVICE -r ORCL3 -a ORCL1,ORCL2

Tim... said...

Hi.

The method used in this article works fine on 10g Release 1, since it's how the services running on my production RAC were created.

Perhaps it has changed in release 2.

Cheers

Tim...

Mark said...

Lionel is correct in that the -a and -r instances are mutually exclusive. If you run

srvctl add service -d ORCL -s OLTP_SERVICE -r ORCL1,ORCL2 -a ORCL1,ORCL2,ORCL3
then an ocrdump will show that all instances are available for the service and none are preferred.

srvctl add service -d ORCL -s OLTP_SERVICE -r ORCL1,ORCL2 -a ORCL3
is correct.

This confused me for a while so please correct the article.

Mark

Tim... said...

Hi.

As I said before, this syntax used in the article works fine for me on 10g Release 1, but I've altered the article as requested sinice it's proved a problem to at least 2 people. :)

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

Add your comments here.
Name
Comment
(max 400 chars - plain text)