OAV-46511: missing plugin for trail at agent on host

Those days, after deploying a new AV agent and trying to setup a new audit trail, I started to receive a weird "OAV-46511: missing plugin for trail at agent on host" error as below: Agent was just deployed so no reason for the agent to not include the plugins. After researching a little, I've found …

Continue reading

Audit Vault installation fails with "Unable to run Clusterware root script"

Today I was installing Audit Vault 12.2.0.4.0 and I started receiving an error saying "Unable to run Clusterware root script" in the final step. First, after researching a little, I found out that I wasn't meeting the requisites for 12.2 installation, only 12.1: For 12.1 (https://docs.oracle.com/cd/E37100_01/doc.121/e27778/preinstall.htm#SIGIG292): Memory Requirements - Each x86 64-bit server must have at …

Continue reading

Oracle Open World 2016 - My POV

Oracle Open World 2016 was really amazing. It was already 1 month ago and only now I had some time to talk about it and Oracle trends for this year. This is the biggest event in DBA area and was outstanding to be in a place with so many experts exchanging ideas! So, there are a lot of …

Continue reading

Oracle Scheduler Jobs and Database Vault

As everybody knows, the "Oracle Scheduler" is the official task manager for an Oracle Database. It is a robust and complex tool, allowing the user to create chains, parameterized intervals on several types of metrics, execution windows, etc. In most cases, when a job is created, modified and executed by its owner, there are not many …

Continue reading

AWR snapshots not being generated even though it's enabled

Those days, I was facing an issue in my Oracle Database 11.2.0.4. My AWR Snapshots were not being generated even though it was full enabled. I did some checks to be sure I had no issues: Checked that I had enough free space on SYSAUX tablespace. I was using only 5GB of the total 15GB. My control_management_pack_access was …

Continue reading