Shell Programming and Scripting

Hello,

Code:

srvctl config database -d db_name

The above command gives the configuration information for a specific database.
My goal is:

1. Retrieve database name on the $host from the list one by one for which I am using below code

Code:

for database in `crsctl status res -n $host| grep -E "ora.*\.db" | awk -F"." '{print $(NF-1)}'`

2.Check if service is running on preferred or available instance of the database.
Below example:

Code:

srvctl status service -d ksr

Service knuggets_ksr.world is running on instance(s) ksr_01
Service ksadmin_ksr.world is running on instance(s) ksr_01

Code:

srvctl config service -d ksr -s knuggets_ksr.world

Service name: knuggets_ksr.world
Service is enabled
Server pool: ksr_knuggets_ksr.world
Preferred instances: ksr_01
Available instances: ksr_02

From first command I get to know both the services are running on ksr_01 instance of the database.

From second command I get to know ksr_01 is the preffered instance of this service.

4. Check if the preferred instance is running on the $host or not.($host is the argument passed in the script)

Code:

srvctl status database -d ksr

ksr_01 is running on node1
ksr_02 is running on node 2

5.Depending on another argument which would be passed while running the script whether the service to be relocated to available or preferred instance I will use flag

Code:

./relocate.sh -n node1 -t preferred

This would mean that all the services which are running on available instances for those databases hosted on node 1 should be relocated to preferred instance if the preferred instance is on node 1 for that service.

This is a cluster envrionment and multiple instances run on different nodes for the same database.

6. Relocate the service

Code:

srvctl relocate service -d $database -i <current node> -t <target node $node1> -s <$service>

Best regards,
Vishal

Please post the output of srvctl config database, don't add -d database! What's the Oracle version?

Check this script from Ilmar Kerm.
You're aware that the service relocation will cause a possibly short outage, aren't you?

Please refer to the below output

Code:

srvctl config database
alfresut
clientut
cmdbut
cpaut
engut
ksrut
lms_dry
mckstgut
miutl2ut
orsut
orsut9fm
personut
sgraphut
timextut
miutl1ut
p3fi_dev
mhidwut
mckdwut
mckdwst

This has both 10g and 11g databases.


Best regards,
Vishal

Thanks! As I said, you don't need to use crsctl ... | grep ... to get the names of the databases resources, srvctl config database is sufficient.
You could use a callout script like the one, I mentioned above. Or you still want to write your own script?

But I want to relocate services fro a specific node maintenance activity.During maintenance of one node I want to write a script that whatever services are running on preferred instances on node 1 they be relocated to their available instances.

Appreciate your help.

Best regards,
Vishal

Why do you think you need a script for that? It happens automatically when you bring the resources or the node down ...
If I understand correctly, all you need is a simple crsctl stop cluster on the node that needs maintenance.

You are right.That happens automatically but we want to relocate the services before stopping the cluster so that if any issue is there while relocating it can be taken care of.
Moreover,when the node would be back up then the services won't fail back to the preferred instance hence for that also a script is required specific to a node services.



Best regards,
Vishal