====== 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>

  * 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>