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.
    • 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 same shipment installer path.
    • Edit and replace the url column with the Host name.
    • Example: UPDATE platoui.product_services_env_ledger set url = 'https://<HOST_NAME>:8082'; Replace the ‘jdbc','flyway.domain.schemas '.
    • 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.

    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

    cd/scratch/obma_installer/deployables/apps/platoinfra

  6. Set java home path export JAVA_HOME=<java_path>

    $JAVA_HOME/bin/keytool -import -alias <CERTIFICATE_ALIAS_NAME> -keystore $JAVA_HOME/lib/security/cacerts -file <CERTIFICATE_NAME>

    $JAVA_HOME/bin/keytool -import -v trustcacerts -alias <CERTIFICATE_ALIAS_NAME> -keystore <KEYSTORE_FILE> -file <CERTIFICATE_FILE> -keypass <keypass> -storepass <STOREPASS>

    nohup java -jar plato-apigateway-router-9.1.0.jar --plato.services.config.uri=https://<HOSTNAME>:<UICONFIG_SERVICE_PORT_NO> --plato.service.logging.path=<LOG_PATH> --server.ssl.enabled=true --server.ssl.key-store=<KEYSTORE_FILE> --key-store-password=<ENCRYPTED_KEY_STORE_PASSWORD> --server.ssl.trust-store=<TRUST_STORE_FILE> --trust-store-password=<ENCRYPTED_TRUST_STORE_PASSWORD> --salt=<ENCRYPTED_SALT>

    Note:

    Use the encryption utility provided at Section Encryption Logic.