Differences

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

--- oracle_services [2020/10/24 18:08] – andonovj
+++ oracle_services [2020/10/24 18:14] (current) – andonovj
@@ Line 45: / Line 45: @@
   * notification - Enables / Disables Fast Application Notifications (FAN) for OCI Connections.
-  * failovertype - Enables Application Continuity, if set to "TRANSACTION" and TAF (for OCI) if set to **SELECT** or **SESSION**.
+  * failovertype - Enables Application Continuity, if set to "TRANSACTION" and TAF (for OCI) if set to **SELECT** or **SESSION**. If you set -failovertype to TRANSACTION, then you must set -commit_outcome to **TRUE**.
-    * **NOTE** If you set -failovertype to TRANSACTION, then you must set -commit_outcome to **TRUE**.
   * clbgoal (Connection Load Balancing Goal) - Indicates to Oracle for what kind of connections this service will handle. Specify **SHORT** if you will do short transactions and **LONG** if you will use this service for BATCH jobs.
@@ Line 102: / Line 101: @@
   * preferred (Oracle RAC Only) - List of preferred instances where the service to run. The list of preferred instances must be mutually exclusive with the list of available instances.
   * available (Oracle RAC Only) - List of available instances where the service CAN run in case the preferred aren't available.
   * tafpolicy - TAF policy specification. You can only use PRECONNECT when you specify the -preferred and -available parameters.
-  *
+These parameters are exclusive for a service on a admin managed database. The rest of the parameters are the same as the policy managed. If it will help you understand services better. You have to answer yourself the following questions.
+  - Where the service will run: (Singleton/Uniform or Preferred/Available)
+  - How we define a failover: (failoverretry/failovermethod/failoverdelay)
+  - What happens when a failover occurs: (tafpolicy, failovertype and others)
+There are more, but these 3 are the main ones. Good luck.
+=====Conclusion=====
+Services are instrument through which we allow access to our database. These services can behave in different ways and it is up to us as DBAs to set them correct, so the client will be able to access his data.