TIBCO CIM 8.2 Installation on Oracle 11g + Jboss 5.1 + Windows 7- 64 bit

wheatauditorSoftware and s/w Development

Oct 30, 2013 (3 years and 7 months ago)

206 views

Document


1








TIBCO CIM

8.2

Installation on Oracle 11g
+ Jboss 5.1 + Windows 7
-

64 bit


Thyag Sundaramoorthy





Revision History:

Version

Date

Notes

1.0

05
-
June
-
2012

Initial version






Document


2




Table of Contents

Introduction

................................
................................
................................
................................
...
3

Required Tools
................................
................................
................................
................................
3

Install Oracle 11gR2

................................
................................
................................
........................
3

Install TIBCO Components

................................
................................
................................
...............
3

Inst
all Jboss and JDK
................................
................................
................................
........................
4

Set the Environment Variables
................................
................................
................................
.........
4

Merging the files in ThirdParty.jar into ECM.ear
................................
................................
................
5

Database Specific
Configurations in CIM:
................................
................................
..........................
5

Creating EMS Queues for CIM
................................
................................
................................
..........
6

Configuring CIM for JBoss Application Server
................................
................................
....................
6

Deploy ECM.ear and Start CIM
................................
................................
................................
.........
8

Issues? Use the Checklist

................................
................................
................................
.................
8




Document


3


Introduction

This is a short

guide to install CIM 8.2

from scratch

on
Windows (7 and
64 bit)
. The database used is
Oracle 11g R2 and the application
server is

Jboss 5.1.

Only the essential steps are covered.

You must
refer to the
official
documentation fo
r prod
uction level installation
s.
The aim

here

is to cut through the
fog and set up CIM real quick.

Require
d Tools



Windows 7 64
-
bit OS




O
racle 11gR2 64 bit

server



jdk
-
6u24
-
windows
-
x64.exe



JBoss

5.1 app server



TIB_rv_8.3.1_win_x86_64_vc8



TIB_tra_5.7.1_win_x86_64



TIB_ems_6.3.0_win_x86_64_vc8



TIB_cim
-
JBOSS_8.2.0_win_x86_64



ThirdParty
.jar

-

The ThirdParty.jar is
a
jar file containing the following third party jar files :
com.ibm.mq.jar,com.ibm.mqjms.jar,connector.jar,gnu
-
regexp.jar,jsse.jar,ti
bjms.jar,xmlc
-
all
-
runtime.jar,xmlc
-
base.jar,xmlc
-
chtml.jar,xmlc
-
taskdef.jar,xmlc
-
xerces.jar,xmlc.jar

-

A slightly hard way is to download these jar files independently and consolidate

into a single
ThirdParty.jar file
. The easier (and recommended)

way

is to
get this file from

your

colleagues

who have already installed CIM.


Install Oracle 11gR2

(Skip this step if you have installed Oracle already
. Including this section to make this document
complete
)



First unpack the “
win64_11gR2_database_1of2.zip
” file in
the directory named “
database
”.
Also unpack the “
win64_11gR2_database_2of2.zip
” into the same “
database
” directory. (the
files in both the zip files should be in the
database

directory)



Double click on the
setup.exe

file in the “database” directory and st
art Oracle 11gR2
installation.



Installation should be straightforward. Create the default database (named “
orcl
”). Provide the
system

user password as “orcl”.



At the end of the installation,
open
cmd

prompt and
make sure you are able to login to the orcl
database:

sqlplus system/orcl@orcl

Install TIBCO Components


Install the following in sequence.



TIB_rv_8.3.1_win_x86_64_vc8

Document


4




TIB_tra_5.7.1_win_x86_64



TIB_ems_6.3.0_win_x86_64_vc8



TIB_cim
-
JBOSS_8.2.0_win_x86_64

At the end of the installation, you should be having the
directory
C:
\
tibco

(or any other
TIBCO_HOME).

Install Jboss and JDK



Copy

or unzip JBoss in
to the TIBCO_HOME directory.




Install
JDK

using “
jdk
-
6u24
-
windows
-
x64.exe
”. It is better to install
in
to
C
:
\
JDK1.6

instead of
installing
inside C:
\
Program Files
\
Java (
to avoid issues due to the

space


character in

the

“Program Files”

directory

name
)


Set the Environment Variables

Set the CIM
specific environment

variables

(at
System

level)

as shown in the table below. You will have
to set them at Start
-
>All Programs
-
>Computer
-
>(right click)
-
>Properties
-
>Advanced System Settings
-
>Environment Variables
-
> System Variables

ENVIRONMENT VARIABLE

EXAMPLE

PATH
s

MQ_HOME

C:
\
tibco
\
cim
\
8.2

MQ_LOG

C:
\
tibco
\
cim
\
8.2
\
log

MQ_COMMON_DIR

C:
\
tibco
\
cim
\
8.2
\
common

MQ_CONFIG_FILE

C:
\
tibco
\
cim
\
8.2
\
config
\
ConfigValues.xml

JAVA_HOME

