Infrastructure at your Service

Category Archives: Database management

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
Grégory Steulet

Stop looking for Oracle Fusion and Oracle Grid Control documentation: use the dbi services firefox add-ons!

By | Database management | One Comment

After my last post title “Stop looking for Oracle and MySQL documentation: use the dbi services firefox add-ons!” Some of you asked me for firefox search add-ons for Oracle Fusion Middleware (http://download.oracle.com/docs/cd/E17904_01/index.htm). This add-on will provide you a fast a reliable way to find easily what you are looking for in the official oracle documentation.

 
Read More
Grégory Steulet

Stop looking for Oracle and MySQL documentation: use the dbi services firefox add-ons!

By | Database management | 2 Comments

Are you often trying to find some functionalities into ORACLE 10gR2, ORACLE 11gR2 or MySQL documentation ? Of course each time you are looking for this documentation you find unofficial documentation which is never corresponding to the version you are looking for.. we have the solution, three firefox add-ons that will allow you to easily find the right official Oracle or MySQL documentation you are looking for.

 
Read More
Hervé Schweitzer

How to debug a Data Pump error

By | Database management | One Comment

Recently, I had an Oracle error with Data Pump at a Customer, which was not easy to localize. Here is the error I received during a DBIOWNER schema export with Data Pump:

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [TABLE_STATISTICS]
ORA-00942: table or view does not exist

 
Read More