Différences

Ci-dessous, les différences entre deux révisions de la page.

--- oracle:database:service [20/02/2025 08:44] – mdl
+++ oracle:database:service [20/02/2025 08:56] (Version actuelle) – mdl
@@ Ligne 1: / Ligne 1: @@
-====== CREATION SERVICE ORACLE ======
+====== SERVICE ORACLE ======
 == NON Clusterware ==
+  * Liste
+<code PLSQL>
+set lines 600
+col name format a20
+col network_name  format a40
+SELECT name,network_name FROM dba_services;
+</code>
+  * Statut
+<code PLSQL>
+SELECT name,network_name FROM v$active_services;
+</code>
+  * création
+<code PLSQL>
+BEGIN
+DBMS_SERVICE.CREATE_SERVICE(
+service_name => 'SERVICE_NAME',
+network_name => 'SERVICE_NAME_NETWORK'
+);
+END;
+/
+</code>
+  * Start
+<code PLSQL>
+BEGIN
+DBMS_SERVICE.START_SERVICE(
+service_name => 'SERVICE_NAME'
+);
+END;
+/
+</code>
+  * Stop
+<code BASH>
+BEGIN
+DBMS_SERVICE.STOP_SERVICE(
+service_name => 'SERVICE_NAME'
+);
+END;
+/
+</code>
-== Clusterware==
+  * Suppression
+<code BASH>
+BEGIN
+DBMS_SERVICE.DELETE_SERVICE(
+service_name => 'SERVICE_NAME'
+);
+END;
+/
+</code>
+ \\
+== Clusterware==
+<code BASH>
+srvctl add service -service digitaluat.bsisa.gva.uat.db -db C3IUATD1DR -pdb DIGITALUAT -role primary -preferred C3IUATD1DR1,C3IUATD1DR2
+</code>