Go to primary content
Oracle® Health Sciences WebSDM and Empirica Study Installation Instructions
Release 3.1.2.1 for Windows 2003/2008 Server
E40537-03
  Go To Table Of Contents
Contents

Previous
Previous
 
Next
Next
 

D Configure WebSDM to Access an Oracle Life Sciences Data Hub Instance

This section applies only to customers who will load SDTM-formatted study data from an instance of the Oracle Life Sciences Data Hub (LSH), version 2.2.

To perform these steps you must know the Oracle DBA account/password and the Oracle master account name/password for WebSDM. In addition, you must have the following information pertaining to an existing LSH database instance:

Finally, you need access to files extracted from database-3_1_2_1_xxx.zip, as described in section 1.2.3, or access to the WebSDM installation media.

D.1 Add Net Service Name for LSH Database

On the WebSDM database server, add an entry for the LSH database service name to the tnsnames.ora file.

<LSH_service_name>=
(DESCRIPTION=
   (ADDRESS=
       (PROTOCOL=TCP)
       (HOST=<LSH_host>)
       (PORT=<LSH_port>)
   ) (CONNECT_DATA=(SID=<LSH_SID>))
)

Note:

The WebSDM application does not require this entry. Use it to access the LSH database and execute the SQL commands listed below.

If you do not want to modify tnsnames.ora, you can substitute the value of <LSH_service_name> directly in the SQL commands in steps D.2 and D.3. Replace <LSH_service_name> with:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<LSH_host>)(PORT=<LSH_port>))

(CONNECT_DATA=(SID=<LSH_SID>)))


D.2 Create a Database Link

  1. Connect to WebSDM DB as <ora_dba_acct>.

    1. Type this command: C:> sqlplus <ora_dba_acct>@<ora_net_service>

    2. When prompted for the password, enter <ora_dba_pass>.

  2. Grant Create DB Link privilege to the websdm master account by typing:

    SQL>GRANT CREATE DATABASE LINK TO <websdm_master_acct>;

  3. Exit SQL*Plus.

  4. Connect to WebSDM DB as <websdm_master_acct>.

    1. Type this command: C:> sqlplus <websdm_master_acct>@<ora_net_service>

    2. When prompted for the password, enter <websdm_master_pass>.

  5. Run the following command, with values substituted as appropriate. The <DB_link_name> is a new name that you provide.

    SQL>CREATE DATABASE LINK <DB_link_name> CONNECT TO <LSH_consumer_acct> 
    IDENTIFIED BY <LSH_consumer_pass> USING '<LSH_service_name>';
    
  6. Exit SQL*Plus.

  7. Repeat step 1 to connect to WebSDM DB again as <ora_dba_acct>.

  8. Revoke Create DB Link privilege from the websdm master account by typing:

    SQL>REVOKE CREATE DATABASE LINK FROM <websdm_master_acct>;

D.3 Install and Run a PL/SQL Package in the LSH Database

  1. Locate the file create_lsh_pkg.plb either in the directory to which you extracted files from database-3_1_2_1_xxx.zip or from the .zip file on the WebSDM installation media.

  2. Connect to the LSH instance as <LSH_consumer_acct>:

    C:> sqlplus <LSH_consumer_acct>/<LSH_consumer_pass>@<LSH_service_name>;

  3. Run this command:

    SQL>@create_lsh_pkg.plb

  4. Exit SQL*Plus.

D.4 Set Site Option to Allow LSH Import

  1. Log into WebSDM using the default administrative account.

  2. Click the Settings link at the top right corner of the page.

  3. Click Set Site Options.

  4. Select the Allow data import from Oracle Life Sciences Data Hub option if it is not already selected.

  5. Click Save.

  6. Click Continue.

  7. Log out.