The AV Console Is Not Working When Trying To Connect As AVAUDITOR. Logs Are Filled With ORA-1017 Errors (Doc ID 1302465.1)

Last updated on NOVEMBER 04, 2015

Applies to:

Oracle Audit Vault - Version 10.2.3.2 and later
Information in this document applies to any platform.
Checked for relevance on 12-Jun-2013

Symptoms

The AV Console is not working when trying to connect as AV AUDITOR. 

The av_client-0.log from AV Server's $ORACLE_HOME/av/log directory shows the following errors:


Mar 8, 2011 2:43:28 PM Thread-13 SEVERE: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

java.sql.SQLException: ORA-01017: invalid username/password; logon denied

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java(Compiled Code))
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java(Compiled Code))
at oracle.jdbc.driver.T2CConnection.processOCIConnectionPooling(T2CConnection.java:939)
at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:227)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:519)
at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:131)
...



After setting the 1017 errorstack event on the AV Server database there is a trace file produced every 10 seconds. The trace file shows that the user ID is 52:



[oracle@oratest5-ro log]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Mar 9 21:02:16 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
and Real Application Testing options

SQL> alter system set events '1017 trace name errorstack level 3';

System altered.


SQL> show parameter user_dump_dest

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
user_dump_dest string /oracle/admin/av/udump

exit

cd /oracle/admin/av/udump

more av_ora_13664.trc

...
Library Cache uid 152 efd 0 whr 0 slp 0
----------------------------------------
SO: 0x8ee38a38, type: 52, owner: 0xbf4ae7d0, flag: INIT/-/-/0x00
user lock: lock=8ee38a38 mode=S
user resource: user=bbef71e8 uid=52 mode=S
----------------------------------------
SO: 0x8ee3ae70, type: 52, owner: 0xbf4ae7d0, flag: INIT/-/-/0x00
user lock: lock=8ee3ae70 mode=S
user resource: user=bbef71e8 uid=52 mode=S
...



SQL> select username from dba_users where user_id=52;

USERNAME
------------------------------
AVREPORTUSER





Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms