Search
Tag Cloud
10.2 10.2.0.5 11.1 11.2 ADR alertlog ASM bug bundle patch cleanupDeploy database database appliance digest diskgroup enterprise manager gi grid control grid infrastructure GrindInst hashes LinkedIn listener localhost monitoring oak oakcli ODA odachk OEM one-off ORA oracle oracle database appliance password patch bundle PLSQL privileges RAC REDO sha1 solaris troubleshooting usable_file_mb x-windws xtermCategories
-
Recent Posts
Blogroll
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 ADR, adrci, adrci_dir.mif, database, LinkedIn, oracle, troubleshooting
3 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
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
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 AWR, database, DBMS_WORKLOAD_REPOSITORY, LinkedIn, oracle, privileges
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 ADR, alertlog, database, dbms_system.ksdwrt, enterprise manager, grid control, LinkedIn, ORA, oracle, simulation, troubleshooting
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 compress, compression, database, dbms_comp_advisor, DIRECT_LOAD, index key compression, LinkedIn, OAC, OLTP, oracle, oracle advanced compression, PLSQL
2 Comments
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