Friday, August 28, 2015

Perimeter Installation on Windows 64 bit OS


                               Perimeter Installation on Windows 64 bit OS


       I.          Install the same JDK version that SI is running on preferably.
     II.          Make sure you know whether it is a 32 bit or 64 bit version of Windows If you are installing in Windows.

    III.          Before you install the perimeter server, you need to gather the following information and answer the following questions:

Table 1.0 Simple Table for myself to understand easily
Perimeter Server Information Gathering Checklist
Your Notes
Path to java
 C:\Program Files\Java\jdk1.6.0_31
Path to the Sterling B2B Integrator installation directory
 C:\perimeter1
Will this perimeter server be installed in a less secure network?
 NO
Please enter the network address that integration server (SI) will listen on for the connection from this server:
(Sterling B2B Integrator host IP)

Please enter the port that integration server (SI) will listen on for the connection from this server:
(Sterling B2B Integrator side Listen port)
 9070
Please enter the local port that perimeter will use for the connection to the integration server (SI):
(Perimeter server side listening port)
 9060

I believe there are some documentation errors from the website.
1.      Do not create the perimeter server directory before you run the installation.  Because, PS code will estimate the size on the disk.
2.      Also, the second point “Path to the Sterling B2B Integrator installation directory” is not the right word in website check list. It should be the path to perimeter server installation directory.

In my example, I am expecting my HTTP data on port 9080.
On Sterling B2B Integrator side, I am listening on port 9070 from Perimeter.
On Perimeter side, Perimeter will listen on the port 9060 from Sterling B2B Integrator.
Installation:
Open the command prompt by “Run as Administrator”. Navigate to Java/bin folder.
Note down the path to the folder ps_4500.jar file which you either copied from Sterling B2B integrator (\install\packages) or from the CD.

Just give your Sterling B2B Integrator Host if no proxy is involved between.


v  Do not run the installPS.cmd now.
v  Just open the installPS.cmd in a text editor. Just change the below value from false to true.
java_64_bits=true.
Now run the installPS and startPSservice.




Friday, August 21, 2015

Sterling Integrator installation and starting problems

I installed SI on Java 32 bit and it installed successfully but I was unable to start the server. There were no logs created apart from one "servicelist" which shows windows services.

Later when I installed SI on Java 64 bit it is successful.
*************************************************************************
External host name and port is important.

If you install SI with hostname as localhost then the installation may work fine. When we wanted to run the GPM from any other computer then we see issue in connecting. So it is suggested to give the proper host name during the installation itself.


The ProcessModeler.jnlp.in file is accessed from E:\IBM\SterlingIntegrator\install\noapp\deploy\gbm\webapp\pmodeler. It looks like below.

<jnlp spec="1.0+" codebase="http://&EXT_HOST_ADDR;:&DAV_PORT;/gbm/pmodeler" href="ProcessModeler.jnlp" version="1.0">
    <title>Modeler-&HOST_NAME;-&WEBAPP_LIST_PORT;</title>
        <argument>&EXT_HOST_ADDR;</argument>

Where the EXT_HOST_ADDR is defined in sandbox.cfg file.
Open the file and change this value
EXT_HOST_ADDR=Your hostname

Run the setupfiles.

*************************************************************************
Installation Steps followed on Windows Non Cluster

1. Install the database. If it is Oracle, run the below DB script. This works for SI 5.1 and 5.2.6.2 as of today. For production environments, please refer the Oracle tuning parameters to setup.

create user siadmin identified by Welcome1;
grant resource to siadmin;
GRANT "CONNECT" TO siadmin;
GRANT SELECT_CATALOG_ROLE TO siadmin;
ALTER USER siadmin DEFAULT ROLE "CONNECT", SELECT_CATALOG_ROLE;
GRANT CREATE PROCEDURE TO siadmin;
GRANT CREATE TRIGGER TO siadmin;
GRANT CREATE TYPE TO siadmin;
GRANT EXECUTE ANY PROCEDURE TO siadmin;
GRANT EXECUTE ANY TYPE TO siadmin;
GRANT SELECT ANY TABLE TO siadmin;
GRANT SELECT ANY DICTIONARY TO siadmin;
grant create any table to siadmin;
grant insert any table to siadmin;
grant update any table to siadmin;
grant create any view to siadmin;
grant create any synonym to siadmin;
grant create session to siadmin;
grant create any sequence to siadmin;
grant alter session to siadmin;
GRANT SELECT ON CTXSYS.CTX_USER_INDEXES TO siadmin;
GRANT SELECT ON SYS.DBA_DATA_FILES TO siadmin;
GRANT SELECT ON SYS.DBA_FREE_SPACE TO siadmin;
GRANT SELECT ON SYS.DBA_USERS TO siadmin;
GRANT SELECT ON SYS.V_$PARAMETER TO siadmin;

2. Get the IBM Java from IBM site
3. Start the Installer


*************************************************************************