Modifying database passwords in the backup-restore environment files

If you change the IBM OpenPages® database password, you need to update the environment files that are used by the backup and restore utilities.

Procedure

  1. Repeat these steps on each application server.
  2. Open a command or shell window as an administrator.
  3. Go to the <OP_HOME>/aurora/bin directory and locate the op-backup-restore.env file.
  4. Make a backup copy of the op-backup-restore.env file.
  5. Open the op-backup-restore.env file in a text editor.
  6. Update the following passwords:
    Db2
    • DB_OP_PWD: Type the password of the schema owner for the OpenPages database.
    Oracle
    • DB_SYSTEM_PWD: Type the password of the SYSTEM user for the OpenPages database.
    • DB_SYS_PWD: Type the password of the DBA user for the OpenPages database.
    • DB_OP_PWD: Type the password of the schema owner for the OpenPages database.
  7. If you're using Oracle, do the following steps:
    1. Go to the <CC_HOME>/tools/bin directory and locate the op-cc-backup-restore.env file.
    2. Make a backup copy of the op-cc-backup-restore.env file.
    3. Open the op-cc-backup-restore.env file in a text editor.
    4. Update the DB_CC_PWD password.
      Type the password of the schema owner for the Cognos® database.
      Note: If you use the same database for OpenPages and the Cognos content store, enter the passwords for the OpenPages database DBA and schema owner.
  8. Re-encrypt the passwords in the op-backup-restore.env and op-cc-backup-restore.env files.
    See Encrypting database passwords in the backup-restore utility environment files.
  9. Repeat these steps on each application server.