Infrastructure at your Service

Sébastien RENTZ

How to add new tables in existing Oracle GoldenGate replication

By | Operation systems | No Comments
 

 Introduction Often some times after having setting up a replication environment, it is needed to add additional tables to the replication, where the additional tables have dependency with the current replicated tables. This tasks must be implemented without disturbing the current replication environment Explanation In this example the below tables from schema G001 on Database PROD1 will be added, to an existing Replication from PROD1 to REP CFG_ADV_COND CFG_NARRATIVE_TEMPLATE CFG_REG_REPORT_RULES CMN_LOOKUP CMN_USER_LOGIN Stop the replication…

Read More
Yann Neuhaus

Oracle Enterprise Manager 12c – Database Target remains in Pending state (SLES x86_64 target)

By | Database management | No Comments
 

 Last month I was confronted to a very interesting and strange problem while deploying a Cloud Control 12c infrastructure. One of my monitored server was a SuSE Linux Enterprise Server (SLES) 64 bits on which a 11.2.0.3 Oracle database was installed. The x86_64 cloud control 12c agent has been deployed on this server with the standard Cloud Control 12c agent deployment procedure (not the scope of this post). However despite several trials to configure the…

Read More
Grégory Steulet

ORA-03113 caused by Database Vault Rule Sets

By | Database management | No Comments
 

Database Vault solution allows to create rules that manage access to database. Among these rules there is what is called in Database Vault “Rule Sets”. These logic components are written as PL/SQL functions to return Boolean results.

If rule expressions do not match the user context, the access is refused and a specific message can be configured in order to warn the user that he is not authorized to access this specific object. These expressions can be for instance related to the client IP address, the session username, the time or date and many other things.

Read More
Open source Team

PostgreSQL: Un aperçu des outils d’administration

By | Database management | No Comments
 

Nous avons dans les articles précédents vu comment installer PostgreSQL et quels étaient les composants d’une base. Nous abordons maintenant le point de l’action
sur le moteur avec deux outils orientés administration de la base, généralement utilisés par les DBAs. Il s’agit de psql et de PgAdmin. Nous aborderons aussi dans cet article la configuration de connexion au travers des fichiers de configuration du serveur.

Read More
David Hueber

hpacucli: Storage management on HP servers through command line

By | Hardware & Storage | No Comments
 

For sure you already used, or at least heard about, the HP Smartstart Kit. This especially includes the storage management part ACU: Array Configuration Utility. This tool is pretty straightforward to configure the storage and RAID volumes before installing an HP server.

However did you know that these features are also available in command line? This is what hpacucli does…

Read More
Pierre Sicot

Oracle Enterprise Manager 12c: Administration Groups & Template Collections

By | Database management | No Comments
 

This document describes the implementation of the
administration groups and template collections with Oracle Enterprise
Manager Cloud Control 12c.

 

Administration Groups (improvement of Grid 11g Target Groups) and Template Collections improve the management of targets and ease the monitoring strategy.

 

Administration Groups allow to organize targets according to several criteria. For instance the Lifecycle status of the target (prod, dev, integration), the location of the target can be used as criteria. The main goal is to apply common settings (i.e monitoring settings) to targets having the same purpose.

 

The first point about administration groups is to define a clear concept and the hierarchy between these several criteria. The administration groups must be organized in a convenient way according to the company organization. In the next chapter we will present how to handle the hierarchy existing in Cloud Control 12c in order to change it in an administration group organization fitting to the company structure.

The target property is used to implement automatically the target in the appropriate administration group.

 

Read More
Yann Neuhaus

Replace a voting disk is so easy with Grid Infrastructure 11.2 & ASM!

By | Hardware & Storage | No Comments
 

For a few day we had a quick request at a customer which was to replace a voting disk in an ASM disk group. The current ASM disk group (redundancy normal) had 3 disks : two located in one data center and one disk in another data center. The goal was to replace one voting disk (from the most used Data Center) with one disk coming from a third Data Center.

Read More
Open source Team

PostgreSQL : Qu’ai-je installé, Où sont mes données ?

By | Technology Survey | One Comment
 

Dans mon dernier article sur PostgreSQL, j’ai présenté l’installation du logiciel en explorant les 2 solutions suivantes, l’installation Debian et l’installation EntrepriseDB. Ces deux installations créent immédiatement un cluster de base de données, Debian nous imposant le point de stockage et EntrepriseDB nous proposant de saisir une destination. Je vous propose maintenant d’explorer ce qui a été installé sur votre disque à la mise en route de ce cluster de base et d’analyser les différences entre les deux installations.

Read More