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


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

No comments:

Post a Comment