Infrastructure at your Service

Category

Database management

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
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