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 …
Oct 24
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 …
Aug 16
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 …
Aug 11
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 …
Aug 11
How to protect CREATE PUBLIC SYNONYM against privilege escalation
During my last presentation on GUOB Tech Tour 2016 – Oracle Technology Tour LA – Brazil, I demonstrate how we could easily use the CREATE PUBLIC SYNONYM privilege to escalate and get DBA privilege. In this article, I will give you a package that I’ve created and I use in my systems to allow users to …





