3 Day 0 Scripts

This topic provides information on Day 0 Scripts.

Perform the below steps to Day 0 Scripts:

  1. Check out PLATO_Day0_Script.sql which is also available in same shipment installer path.

    Ex : /scratch/obma_installer/Day0Script

    • Edit and replace the Host name.
    • Example: Insert into PLATO.PROPERTIES (ID,APPLICATION,PROFILE,LABEL,KEY,VALUE) values (PROPERTIES_ID_SEQ.NEXTVAL,'obis-process-driver-services','jdbc','jdbc','spring.cloud.stream.kafka.binder.brokers','<HOST_NAME>:9092').
    • After replacing the above column, Run this SQL script in PLATO Schema.
  2. Check out PLATOUI_Day0_Script.sql which is also available in the same shipment installer path.
    • Run the SQL script in PLATO UI schema.
    • Example: UPDATE PRODUCT_SERVICES_ENV_LEDGER SET URL = REPLACE(URL, '8006', '8082');
    • After replacing the above property, run this SQL script in PLATOUI Schema.
  3. Check out ERTB_MSGS_Day0_Script.sql which is also available in same shipment installer path.

    Run this SQL script in FCIS Schema. Example : DISTBITRENV

    Note:

    Please make sure Release Configuration should not be enabled in WebLogic.
  4. Execute the obis_installer.

    cd /scratch/obma_installer/chef-reposh obis_installer.sh

    It will take around 20 mins to complete obis setup.

  5. Verify OBIS installation completed.

    cd /scratch/obma_installer/chef-repo obis_installer.log

    Note:

    Use the encryption utility provided at Section Encryption Logic.