Database Administration & Monitoring, Hardware & Storage ODA X7-2S/M 12.2.1.2.0: update-repository fails after re-image 21.02.2018 by David Hueber While playing with a brand new ODA X7-2M, I faced a strange behaviour after re-imaging the ODA with the latest version 12.2.1.2.0. Basically after re-imaging and doing the configure-firstnet the next step is to import the GI clone in the(…)
Database Administration & Monitoring ODA 12.2.1.2.0 – VLAN Management 20.02.2018 by David Hueber Virtual Local Area Network (VLAN) have become since several years a standard in enterprise class networks. Most enterprises are now segregating their network, especially for security reasons, between server and user or prod and test or applications and backup and(…)
Database Administration & Monitoring, Database management, Hardware & Storage, Operating systems ODA – 32GB template but got a database with 16GB SGA??? 06.03.2017 by David Hueber I got an interesting question today from a customer which created a database on ODA. He selected the template odb-04 which shows 32GB Memory but got a database with a 16GB SGA… Is it due to the PGA size, a(…)
Database Administration & Monitoring, Technology Survey About SSH keys in Oracle Public Cloud 18.01.2016 by David Hueber When working with resources on the Oracle public cloud, whatever it is IaaS or PaaS, the principle access method is based on SSH keys exchange. Once our instance is created this is going to be the first and only way(…)
Database Administration & Monitoring, Database management Oracle 12c duplicate in cluster fails with ORA-65500 03.09.2015 by David Hueber 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(…)
Hardware & Storage ODA – VMs possibilities & performances 30.06.2015 by David Hueber 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(…)
Database management ODA 12.1.X.X.X – add a multiplexed control file under ACFS 12.03.2015 by David Hueber 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(…)
Database management Oracle 12c Backup & Recovery: What’s new? 18.07.2013 by David Hueber 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(…)
Database management Oracle 12c: Pluggable databases not that isolated 04.07.2013 by David Hueber 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(…)
Operating systems Linux: Disks diagnostic using smartctl 13.09.2012 by David Hueber 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,(…)