Infrastructure at your Service

Category Archives: Database management

Stéphane Haby

SQL Server 2012 ‘Denali’: a new panel of DMVs

By | Database management | One Comment

Dynamic management views (DMVs) return server state information that can be used to monitor the health of a server instance, diagnose problems and tune performance.
Since few months, I test the future new version SQL Server 2012 codename Denali and I was very surprised form the news DMVs from this version.
I will just explain some DMVs very interesting for a DBA.
My article is based on msdn web site reference and you find in the end from each chapter a msdn reference for more details of the DMV.

Read More
Yann Neuhaus

Oracle RunInstaller crashes while installing Cloud Control 12c on OEL 5.7

By | Database management | 7 Comments

A few days ago I downloaded the Cloud Control 12c binaries for Linux x86_64 from the Oracle Technet.

My friend, Hervé Schweitzer, configured an OEL 5.7 VM for test purpose and I was quite eager to install this new software. I checked the O.S settings, the required parameters, aso …, everything was fine. My OMS repository database (11.2.0.3) was ready. Unfortunately, as soon as I started the installer, it directly crashed.

Read More
Stéphane Haby

Changing the reference instance for SQL Server Integration Service (SSIS)

By | Database management | No Comments

In my experience, I have seen many clients do not know how to do when they have multiple databases instances and Integration Servicet for manage the end of the instance that is the reference for Integration Services.

When Integration Service is installed with the instance “TOTO” and that it is at the end of his life, we’ll see how to transfer information to the second instance “TITI”. We present you a small working method to transfer information correctly.

Only the folders transfert is presented in this article and the  transfert of the SSIS packages are explained at the end.

Read More
Yann Neuhaus

Oracle space management & recycle bin

By | Database management | One Comment

This post describes some basic Oracle database management issues database administrators might be confronted with. It is about space management and differences observed while monitoring the available space from several point of views (tablespace/datafile) in Grid Control 11g. It also relates and explains an issue (ORA-01652) observed on pre 11.2 Oracle releases (targets) concerning the tablespace/datafile space management and the recycle bin. First of all, a simple example: let’s check the used and available space…

Read More
Pierre Sicot

Inside Grid Control

By | Database management | No Comments

Lors de mon activité de consultant, et suite à un bug qui n’affiche pas correctement le nombre de CPU (OMS 10.2.0.5, agent 10.2.0.5 et linux x86_64), je me suis intéressé à la manière dont Oracle Enterprise Manager Grid Control (OEM GC) récupérait les informations de mémoire et de cpu sur les différents hôtes surveillés par ce dernier.

Read More
David Hueber

Oracle Basics (3) – Database startup and shutdown

By | Database management | 6 Comments

It’s already quite a while that I posted my last article on the Oracle basis, so I decided to take some times in the train to continue this small serie.
This time, I’m going to speak about one of the root of Oracle administration, starting and shutting down a database.

Startup and shutdown processes within oracle databases are splitted in different steps (for startup) and modes (for shutdown) and even if these principles are quite trivial, some confusions between these steps and/or modes can easily be done. So I’m going to give a picture of both of these processes and their variations.

Before shutting any database down, it needs first to be started, so let’s begin with the startup process…

Read More
Stéphane Haby

A brief PowerShell 2.0 overview

By | Database management | No Comments

SQL server 2008 has PowerShell and at the end of this article, I speak of this topic but to use correctly Powershell, you must have a basic notion about this technologie.

In microsoft Techdays in Basel, Marc van Orsouw presents Powershell.
I think it was a nice opportunity to presents you an overview of Powershell based on this

presentation with adding microsoft msdn web site commentar.

Read More
Pierre Sicot

Pourquoi mettre une base de données Oracle en force logging ?

By | Database management | One Comment

Certaines requêtes DDL offrent la possibilité de ne pas générer des enregistrements dans les redo log via la clause NOLOGGING. Le mode nologging permet donc dans certains cas d’accélérer des traitements, ceux-ci pouvant facilement être récupérables à travers des mécanismes externes à la base de données. Ce mode peut cependant avoir des conséquences fâcheuses comme nous allons le constater et ce pas uniquement dans le contexte de configurations comme Oracle DataGuard.

Read More