Infrastructure at your Service

All Posts By

Grégory Steulet

Grégory Steulet

Oracle AVDF – Database Firewall Policies

By | Database management | 4 Comments

The successful deployment of a Database Firewall depends on an effective policy. Oracle AVDF includes preconfigured firewall policies as described in the Firewall Policy page in the Policy tab of the Audit Vault Server console. These include policies that log all SQL statements, or log only unique SQL statements. In addition, the Database Firewall policy editor enables you to design your own policies quickly and efficiently. Policy rules can depend on any combination of the…

Read More
Grégory Steulet

Oracle AVDF post-installation configuration

By | Database management | 10 Comments

In one of my last blog, named: “Oracle Audit Vault and Database Firewall (AVDF) 12.1 – installation on VirtualBox” I explained how to install AVDF on VirtualBox. Since some of you asked for a blog on “How to configure AVDF”, I decided to write this posting on AVDF post-installation configuration. This one only concerns the post-installation phase, a third blog will be dedicated to practical cases concerning the configuration of Database Firewall Policies. Specifying the…

Read More
Grégory Steulet

MySQL high availability management with ClusterControl

By | Database management | One Comment

Installing and managing a highly available MySQL infrastructure can be really tedious. Solutions to facilitate database and system administrator’s task exist, but few of these cover the complete database lifecycle and address all the database infrastructure management requirements. Severalnines’ product ClusterControl is probably the only solution that covers the full infrastructure lifecycle and is also able to provide a full set of functionalities required by database cluster architectures. In this article, I will show how…

Read More
Grégory Steulet

Oracle Audit Vault and Database Firewall (AVDF) 12.1 – installation on VirtualBox

By | Database management | 19 Comments

This blog explains how to install Oracle Audit Vault and Database Firewall (AVDF) 12.1.1.1.0 on VirtualBox step-by-step. The configuration will be covered in a second blog. Download AVDF Binaries First of all, download the binaries on support.oracle.com: https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?_afrLoop=140865428570210&patchId=16965974&_afrWindowMode=0&_adf.ctrl-state=1a5l4hvifo_4 Patch 16965974: 12.1.1.1.0 FULL INSTALL IMAGES FOR ORACLE AUDIT VAULT AND DATABASE FIREWALL There are three files: 1. Audit Vault Server 2. Database Firewall 3. Documentation You can find the Audit Vault and Database Firewall documentation online…

Read More
Grégory Steulet

Oracle Database 12c new features: segregation of duties with new administrative roles

By | Database management | No Comments

Starting with Oracle Database 12C Release 1 a set of new administrative privileges that are more task oriented are available.

Before Oracle 12c it was needed to have the SYSDBA privilege to make a backup, to monitor the Data Guard status or to administrate some features of Oracle Transparent Data Encryption. Starting with this new Oracle release it is not anymore the case. We can grant limited administrative privileges to operate an Oracle 12c database.

Read More
Grégory Steulet

Errors while installing Oracle Database Vault on Oracle 11.2.0.3

By | Database management | 2 Comments

During one of my last consulting missions, I had to install Oracle Database Vault on an existing Oracle environment. It clearly was not a straigthforward process, since I experienced some weird errors such as: ORA-28003: password verification for the specified password failed, ORA-20001: Password length less than 8, and ORA-01917: user or role ‘LBACSYS’ does not exist. After having a look at several log files, I found the root causes of this error. Below, you…

Read More
Grégory Steulet

Oracle 12c now available for download on OTN and Oracle E-delivery

By | Database management | No Comments

Finally after some months … The Oracle’s long-awaited 12c database (12.1.0.1) is now available for download on OTN and Oracle E-delivery ( http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html). Without any surprise the first platforms are Linux and Solaris! Weird, but until now no “official” announcement from Oracle has been made… Have a look on all new features integrated in this release: http://docs.oracle.com/cd/E16655_01/server.121/e17906/chapter1.htm#NEWFTCH1    

Read More
Grégory Steulet

Mysqldump issue – SELECT command denied to user

By | Database management | One Comment

During one of my last MySQL mission, I encountered a “security error” with mysqldump. The mission was about migrating a MySQL database from one box to another MySQL version and from Windows to Linux with different users. In order to do that, I used mysqldump. During the import of the data, I got the following warning: ERROR 1449 (HY000) at line 1860: The user specified as a definer (‘cdadmin’@’%’) does not exist Following the migration,…

Read More