Monitoring WebLogic Server 12c - Oracle WebLogic Server 12c Advanced Administration - page 176

ATTRTYPE number default NULL,
ATTRVALUE varchar2(4000)
);
DROP SEQUENCE MON_EVENTS;
CREATE SEQUENCE MON_EVENTS
START WITH 1
INCREMENT BY 1
NOMAXVALUE;
DROP TRIGGER TRIG_EVENTS;
CREATE TRIGGER TRIG_EVENTS
BEFORE INSERT ON WLS_EVENTS
FOR EACH ROW
BEGIN
SELECT MON_EVENTS.NEXTVAL INTO :NEW.RECORDID FROM DUAL;
END;
/
DROP SEQUENCE MON_HVST;
CREATE SEQUENCE MON_HVST
START WITH 1
INCREMENT BY 1
NOMAXVALUE;
DROP TRIGGER TRIG_HVST;
CREATE TRIGGER TRIG_HVST
BEFORE INSERT ON WLS_HVST
FOR EACH ROW
BEGIN
SELECT MON_HVST.NEXTVAL INTO :NEW.RECORDID FROM DUAL;
END;
/
Follow these steps to create the JDBC data source:
1. Access the Administration Console with your web browser at http://adminhost.
domain.local:7001/console .
2. Click on the Lock & Edit button to start a new edit session.
3. Click on the plus sign to open the Services tree on the left and then click
Data Sources.
4. Click on the New button and click on Generic Data Source.