Qscript to Globally set passwords and optionally usernames for Oracle iDa's


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. To change the password for the specific instance, you must use the GUI 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 can be performed to validate it.

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

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


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 password for a all client, 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 password for a specific client, where the password is encrypted:

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



For more infomartion about the qoperation please refer to:

http://documentation.commvault.com/commvault/release_8_0_0/books_online_1/english_us/features/cli/cli.htm#execscript