Category: Oracle Database General

Oracle Database General

May 10

Where is Oracle Database 12.2.0.1 April 2017 PSU ?

Oracle 12.2 database is already available for more than 3 months. As expected, the first Patch Set for a given Release comes with a lot of bugs and we want as soon as possible a PSU to close all those gaps. However, I couldn’t find the PSU for the 12.2 version on the quarterly April 2017 …

Continue reading

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 …

Continue reading

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

Mar 10

ORA-00600: internal error code, arguments: [kpdbSwitchPreRestore: txn] in Oracle Database 12c

On several Oracle DB in 12.1.0.2 version I started receiving some strange ORA-00600 and ORA-07445 errors in the alert file. In ORA-00600, the first parameter was “[kpdbSwitchPreRestore: txn]”: Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xFAC8] [PC:0x7A1FA6E, qksanEndSession()+30] [flags: 0x0, count: 1] Errors in file /u02/diag/rdbms/cdbtim01/cdbtim01/trace/cdbtim01_j004_21773.trc (incident=57639): ORA-07445: exception encountered: core dump [qksanEndSession()+30] [SIGSEGV] [ADDR:0xFAC8] [PC:0x7A1FA6E] …

Continue reading