Infrastructure at your Service

Category Archives: Database management

Yann Neuhaus

Password Oracle : vos mots de passe sont-ils sécurisés ?

By | Database management | No Comments

Quelles sont les faiblesses de l’encryption des mots de passe Oracle ? Comment est-ce qu’Oracle crée les clés de hachage afin d’en améliorer la sécurité ? C’est ce que je vous propose de découvrir dans ce post. Le mot de passe est la forme la plus commune d’authentification. Ce dernier est stocké dans une table Oracle sous la forme d’une clé de hachage. Lorsqu’un utilisateur tente de se connecter, le mot de passe saisi est…

 
Read More
Yann Neuhaus

Monitoring 11g databases with Grid Control 10.2.0.5

By | Database management | No Comments

The Metalink note 949858.1 describes problems with 10.2.0.5 agents monitoring 11g databases – this might be the case if you have an “old” 10.2.0.5 Grid Infrastructure you did not want to upgrade yet. The 11g databases are generating errors in both the alert.log and the log.xml file. The agent 10.2.0.5 agent seems to have problem with this. This posting will show you what to do.

 
Read More
David Hueber

Oracle Basics (1): Oracle Database vs Oracle Instance

By | Database management | 3 Comments

While beginning to work with Oracle, one of the most common confusion is between Oracle database and Oracle instance. At most of the time the term Oracle Database is used to designate the whole Oracle RDBMS architecture. However looking deeper in what is an Oracle RDBMS Server, we can see that it is compose of 2 entities, the database and the instance.

 

So lets have a look to the difference between database and instance.

 
Read More