1. Analytical Applications Infrastructure
  2. Additional Information
  3. Configure Password Changes
  4. Modify the OFSAA Infrastructure Atomic Schema Password in a Wallet-Based Setup

Modify the OFSAA Infrastructure Atomic Schema Password in a Wallet-Based Setup

To change the Atomic Schema Password in a Wallet-Based setup, follow these steps:
  1. Shutdown all the OFSAAI Services and Web Servers.
  2. Change the Atomic Schema User Password in the Database.
  3. Log in as a UNIX user with the permission to modify the Oracle Wallet.
  4. Execute the following command to configure the Atomic Schema credentials.
    $ORACLE_HOME/bin/mkstore -wrl <WALLET_HOME> -modifyCredential -nologo <ATOMICALIASNAME> <ATOMIC_DATABASE_USERNAME> <ATOMIC_DATABASE_NEWPASSWORD>

    Note:

    ATOMICALIASNAME value is a TNS alias for Atomic Schema and must not contain underscores. For example, if the Atomic Schema Name is PROD_OFSAAATM, then the value for ATOMICALIASNAME must be entered as PRODOFSAAATM.
  5. Enter the password to store the credentials in the Wallet when prompted.
  6. Start all the OFSAAI Services excluding Web Servers.
  7. If you use Apache Tomcat, WebSphere, or WebLogic as the Web Server, update the associated Wallet directory with the new Atomic Schema User Password.
  8. Start the associated Web Servers.