Updating the location of the openpages-storage directory (Oracle)

Applies to: On premises

In the database, update the location of the openpages-storage directory.

If you are using Microsoft Windows, you can also use this procedure to change the storage type from LFS to UNC.

Before you begin

Stop the IBM OpenPages® services if they are running.

Procedure

  1. Log on to the target environment as a user with administrative permissions. You can use any system with access to SQL*Plus that can connect to the database server.
  2. Open a command or shell window.
  3. Locate the update-storage.sql script.

    The script is stored in the following directories. You can use the script in either location.

    • /OP_<version>_Main/OP_<version>_Configuration/Database/ORACLE/INSTALL_SCRIPTS directory.
    • /OP_<version>_Main/OP_<version>_Configuration/Database/ORACLE/UPGRADE_SCRIPTS
  4. Run the update-storage.sql script to update the openpages-storage directory location in the database: 
    sqlplus /nolog @sql-wrapper.sql update-storage.sql <log_file> <oracle_tns_alias> <op_db_user> <op_db_password> <storage_type> <storage_server_name> <host_name> <os_type> <path_or_UNC_name>
    Table 1. Parameters in the update-storage.sql script (Oracle)
    Parameter Description
    <log_file> The name of the log file that the script will create and write information to.
    <oracle_tns_alias> The database alias for the OpenPages database instance, as set during the Oracle database installation.
    <op_db_user> The user name for accessing the OpenPages database.
    <op_db_password> The password for accessing the OpenPages database.
    If the password contains special characters, surround the password in quotation marks:
    • Windows: "password"
    • Linux®: 'password'
    <storage_type> The type of file storage to be used. Valid values are:
    • LFS (local file system)
    • UNC (Universal Naming Convention) - for Windows only
    Note: After you move from LFS to UNC, you cannot go back to using LFS.
    <storage_server_name> The name of the storage server.
    <host_name> The hostname of the storage server.
    <os_type> The type of operating system. Valid values are:
    • Windows
    • Unix
    <path_or_UNC_name> The file path or UNC of the storage location. If the path contains backslashes, wrap the path in single quotation marks.
    Examples
    • LFS

      Windows 

      sqlplus /nolog @sql-wrapper.sql update-storage.sql output.log OP openpage "password" LFS mystorageserver.ibm.com mystorageserver Windows 'C:\IBM\OpenPages\openpages-storage'
      Linux 
      sqlplus /nolog @sql-wrapper.sql update-storage.sql /home/op/upd-storage-output.log op openpage 'password' LFS mystorageserver.ibm.com mystorageserver Unix /usr/opdata/openpages-storage
    • UNC

      Windows

      In the following example, openpages-storage is the UNC share name of the storage location. The openpages-storage location is accessible to all horizontal cluster members as \\mystorageserver\openpages-storage.

      sqlplus /nolog @sql-wrapper.sql update-storage.sql c:\temp\update-storage-output.log op openpages "password" UNC mystorageserver.ibm.com mystorageserver Windows openpages-storage