Installation steps of OMLR 5.0.1 HF1

Installation steps of OMLR 5.0.1 HF1

book

Article ID: KB0071596

calendar_today

Updated On:

Products Versions
TIBCO Order Management - Long Running 5.0.1 HF-01

Description

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.

Issue/Introduction

Complete installation steps of OMLR 5.0.1 HF1 as the readme has some missing steps for the installation of the hotfix

Environment

ALL

Resolution

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

Attachments

Installation steps of OMLR 5.0.1 HF1 get_app