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 …

Continue reading

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 …

Continue reading

Jun 16

GUOB TECHDAY 2016

The year passed very fast and GUOB TechDay 2016 is now closer than it looks! And for those who do not know, this is one of the major Oracle users event in Brazil. It takes place annually in São Paulo, on a July or August Saturday. Unlike the OOW, which is a more commercial and …

Continue reading

Jun 06

SQLcl not connecting as sysdba

SQLcl is the modern SQL Plus. It was developed my the same team who created the SQL Developer and is java based, with a lot of features that SQL Plus was lacking for years. One problem that I was having after a fresh installation was some error when trying to connect as sysdba: [oracle@myserver ~:orcl]$ …

Continue reading

May 16

EM agent start fails With ‘Target Interaction Manager failed at Startup’ and ‘java.lang.OutOfMemoryError: Java heap space’ reported on logs

In this article, I will show how to solve EM Agent failing to startup related to java memory problems. Those days, after applying some EM Agent patches and trying to restart them, I received the error below: [emc12@localhost ~]$ emctl start agent Oracle Enterprise Manager Cloud Control 12c Release 5 Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved. …

Continue reading