Differences

This shows you the differences between two versions of the page.

--- database:oracle:rac:commands [2018/12/03 20:32] – odefta
+++ database:oracle:rac:commands [2018/12/03 21:15] – odefta
@@ Line 193: / Line 193: @@
 Instance SNT2 is running on node lptxrac122n2
 </code>
+===== Find server pool name =====
+<code>
+srvctl status srvpool
+</code>
+Possible output:
+<code>
+Server pool name: Free
+Active servers count: 0
+Server pool name: Generic
+Active servers count: 2
+</code>
+===== Automate start / stop PDB =====
+Adding the service (for admin-managed database) with PDB name SNTL:
+<code>
+srvctl add service -db SNT -service plug -preferred SNT1 -available SNT2 -tafpolicy BASIC -policy AUTOMATIC -failovertype SELECT -failovermethod BASIC -failoverretry 5 -pdb SNTL -verbose
+</code>
+Start the service:
+<code>
+srvctl start service -db SNT -s plug
+</code>