Skip to main content
Skip table of contents

CLI cookbook: how to change database user password

  1. ssh into your engine using Admin privileges.

    CODE
    ssh admin@delphixengine
  2. Go to sourceconfig and find the Database that you need to update the password on.

    CODE
    delphix > sourceconfigdelphix sourceconfig > lsdelphix sourceconfig > select <yourdatabase>
  3. Update the password.

    CODE
    delphix sourceconfig "yourdatabase" > updatedelphix sourceconfig "yourdatabase" update *> lsdelphix sourceconfig "yourdatabase" update *> set credentials.password=<new password>
  4. Commit the change.

    CODE
    delphix sourceconfig "database" update *> commit

Example:

CODE
ssh admin@exampledelphix > sourceconfigdelphix sourceconfig > lsObjects NAME   REPOSITORY                  LINKINGENABLEDmeta1  '/u01/oracle/10.2.0.4/ee1'  true Operationscreate delphix sourceconfig > select meta1delphix sourceconfig "meta1" > ls  Properties    type: OracleSIConfig    name: meta1    credentials:        type: PasswordCredential        password: ********    databaseName: meta1    discovered: true    environmentUser: delphix    instance:        type: OracleInstance        instanceName: meta1        instanceNumber: 1    linkingEnabled: true    nonSysCredentials: (unset)    nonSysUser: (unset)    reference: ORACLE_SINGLE_CONFIG-1    repository: '/u01/oracle/10.2.0.4/ee1'    services:        0:            type: OracleService            discovered: true            jdbcConnectionString: jdbc:oracle:thin:@172.16.100.69:1525:meta1        1:            type: OracleService            discovered: true            jdbcConnectionString: jdbc:oracle:thin:@172.16.100.69:1521:meta1    uniqueName: meta1    user: delphix OperationsdeleteupdatevalidateCredentials delphix sourceconfig "meta1" > updatedelphix sourceconfig "meta1" update *> set credentials.password=<new password>delphix sourceconfig "meta1" update *> commit
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.