APAR status
Closed as fixed if next.
Error description
When installing Worklight using an Oracle database, there are 4 styles of JDBC URLs that Oracle supports: Oracle JDBC Thin using an SID: jdbc:oracle:thin:@<host>:<port>:<SID> Example: jdbc:oracle:thin:192.168.2.1:1521:X01A Note: Support for SID is being phased out. Oracle recommends that users switch over to using service names. Oracle JDBC Thin using a Service Name: jdbc:oracle:thin:@//<host>:<port>/<service_name> Example: jdbc:oracle:thin:@//192.168.2.1:1521/XE Oracle JDBC Thin using a TNSName: jdbc:oracle:thin:@<TNSName> Example: jdbc:oracle:thin:@GL Note: Support for TNSNames was added in the driver release 10.2.0.1 Generic Oracle JDBC Thin URL: For Oracle RAC, one customer reports that he is using the JDBC URL jdbc:oracle:thin:@(Description = (Failover=ON) (Address_List= (Load_Balance=ON) (address = (protocol = tcp) (host = $HOSTNAME1) (port = 1521)) (address = (protocol = tcp)(host = $HOSTNAME2) (port = 1521)) ) (Connect_data=(service_name = $SERVICENAME.domain.ext) ) ) The Worklight installer currently only supports the SID syntax and is unable to connect to the database.
Local fix
A dummy databse may be specified during the installation to overcome this limitation: - Prepare an empty database (later steps are easier if it's Oracle, but it can also be DB2 or MySQL). - Install Worklight Server, specifying this database. - In the WAS console, if the dummy database is not Oracle, create a JDBC provider for Oracle, as described in step 1 of http://pic.dhe.ibm.com/infocenter/wrklight/v5r0m6/index.jsp?topi c=%2Fcom.ibm.worklight.help.doc%2Fadmin%2Ft_configuring_webspher e_application_server_for_oracle_manually.html and update the worklight.properties file, as described in http://pic.dhe.ibm.com/infocenter/wrklight/v5r0m6/index.jsp?topi c=%2Fcom.ibm.worklight.help.doc%2Fadmin%2Ft_setting_up_your_orac le_database_manually.html - In the WAS console, delete the dummy datasources, and create a JDBC datasource for WRKLGHT and one for WLREPORT, with the JNDI names 'jdbc/WorklightDS' and 'jdbc/WorklightReportsDS', respectively, as described in http://pic.dhe.ibm.com/infocenter/wrklight/v5r0m6/index.jsp?topi c=%2Fcom.ibm.worklight.help.doc%2Fadmin%2Ft_configuring_webspher e_application_server_for_oracle_manually.html Here you can specify any URL.
Problem summary
**************************************************************** * USERS AFFECTED: * * Administrators of Worklight 5.0.x or Worklight 6.0.0.0, who * * attempt to install Worklight Server with reference to an * * Oracle database which is not just a simple database with a * * SID. * **************************************************************** * PROBLEM DESCRIPTION: * * When installing Worklight using an Oracle database, there * * are 4 * * styles of JDBC URLs that Oracle supports: * * * * Oracle JDBC Thin using an SID: * * jdbc:oracle:thin:@<host>:<port>:<SID> * * Example: jdbc:oracle:thin:192.168.2.1:1521:X01A * * Note: Support for SID is being phased out. Oracle recommends * * that users switch over to using service names. * * * * Oracle JDBC Thin using a Service Name: * * jdbc:oracle:thin:@//<host>:<port>/<service_name> * * Example: jdbc:oracle:thin:@//192.168.2.1:1521/XE * * * * Oracle JDBC Thin using a TNSName: * * jdbc:oracle:thin:@<TNSName> * * Example: jdbc:oracle:thin:@GL * * Note: Support for TNSNames was added in the driver release * * 10.2.0.1 * * * * Generic Oracle JDBC Thin URL: * * For Oracle RAC, one customer reports that he is using the * * JDBC * * URL * * jdbc:oracle:thin:@(Description = (Failover=ON) * * (Address_List= * * (Load_Balance=ON) (address = (protocol = tcp) (host = * * $HOSTNAME1) (port = 1521)) (address = (protocol = tcp)(host * * = * * $HOSTNAME2) (port = 1521)) ) (Connect_data=(service_name = * * $SERVICENAME.domain.ext) ) ) * * * * The Worklight installer currently only supports the SID * * syntax * * and is unable to connect to the database. * **************************************************************** * RECOMMENDATION: * * - * ****************************************************************
Problem conclusion
Temporary fix
Comments
The product supports references to Oracle databases through JDBC URLs other than the simple ones for SIDs in fixpack 6.0.0.1 and later.
APAR Information
APAR number
PM95797
Reported component name
WORKLIGHT ENTER
Reported component ID
5725I4300
Reported release
506
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-08-26
Closed date
2014-02-06
Last modified date
2014-02-06
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
R506 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSZH4A","label":"IBM Worklight"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"506","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
06 February 2014