Resolving Oracle specific errors ( ORA-01031, ORA-00942 etc.)
I lost a count how many times I run into ORA-01031 error .Since I am the one executing the query I can see which SQL statement I am running and then focus on specific objects to find missing privilages. It gets more difficult when end-user get this error.Thanks to Oracle events this is easy to resolve. … Read more
Disabling Oracle Streams Propagation when nothing else works
It’s been a while since I wrote any post .. I need vacation too Here is very short one but useful tip for folks that are using Oracle Streams. I know everyone is talking about GoldenGate but trust me Oracle Streams are good solution if you do not have budget for GoldenGate.Oracle is working very hard … Read more
OEM 11g install and ORA-12650
Two weeks ago I was trying to install OEM grid control version 11 .I did it many times already but this time my process failed in the middle of install. After digging numerous number of install logs I have found message like one bellow: HealthMonitor Jan 26, 2011 5:39:44 PM OMS Heartbeat Recorder: error: Could … Read more
MOS notes – Troubleshooting ASM
I just summarized few notes that I have used for troubleshooting ASM. Placeholder for AMDU binaries and using with ASM 10g [ID 553639.1] ASMIOSTAT Script to collect iostats for ASM disks [ID 437996.1] Information to gather when diagnosing ASM space issues [ID 351117.1] and of course you can always dump ASM block using SQL> alter … Read more
Patch WDJ7 and “Unable to verify your status” error
According to Oracle Documentation WebLogic ( which is now part of new OEM 11g grid install ) must be updated with patch WDJ7. When we tried to authenticate to my Oracle Support with the smart update GUI I received an error message “Unable to verify your status“. After some time dealing with this error and troubleshooting I decided that easiest way … Read more
