The AVSYS account is kept as locked in the Audit Vault database after the installation is done. The Audit Vault database has the Database Vault option also enabled. To unlock and reset password for any database user account you have to login as the Database Vault account manager, which is “dvaccountmgr” in Oracle Audit Vault 220.127.116.11 (AVDF). In order to do so you have to login to the Audit Vault server using root password (set during the AVDF installation) and then switch user to “dvaccountmgr” os user .
su – dvaccountmgr
env| grep ORA
SQL> show user;
USER is “OPS$DVACCOUNTMGR”
Now, you are logged in the audit vault database using “DVACCOUNTMGR” account and you can perform the account unlock and password reset operation.
SQL> Alter user avsys account unlock;
SQL> Alter user avsys identified by Welcome1;
Now, you can login to AVSYS account using sqlplus as below
su – oracle
sqlplus / as sysdba
SQL> conn avsys/Oracle123;