Oracle Team

Statspack installation scripts

By Franck Pachot . When Diagnostic Pack is disabled, either because you don't have Diagnostic Pack or you are in Standard Edition, I highly recommend to install Statspack. When you will need it, to investigate on an issue that occured(…)

DataGuard and Transparent Data Encryption

By Mouhamadou Diaw Setting up a DatagGard environment for a database with Transparent Data Encryption requires some tasks concerning the encryption keys. Otherwise the steps are the same than for an environment without TDE. In this blog we will(…)

PGIO, PG_STAT_ACTIVITY and PG_STAT_STATEMENTS

By Franck Pachot . For an Oracle DBA, we are used to join active sessions (from V$SESSION where status='ACTIVE) with active statements (from V$SQL where users_executing>0) on the SQL_ID. V$ACTIVE_SESSION_HISTORY also displays the TOP_LEVEL_SQL_ID to get the entrypoint of the(…)

Lighty for PostgreSQL

By Franck Pachot . If you follow this blog, you should know how I like Orachrome Lighty for Oracle, for its efficiency to monitor database performance statistics. Today Orachrome released the beta version of Lighty for Postgres:(…)

Oracle Virtual Private Database

By Mouhamadou Diaw Oracle Virtual Private Database (VPD) enables you to dynamically add a WHERE clause in any SQL statement that a user executes. The WHERE clause filters the data the user is allowed to access, based on the identity(…)

Kernel panic – not syncing: Out of memory and no killable processes

By Franck Pachot . This is a quick post to give a solution (maybe not the best one as this was just quick troubleshooting) if, at boot, you see something like: Trying to allocate 1041 pages for VMLINUZ [Linux=EFI, setup=0x111f,(…)

18c: No Active Data Guard required (and detected) when only CDB$ROOT and PDB$SEED are opened in read-only

By Franck Pachot . When you clone a PDB on the primary CDB, you want that the same is automatically done on the standby ones. Unfortunately, for this operation, the CDB must be opened read-only. In 12.1 even the PDB(…)

Introduction to databases for {Power.Coders} with MySQL

By Franck Pachot . This week I took some days off to do something related to my job but a bit different. I've given a course on Databases and SQL. But not for my usual customers. And not(…)

utl_dbws causes ORA-29532 and bad_record_mac

After installing OJVM patch set update APR-2017 on a 11.2.0.4 database with PSU APR-2017 installed, first call of utl_dbws package was successful, but after a while utl_dbws calls failed always with ORA-29532 and bad_record_mac. All Java objects remained valid.

Migrating from ASMLIB to ASMFD

By Mouhamadou Diaw Before Oracle 12.1 the methods used to configure ASM were • udev • asmlib Oracle 12.1 comes with a new method called Oracle ASM Filter Driver (Oracle ASMFD). In Oracle documentation we can(…)