OEM 13c New Features – System Broadcast

I can’t finish the year without a post about OEM 13c. I finally had some time to install it and from first hand go through its new features.  I find this “System Broadcast” feature so useful, especially when you have tons of users using OEM. You can try to email users, give them a call… Continue reading OEM 13c New Features – System Broadcast

ORA-01555 query duration 0 seconds with Dataguard

How many times we have calls from users complaining about their process that failed due to an ORA-01555 error?We know that if the queries are not well tuned and they modify a lot of data, the image held in the UNDO Tablespace could not be consistent with the real data. But have you ever seen… Continue reading ORA-01555 query duration 0 seconds with Dataguard

CRS-2632: There are no more servers to try to place resource ‘resource_name’ on that would satisfy its placement policy

I just got this error from CRS while trying to start a database using srvctl. I find this error kind of missleading as the error doesn’t tell what is really happening with the resource.I suggest you to manually check the logs of the resource. In this case it had to do with a cluster database… Continue reading CRS-2632: There are no more servers to try to place resource ‘resource_name’ on that would satisfy its placement policy

Tim Gorman is our guest speaker for September 30th NEOOUG’s quarterly meeting.

Tim currently works as a Technical Consultant at Delphix. Oracle ACE Director, Oak Table member and an advocate of the North East Ohio Oracle Users Group for many years. This time Tim brings two interesting sessions, “Split Brain Syndrome” and “Scaling To Infinity”.Join us for these sessions, have lunch and learn from one of the… Continue reading Tim Gorman is our guest speaker for September 30th NEOOUG’s quarterly meeting.

WAIT_FOR_GAP. How to restore missing archivelogs from backup?

In a Dataguard configuration, Oracle’s RFS (Remote File Server) writes redo data to the standby. When for any reason it can’t write this data, MRP (Managed Recovery Process) will wait for the archivelog to be applied and have the status “WAIT_FOR_LOG”. This will lead the standby to be out-of-sync with the primary database.Sometimes some archivelogs… Continue reading WAIT_FOR_GAP. How to restore missing archivelogs from backup?

How to upgrade the RMAN recovery catalog to 12c?

Some days back I faced an issue while trying to upgrade the RMAN recovery catalog to support 12c databases.RMAN> upgrade catalog;RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-07539: insufficient privileges to create or upgrade the catalog schemaThe problem is that for 12c the catalog owner requires additional privileges. The solution is to run the… Continue reading How to upgrade the RMAN recovery catalog to 12c?

Why You Should Attend GLOC 2016?

This year’s Great Lakes Oracle Conference (GLOC) is going to be huge! I had the privilege to attend the GLOC 2014 and present in the GLOC 2015. The conference continues to bring most of the best Oracle experts to the Midwest, helping professionals and organizations to keep up to-date on products plus a great networking… Continue reading Why You Should Attend GLOC 2016?