Oracle® Health Sciences WebSDM and Empirica Study Installation Instructions Release 3.1.2.1 for Windows 2003/2008 Server E40537-02 |
|
![]() Previous |
![]() Next |
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:
<LSH_consumer_acct>—LSH database account having "LSH Consumer" role.
<LSH_consumer_pass>—Password for the above LSH database account.
<LSH_host>—LSH database server.
<LSH_port>—Port number where LSH database server listens for incoming connections
<LSH_SID>—Oracle system identifier for the LSH database instance.
<LSH_service_name>—Alias for the LSH database address containing connection information.
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.
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
|
Connect to WebSDM DB as <ora_dba_acct>.
Type this command: C:> sqlplus <ora_dba_acct>@<ora_net_service>
When prompted for the password, enter <ora_dba_pass>.
Grant Create DB Link privilege to the websdm master account by typing:
SQL>GRANT CREATE DATABASE LINK TO <websdm_master_acct>;
Exit SQL*Plus.
Connect to WebSDM DB as <websdm_master_acct>.
Type this command: C:> sqlplus <websdm_master_acct>@<ora_net_service>
When prompted for the password, enter <websdm_master_pass>.
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>';
Exit SQL*Plus.
Repeat step 1 to connect to WebSDM DB again as <ora_dba_acct>.
Revoke Create DB Link privilege from the websdm master account by typing:
SQL>REVOKE CREATE DATABASE LINK FROM <websdm_master_acct>;
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.
Connect to the LSH instance as <LSH_consumer_acct>:
C:> sqlplus <LSH_consumer_acct>/<LSH_consumer_pass>@<LSH_service_name>;
Run this command:
SQL>@create_lsh_pkg.plb
Exit SQL*Plus.
Log into WebSDM using the default administrative account.
Click the Settings link at the top right corner of the page.
Click Set Site Options.
Select the Allow data import from Oracle Life Sciences Data Hub option if it is not already selected.
Click Save.
Click Continue.
Log out.