First, create an Oracle Database table WLSLOG using the following SQL script. The SQL script may be run from SQL*Plus.
CREATE TABLE OE.WLSLOG (ID VARCHAR2(255) PRIMARY KEY, TIME_STAMP VARCHAR2(255), CATEGORY VARCHAR2(255), TYPE VARCHAR2(255), SERVERNAME VARCHAR2(255), CODE VARCHAR2(255), MSG VARCHAR2(255));
INSERT INTO OE.WLSLOG (ID, TIME_STAMP, CATEGORY, TYPE, SERVERNAME, CODE, MSG) values (‘catalog1′,’Apr-8-2014-7:06:16-PM-PDT’,’Notice’,’WebLogicServer’,’AdminServer’,’BEA- 000365′,’Server state changed to STANDBY’);
INSERT INTO OE.WLSLOG (ID, TIME_STAMP, CATEGORY, TYPE, SERVERNAME, CODE, MSG) values (‘catalog2′,’Apr-8-2014-7:06:17-PM-PDT’,’Notice’,’WebLogicServer’,’AdminServer’,’BEA- 000365′,’Server state changed to STARTING’);
INSERT INTO OE.WLSLOG (ID,TIME_STAMP, CATEGORY, TYPE, SERVERNAME, CODE, MSG) values (‘catalog3′,’Apr-8-2014-7:06:18-PM-PDT’, ‘Notice’, ‘WebLogicServer’, ‘AdminServer’, ‘BEA-000365’, ‘Server state changed to ADMIN’);
INSERT INTO OE.WLSLOG (ID,TIME_STAMP, CATEGORY, TYPE, SERVERNAME, CODE, MSG) values (‘catalog4′,’Apr-8-2014-7:06:19-PM-PDT’, ‘Notice’, ‘WebLogicServer’, ‘AdminServer’, ‘BEA-000365’, ‘Server state changed to RESUMING’);
INSERT INTO OE.WLSLOG (ID,TIME_STAMP, CATEGORY, TYPE, SERVERNAME, CODE, MSG) values (‘catalog5′,’Apr-8-2014-7:06:20-PM-PDT’, ‘Notice’, ‘WebLogicServer’, ‘AdminServer’, ‘BEA-000361’, ‘Started WebLogic AdminServer’);
INSERT INTO OE.WLSLOG (ID,TIME_STAMP, CATEGORY, TYPE, SERVERNAME, CODE, MSG) values (‘catalog6′,’Apr-8-2014-7:06:21-PM-PDT’, ‘Notice’, ‘WebLogicServer’, ‘AdminServer’, ‘BEA-000365’, ‘Server state changed to RUNNING’);
INSERT INTO OE.WLSLOG (ID,TIME_STAMP, CATEGORY, TYPE, SERVERNAME, CODE, MSG) values (‘catalog7′,’Apr-8-2014-7:06:22-PM-PDT’, ‘Notice’, ‘WebLogicServer’, ‘AdminServer’, ‘BEA-000360’, ‘Server started in RUNNING mode’);
Source: Vohra Deepak (2015), Pro MongoDB™ Development, Apress; 1st ed. edition.