Oracle Database as our consultants live it every day: installation and patching, upgrades, RMAN backup and recovery, Data Guard, RAC, performance tuning, multitenant, licensing, and engineered systems such as ODA and Exadata.
By Mouhamadou Diaw Point-In-Time Recovery is also possible in a multitenant environment. As in Non-CDB, a recovery catalog can be used or not. In this blog we will see how to recover a dropped tablespace in a PDB. We will also see the importance of using a recovery catalog or not. A PITR of a PDB does not affect remaining…
Introduction ODA X7-2 marked the maturity of the Oracle Database Appliance evolution, with 3 models suitable for nearly all customers using Oracle databases. The X7-2M was my favorite, with a lots of cores available (and restrainable), enough memory for dozens of databases, and strong storage performance and capacity (with a maximum of 50TB RAW NVMe). And taking up only 1U…
By Mouhamadou Diaw The Oracle Multitenant architecture came with Oracle 12c a few years ago. For people usually working with traditional Non-CDB database it might be confusing the first time to do Backup and Recovery with pluggable databases (PDBs) In this document we are trying to explain how to use RMAN backup and recovery in a multitenant environment for an…
Moving database to new ORACLE_HOME is a common dba task. Performing this task on an ODA will need an additional step knowing ODA Lite is using an internal Derby database for the metadata. ODA HA will not be a problem here, knowing we do not have any Derby database. Through this blog I would like to give you some guidance…
POUG (Pint with Oracle users group) organized his annual conference on 6-7th September in Wroclaw in New Horizons Cinema. My abstract about “MySQL 8.0 Community: Ready for GDPR?” was accepted, so I had the opportunity to be there. Sessions My talk was planned for the first day. New MySQL 8.0 version introduces several improvements about security and these are the…
Introduction Oracle & Linux is a great duet. Very powerfull, very scriptable. Here are several commands that make my life easier. These tools seems to be widespread on most of the Linux distributions. watch with diff It’s my favorite tool since a long time. watch can repeat a command indefinitely until you stop it with Ctrl+C. And it’s even more…
Introduction One of the key features of the ODA (Oracle Database Appliance) is the ability to patch the entire stack every three months, the goal being to keep all the components up-to-date. Most of the customers won’t patch so often, but one patch a year is quite a good average. But when comes the time for patching, comes the time…
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 300 I decided to increase its value to 800: SQL> alter system set open_cursors=800; System altered. But a few minutes…
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. Before you read This is a series of different blog posts: In the first blog post, I talk about “What you should measure on your database storage and…
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 apply multiple intermediate patches to reach the target version. Or simply because you need to change the configuration (for example…
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 much information all over and it’s hard to make decisions. Isn’t it? Clouds infrastructure provide traditional data centers, nothing new, but instead of provisioning…
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 Top Of PL/SQL – 25 years of Coding, Sharing, and Learning” by Martin Widlake, I decided to attend presentations on following…
