Category Archives: Database

adrci – No ADR base is set

Some time ago we had a problem using the adrci (ADR Command Interpreter) to look into some diagnostic information for a listener. After staring up the tool it came back with the warning “No ADR base is set”, even while … Continue reading

Posted in Database | Tagged , , , , , , | 4 Comments

Expired passwords in 11g database using 10g client

When I create a new user/schema in an Oracle database I specify a password and immediately use the PASSWORD EXPIRE clause to expire this one-time-use only password. This way I make sure the user/application who is going to use this … Continue reading

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

Dump interesting information about Oracle files

Here are some useful statements for generating trace files in your udump directory about various important Oracle files: Get a dump of your controlfiles: ALTER SESSION SET EVENTS ‘IMMEDIATE TRACE NAME CONTROLF LEVEL 10’; Dump the headers for all your … Continue reading

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

Privileges for AWR reporting

Sometimes during a project there are people that would like to generate AWR reports. Here are the privilges on certain database objecs that a user needs to be able to generate such reports using SQL*Plus (in this case granted to … Continue reading

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

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