Restore a 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.
2. Run the following command to stop all InForm studies.

   pfadmin /STOPALL

3. Rename the OracleHS folder to OracleHS-631.
4. Rename the folder containing the Oracle InForm files for the previous release (for example, OracleHS-7001) 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 pfst621.dmp pfst621uid
       

   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 Oracle InForm settings from your previous release.