Infrastructure at your Service

Franck Pachot

ODA X6 installation: re-image

By | Database management | No Comments
 

 The Oracle Database Appliance is shipped with a bare-metal installation which may not be the latest version. You may want to have it virtualized, or get the latest version to avoid further upgrade, or install an earlier version to be in the same configuration as another ODA already in production. The easiest for all cases is to start with a re-image as soon as the ODA is plugged. This post is not a documentation, just…

Read More
Daniel Westermann

Summer, autumn and winter: a lot of conferences ahead

By | Database Administration & Monitoring | No Comments
 

 It is hot in Europe, it is summer, enjoy, but technology moves fast so you have the chance to already prepare for the next conferences. The IT Tage 2017 will happen the 11th to 14th of December this year and we are happy to be there again. This event covers a wide range of topics and we will be there again covering and talking about: Stéphane Haby, SQL Server 2017: Überblick Stéphane Haby, SQL Server:…

Read More
William Sescu

OUD 11.1.2.3 – ODSM Session Timeout

By | Application integration & Middleware, Database Administration & Monitoring | No Comments
 

 The ODSM is a quite powerful tool for managing the Oracle Unified Directory, and quite a lot of default settings are very reasonable. But there is one that disturbed me from the beginning. It is the ODSM Session Timeout. You might see a message like the following. Or maybe this one. It just says, that the page will expire unless a response is received within 2 minutes. Doing some complex searches or similar stuff often…

Read More
Franck Pachot

12cR2 Application Containers and Foreign Keys

By | Database management | 2 Comments
 

 Application Container brings a new way to share data among databases, and adds a new dimension to referential integrity. A foreign key in an application PDB can reference a row belonging to a root data link table. But then, should a delete on the root validate that there are no orpheans in the application PDBs? And what if those PDBs are closed at the time of this delete? Here is a small example.

Read More
Olivier Toussaint

DBSAT un outil pour la sécurité de vos bases de données Oracle

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

 Qu’est-ce que DBSAT ? C’est un outil gratuit d’Oracle que vous pouvez télécharger sur My Oracle Support avec comme référence : Doc Id 2138254.1. Il a pour but d’évaluer la sécurité de vos bases de données Oracle en analysant la configuration et les stratégies de sécurité mise en place afin de découvrir les risques liés à la sécurité. Comment cela fonctionne t-il ? Dans un premier temps il sera nécessaire de collecter les informations de…

Read More
William Sescu

OUD 11.1.2.3 – How to create an OUD Start/Stop/Status script on Oracle Linux 6

By | Database Administration & Monitoring | No Comments
 

 One of the questions that pops up immediately, after you have installed your OUD successfully is how to integrate it into the automatic startup routines of the OS. My example here show how to do it on Oracle Linux 6. On Oracle Linux 7 it looks a little different. Fortunately, Oracle delivers a script called “create-rc-script”, which can be found in your asinst home directory. It lets you specify the user name under which the…

Read More
Daniel Westermann

A first look at EDB Postgres Enterprise Manager 7 beta – Connecting a PostgreSQL instance

By | Database Administration & Monitoring | No Comments
 

 In the last post we did a click/click/click setup of the PEM server. What we want to do now is to attach a PostgreSQL instance to the PEM server for being able to monitor and administer it. For that we need to install the PEM agent on a host where we have a PostgreSQL instance running (192.168.22.249 in my case, which runs PostgreSQL 10 Beta1). Lets go …

Read More
William Sescu

Oracle 12.2 – How to rotate the 12.2 listener log (DIAG_ADR_ENABLED_LISTENER = OFF) – Follow Up

By | Database Administration & Monitoring | No Comments
 

 My blog about listener rotation caused some discussion, which is great. It sounds like an easy stuff, but in case of listener logging it isn’t. https://blog.dbi-services.com/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off/ Many ways do exist to rotate the listener log, but I was trying to point out some issues, because there are a few, e.g. What happens when the log file reaches 4G? What are the performance implications? What happens if I move the listener.log while the listener is running…

Read More
William Sescu

Oracle 12.2 – How to run a consistent full database export with dbms_datapump and parallel degree of 8

By | Database Administration & Monitoring | 2 Comments
 

 Nowadays, since the cloud is becoming more and more important, the PL/SQL API’s become more and more important too. Fortunately, Oracle has quite a lot of them. E.g. How do you run a Data Pump export if you have no ssh connectivity to the server? You could use the old exp tool, which is still available even with Oracle 12.2, or you can use DBMS_DATAPUMP. The Data Pump API is quite good documented in the…

Read More