Infrastructure at your Service

Category

Database Administration & Monitoring

Mouhamadou Diaw

Oracle 12C Unified Auditing Feature in a multitenant environment

By | Database Administration & Monitoring | No Comments

In oracle 12c we have a new feature called Unified Auditing. What is it, how to implement it, how it works in a multitenant environment that’s what we will try to explain briefly in this article. Traditional oracle audit involves many audit-trail locations and tables and does not follow a standard. To help with this oracle 12c has introduced Unified Auditing  1- Enabling Unified Auditing By default the feature is disabled SQL> select value from…

Read More
Daniel Westermann

The (almost) same sample schema for all major relational databases (1) – PostgreSQL

By | Database Administration & Monitoring | No Comments

The are times when it would be nice to have the same sample schema in all relational databases you or your company are working on. This is great if you want to compare how different databases execute the same tasks on the same data. This can be great if you want to test logical replication between different databases and this might be great if you want to test migration tools that support you in migrating…

Read More
Franck Pachot

Transparently externalize BLOB to BFILE

By | Database Administration & Monitoring | One Comment

By Franck Pachot . Storing documents within the database is the easiest, especially because you get them consistent with the metadata stored in the database. If you store them externally, then you need to manage their backup, their synchronization to standby site, the consistency in case of flashback or PITR, etc. However, documents grow (in number and in size thanks to better resolution of scan) and you don’t want a database where half of the…

Read More

VM Linux – Device not found : Network unreachable

By | Database Administration & Monitoring, Operation systems | No Comments

Recently I exported an Oracle Virtual Box VM as an “.ova” file. When the file was imported again I faced issues with the network devices inside the VM. This post is about what I experienced and how I resolved it. In my example I have two networks devices configured for the VM in the Virtual Box: When I logged in I found that eth0 and eth1 are not available: [[email protected] ~]# ifconfig lo Link encap:Local…

Read More
Oracle Team

Dbvisit Standby Version 7 auf Windows Server 2012 R2

By | Database Administration & Monitoring, Database management | No Comments

Ausgangslage Wie gut lässt sich mit Oracle Standard Edition unter Windows eine Hochverfügbarkeitslösung aufbauen? Die Basis, zwei Windows Server 2012 R2, Oracle Standard Edition und Dbvisit Standby. Die eingesetzte Version Dbvisit Standby 7.0.48.15006. Die eingesetzte Oracle Version 12.1.0.2.0. Installation Die Windows Installation ist Standard, nur die beiden Server müssen, zwecks Namensauflösung im Hosts File(C:\Windows\System32\drivers\etc\hosts) unter Windows eingetragen werden. 192.168.198.129 node01.localdomain node01 NODE01 192.168.198.130 node02.localdomain node02 NODE02 Der zweite Schritt, die Installation der Oracle Software. Als erstes…

Read More
Oracle Team

Stay tuned with kernel parameters

By | Database Administration & Monitoring, Operation systems | No Comments

Why does the sysctl.conf value for swappiness on Oracle Linux 7.x not survive a reboot For a project I applied the dbi services best practices for Oracle databases. One of these is to adjust the swappiness parameter. We recommend to use a very low for the swappiness value like 10 or even lower to reduce the risk for Linux to begin swapping! Swapping on a database server is not a problem per se, but it generates activity…

Read More
Franck Pachot

Single-Tenant vs. non-CDB: no reason to refuse it

By | Database Administration & Monitoring | 4 Comments

By Franck Pachot . When non-CDB has been declared deprecated, I was a bit upset because multitenant with a lone PDB just looks like an overhead of 3 containers instead of one. But with experience I changed my mind. First because the multitenant architecture brings some features that are available even without the option. And second, because this overhead is not a big problem. Let’s put numbers on that last point.

Read More
Clemens Bleile

Oracle kernel relink on Linux: Are my options stored persistently?

By | Database Administration & Monitoring, Database management, Oracle | 2 Comments

I recently visited an Oracle presentation about the Oracle-kernel built-in directNFS (dNFS) driver. To use dNFS in the database you have to enable it: cd $ORACLE_HOME/rdbms/lib make -f ins_rdbms.mk dnfs_on REMARK: In versions before 11gR2/12c the following manual steps were necessary: cd $ORACLE_HOME/lib mv libodm11.so libodm11.so_stub ln –s libnfsodm11.so libodm11.so In the context of make-commands, somebody in the audience asked the question how Oracle persistently stores the current link options, so that a future relink…

Read More