Brian Peasland

Author's posts

Oct 23

Oct2014CPU Crashes ArcGIS Desktop

Right after I applied the Oct2014 SPU to our development database, members of our IT staff started complaining that direct-connect connections with ArcCatalog and ArcMap would crash. The app wouldn’t even connect to the database. I tried various things…even upgrading Oracle Client to 11.2.0.4 to match the database version (it was 11.2.0.1) but nothing worked. …

Continue reading

Oct 01

Zero Data Loss Recovery Appliance

Oracle’s standby databases have been around for a long time now. The primary ships redo to the standby to keep them in sync. It seems to be a natural fit that Oracle has now extended this concept to a backup and recovery appliance. The idea is that you take one backup of your database at …

Continue reading

Sep 19

Error 1033 received logging on to the standby

Upgraded production to 11.2.0.4 a few nights ago. The primary is 3-node RAC and the standby is 2-node RAC. Notice that one of the threads was not transmitting redo to the standby. Saw this repeatedly in the alert log:   Error 1033 received logging on to the standby   Turns out this was a problem …

Continue reading

Sep 16

Good Time for DBAs?

Is this a good time to be a DBA? My biased opinion is that any time is a good time to be a DBA. The US Bureau of Labor Statistics released an outlook indicating that DBA positions are expected to increase 15% between 2012 and 2022. Now comes this article that says about 50% of DBAs …

Continue reading

Sep 05

Oracle 12.2.0.1 coming in 2016

Oracle will be releasing Oracle 12cR2 in the first half of 2016. See Metalink Note 742060.1 for the current release schedule. The Oracle 12.1.0.3 patchset is not on the list but there is a chance it will be out before 12cR2. We’ll have to wait and see I guess. Erectile dysfunction is termed as a …

Continue reading

Sep 02

Importance of Testing

I am working on upgrading all of our production databases to the Oracle 11.2.0.4 version. My company’s most important database serves a custom, in-house developed application so we have the luxury (and sometime the curse) of having complete control over the application source code. If I discover a version-specific issue with a their party application, …

Continue reading

Aug 22

GIMR now mandatory for GI12.1.0.2

I found this nice blog entry today: https://blogs.oracle.com/UPGRADE/entry/grid_infrastructure_management_repository_gimr However, there are several ED medicines in the market that can increase the level of generico levitra on line this sex hormone. Cheap kamagra tablets have been packed with sildenafil citrate, the award-wining chemical approved by the commander cialis Food and Drug Administration for the treatment of …

Continue reading

Aug 19

Sticky Upgrade Problem

When performing database upgrades, adequate testing is important to understand the impacts, both positive and negative, the database upgrade has on the application. I have been preparing to upgrade databases from the 11.2.0.3 version to 11.2.0.4. One weekend, myself and another DBA spent some time upgrading about half of our production databases to the new …

Continue reading

Aug 14

Result Cache

I was playing around with the Result Cache the other day…I know…this isn’t a new feature and has been available for awhile. Unfortunately, it can take a while to get to things I guess. In my simple test, I had a query that exhibited this behaviour: select    max(det.invoice_date) from    invoices i join    …

Continue reading

Aug 13

Big Data, Cloud Computing, and In Memory databases

Found this on Twitter today. http://diginomica.com/2014/08/12/gartnerhypecycle/#.U-t6w2N98mR Remember that blood circulation, as well as strong erection. acheter pfizer viagra The above mentioned problems http://robertrobb.com/bronovich-overreaches-on-reagan-investigation/ viagra sample canada such as smoking stress etc are all the major reasons that develop the risks of rapid hormonal change or imbalance and hold different set of causes. It is said …

Continue reading