Tag Archives: 11g

Migrating to 11gR2 – with an Existing Logical Standby

Upgrading Oracle Database with a Logical Standby Database In Place [ID 437276.1] Migrating from 10.2.0.4 to 11.2.0.2 Primary database is approximately 80 GB Binary software has already been installed on all nodes RMAN catalog upgraded Oracle listeners already migrated to … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , | 1 Comment

RMAN Upgrade Catalog Bug in 11.2.0.2

RMAN> CONNECT CATALOG * connected to recovery catalog database PL/SQL package RMAN.DBMS_RCVCAT version 11.02.00.01 in RCVCAT database is not current PL/SQL package RMAN.DBMS_RCVMAN version 11.02.00.01 in RCVCAT database is not current RMAN> RMAN> **end-of-file** RMAN> upgrade catalog; recovery catalog owner … Continue reading

Posted in Uncategorized | Tagged , , | 3 Comments

ORA-20011 ORA-01870 Errors when Gathering Fixed Object Stats in 11.2.0.1

A bug found in 11.2.0.1…this occurs when AQ_TM_PROCESSES=0 At the time of this writing MOS didn’t have the information publicly available, I had to open a SR to get the resolution.   The fix is to set the database initialization … Continue reading

Posted in Uncategorized | Tagged | 3 Comments

Unable to drop Database Link After Clone and Upgrade to 11gR2 (11.2.0.1)

I wanted to post this issue because I know someone else will skip this important step as part of the upgrade to 11.2 and wonder if what is wrong. Cloned a database using the RMAN duplicate command which is standard … Continue reading

Posted in Uncategorized | Tagged , , , | Leave a comment

Where have you been April? Writing a Book.

Book Giveaways this fall – Come see presentations at SETA this fall in San Antonio and Portsmouth VA. I plan on giving away a copy after the final presentation for all attendees. Look for the book at the Oracle OpenWorld Bookstore … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , | Leave a comment

Where have you been April? Writing a BOOK.

Book Signing at IOUG COLLABORATE 2010  Bookstore – Monday April 19th at 12:45pm.  I was there but no books available so this was a wash…sorry if you showed up. First thing you will notice when looking at the cover, the … Continue reading

Posted in Uncategorized | Tagged , , , , | 1 Comment

Migrating to 11g

Migrating to a new version of Oracle can be safely done in several steps, it doesn’t have to be an all or none transition. Note: The following steps assume a UNIX environment. Interim Steps: 1.  Install the 11g binaries in … Continue reading

Posted in 11g | Tagged , , , | Leave a comment