Hi at all,
I have a question about the installation of the agent on the RAC configuration. Where must I install the Audit vault agent, on all RAC nodes or is there a properly configuration?
By default when you install the agent on any single node the installation recognizes that it is a cluster and presents you with a list of available nodes from which to select.
With a RAC cluster you have one database and multiple instances. All instances will write to one, and only one AUD$ and FGA_LOG$ table so if you are using database auditing one node will suffice. Which node that is though depends on knowing which node is up at any one time so you could potentially choose a node that is dropped from the cluster or is down for patching and maintenance while the cluster is still running. With respect to REDO collection each node has its own redo thread so you definitely need to be collecting from every node.
Audit Vault has not been out long enough that I can tell you from experience what might be defined as "best practice" and often what we really need to study is "worst practice" to know what not to do. But in the case of RAC my instinct would be to first determine the collection type(s) and then decide. Erring on the side of collecting from all nodes makes a lot of sense.
i have installed AV agent on RAC DB, but it didn't offer me to installation on other nodes. Are you try this, and worked for you ? Are there any extra steps before installing agent on RAC DB ?
In the case of installation on one node, i assume that it does not read all audit data: it can't read from alert and redo files (OSAUD and REDO collectors) on other nodes, is this right assumption?
Go to Morgan's Library at www.psoug.org
Click on Audit Vault
Scroll to page bottom
If you didn't see these screens my guess is that you may have some issues with that RAC cluster of which you are not already aware.
What version is it (3+ decimal places)?
Anybody found any instruction about Agent RAC installation?
Cannot find enough resources on the web.
Just found this:
Audit Vault Collection Agent Configuration for RAC Database - Step by Step Guide [ID 788381.1]
Edited by: drbiloukos on 12 Ιουλ 2011 1:01 μμ