Brian Peasland
Author's posts
May 14
Recovery Requirements Before Backups
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 …
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 26
Blackouts with EMCTL
I have a need to take down a database to perform a cold snapshot of the database’s files. This database is monitored by Enterprise Manager and I do not want to receive an alert when the database is down. So I need to figure out how to start a blackout in Enterprise Manager from the …
Apr 24
Installing Agent11g on Windows
Normally, to install the 11g version of the Oracle agent for Grid Control, one would push the agent from Grid Control the database server. However, when pushing from Grid Control to a Windows server, we receive an error telling us that Windows does not have SSH running on port 22. Windows servers normally do not …
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 …
Apr 02
One Exabyte Per Day
I ran across this article which discusses the Square Kilometer Array (SKA). As a DBA, the thing that struck me was that this system will generate 1 exabyte of data per day that will have to be stored somewhere. That is challenge #1, getting the data into a data store of some type in a …
Mar 29
OEL6 and Oracle 11g
I’ve never quite understood why Oracle released their own OS, Oracle Enterprise Linux 6 and then waited over a year for their flagship product, Oracle RDBMS 11g, to be certified on that OS platform. But the wait is over. You can now safely run Oracle 11g on Oracle Linux 6. But wait…no so fast…While you …
Mar 09
ORA-9925
Recently, I was trying fix the creation a dev database from a snapshot of our production database. To do that, we mount up the snapshot datafiles, create a new controlfile, and apply recovery and then open with resetlogs. This is pretty standard fare for us however, this time, the person performing the database refresh noted …
Oracle DBA Mentor
Oracle RAC Performance Tuning
Latest Tweets
-
@sacrophyte That was an old recommendation which is probably out of date now. When I look at the 19c doc for that p… https://t.co/h0VwGJECvH
-
Also in that note is "We decided to not promote our Database 20c Preview version to General Availability. Instead,… https://t.co/bvUcRKQ9gt
