1 Reply Latest reply: May 16, 2014 4:43 AM by 2628932 RSS

    Audit Vault agent issue

    2628932

      I have installed Oracle Audit Vault server (10g rel3) 64bit  on Oracle Enterprise Linux 5 64bit and installation went successful. Afterwards I have installed Oracle Audit Vault Agent (10g Rel3 64bit) on a seperate server having Oracle Enterprise Linux 4.7 64bit. This machine has already Oracle 9 installed in seperate HOME whereas Audit vault agent is installed in seperate HOME. After installation of Audit Vault agent installation I am facing following error for which I am seeking your assistance.

       

      avorcldb verify -src AvAgentDb:1521:db9i -CollType ALL

      Enter source UserName: db_user

      Enter Source Password:*******

       

      Error: Couldn't get source user connection using jdbc:oracle:oci:@(DESCIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=AvAgentDb)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=db9i)))

      Error: ORA-00604: Error occured at recursive sql level 1

      ORA-01882: Timezone region not found

       

      I am executing avorcldb command from Audit Vault Agent HOME and db_user is created in source database which is oracle 9i. I am able to tnsping db9i from Audit Vault Agent HOME without any issue. There is no listener installed/configured in Audit Vault Agent home however tnsnames.ora contains connect information to source database which oracle 9i (db9i). Please suggest fix of this error.