C:
\
JDK1.6

EMS_HOME

C:
\
tibco
\
ems
\
6.3

JBOSS_HOME

C:
\
tibco
\
jboss
5.1

ANT_HOME

C:
\
tibco
\
tpcl
\
5.7
\
ant
\
1.6

ORACLE_HOME

G:
\
app
\
tsundara
\
product
\
11.2.0
\
dbhome_2

AS_HOME

C:
\
tibco
\
cim
\
8.2
\
bin
\
as

OS

Windows
_NT

NODE_ID

Member1

NLS_LANG

AMERICAN_AMERICA.UTF8


Prepend the
following environment

paths

to

the
PATH
variable

%JAVA_HOME%
\
bin;%EMS_HOME%
\
bin;%JBOSS_HOME%
\
bin;%ORACLE_HOME%
\
bin;%AS_HOME%
\
bi
n;%AS_HOME%
\
lib;%AS_HOME%
\
lib
\
as
-
common.jar;


Perform some simple checks by opening
cmd prompt

and

by

hitting the following commands:

set

: this command will show all the environment variables.

java

version

:
to show the java version

Document


5


javac

version

:
to show the javac version

tibemsadmin

:

should take you into the TIBCO EMS administration prompt



Merging the files in ThirdParty.jar

into ECM.e
ar



In
cmd

prompt, navigate to :
%MQ_HOME%



Create
a

directory

named thirdPartyLibrary

:
md thirdPartyLibrary



Copy the
ThirdParty.jar

file to the
thirdPartyLibrary

directory.

Y
ou
will
have the

jar file’s

full
path
as
:
%MQ_HOME%
\
thirdPartyLibrary
\
ThirdParty.jar



Now
navigate to :
%MQ_HOME%
\
build
\
custom
, and
run

the following
script
:

customUtil.bat

mergeExternalLibrary



Follow the instructions

given by customUtil.bat
, until the files in the ThirdParty.jar file are
merged into ECM.ear file.


Database
Specific Configurations

in CIM
:



Go to the folder
: %MQ_HOME%
\
db
\
oracle
\
configure

and open the file
createtablespace.sql
in
a text editor.



Modify the path of the tablespace data files, as shown below:

FIND

C:
\
oracle
\
product
\
10.2.0
\
oradata
\
orcl6

REPLACE

G:
\
app
\
tsundara
\
oradata
\
orcl



Now open
cmd

prompt. Navigate to the directory :
%MQ_HOME%
\
db
\
oracle
\
configure



Run the batch file :
doall.bat



You will be asked to provide some input, as shown below:

"specify the sys dba user : "

system

"specify the sys dba

password : "

orcl

"specify the instance name : "

orcl

"specify the new user to create : "

cimuser

"specify the password to new user : "

cimuser




After providing the input, you will see that the tablespaces are getting created. The script then
runs for a
bout a minute, creating the cimuser, the CIM specific tables, and imports
all
the seed
data.

Make sure you don’t see any errors.


Document


6


Creating EMS Queues for CIM



Make sure you have installed EMS, and that the EMS server is running (default port is 7222)



Open
c
md

prompt, and navigate to :
%MQ_HOME%
\
bin



Create the CIM specific EMS queues using the below command

(or you can also copy paste the
create queue commands after logging into tibemsadmin)
:

tibemsadmin
-
server "tcp://localhost:7222"
-
user admin
-
password ""

-
script
C:
\
tibco
\
cim
\
8.2
\
bin
\
createQueues.txt




In the above case, the
EMS
user
name is admin

and has no password. If you do have a password,
change it
accordingly.


Configuring CIM for JBoss Application Server



Create new Jboss Server
Instance
:

In Windows Explorer, navigate to
the
%JBOSS_HOME%
/server

directory
.
Make a copy the “
default

folder in

the same location, and
rename it to “
CIM
” (or any other valid ASCII directory name without spaces). In my case, the
complete folder name is :

C:
\
tibco
\
JBOSS5.1
\
server
\
CIM



Change JTA Timeout:

Go to the
folder:

%JBOSS_HOME%
\
server
\
CIM

\
deploy
,

and open
the
transaction
-
jboss
-
beans.xml

file in a text
editor.
Change the
transactionTimeout
parameter
as shown below:

OLD

<property name="transactionTimeout">300<
/property>

NEW

<property name="transactionTimeout">
7200
</property>




Change Jboss/CIM Port if Required
:
Go to the
directory:

:
%JBOSS_HOME%
\
server
\
CIM
\
conf
\
bindingservice.beans
\
META
-
INF

, and open the file
bindings
-
jboss
-
beans.xml

in a text editor. Find the
org.jboss.services.binding.ServiceBindingMetadata

bean
class, and change the
port

property

(only if you want to change it
)

as shown below:

OLD

<bean class="org.jboss.services.binding.ServiceBindingMetadata">

<property name="
serviceName">jboss.web:service=WebServer</property>

<property name="port">
8080
</property>

NEW

<bean class="org.jboss.services.binding.ServiceBindingMetadata">

