Back up the Oracle InForm study and admin databases and files for the in-place upgrade

  1. Stop the studies and servers, by typing the following commands in the order listed:
    pfadmin stop trial <studyname>
    pfadmin stop server <servername>
  2. Stop all InForm applications and integrations that require the Oracle InForm service, for example, the Oracle Central Designer application.
  3. Stop the Oracle InForm service.
  4. To back up the Oracle InForm study database, run ExportDB.cmd (located in the <InstallationDirectory>\InForm\bin\DBOra folder) on the Oracle InForm database server to back up each Oracle InForm study database as a DMP file, using the following syntax:
    ExportDB.cmd <TNS_Service_Name> <Physical_Directory_Path> <Dump_File_Name>
    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.

      Note:

      Do not include spaces in the directory path to the DMP file.
    • DUMP_File_Name — Name of the DMP file to export.

      Note:

      Do not include spaces in the DMP file name.
    You are prompted for the following values:
    • orasystem_user — Name of the Oracle database system user.
    • orasystem_user_pass — Password for the Oracle database system user.
    • trial_user — Name of the study database schema owner.
    • trial_user_pass — Password for the owner of the study database schema.
    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: ExportDB.cmd trial1 /u01/app/oracle/dp_export pfst55.dmp
    The ExportDB command creates the log file <DMP_File>.log.
  5. To back up the InForm admin database, run ExportDB.cmd (located in the <InstallationDirectory>\InForm\bin\DBOra folder) on the InForm database server to back up each InForm study database as a DMP file, using the following syntax:
    ExportDB.cmd <TNS_Service_Name> <Physical_Directory_Path> <DMP_File_Name>
    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.

      Note:

      Do not include spaces in the directory path to the DMP file.
    • DMP_File_Name — Name of the DMP file to export.

      Note:

      Do not include spaces in the DMP file name.
    You are prompted for the following values:
    • orasystem_user — Name of the Oracle database system user.
    • orasystem_user_pass — Password for the Oracle database system user.
    • admin_user — Name of the Oracle InForm admin database schema owner.
    • admin_user_pass — Password for the owner of the Oracle InForm admin database schema.
    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: ExportDB.cmd trial1 /u01/app/oracle/dp_export pfst62.dmp
    The ExportDB command creates the log file <DMP_File>.log.
  6. Export the Oracle InForm registry keys from all servers, including the Oracle InForm server and the Reporting and Analysis server, found in the following locations:
    • HKLM\SOFTWARE\OracleHS
    • HKLM\SOFTWARE\ODBC.INI
    • HKLM\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall\{BF0ACB61-BCAB-4364-A881-76863CD9CCF2}

    For example:

    C:\>reg export HKLM\SOFTWARE\OracleHS OracleHS-Backup.reg
C:\>reg export HKLM\SOFTWARE\ODBC.INI OdbcIni-Backup.reg
C:\>reg export HKLM\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall\{BF0ACB61-BCAB-4364-A881-76863CD9CCF2} InFormUninstall-Backup.reg
C:\>
  7. Backup the Microsoft Visual C++ Runtime by creating a folder for the runtime files backup, and copying the following files:
    • %SYSTEMROOT%\System32\vcruntime140*.dll
    • %SYSTEMROOT%\System32\vccorlib140*.dll
    • %SYSTEMROOT%\System32\msvcp140*.dll
    • %SYSTEMROOT%\System32\concrt140*.dll
    • %SYSTEMROOT%\System32\mfc140*.dll
    • %SYSTEMROOT%\System32\mfcm140*.dll
    • %SYSTEMROOT%\System32\vcamp140*.dll
    • %SYSTEMROOT%\System32\vcomp140*.dll

    For example:

    C:\>mkdir Runtime-Backup
C:\> copy %SYSTEMROOT%\System32\vcruntime140*.dll Runtime-Backup
C:\> copy %SYSTEMROOT%\System32\vccorlib140*.dll Runtime-Backup
C:\> copy %SYSTEMROOT%\System32\msvcp140*.dll Runtime-Backup
C:\> copy %SYSTEMROOT%\System32\concrt140*.dll Runtime-Backup
C:\> copy %SYSTEMROOT%\System32\mfc140*.dll Runtime-Backup
C:\> copy %SYSTEMROOT%\System32\mfcm140*.dll Runtime-Backup
C:\> copy %SYSTEMROOT%\System32\vcamp140*.dll Runtime-Backup
C:\> copy %SYSTEMROOT%\System32\vcomp140*.dll Runtime-Backup
C:\>
  8. Backup the Microsoft VC++ Runtime Registry.
    There are multiple occurrences that can have different paths, so first locate the entries and note the key paths.

    Both 32 and 64 bit registry entries must be backed up.

    C:\>reg query HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall /s /f "Microsoft Visual C++" /reg:64
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{455DF12C-7D43-4EFF-AE2F-43C8AF2817A3}
    DisplayName    REG_SZ    Microsoft Visual C++ 2019 X64 Minimum Runtime - 14.28.29914
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{5A23DBE2-A05C-4A9C-9C17-EA88BF5D7B43}
    DisplayName    REG_SZ    Microsoft Visual C++ 2019 X64 Additional Runtime - 14.28.29914
End of search: 2 match(es) found.
C:\>reg query HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall /s /f "Microsoft Visual C++" /reg:32
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{43d1ce82-6f55-4860-a938-20e5deb28b98}
    DisplayName    REG_SZ    Microsoft Visual C++ 2015-2019 Redistributable (x64) - 14.28.29914
End of search: 1 match(es) found.
C:\>

    Export each of the located registry keys.

    Note:

    You must use unique file names. 
    C:\>reg export HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{455DF12C-7D43-4EFF-AE2F-43C8AF2817A3} RuntimeBackup\runtime64-1.reg /reg:64
The operation completed successfully.
C:\>reg export HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{5A23DBE2-A05C-4A9C-9C17-EA88BF5D7B43} RuntimeBackup\runtime64-2.reg /reg:64
The operation completed successfully.
C:\>reg export HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{43d1ce82-6f55-4860-a938-20e5deb28b98} RuntimeBackup\runtime32-1.reg /reg:32
The operation completed successfully.
C:\>
  9. Create a backup copy of the OracleHS folder:
    For example:
    C:\> xcopy /E \OracleHS \OracleHS-backup\
C:\>
  10. For each Oracle InForm study that includes the Reporting and Analysis module, ensure that all users move the content in their My Folders area to the study folder in Public Folders.

    Note:

    Content in the My Folders area and individual User Preferences are not migrated during the export and import steps of the Cognos upgrade.

    Note:

    In multi-server Cognos environments, the deployment archives are created on the active Content Manager server.

Parent topic: Running an in-place upgrade