Database Administration & Monitoring, Oracle ORA-01000 and agent13c 23.07.2019 by Oracle Team Recently I received errors messages from OEM13c saying too many cursors were opened in a database: instance_throughput:ORA-01000: maximum open cursors exceeded My database had currently this open_cursors value: SQL> show parameter open_cursors NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ open_cursors integer(…)
Database Administration & Monitoring, Hardware & Storage, Operating systems, Oracle Huawei Dorado 6000 V3 benchmark 10.07.2019 by Oracle Team I had the opportunity to test the new Dorada 6000 V3 All-Flash storage system. See what the all-new Dorado 6000 V3 All-Flash Storage system is capable as storage for your database system.
Database Administration & Monitoring, Database management, Oracle Why ODA reimaging doesn’t work on the first try? 07.06.2019 by Jérôme Dubar Introduction Reimaging an ODA is a good practice for a lot of reasons. To make your ODA cleaner if it’s running for many years and if you patch regularly. To simplify patching because if you’re late you could have to(…)
Cloud, Database Administration & Monitoring, Database management, Oracle What Benefit You Get From The Cloud For Your Business? 29.05.2019 by Oracle Team Microsoft, Amazon, Google and Oracle offer infrastructure services whose names change, but the concepts remain the same. It may be that you are interested in the cloud too, but it's still not clear because you find(…)
Application integration & Middleware, Development & Performance, Oracle APEX Connect 2019 – Day 1 07.05.2019 by Alain Lacour This year again the APEX connect conference spans over three days with mixed topics around APEX, like JavaScript, PL/SQL and much more. After the welcome speech and the very funny and interesting Keynote about “PL/SQL: A Career Built On(…)
Database Administration & Monitoring, Oracle Oracle 19C : Exporting and Importing Broker Configuration 04.05.2019 by Oracle Team By Mouhamadou Diaw Up to Oracle 19c, there was no automatic way to backup the configuration of the broker. One solution was to manually copy all executed instructions in a file. With Oracle 19c, there is now the possibility(…)
Database Administration & Monitoring, Oracle Oracle 19C : Dynamic Change of Fast-Start Failover Target 03.05.2019 by Oracle Team By Mouhamadou Diaw Oracle 19C is now available on premise. There are lot of new features. One for the Data Guard Broker is that now we can dynamically change the fast-start failover target to a specified member in the list(…)
Database Administration & Monitoring, Oracle Oracle 18c Grid Infrastructure on Windows Server 27.04.2019 by Oracle Team By Mouhamadou Diaw Oracle Grid Infrastucture can be installed on Windows platform. The steps are the same that on other platforms. In this blog we are going to install Oracle GI 18c on Windows 2016.I have two disks on my(…)
Database Administration & Monitoring, Database management, Oracle Direct NFS, ODM 4.0 in 12.2: archiver stuck situation after a shutdown abort and restart 24.04.2019 by Clemens Bleile A customer had an interesting case recently. Since Oracle 12.2. he got archiver stuck situations after a shutdown abort and restart. I reproduced the issue and it is caused by direct NFS since running ODM 4.0 (i.e. since 12.2.). The(…)
Database Administration & Monitoring, Database management, Development & Performance, Hardware & Storage, Oracle When you change the UNDO_RETENTION parameter, the LOB segment’s retention value is not modified 18.03.2019 by Oracle Team Below, I will try to explain, a particular case for the general error : ORA-01555 snapshot too old error.. Normally, when we have this error, we are trying to adapt the retention parameters or to tune our queries. SQL> show(…)