Restore the previous Oracle InForm 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 previous Oracle InForm environment.

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

   pfadmin /STOPALL

3. Run the following command to unregister the Oracle InForm services.

   \OracleHS\InForm\bin\regservers /s /f /u

4. Rename the OracleHS folder with the current version number (for example, OracleHS-7011).
5. Rename the folder containing the Oracle InForm files for the previous release (for example, OracleHS-Backup) to OracleHS.
6. Restore the Microsoft C++ Runtime files from the backup.

   copy /y Runtime-Backup\*.dll %SYSTEMROOT%\System32

7. Restore the Microsoft Runtime registry.

   Note:

   All backed up registry files must be restored to their original location.

   Using the file names from the example on the backup instructions page:

   reg import Runtime-Backup\runtime64-1.reg /reg:64
   reg import Runtime-Backup\runtime64-2.reg /reg:64
   reg import Runtime-Backup\runtime32-1.reg /reg:32
   

8. Restore the Oracle InForm registry.
   Using the file names from the example on the backup instructions page:

   reg import OracleHS-Backup.reg
   reg import OdbcIni-Backup.reg
   reg import InFormUninstall-Backup.reg
   

9. Run the following command to register the Oracle InForm services:

   \OracleHS\InForm\bin\regservers /s

10. Run the following command to restore the Trial Server services:

    Note:

    The PowerShell script is run from the new version files, not the version that is being restored.

    powershell -ExecutionPolicy Bypass \OracleHS-7011\InstallSupport\ResetTrialServersMtx.ps1

11. 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 Oracle 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 pfst621.dmp pfst621uid
        

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