SERVICE ORACLE

• Liste

SET lines 600
col name format a20
col network_name  format a40
SELECT name,network_name FROM dba_services;

• Statut

SELECT name,network_name FROM v$active_services;

• création

BEGIN
DBMS_SERVICE.CREATE_SERVICE(
service_name => 'SERVICE_NAME',
network_name => 'SERVICE_NAME_NETWORK'
);
END;
/

• Start

BEGIN
DBMS_SERVICE.START_SERVICE(
service_name => 'SERVICE_NAME'
);
END;
/

• Stop

BEGIN
DBMS_SERVICE.STOP_SERVICE(
service_name => 'SERVICE_NAME'
);
END;
/

• Suppression

BEGIN
DBMS_SERVICE.DELETE_SERVICE(
service_name => 'SERVICE_NAME'
);
END;
/

srvctl add service -service digitaluat.bsisa.gva.uat.db -db C3IUATD1DR -pdb DIGITALUAT -role primary -preferred C3IUATD1DR1,C3IUATD1DR2