Oracle® Health Sciences WebSDM and Empirica Study Installation Instructions Release 3.1.2.1 for Windows 2003/2008 Server E40537-02 |
|
![]() Previous |
This section applies only to customers who will load SDTM-formatted study data from an Oracle Health Sciences InForm instance.
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 InForm database instance:
<InForm_acct>—InForm database account containing SDTM-formatted study data.
<InForm _pass>—Password for the above InForm database account.
<InForm _host>—InForm database server.
<InForm _port>—Port number where InForm database server listens for incoming connections.
<InForm _SID>—Oracle system identifier for the InForm database instance.
<InForm _service_name>—Alias for the InForm 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 InForm database service name to the tnsnames.ora
file.
<InForm_service_name>= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=<InForm_host>) (PORT=<InForm_port>) ) (CONNECT_DATA=(SID=<InForm_SID>)) )
Note: The WebSDM application does not require this entry. Use it to access the InForm database and execute the SQL commands listed below.If modifying tnsnames.ora is not desired, you can substitute the value of <InForm_service_name> directly in the SQL commands in steps C.2 and C.3. Replace <InForm_service_name> with: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<InForm_host>) (PORT=<InForm _port>)) (CONNECT_DATA=(SID=< InForm_SID>))) |
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 <InForm_acct> IDENTIFIED BY <InForm_pass> USING '<InForm_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>;
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 Health Sciences InForm option, if it is not already selected.
Click Save.
Click Continue.
Log out.