Restore an InForm 6.1.1.0, 6.1.1.1, 6.1.1.2, 6.1.1.3, or 6.1.1.4 release

Previous Topic

Next Topic

Book Contents

Restore an InForm 6.1.1.0, 6.1.1.1, 6.1.1.2, 6.1.1.3, or 6.1.1.4 release

Note: If the in-place upgrade fails for any reason, use the backup files you created in Back up the InForm study and admin databases and files for the in-place upgrade to restore your InForm 6.1.1.x environment.

To restore an in-place upgrade to an InForm 6.1.1.0, 6.1.1.1, 6.1.1.2, 6.1.1.3, or 6.1.1.4 release:

  1. Open a Command Prompt window.
  2. Run the following command to stop all InForm studies.

    pfadmin /STOPALL

  3. Rename the OracleHS folder to OracleHS-61.
  4. Rename the folder containing the InForm 6.0 or 6.1 files (for example, OracleHS-60) to OracleHS.
  5. Run ImportDB.cmd (located in the <InstallationDirectory>\InForm\Bin\DBOra folder) to import the studies from the study schema DMP files, using the following syntax:

    ImportDB.cmd <TNS_Service_Name> <Physical_Directory_Path> <DMP_File_Name> <From_User>

    where:

    • TNS_Service_Name—TNS name for the database instance.
    • Physical_Directory_Path—Location of the directory that you created on the InForm database server for the data pump.
    • DMP_File_Name—Name of the DMP file to import.
    • From_User—Owner of the database schema being migrated.

    You are prompted for the following values:

    • orasystem_user—Oracle database system user.
    • orasystem_user_pass—Password for the Oracle database system user.
    • trial_user—Owner of the study schema created by the import.
    • trial_user_pass—Password for the owner of the study schema created by the import.

    You can also pass the parameters by using the /accountparams:"path_to_parameter_file" command option.

    When specified, this option includes the path to a text file that contains the values required to run the command. The format of the parameter file is parameter=value. There is a new line for each parameter, and there are no spaces on a line.

    For example:

    ImportDB.cmd trial1 /u01/app/oracle/dp_export pfst46.dmp pfst46uid

    The ImportDB command creates the log file <DMP_file>.log.

  6. Import the HKEY_LOCAL_MACHINE\Software\OracleHS key into the Windows registry to restore the InForm 6.0 or 6.1 settings.
  7. Add the pfUSR_<machinename> user to the Administrators group on the InForm application server.

    Note: This step is only required if you are restoring an InForm 6.1.1.x release.

Send Feedback