So I have a request to create a new service in the RAC oracle database. Currently we are letting our application to connect to only one instance and load balancing our applications.But for this one application we wanted service to run on more than one instance actually on all nodes to see if the performance improve of datawarehouse loads. So below steps can be used to created a dedicated NEWSR new service and can be run on all nodes.
srvctl start service -d DWAP -s NEWSR
Perform a few log switches on primary, then create services on local and remote standby if this is a Prod database.
1. Login to your server as oracle or sudo oralce and set your database environment.
2. Run the below command where DWAP is database name and NEWSR is a service name as an example you can name as per your need.
srvctl add service -d DWAP -s NEWSR -r DWAP2,DWAP3,DWAP4,DWAP5 -a DWAP1,DWAP6,DWAP7,DWAP8 -l PRIMARY,SNAPSHOT_STANDBY -q TRUE -e SESSION -m BASIC -w 10 -z 150
srvctl start service -d DWAP -s NEWSR
Perform a few log switches on primary, then create services on local and remote standby if this is a Prod database.
That is it you have a service added to your RAC databases services using server control utility.
No comments:
Post a Comment