Is there a way to reset the password of DB accounts in Demo vApp Environment

Products

• CA Identity Suite

Issue/Introduction

We would like to change the password used by oracle users inside of vApp Demo environment.

Environment

vApp 14.X

Resolution

Demo Environment of vApp uses Oracle Express Database to change users there follow process below:

Login to vApp CLI

Change user to oracle.

su - oracle

In bash run

source /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh

Connect to SQL Plus:

sqlplus / as sysdba

Change password of user and unlock them:

ALTER USER <username> IDENTIFIED BY <new_password> ACCOUNT UNLOCK;

You can change IDM, SYS or SYSTEM user like this. 

Take into account that password for IDM needs to be provided in Directory.xml for IM to work.