Tag Archives: oracle

Solaris SMF Oracle Grid agent service killing Oracle instance

In the last couple of months we had some strange problems with all processes of Oracle database and ASM instances just disappearing. The shared memory segment was still there and you could connect internally to the instance, even execute some … Continue reading

Posted in Enterprise Manager | Tagged , , , , , , , , , , | Leave a comment

Creating database links for another schema

There are situations (like after cloning databases) where you, as a DBA, want to create database links in other schema’s, for which you don’t have the password. Unfortunately the security of Oracle doesn’t allow (even SYS) you to drop/create database … Continue reading

Posted in Database | Tagged , , , , , , , , | 5 Comments

Password History – Reusing a password

By setting either one or both the profile limits PASSWORD_REUSE_MAX or PASSWORD_REUSE_TIME are set to anything other than UNLIMITED, Oracle somewhere keeps a history of passwords used by a user. This password history is stored in a table with the … Continue reading

Posted in Database | Tagged , , , , , | 3 Comments

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

Unregistering (removing) agent from OEM Grid Control

When you want to permanently remove an agent from you OEM GC environment, you will have the GUI method and the manual method. The reason for writing this post is that I was able to remove all targets from within … Continue reading

Posted in Enterprise Manager | 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