Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Audit Vault agent issue

User_MKN83May 15 2014 — edited May 16 2014

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.

Comments

Scott Wesley
Answer

The native Popup Lov facilitates multi-value selection (from 19.x), or the Select2 plugin can do the same. This would be from a known set of values.
They will store the values in a delimited string for that field, which you than then use apex_string.split to break it up as necessary.
If you need to dynamically add tags, then you may consider the United Codes List Extension plugin

Marked as Answer by SteveQuinlivan · Apr 21 2021
SteveQuinlivan

Thanks @scott-wesley, the Popup Lov will give me what i need

Regards

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 13 2014
Added on May 15 2014
1 comment
1,079 views