All too often, I see people asking questions about backup strategies they should employ for their databases. It never seems to fail, every question of this sort that I have come across in a variety of forums never once includes their recovery requirements. I have often stumped for considering your recovery requirements before designing your …
Category: Oracle
Apr 30
Error 404 Not Found with EM 12c
I have recently installed Oracle’s Enterprise Manager 12c for a new environment. Everything was working just fine when I left work last week but when I tried to connect to EM today, I got the following: Error 404–Not Found From RFC 2068 Hypertext Transfer Protocol — HTTP/1.1: 10.4.5 404 Not Found Huh?!?!? What do you …
Apr 30
_gc_fusion_compression
I found this very cool blog post which discusses how Oracle decides how much of a datablock to transmit across a RAC cluster interconnect: http://orainternals.wordpress.com/2012/04/29/_gc_fusion_compression/ Get the right amount of low cost levitra exercise.Getting adequate exercise is important for informing and using protection. The Recommended Dosage of Kamagra Jelly Kamagra Jelly may outcome with austere …
Apr 26
Blackouts with EMCLI
In my previous post, I talked about how to set a Enterprise Manager blackout with the Agent’s emctl utility on the command line. Everything was working fine until I tried to set a blackout with a clustered database. When trying to set a blackout on a clustered database target you will get an error similar …
Apr 23
Patch Policy
About a year and a half ago, I moved to a new company and started working as their DBA. The company did not previously apply any patches to any Oracle databases. Since I have been here, I have seen IT system security become more of a focus point and undergo a higher level of scrutiny …
Jan 19
Agent Is Blocked
I recently upgraded a database from Oracle 10.2.0.3 to Oracle 11.2.0.2. Everything went well. Some time after the upgrade, Grid Control 11g sent me an alert with the following: Agent is blocked. Blocked reason is: Agent is out-of-sync with repository. This most likely means that the agent was reinstalled or recovered. Please contact an EM …
Jan 03
Error Adding Standby
I have been trying to create a Standby database from a new Primary that was recently put into production. I like how Grid Control automates much of the work for me. So Enterprise Manager is my preferred method. I recently ran into a problem using the Add Standby Database wizard in my 11g Grid Control. …
Dec 13
Brand New Production Database
Every once in a while, no matter which company I work for, I am asked to set up a new production database. I was working on this very task today when I started thinking about how much work it was to create a brand new database in that past, how much the DBCA handles for …
Dec 12
Wait Event: asynch descriptor resize
In my recently upgraded production database, I am seeing a number of SQL statements that are now experiencing high waits on the “asynch descriptor resize” event. I recently upgraded from 11.1.0.7 to 11.2.0.2 and SQL statements that never waited on this event are now getting caught. Oracle 11.2 slightly changed the way the database and …
Nov 22
Background Processes
I swear that as I get further and further along in my Oracle career, I have a harder and harder time keeping up with Oracle’s background processes. I’d like to chalk this up to getting older, but after digging into it, I’m pretty sure its just Oracle’s explosion of background processes in 11g that is …