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

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 …

Continue reading