Oracle® Health Sciences WebSDM and Empirica Study Upgrade Instructions Release 3.1.2.1 for Windows 2003/2008 Server E40536-01 |
|
![]() 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.
If you do not perform these steps, security-related dialog boxes appear for end users when they work with DataMontage graphs in applet mode, and DataMontage may even be completely blocked by a client machine's security settings. To perform these steps, you need access to the Java jar and jarsigner utilities in the Java jdk1.6\bin
directory (jdk1.6\bin
must be in the application server's PATH), and you must have access to your company's jar signing process.
From the <root>:\Lincoln\apps\<instance>\webapps\web_root\AppJars\DataMontage23\
folder, copy files lti.jar
and DataMontage.jar
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 a text file and save it. The example later in this procedure uses the name MANIFEST.MF.
Insert two lines of text in the file, supplying the fully qualified domain name of the Windows application server (or its IP address) and the connection port on each line. For example:
Codebase: <server_name>.example.com:80
Caller-Allowable-Codebase: <server_name>.example.com:80
Alternatively you can use an asterisk (*) as a wildcard for the most specific part of the domain name, but this will result in a less secure deployment.
Be sure to insert a line break after the second line of text. Then save and close the file.
Open a DOS Command window and navigate to the temporary folder containing the JAR files and the text file you created.
At the DOS prompt, issue the following commands, replacing MANIFEST.MF with the name of the text file you created:
jar -ufm DataMontage.jar MANIFEST.MF
jar -ufm lti.jar MANIFEST.MF
You must now sign the modified JAR files before they will work correctly within the WebSDM application. Use your company's jar signing process to perform this signing task, which probably includes using Java's jarsigner utility. (See http://docs.oracle.com/javase/7/docs/technotes/tools/windows/jarsigner.html
for additional information about this utility.)
Copy both signed JAR files to the <root>:\Lincoln\apps\<instance>\webapps\web_root\AppJars\DataMontage23\
folder, replacing the original files.
Finally, copy 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 location.)
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.