1. Administration and Configuration Guide
  2. Configurations for Connecting OFSAA to Oracle Database using Secure Database Connection (TCPS)
  3. Configure OFSAA to Store Config Schema, Atomic Schema, and SysDBA Credentials with Oracle Wallet

Configure OFSAA to Store Config Schema, Atomic Schema, and SysDBA Credentials with Oracle Wallet

To configure the OFSAA to store the Config and Atomic Schema credentials with Oracle Wallet, follow these steps:
  1. Log in as a UNIX user with the permission to modify the Oracle Wallet.
  2. Execute the following command to configure Config Schema credentials. Enter the password to store the credentials in the Wallet when prompted.
    $ORACLE_HOME/bin/mkstore -wrl <WALLET_HOME> -createCredential -nologo CONFIG <CONFIG_DATABASE_USERNAME> <CONFIG_DATABASE_PASSWORD>
  3. Execute the following command to configure the Atomic Schema credentials. Enter the password to store the credentials in the Wallet when prompted.
    $ORACLE_HOME/bin/mkstore -wrl <WALLET_HOME> -createCredential -nologo <ATOMICALIASNAME> <ATOMIC_DATABASE_USERNAME> <ATOMIC_DATABASE_PASSWORD>
  4. Configure SysDBA credentials. Execute the following command to configure SysDBA Schema credentials. Enter the password to store the credentials in the Wallet when prompted.
    $ORACLE_HOME/bin/mkstore -wrl <WALLET_HOME> -createCredential -nologo SYS <SYS_DATABASE_USERNAME> <SYS_DATABASE_PASSWORD>

    Note:

    • CONFIG value is a TNS alias for Config Schema. Do not change this value.
    • SYS value is a TNS alias for SYSDBA Schema user. Do not change this value. This is required only to execute Schema Creator Utility in Online mode. If Schema creation is executed in Offline mode, this alias is not required.
    • ATOMICALIASNAME value is a TNS alias for Atomic Schema. It must not contain underscores.

      For example, if the Atomic Schema Name is PROD_OFSAAATM, then the value for ATOMICALIASNAME must be entered as PRODOFSAAATM.

    • In case of Config and Atomic Schema passwords are changed over a period of time, new password credentials needs to be updated for Config and Atomic Schema in the Oracle Wallet so that OFSAA and Webserver takes the new credentials.
      1. Execute the following command to update passwords of Config and Atomic Schema users.
      2. Enter the password to store the credentials in the Wallet when prompted.

      $ORACLE_HOME/bin/mkstore -wrl <WALLET_HOME> -modifyCredential -nologo CONFIG <CONFIG_DATABASE_USERNAME> <CONFIG_DATABASE_PASSWORD> $ORACLE_HOME/bin/mkstore -wrl <WALLET_HOME> -modifyCredential -nologo <ATOMICALIASNAME> <ATOMIC_DATABASE_USERNAME> <ATOMIC_DATABASE_PASSWORD>