Tag Archives: database

Simulating ORA-errors

Sometimes it can be useful to simulate a problem in your database by simulating an ORA-error. After we had a nasty bug with Grid Control (GC suddenly wasn’t able to monitor the alertlog of 10.2.0.5 databases anymore, see my post … Continue reading

Posted in Database | Tagged , , , , , , , , , , | Leave a comment

Calculating Compression Ratio

Before implementing one or more of the Oracle compression options that are available within an Oracle database, there are a couple of things you would like to examine before implementing one or more of these compression options. One thing you … Continue reading

Posted in Database | Tagged , , , , , , , , , , , | 2 Comments

A listener and its children

Until last week I din’t know about a listener process having one or more childrens (a child process has exactly the same name as its parent but have their parent-pid set to the parent listener pid). Trying to find information … Continue reading

Posted in Database | Tagged , , , , , , | 1 Comment

Constraint Exceptions

When adding or enabling a constraint on a table, it is possible that an error occurs because of an constraint violation.  If for example you are trying to add a unique constraint to a column (or combination of columns) of … Continue reading

Posted in Database | Tagged , , , , | Leave a comment

Password Hashes

Within Oracle databases passwords get hashed. When, for example, you create a new account or change the password of an account, the specified clear-text password gets hashed. This hash value is stored in the database with the account. Once hashed … Continue reading

Posted in Security | Tagged , , , , , , | 6 Comments

Unwrapping wrapped PLSQL in 10g, 11g and 12c

There are circumstances where you whish to have a look at the source of an wrapped PL/SQL package, procedure or function. The circumstances I want to have peek at the source is when some PL/SQL code becomes invalidated because an … Continue reading

Posted in Security | Tagged , , , , , , , , | 2 Comments

Unable to monitor ORA-errors in alertlog for 10.2.0.5 databases

There is a problem monitoring Oracle 10.2.0.5 databases in OEM. Alerts for ORA- errors that appear in the alertlog of 10.2.0.5 databases won’t get generated and you will not be able to view the alertlog (time range) for databases of … Continue reading

Posted in Enterprise Manager | Tagged , , , , , , , , , , | 5 Comments