Infrastructure at your Service
I had to perform a duplicate database between 2 ODAs and was always facing an ORA-65500 at the begin of the RMAN operation. Looking a bit deeper in the log outputs pointed me out that it was due to some changes in the way RMAN makes the duplicate in 12c and cluster resources management.
As you know it is possible to install the ODA in a virtualized mode and to take avantages from all cores not licensed with Enterprise Edition for additional VMs. The question is what could we do with it and which performances could we expect… The answer to the first question is indeed pretty simple….almost everything. If you have and ODA X5-2 with the version 12.1.2.3.0 implemented in virtualized mode then you are running an OVM…
Since version 12, ODA stores databases on ACFS volumes instead of ASM directly. This slightly changed the way the files are managed and administer. This articles presents how to multiplex your control files on ACFS. At first database creation, ODA set up 3 ACFS volumes to store all non-CDB databases (CDB are managed on dedicated volumes): /dev/asm/datastore-386 62G 5.2G 57G 9% /u01/app/oracle/oradata/datastore /dev/asm/datastore-286 1.7T 871G 836G 52% /u02/app/oracle/oradata/datastore /dev/asm/datastore-360 2.2T 5.6G 2.2T 1% /u01/app/oracle/fast_recovery_area/datastore These…
After months of waiting, Oracle Database 12c is finally available. In this posting, I am going to provide a summary of the new features of Oracle 12c in terms Backup and Recovery. Pluggable, what else? For sure, the most remarkable change in this brand new version is the Pluggable Database or so called Multitenant Database concept, which is a huge change in the whole RDBMS architecture. So what does it offers in terms of Backup…
As you probably know, the multitenant databases is the new feature of Oracle 12c to solve the dilema of applications segregation. Thanks to a multitenant container database, it allows to manage many databases as one taking advantage of resources consolidation. A perfect way to manage several applications in a single container. However are these plugglable databases that isolated as expected? Not exactly: As I will show in this posting, a single PDB can, under certain…
Facing disk issues such as corruption or block defect is thankfully not happening frequently. However when it does, the diagnose may look sometimes like a real struggle. This is forgetting that disks integrate since years the S.M.A.R.T technology. Good point, it can easily be adressed in Linux command line through smartctl What is S.M.A.R.T. exactly? S.M.A.R.T., which stands for Self-Monitoring, Analysis and Reporting Technology (also called SMART), is a monitoring system for and integrated in…
For sure you already used, or at least heard about, the HP Smartstart Kit. This especially includes the storage management part ACU: Array Configuration Utility. This tool is pretty straightforward to configure the storage and RAID volumes before installing an HP server.
However did you know that these features are also available in command line? This is what hpacucli does…
Who never had to measure the disk performances on a system?
Speaking about Linux performance monitoring includes a significant part on disk performances. If you are facing applications or databases running slower than expected or than on other environments, you may take a look on the I/O performances.
This blog aims to provide to introduction to a pretty interesting tool, iozone…
I’m pretty sure that most of you already struggled with some low performance systems. In order to analyse such cases several tools and utilities, like top, nmon, fuse or lsof are available under Linux. However trying to dig in processes analysis and looking for files and processes relations may be quite painful.
To get started with performance checks and analysis, a interesting utility is available: htop
So we are now arrived at the end of the largest Oracle OpenWorld ever. Around 45’000 people had joined San Francisco to exchange around IT and especially Oracle technologies.
It has been a great conference with much of interesting sessions and as each year several announcements: Enterprise Manager 12c, Exalytics and Oracle Public Cloud.
For my last post about OOW11, I want to talk about the last session I attended. Who said that the late sessions are usually having less interest? I personally was lucky enough to attend a great presentation held by Oak Table member, Alex Gorbachev. Alex used ASM to demonstrate how hardware and software fault tolerance mechanisms, especially mirroring, are affected by different parameters such MTBF.
