SetOracleCredentials

Scope

Intended Audience
All X
CommVault Internal  
CE/System Test  
Development  

Platform

  • CommServe (Database: CommServ)

Release

  • 9.0.0

Description

The SetOracleCredentials qscript allows you to globally set passwords and optionally usernames for Oracle agents.

Usage

Use the following command to change the password credentials:

qscript -f setOraclecredentials -i c=clientName|allclients t=Catalog|DB|Impersonate|RAC encryptedpassword [username]

Notes:

1) Requires Client name, Credential, password and login as an input. Refer to step 2, 3, 4 and 5

 

2) The script can be used on a specified Client or all clients which must be specified as an input. However, to change the password for the specific instance, you must use the CommCell Console to do so.

 

3) Please provide the credentials type as DB, Catalog, Impersonate User (Windows platforms only) or RAC as an input. Parameter 2 (Credentials type) can be in the following format: t=Catalog, t=DB, t=RAC, or t=Impersonate. In the case of RAC, all databases under the Oracle RAC instance will be given the same password/(username).

 

4) The passwords can be passed as plain text using -p1|-p2|-p3 or encrypted using -si. If you are using -p1|-p2|-p3 argument then the qcommand will essentially encrypt the password before passing it to qscript. No check is/can be performed to validate it.

 

5) If the username option is specified, the username in addition to the password is modified. If username is not specified, only password(s) are modified.

Examples

  1. To change the password for a specific client, where the password is in plain text:

    qoperation execscript -sn SetOracleCredentials.sql -si c=client1 -si t=RAC -p2 passwd -si cvadmin

  2. To change the connect string user name/password credentials for all databases on all clients, where the password is in plain text:

    qoperation execscript -sn SetOracleCredentials.sql -si allclients -si t=DB -p2 passwd -si cvadmin

  3. To change the credentials for impersonate user (applicable for windows clients only)
    • For specific client

      qoperation execscript -sn SetOracleCredentials.sql -si c=client1 -si t=Impersonate -p2 passwd -si domainname\username

    • For all the clients

      qoperation execscript -sn SetOracleCredentials.sql -si allclients -si t=Impersonate -p2 passwd -si domainname\username

  4. To change the password for a specific client, where the password is encrypted:

    qoperation execscript -sn SetOracleCredentials.sql -si c=client1 -si t=Catalog -si <encrypted>  -si cvadmin

Version

 

Disclaimer of Warranties

CommVault provides software tools and utilities on an "as is" basis, as a courtesy and convenience to its users, and they may be changed from time to time without notice. These tools and utilities are provided without express, implied, or statutory warranties of any kind. You assume full risk and responsibility for the selection, possession, performance and proper installation and use of the software tools and utilities, and for verifying the results obtained there from. Your use of CommVault software tools and utilities indicates your unconditional acceptance of the above disclaimer.