Products | Versions |
---|---|
TIBCO Order Management - Long Running | 5.0.1 HF-01 |
Following are the steps that need to be followed to install OMLR 5.0.1 HF-01 since the read me hasn't added the complete steps to install the hotfix.
1. Shut down all other TIBCO applications that are running. 2. Back up {TIBCO_HOME}/om-lr/5.0/roles/{service_Name}/standalone/config directories on all services (Order Management Server, Automated Order Plan Development, Order Capture System, Order Management System User Interface, and Configurator) from te previous version. 3. Copy the TIB_om-lr_5.0.1-HF1.zip hotfix archive file to a temporary location and extract all files using unzip TIB_om-lr_5.0.1-HF1.zip 4. Create following directories in $OM_HOME/externalLib directory and copy required third party libraries in those directories Directory Name Jar File Name a. hibernateLibs --------> hibernate-commons-annotations-4.0.5.Final.jar hibernate-core-4.3.11.Final.jar hibernate-jpa-2.1-api-1.0.0.Final.jar b. jms --------> javax.jms-api-2.0.1.jar c. mail --------> mail-1.4.jar d. RESTful_api --------> javax.ws.rs-api-2.0.1.jar e. servlet_api --------> javax.servlet-api-3.1.0.jar f. Copy ojdbc7.jar file to $OM_HOME/externalLib directory 5. Copy the following JAR's to lib directory of the omsServer and omsui a. antlr-2.7.7.jar b. dom4j-2.1.3.jar 6. Update $OM_HOME/roles/copyLib.sh with the correct paths: export JDBC_JAR_PATH=$OM_HOME/externalLib/ojdbc7.jar export EMS_JAR_PATH_tibjms=$EMS_HOME/lib/tibjms.jar export EMS_JAR_PATH_jms=$EMS_HOME/lib/jms-2.0.jar export HIBERNATE_JAR_PATH=$OM_HOME/externalLib/hibernateLibs/*.jar export RESTFUL_API_JAR_PATH=$OM_HOME/externalLib/RESTful_api/javax.ws.rs-api-2.0.1.jar export MAIL_JAR_PATH=$OM_HOME/externalLib/mail/mail-1.4.jar export JAVAX_API_JAR_PATH=$OM_HOME/externalLib/servlet_api/javax.servlet-api-3.1.0.jar export JMS_API_JAR_PATH=$OM_HOME/externalLib/jms/javax.jms-api-2.0.1.jar 7. Give the execute permission to $OM_HOME/roles/copyLib.sh file chmod +x $OM_HOME/roles/copyLib.sh 8. Execute copyLib.sh file with sh $OM_HOME/roles/copyLib.sh 9. To execute the ems script, run the below command: a. cd $OM_HOME/ems b. tibemsadmin -server tcp://<host_ip_address>:7222 -user admin -password admin -script AF_CreateEMSChannel.txt -ignore c. tibemsadmin -server tcp://<host_ip_address>:7222 -user admin -password admin -script UpgradeEMSChannel_4.0.2hf3_to_5.0.0-lr.txt -ignore Note: Double check the output of both the ems script exeuctions for any errors other than '.... already exists' Execute below steps to setup the Database: 1. Oracle DB a. Update the values in $OM_HOME/db/oracle/oms/CreateTableSpace.sql and run the script b. Update the values in $OM_HOME/db/oracle/oms/createOMSUser.sql and run the script(Take this script from 5.0.0 installation since it is missing in the 501fh1 zip file. Create the users for admin DB and for fom DB) SET DEFINE OFF; SET ECHO ON; CREATE USER <<user_name>> IDENTIFIED BY <<user_name>>; GRANT CONNECT, CREATE TABLE, CREATE VIEW, CREATE SEQUENCE, CREATE SYNONYM, CREATE CLUSTER, CREATE DATABASE LINK, ALTER SESSION, CREATE TYPE, CREATE TRIGGER, CREATE INDEXTYPE, CREATE PROCEDURE, QUERY REWRITE TO <<user_name>>; ALTER USER <<user_name>> DEFAULT TABLESPACE <<tablespace_name>> QUOTA unlimited ON <<tablespace_name>>; exit; c. cd $OM_HOME/db/oracle/oms d. Execute following db scripts for admin database: OMS_AdminDatabase_DDL.sql OMS_Admin_SeedData.sql upgrade-admin-fom5.0_to_fom5.0hf1.sql e. Execute following db scripts for fom database: OMS_DDL.sql OMS_SeedData.sql OMS_Seed_OrderAddress.sql OMS_Create_Future_Partitions_SQL_Weekly.sql upgrade-fom4.0.2hf3-to-om5.0.0-lr.sql upgrade-fom5.0hf5_to_fom5.0hf6.sql f. Update the configDB.properties file from $OM_HOME/db/migration500To500HF1/standalone/config and set the details for oracle DB g. cd $OM_HOME/db/migration500To500HF1/standalone/bin and execute below files: copyLib.sh startMigration.sh 2. Postgres DB a. Update the variables to be set by user in setup.sh file from $OM_HOME/db/postgreSQL/oms directory b. Give the execute permission to $OM_HOME/db/postgreSQL/oms/setup.sh file chmod +x $OM_HOME/db/postgreSQL/oms/setup.sh c. Execute setup.sh file sh $OM_HOME/db/postgreSQL/oms/setup.sh d. Update the variables to be set by user in upgrade-5.0hf5_to_5.0hf6_setup.sh file from $OM_HOME/db/postgreSQL/oms directory e. Give the execute permission to $OM_HOME/db/postgreSQL/oms/upgrade-5.0hf5_to_5.0hf6_setup.sh file chmod +x $OM_HOME/db/postgreSQL/oms/upgrade-5.0hf5_to_5.0hf6_setup.sh f. Execute upgrade-5.0hf5_to_5.0hf6_setup.sh file sh $OM_HOME/db/postgreSQL/oms/upgrade-5.0hf5_to_5.0hf6_setup.sh g. Execute following db scripts for admin database from pgAdmin: $OM_HOME/db/postgreSQL/oms/dbscripts/upgrade-admin-fom5.0_to_fom5.0hf1.sql You can also execute below command to run the script: psql -U <admin_user_name> -d <admin_db> -v pg_super_user=<pg_super_user> -v pg_user=<admin_user_name> -v pg_password=<admin_user_password> -v pg_tablespace=<pg_tablespace_name> -h <host_ip_address> -p 5432 -f $OM_HOME/db/postgreSQL/oms/dbscripts/upgrade-admin-fom5.0_to_fom5.0hf1.sql h. Execute following db scripts for fom database from pgAdmin: $OM_HOME/db/postgreSQL/oms/dbscripts/upgrade-fom4.0.2hf3-to-om5.0.0-lr.sql $OM_HOME/db/postgreSQL/oms/dbscripts/upgrade-fom5.0hf5_to_fom5.0hf6.sql You can also execute below command to run the script: psql -U <fom_user_name> -d <fom_db_name> -v pg_super_user=<pg_super_user> -v pg_user=<fom_user_name> -v pg_password=<fom_user_name> -v pg_tablespace=<pg_tablespace_name> -h <host_ip_address> -p 5432 -f $OM_HOME/db/postgreSQL/oms/dbscripts/upgrade-fom4.0.2hf3-to-om5.0.0-lr.sql psql -U <fom_user_name> -d <fom_db_name> -v pg_super_user=<pg_super_user> -v pg_user=<fom_user_name> -v pg_password=<fom_user_name> -v pg_tablespace=<pg_tablespace_name> -h <host_ip_address> -p 5432 -f $OM_HOME/db/postgreSQL/oms/dbscripts/upgrade-fom5.0hf5_to_fom5.0hf6.sql Note: Double check the output of both the ems script exeuctions for any errors other than '.... already exists' i. Update the configDB.properties file from $OM_HOME/db/migration500To500HF1/standalone/config and set the details for postgres DB j. cd $OM_HOME/db/migration500To500HF1/standalone/bin and execute below files: sh copyLib.sh sh startMigration.sh Follow below steps to start the services: 1. Update $OM_HOME/roles/configurator/standalone/config/configDBrepo.properties with the correct details to connect to the OM Admin db schema 2. Update the below files from $OM_HOME/roles/configurator/standalone/config and enter the correct data for ems and database details wherever required a. ConfigValues_AOPD.xml b. ConfigValues_JEOMS.xml c. ConfigValues_OMS.xml d. AOPDLog4j.xml e. OMSServerLog4j.xml 3. chmod +x $OM_HOME/roles/configurator/standalone/bin/*.sh 4. $OM_HOME/roles/configurator/standalone/bin/start.sh 5. Update $OM_HOME/roles/omsServer/standalone/config/configDBrepo.properties with the correct details to connect to the OM Admin db schema 6. chmod +x $OM_HOME/roles/omsServer/standalone/bin/*.sh 7. $OM_HOME/roles/omsServer/standalone/bin/start.sh 8. Update $OM_HOME/roles/omsui/standalone/config/configDBrepo.properties with the correct details to connect to the OM Admin db schema 9. chmod +x $OM_HOME/roles/omsui/standalone/bin/*.sh 10. $OM_HOME/roles/omsui/standalone/bin/start.sh