Monthly Archives: May 2010

Error when setting up Network ACLS for Banner on 11g

There is some additional code to setup ACLS in 11g, this example was done in From SUNGARDHE FAQ 1-4W1JEA – Banner and Oracle Database 11g FAQ Instructions followed on how to setup a network ACL…but you may encounter an … Continue reading

Posted in 11g, banner | Tagged | 2 Comments

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

A bug found in…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

How to Resume a Failed RMAN Duplicate Due to Missing Backups or ArchiveLogs

It is relatively easy to resume the rman restore and recovery process if it has failed due to missing backups or archivelogs.  You most often see the following error messages complaining that something is missing. RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate … Continue reading

Posted in Recovery, RMAN | Tagged , , , , | 4 Comments

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

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

Change to Password Protected Default Role Not Well Documented

Recently I upgraded a database to and the default role mechanism wasn’t working. Queries were failing for endusers that had worked before…. Come to find out Oracle changed the way Default Roles work, the following is a quote … Continue reading

Posted in Uncategorized | 2 Comments