Worklight Server/Oracle/Multi Instance -
Before beginning the Worklight Install, create 3 databases using the Oracle Database Configuration Assistant called WRKLGHT, WLREPORT and APPCNTR.
NOTE: Select the following character sets. Unicode (AL32UTF8) character set and UTF8 - Unicode 3.0 UTF-8 national character set.
-
Run the following statements to create the Worklight user on the databases you created above and grant the proper permissions.
CONNECT system/@WRKLGHT
CREATE USER wluser IDENTIFIED BY wluser;
GRANT CONNECT TO wluser;
GRANT RESOURCE TO wluser;
GRANT CREATE VIEW TO wluser;
DISCONNECT;
CONNECT system/@WLREPORT
CREATE USER wluser IDENTIFIED BY wluser;
GRANT CONNECT TO wluser;
GRANT RESOURCE TO wluser;
GRANT CREATE VIEW TO wluser;
DISCONNECT;
CONNECT system/@APPCNTR
CREATE USER wluser IDENTIFIED BY wluser;
GRANT CONNECT TO wluser;
GRANT RESOURCE TO wluser;
GRANT CREATE VIEW TO wluser;
DISCONNECT;
-
Click on the 'Install Maximo Anywhere Work Manager' and check the box beside 'IBM Worklight Server for Worklight Consumer Edition'
-
Select the Work Light Version 5.0.6 Install Package and click next.
-
Choose your shared install directory path then click next then chose the installation directory for Worklight, click next again.
-
On the database configuration screen choose Oracle 11g Standard/Enterprise Editions Release 1 and Later
-
On the setting screen enter the following data and click next three times
Hostname: host name for the oracle server
Port: Port to the Oracle Server (1521)
User name: WLUSER created previously
Password: WLUSER password created previously.
Oracle JDBC Driver: Download the driver from the link provided on the install screen, extract the driver and point this installer field to it.
-
On the application server choice screen choose 'Use pre-installed application server' then choose 'WebSphere Application Server (Liberty Profile, 7.0,8.0,8.5 Full Profile)' and click next.
-
Select the directory for your WebSphere Application Server that contains the Worklight Profile for example: c:\IBM\WebSphere\AppServer\profiles. Choose the Worklight Profile and then Select the Worklight Server and enter your WASADMIN username and password.
-
Select the Installation Mode, either Single user or Multiple users. If multiple users select the appropriate OS group and continue until you can click install
-
If prompted for an install package point to your disk1 folder in Launchpad\masterSetupDisk.
This will install and deploy the Worklight Server to WebSphere Full Profile. You can verify the appcenterconsole and Worklight console are running using the following URL.
http://{yourhostname}:{yourport}/worklight/console
http:// {yourhostname}:{yourport}/appcenterconsole
Worklight Server/Oracle/Multi Schema -
Click on the 'Install Maximo Anywhere Work Manager' and check the box beside 'IBM Worklight Server for Worklight Consumer Edition'
-
Select the Work Light Version 5.0.6 Install Package and click next.|
-
Choose your shared install directory path then click next then chose the installation directory for Worklight, click next again.
-
On the database configuration screen choose 'Install Apache Derby 10.8 Release (not for production use)
-
Click next until you reach to Application server choice page. Choose Install WebSphere Application Server Liberty Profile. Note: Even though you may not be using WebSphere Liberty, this will streamline the installation process.
-
Click Next until you see Install then click Install. If prompted for a Disk Location point to the Disk 1 Folder we extracted to Launchpad\masterSetupDisk.
-
If you are not using the WebSphere Liberty installed, remove the Liberty Profile and Derby Databases after the install is successful by deleting the c:\ProgramData\IBM\Worklight folder.
-
Create a Worklight database for your Schemas using the Oracle Database Configuration Assistant.
-
Create 3 separate users for your Schemas on the Worklight Database (WORKLIGHT, WORKLIGHTREPORTS, APPCENTER) and grant the appropriate permissions.
CONNECT system/system_password@WORKLIGHTDB
CREATE USER wluser IDENTIFIED BY wluser_password;
GRANT CONNECT, RESOURCE, CREATE VIEW TO wluser;
DISCONNECT;
CONNECT system/system_password@WORKLIGHTDB
CREATE USER WORKLIGHTREPORTS IDENTIFIED BY WORKLIGHTREPORTS_password;
GRANT CONNECT, RESOURCE, CREATE VIEW TO WORKLIGHTREPORTS;
DISCONNECT;
CONNECT system/system_password@WORKLIGHTDB
CREATE USER APPCENTER IDENTIFIED BY APPCENTER_password;
GRANT CONNECT, RESOURCE, CREATE VIEW TO APPCENTER;
DISCONNECT;
-
Create the tables in the Worklight database for each of the schemas, ensure you are running the scripts on the correct schema's.
CONNECT WORKLIGHT/WORKLIGHT_password@WORKLIGHTDB
@worklightserver_home/WorklightServer/databases/create-worklight-oracle.sql
DISCONNECT;
CONNECT WORKLIGHTREPORTS/WORKLIGHTREPORTS_password@WORKLIGHTDB
@worklightserver_home/WorklightServer/databases/
create-worklightreports-oracle.sql
DISCONNECT;
CONNECT APPCENTER/APPCENTER_password@WORKLIGHTDB
@worklightserver_home/ApplicationCenter/databases/create-appcenter-oracle.sql
DISCONNECT;
-
Download the Oracle JDBC Driver for use with WebSphere Datasources.
-
Log into the WebSphere Console and expand Resources - > JDBC - > JDBC Providers and click on New and enter the following properties.
Database Type: Oracle
Provider Type: Oracle JDBC Driver
Implementation Type: Connection pool data source
Name: Oracle JDBC Driver
-
Save the Driver, then go back in and specify the path to your Oracle JDBC driver downloaded earlier.
-
Expand Resources - > JDBC -> Data sources and click on New. Set the JNDI name to jdbc/WorklightDS provide a description and click next.
-
Choose Select an existing JDBC provider and select the Oracle JDBC Driver you created earlier from the list.
-
Set the URL to the JDBC path for your Oracle Database
(e.g jdbc:oracle:thin:@{yourserver}:1521:WORKLIGHTDB)
-
On the same data sources create two new custom properties
user: wluser
password: password for wluser user
-
Repeat steps 20 to 23 for the following JNDI, specifying the Worklight database and the user and password in custom properties for the corresponding schema's
JNDI name jdbc/WorklightReportsDS.
JNDI name jdbc/AppCenterDS.
-
Once done test your data sources.
-
Once your data sources have been tested you will need to modify the worklight.properties inside the Worklight war file. Open the file in an archive tool and edit the properties file.
-
Remove the comments on the #wl.db.type and #wl.reports.db.type properties by removing # and replace with your corresponding database type in this case you would have.
wl.db.type=Oracle
wl.reports.db.type=Oracle
-
Comment out the JDBC string as data sources are being used to make the connection by adding # infront of wl.db.url and wl.reports.db.url so it looks like
#wl.db.url
#wl.reports.db.url
-
Save the properties file back into the war
-
Manually configure WebSphere for Worklight server and deploy the Worklight war using the Worklight step by step documentation
http://pic.dhe.ibm.com/infocenter/wrklight/v5r0m6/index.jsp?topic=%2Fcom.ibm.worklight.help.doc%2Fadmin%2Fc_manually_configuring_app_server.html
Share with your friends: |
