Oracle® Health Sciences WebSDM and Empirica Study Upgrade Instructions Release 3.1.2.1 for Windows 2003/2008 Server E40536-02 |
|
![]() Previous |
This chapter contains information on upgrading to WebSDM 3.1.2.1.
You must have the following information when you start the upgrade. In these procedures, the values are shown in <text_in_angle_brackets>.
The installation media for WebSDM 3.1.2.1
The product ZIP file from My Oracle Support (https://support.oracle.com).
Windows administrator account
<win_admin_acct> and <win_admin_pass>
Windows account and password on the server where WebSDM is installed. The account must have the Administrator role.
Installation root
<root>
File system root where the \Lincoln
subdirectory is located, typically C:\.
WebSDM instance name
<instance>
Name of the WebSDM 3.1.2 instance you are upgrading.
WebSDM Superuser account and password. For example, the admin
username supplied with WebSDM is a Superuser.
<app_admin_acct> and <app_admin_pass>
Password for the WebSDM user account with the reserved name admin, or other Superuser.
Note whether the WebSDM application server is 32-bit or 64-bit.
Note the operating system version running on the WebSDM server (Windows 2003 or Windows 2008).
WebSDM Windows user account
<win_user_acct>Name of the Windows account that is running the WebSDM service. Usually this is the WebSDM instance name, with the suffix, _app, appended. For example, websdm_app.
You must also have access to the Java jar and jarsigner utilities, and to your company's jar signing process.
Log into WebSDM as <app_admin_acct>.
Click Settings, and then click View Currently Logged in Users.
If sessions in addition to your own are running, either instruct the users to finish their sessions or cancel the sessions from the WebSDM interface.
Exit WebSDM.
Log into the Windows administrator account using <win_admin_acct>
.
Select Start > Administrative Tools > Services.
Right-click the <instance> service, and then click Stop.
Right-click World Wide Web Publishing Service, and then click Stop.
Navigate to the <root>\Lincoln\apps\<instance>\bin
folder.
Do one of the following:
(Windows 2008 server)-Right-click the uninstall_service.bat
file, and select Run as administrator.
(Windows 2003 server) -Double-click the uninstall_service.bat
file.
Back up the <root>\Lincoln
folder.
Locate the Lincoln.zip
file on the installation media. (For a 64-bit server, use Lincoln_x64.zip
.)
Extract the contents of this file to a temporary folder, making sure that path names stored in the archive will be used (for example, in WinZip, the Use folder names checkbox must be selected).
Copy the apache-tomcat-6.0.41
folder from the temporary folder to the <root>\Lincoln
folder.
Delete the \apache-tomcat-6.0.36
folder under <root>\Lincoln
.
Update the JDK:
Delete the jdk1.x
folder under <root>\Lincoln\
.
Locate the jdk1.6
folder in the temporary folder, and copy the folder to the <root>\Lincoln
folder.
Delete all the files from the <root>\Lincoln\apps\<instance>\bin
folder.
Copy all the files from the temporary \Lincoln\apps\<instance>\bin
folder into <root>\Lincoln\apps\<instance>\bin
folder.
Locate the <root>\Lincoln\apps\<instance>\webapps\web_root
folder on the server that is running your current installation of WebSDM. Copy the contents of this folder to a temporary folder, such as C:\temp\web_root.
Delete the contents of the <root>\Lincoln\apps\<instance>\webapps\web_root
folder, keeping the folder itself in place.
Locate the websdm-3_1_2_1_4xx.zip
file (where 4xx
represents a specific build number) on the installation media. Extract the contents of this file to the <root>\Lincoln\apps\<instance>\webapps\web_root
directory, making sure that path names stored in the archive are used (for example, in WinZip the Use folder names checkbox must be selected).
Restore your saved copy of website.properties
, and of license.config
, if it exists, from the temporary folder C:\temp\web_root\WEB-INF\classes\
to <root>\Lincoln\apps\<instance>\webapps\web_root\WEB-INF\classes
.
Restore your saved copy of ojdbc*.jar
(either ojdbc6.jar
or ojdbc14.jar
) from the temporary folder C:\temp\web_root\WEB-INF\lib\
to <root>\Lincoln\apps\<instance>\webapps\web_root\WEB-INF\lib
.
If you have created or included any custom content (home pages or logos), copy the files from the \customhome
s or \image subfolder
under C:\temp\web_root\
to the respective subfolder under <root>\Lincoln\apps\<instance>\webapps\web_root
.
Delete the contents of the <root>\Lincoln\apps\<instance>\work
folder.
This section contains information on reinstalling the WebSDM Service on Windows 2003 and 2008 configurations.
This section is for Windows 2008 Server only.
Delete the existing Windows user account that is running the WebSDM service.
Select Start > Administrative Tools > Server Manager > Configuration > Local Users and Groups > Users.
Right-click the account named <win_user_acct>
(usually <instance>_app) that is running the WebSDM service.
Click Delete, and then click Yes to confirm.
Close Administrative Tools.
Navigate to the <root>\Lincoln\apps\<instance>\bin
folder.
If you are using a WebSDM instance name other than websdm:
Edit the uninstall_service.bat
file.
Change the value of SERVICE_NAME from websdm to the value of <instance>.
Save your changes.
Edit the install_service.bat
file.
Change the value of SERVICE_NAME from websdm to the value of <instance>.
Change the value of the APPLICATION_DIR from websdm to the value of <instance>.
Save your changes.
Right-click the install_service.bat
file, and then select Run as administrator.
After install_service.bat
runs, inspect the transcript to ensure that no errors occurred. When you are finished, press any key.
Select Start> Administrative Tools > Server Manager > Configuration > Local Users and Groups > Users.
Right-click <instance>_app and select Set Password.
In the Set Password for <instance>_app dialog box, click Proceed.
Change the password according to the password policy restrictions at your site, and click OK.
Click Services.
Right-click the <instance> service, and select Properties.
On the Log On tab, click This account, clear the password fields, and enter the password you just changed.
On the Recovery tab, select the Restart the Service value for both First Failure and Second Failure.
On the General tab, set Startup type to Automatic (Delayed Start).
Note: This setting allows time for the database service to start before the WebSDM application service. |
Click OK.
This section is for Windows 2003 Server only.
Delete the existing Windows user account that is running the WebSDM service.
Right-click the server's desktop My Computer icon and select Manage. Expand System tools > Local Users and Groups > Users.
Right-click Users and select the account named <win_user_acct> (usually <instance>_app) that is running the WebSDM service.
Click Delete.
Close the Computer Management window.
Navigate to the <root>\Lincoln\apps\<instance>\bin
folder.
If you are using a WebSDM instance name other than websdm:
Edit the uninstall_service.bat
file.
Change the value of SERVICE_NAME from websdm to the value of <instance>.
Save your changes.
Edit the install_service.bat
file.
Change the value of SERVICE_NAME from websdm to the value of <instance>.
Change the value of the APPLICATION_DIR from websdm to the value of <instance>.
Save your changes.
Double-click the install_service.bat
file.
After install_service.bat
has completed, inspect the transcript to ensure that no errors occurred. When you are finished, press any key.
Close the Command window.
Right-click the server's desktop My Computer icon and select Manage. Expand System Tools > Local Users and Groups > Users.
Right-click <instance>_app, and select Set Password.
In the Set Password for <instance>_app dialog box, click Proceed.
Change the password, using the password policy restrictions at your site, and click OK.
Expand the Services and Applications directory, and then click Services.
Right-click the <instance> service, and select Properties.
On the Log On tab, click This account. Clear the password fields, and enter the password you just changed.
On the Recovery tab, select Restart the Service for both First Failure and Second Failure.
Click OK.
Modify the WebSDM JAR files to enable users to work with DataMontage graphs in applet mode. If you do not perform this procedure:
Security-related dialog boxes appear when users work with DataMontage graphs in applet mode.
DataMontage might be blocked by a client machine's security settings.
Before you begin, verify that:
The PATH variable on the application server includes the jdk1.6\bin
directory.
You have access to the Java jar and jarsigner utilities in the jdk1.6\bin
directory.
You have access to your company's JAR signing process.
From the <root>:\Lincoln\apps\<instance>\webapps\web_root\AppJars\DataMontage23\
folder, copy the lti.jar
and DataMontage.jar
files to a temporary folder such as C:\temp\UpdateJarManifest\
.
Update the manifest is both JAR files:
In the temporary folder where you copied the JAR files, create the following text files.
AddToDMjar.txt
AddToLTIjar.txt
In a text editor, insert the following lines in the AddToDMjar.txt
file.
Caller-Allowable-Codebase: * Codebase: *
Note: You must include a carriage return after the last line. |
In a text editor, insert the following lines in the AddToLTIjar.txt
file.
Application-Library-Allowable-Codebase: *.example.com Caller-Allowable-Codebase: *.example.com Codebase: *.example.com
where example.com
is the domain name or IP address where the Empirica Study application is hosted. For more information, see https://docs.oracle.com/javase/8/docs/technotes/guides/deploy/manifest.html
Note: You must include a carriage return after the last line. |
Save and close the text files.
In a Windows command window, navigate to the temporary folder containing the JARs and text files.
At the prompt, issue the following commands:
jar -ufm DataMontage.jar AddToDMjar.txt jar -ufm lti.jar AddToLTIjar.txt
Sign the modified JAR files using your company's JAR signing process.
If the process includes using Java's jarsigner utility, see http://docs.oracle.com/javase/7/docs/technotes/tools/windows/jarsigner.html
for information about the utility.
Copy both signed JAR files to the <root>:\Lincoln\apps\<instance>\webapps\web_root\AppJars\DataMontage23\
folder, replacing the original files.
Copy only the signed DataMontage.jar
file to the <root>:\Lincoln\apps\<instance>\webapps\web_root\WEB-INF\lib\
folder, replacing the original file.
You do not need a copy of lti.jar
in this folder.
Navigate to the <root>\Lincoln\apps\<instance>\bin
folder.
Use a text editor to open the file set_permissions.bat
and review the values of SERVICE_NAME, INSTALL_ROOT and APPLICATION_DIR, and WORKING_DIR:
If the value of <instance> is other than websdm, change the values of SERVICE_NAME, APPLICATION_DIR, and WORKING_DIR to the value of <instance>.
If the value of <root> is other than the C drive, change the value of the INSTALL_ROOT to the value of <root>.
If the D drive is not an acceptable location for the working directory, change the drive for WORKING_DIR to an acceptable drive.
Verify that CATALINA_HOME is defined correctly.
Optionally, grant permissions to a Windows group of non-administrator users who might require access to the log files and \web_root
folder.
While editing the set_permissions.bat file, locate the following lines:
REM -
REM - Local Administrators group
REM -
REM SET ADMIN_GROUP=Study Operators
Remove REM
from the REM SET ADMIN_GROUP
line.
Replace Study Operators
with the Windows user group that requires access.
If changes are needed, edit, save, and close the file.
When you are prompted, press any key.
Examine the log file <root>\Lincoln\apps\<instance>\logs\set_permissions.log
for errors. If errors occur, you must take ownership, recursively, of C:\Lincoln\apps\<instance>
and D:\websdm
, and then repeat this procedure.
Do one of the following:
(Windows 2003 server) -Double-click the set_permissions.bat
file.
(Windows 2008 server) -Right-click the set_permissions.bat
file, and then select Run as administrator.
Select Start > Administrative Tools > Services.
Right-click the <instance> service, and then select Start.
Right-click the World Wide Web Publishing Service, and then click Start. If the service is already running, click Restart.
In an Internet Explorer window, access the URL for WebSDM.
If you receive a message that the server is still initializing, wait a few minutes and access the URL again.