Infrastructure at your Service

 
David Hueber

Linux: Disks diagnostic using smartctl

By | Operation systems | No Comments

Facing disk issues such as corruption or block defect is thankfully not happening frequently. However when it does, the diagnose may look sometimes like a real struggle. This is forgetting that disks integrate since years the S.M.A.R.T technology. Good point, it can easily be adressed in Linux command line through smartctl What is S.M.A.R.T. exactly? S.M.A.R.T., which stands for Self-Monitoring, Analysis and Reporting Technology (also called SMART), is a monitoring system for and integrated in…

Read More
Stéphane Haby

SnapManager for SQL Server: databases limitation policy

By | Database management | No Comments

I recently talked to a customer about SnapManager, its recommendation on the number of databases and about a way to prevent the creation of more than 35 databases. The NetApp recommendation is no more than 35 databases on a single volume. The reason is that SQL Server has to use 4-5 worker threads per database in order to manage the freezing and un-freezing I/O for each database. Look at this note: More information on this…

Read More
Gérard Wisson

Oracle Middleware, administration and monitoring: a day at the DOAG SIG Middleware

By | Application integration & Middleware | No Comments

I am in the train back to Basel (Switzerland) and I will try to summarize the day spent on a SIG Oracle Middleware of the DOAG (German Oracle User Group) session related to Oracle Middleware administration and monitoring. The different topics I saw were: WebLogic 11g clustering and high availability Overiew of the Cloud Control 12c (monitoring, automatization, quality management, cloud management Real User Experience Insight (RUEI): End-to-End User Monitoring and Java Diagnostic Administration and…

Read More
Stéphane Haby

SQL Server 2012: Cumulative Update 3 (CU3) now available

By | Technology Survey | No Comments

This week, the third cumulative update was made available on the Microsoft website. What is in this CU for SQL Server 2012? This CU has 36 hotfixes: 25 for the engine 1 for SSAS 4 for SSIS 6 for SSRS To have more information and download it, click here Historic of SQL Server 2012 If you update your SQL Server 2012, you will have a new build version: 11.00.2332 I will give you a quick…

Read More
Hervé Schweitzer

Adding new tables to an existing Oracle GoldenGate replication

By | Application integration & Middleware | 14 Comments

Once a replication environment is set up, it’s rarely forever. Adding tables to an Oracle GoldenGate replication group with minimal impact to the current replication is quite a difficult operation. This posting should help you with this task. In the example below, tables from schema G001 will be added to an existing replication setup from the database PROD1 to REP1. CFG_ADV_COND CFG_NARRATIVE_TEMPLATE CFG_REG_REPORT_RULES CMN_LOOKUP CMN_USER_LOGIN   Stop the replication environment Connect to the source database PROD1 and…

Read More

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