Previous Topic

Next Topic

Book Contents

Installing PFST45 Trial using Oracle dump file (has sample data)

The PFST45 sample trial includes an Oracle dump file containing Base and PFST45-specific trial components, and a collection of patients and sample clinical data. The procedure described in this section:

To import data into your PFST45 trial:

  1. Open a command window.
  2. Go to the <install_directory>\InForm\bin\DBOra folder.
  3. Run DropDB.cmd (located in the <Installation_Directory>\InForm\Bin\DBOra folder) to create the database user to own the trial schema, using following syntax:

    DropDB.cmd <TNS_Service_Name>

    where:

    • TNS_Service_Name—TNS name for the database instance.

    You are prompted for the following values:

    • trial_user—Owner of the trial schema created by the import.
    • trial_user_pass—Password for the owner of the trial schema created by the import.
    • pfdbauid—InForm database admin user.
    • pfdbapid—InForm database admin password.

    The Oracle user is dropped and recreated.

  4. To import the data into the sample trial, go to the <install_directory>\InForm\Sample_PFST45\ DUMP folder and type:

    imp system/password@oracle_connection_string file=pfst45.DMP fromuser=pfst45uid touser=pfst45uid buffer=999999

    When prompted, enter the password for the database system user.

  5. Run updatec.sql for each trial, using the following command and syntax:

    SQLPLUS <pfdbadmin_username>@<trial_instance> @updatec.sql <trialuserid>

    When prompted, enter the password for the InForm database administrator.

  6. To set up the application server and the trial, type the following commands:

    pfadmin setup server servername

    pfadmin setup trial trialname servername /db oracle_connection_string

    When prompted, enter the:

    • Trial user ID.
    • Password for the trial user.

      pfadmin setserver site trialname computername

      pfadmin setserver medmlinstaller trialname computername

  7. To start the application server and trial, type:

    pfadmin start server servername

    pfadmin start trial trialname

  8. Log on to the InForm trial.
Send Feedback