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
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
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 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.
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?
Today I want to write about Oracle Enterprise Manager (OEM) 12c plug-ins and how to test them. OEM is divided into two logical parts, the EM Platform and the EM Plug-ins. The EM Platform basically consists of the UI console, job system, metrics, EM agent, etc. The EM Plug-ins are modules that you can attach to you… Continue reading OEM Agent Plug-in Testing
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?
Few weeks ago I had to modify an instance parameter to a different value. In this case, I just wanted to modify it for only one instance and leave the other instance as it was.I thought that if I didn’t specify the instance name using the SID clause, the default is going to be just… Continue reading ALTER SYSTEM in a RAC environment
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?