SRVCTL: Add Preferred Instances

Dedicated to an old friend and colleague.
1.     Add the service. Please take note, the instance names are in UPPER case.
[oowner@gxtbdb01 ~]$ srvctl status service -d utldb
[oowner@gxtbdb01 ~]$ srvctl add service -d utldb -s test -r UTLDB1
2.     Start it
[oowner@gxtbdb01 ~]$ srvctl status service -d utldb
Service test is not running.
[oowner@gxtbdb01 ~]$ srvctl start service -d utldb -s test
[oowner@gxtbdb01 ~]$ srvctl status service -d utldb
Service test is running on instance(s) UTLDB1
3.     Modify it to add a new instance to the preferred list
[oowner@gxtbdb01 ~]$ srvctl modify service -d utldb -s test -n -i UTLDB1,UTLDB2
[oowner@gxtbdb01 ~]$ srvctl status service -d utldb
Service test is running on instance(s) UTLDB1
4.     Service has to be restarted for the changes to take into effect
[oowner@gxtbdb01 ~]$ srvctl stop service -d utldb -s test
[oowner@gxtbdb01 ~]$ srvctl start service -d utldb -s test
[oowner@gxtbdb01 ~]$ srvctl status service -d utldb
Service test is running on instance(s) UTLDB1,UTLDB2

Cheers!
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Musings

Things I see and learn!

Thoughts from James H. Lui

If you Care a Little More, Things Happen. Bees can be dangerous. Always wear protective clothing when approaching or dealing with bees. Do not approach or handle bees without proper instruction and training.

bdt's oracle blog

Sharing experience (by Bertrand Drouvot)

Frits Hoogland Weblog

IT Technology; Oracle, linux, TCP/IP and other stuff I find interesting

Vishal desai's Oracle Blog

Just another WordPress.com weblog

%d bloggers like this: