CLI Cookbook: How to Change Database User Password

1. ssh into your engine using Admin privileges

ssh delphix_admin@delphixengine

2. Go to sourceconfig and fine the Database that you need to update the password on

delphix > sourceconfig
delphix sourceconfig > ls
delphix sourceconfig > select <yourdatabase>

3. Update the password

delphix sourceconfig "yourdatabase" > update
delphix sourceconfig "yourdatabase" update *> ls
delphix sourceconfig "yourdatabase" update *> set credentials.password=<new password>

4. Commit the change

delphix sourceconfig "database" update *> commit

Examaple:

ssh delphix_admin@example
delphix > sourceconfig
delphix sourceconfig > ls
 
Objects

NAME   REPOSITORY                  LINKINGENABLED

meta1  '/u01/oracle/10.2.0.4/ee1'  true

Operations

create

delphix sourceconfig > select meta1
delphix 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




Operations

delete

update

validateCredentials
 
delphix sourceconfig "meta1" > update
delphix sourceconfig "meta1" update *> credentials.password=<new password>
delphix sourceconfig "meta1" update *> commit