<property name="serviceName">jboss.web:service=WebServer</property>

<property name="port">
8181
</
property>




Copy Oracle Driver jar file

:
Copy the
odbc6.jar

file

FROM


%ORACLE_HOME%
\
jdbc
\
lib

TO


%JBOSS_HOME%
\
server
\
CIM
\
lib

Document


7






Copy Data source File :

Copy the
oracle
-
ds.xml

file

FROM


%MQ_HOME%
\
config

TO

%JBOSS_HOME%
\
server
\
CIM
\
deploy





Edit
oracle
-
ds.xml :

Change the following property values in the oracle
-
ds.xml file.

PROPERTY

OLD

NEW

connection
-
url

jdbc:oracle:thin:@localhost:1521:cimdev

jdbc:oracle:thin:@localhost:1521:
OR
CL

user
-
name

cimdev

cimuser

password

cimdev

cimuser




Edit
MQ_CONFIG_
FILE for

Database Parameters
: %MQ_CONFIG_FILE
%

,
that

is the
file C:
\
tibco
\
cim
\
8.2
\
config
\
ConfigValues.xml has
some

database properties
which should

to be
modified. For some reason, this step is not available in the CIM installation document. B
ut here
are the properties that need to be
edited

:

PROPERTY

Example VALUE

com.tibco.cim.database.name

orcl

com.tibco.cim.database.user

cimuser

com.tibco.cim.database.password

cimuser

com.tibco.cim.database.docroot

G:
\
app
\
tsundara
\
oradata
\
orcl

Note:
It is best to modify the above properties via the Configurator tool.




Modify Jboss run.bat

:




Open the Jboss start up

file :

%JBOSS_HOME%
\
bin
\
run.bat

in a text editor,



Comment out the line starting with

"%JAVA%" %JAVA_OPTS%

by prefixing

it with

rem

rem
"%JAVA%" %JAVA_OPTS%

…. <rest of the line>




Now a
dd the following line

(the variables in
bold

are
the
CIM

specific

paths)
:

Document


8


"%JAVA%" %JAVA_OPTS%
-
Djava.endorsed.dirs="%JBOSS_ENDORSED_DIRS%"
-
DCIM_HOTDEPLOYMENTSERVICE_PORT=57573
-
DMQ_HOME
="%MQ_HOME%"
-
DMQ_LOG
="%MQ_LOG%"
-
DOS="Windows_NT"
-
DMQ_COMMON_DIR
="%MQ_COMMON_DIR%"
-
DAS_HOME
="%AS_HOME%"
-
DMQ_CONFIG_FILE
="%MQ_CONFIG_FILE%"
-
DLD_LIBRARY_PATH="%LD_LIBRARY_PATH%"
-
DNODE_ID
="%NODE_ID%"
-
DPATH="%PATH%"
-
Dcom.sun.management.jmxremote
-
Dtangosol.coherence
.management=all
-
Dtangosol.coherence.management.remote=true
-
Dcom.sun.management.jmxremote.authenticate=false
-
Dcom.sun.management.jmxremote.ssl=false
-
Dcom.sun.management.jmxremote.port=9999
-
classpath "%JBOSS_CLASSPATH%" org.jboss.Main %*



Deploy
ECM.ear and Start CIM

Copy the
ECM.ear

file :

FROM


%MQ_HOME%

TO

%JBOSS_HOME%
\
server
\
CIM
\
deploy




Start CIM: Open cmd prompt , navigate
%JBOSS_HOME%
\
bin

and hit the following
command:


The above script will start CIM in a couple of minutes. If you see the message : “”, it indicates
that CIM has been installed correctly.

You should be able to login to the CIM GUI from the URL :
http://localhost:8080/eml/Login

. The default
enterprise is TIBCOCIM with username “tadmin” and password “euc!1d”

Issues?
Use the Checklist

Here is a checklist which you can use to debug and isolate issues

CHECK

Yes/No

Oracle server / database is up
?


You are able to login to
database:

sqlplus cimuser/cimuser@orcl
?


Faced any issues while running
doall.bat?
CIM specific tables have been created in the
database?


EMS server is up?


You are able to connect to ems
server

using tibemsadmin or GEMS
?


CIM

specific
queues have

been
created?
show queues



CIM specific topics are
available?

show topics



ALL the environment variables (around 13) are set
correctly?


The PATH environment
variable ha
s

all the CIM, ORACLE.JBOSS, AS specific
paths?

:
echo
%PATH%


The oracle
-
ds
.xml

file in the jboss deploy directory is edited correctly to include database
parameters?


The configvalues.xml file is edited correctly to include the database
parameters?


run.bat

c CIM

b 0.0.0.0

Document


9


The jboss run.bat file has the JAVA_OPTS set
correctly
?


The ojdbc6
.jar file is copied to the %JBOSS_HOME%/

lib
directory?


The
“updated”
E䍍.ear file presen琠in 瑨e Tirec瑯ry 㨠
%JBOSS_HOME%/server/<CIM_SERVER>/deploy


?