注册服务

1、注册服务

---

BEGIN
    DBMS_SERVICE.CREATE_SERVICE(SERVICE_NAME        => 'DPC.RAILWAYDETECT.COM',
                                NETWORK_NAME        => 'DPC.RAILWAYDETECT.COM',
                                AQ_HA_NOTIFICATIONS => TRUE,
                                FAILOVER_METHOD     => 'BASIC',
                                FAILOVER_TYPE       => 'SELECT',
                                FAILOVER_RETRIES    => 180,
                                FAILOVER_DELAY      => 1);

END;
/

 

 

2、手动启动服务

---

BEGIN
    DBMS_SERVICE.START_SERVICE('DPC.RAILWAYDETECT.COM ');
END;
/

 

3、自动启动服务

---

CREATE OR REPLACE TRIGGER TRG_MANAGE_OCISERVICE
    AFTER STARTUP ON DATABASE
BEGIN
    DBMS_SERVICE.START_SERVICE('DPC.RAILWAYDETECT.COM');

END;
/