Infrastructure at your Service

Category

Oracle

Marc Wagner

oracle update-dcscomponents failure during ODA patching to 19.11

By | Oracle | No Comments

You might know that since ODA 19.10, the ODA metadata database is now stored in a MySQL database and not in the apache derby database any more. During a patching to 19.10 or 19.11 from a release earlier than 19.10, the apache derby database will be migrated to a mysql database. This is performed during the odacli update-dcscomponent command. Starting 19.10, DCS Agent will then use MySQL server to display any metadata information, as for…

Read More
Marc Wagner

odabr tool : how to resolve efi device backup failure?

By | Oracle | No Comments

During all my ODA projects where I need to perform patching operation, I’m using odabr tool. This tool is really easy to use and well designed. It offers the possibility to create snapshot on the /, /u01 and /opt LVM file systems as well as a physical copy (rsync) of the files to an external destination storage as NFS. This is powerful in case you would like to get just one file back. The tool,…

Read More
Jérôme Dubar

Manage ODA patching with Data Guard or Dbvisit Standby

By | Database Administration & Monitoring, Database management, Operation systems, Oracle | No Comments

Introduction Building an Oracle infrastructure today without thinking about a Disaster Recovery solution (DR) is quite rare. This became obvious that a backup or a dump will not help if you do not know where to restore or import once your production server is down. And restoring a backup is definitely not the fastest way to bring back your database to life. As a consequence, Data Guard or Dbvisit Standby, depending on which edition you’re…

Read More
Clemens Bleile

Creating an Oracle Snapshot Copy PDB on top of ASM

By | Oracle | No Comments

Creating a snapshopt copy Pluggable Database (PDB) on top of Automatic Storage Management (ASM) is not possible, because you need to have a filesystem which supports sparse files. According the following MOS-Note sparse files are supported on Automatic Storage Management Cluster File System (ACFS) since 12.2.: 12.2 Oracle ACFS Sparse Files Enhancements (Doc ID 2200264.1) However, I thought it is more fun to create a PDB Snapshot Copy on a XFS-filesystem, which I wanted to…

Read More
Franck Pachot

See you on Polywork (an new LinkedIn?)

By | AWS, Database Administration & Monitoring, Kubernetes, NoSQL, Oracle, Postgres | No Comments

By Franck Pachot . I have published 105 additional blog posts here since the 500th one https://blog.dbi-services.com/rollback-to-savepoint/ that I have written on my come back to dbi-services. On Oracle Database, of course, other databases as well, on clouds (OCI and AWS mainly, with a look at GCP and Azure). But also with some thoughts on the rise of the “scale-out” obsession of NoSQL. And, because I’m convinced that consistency, referential integrity, and SQL is a…

Read More
Pascal Brand

Oracle Internet Directory or Oracle Access manager 12.2.1.4 fails to install on Red Hat Linux8

By | Application integration & Middleware, Oracle | No Comments

Recently I had to install Oracle Internet Directory (OID) and Oracle Access Manager (OAM) both in 12.2.1.4 on a Red Hat 8 for new QA and PRODUCTION environments. The installation of the OID 12.2.1.4 failed on packages prerequisites check. It complained about missing packages that do not exist anymore in Red Hat 8 or in Oracle Linux 8 either. Checking for compat-libcap1-1.10; Not found. Failed Checking for compat-libstdc++-33-3.2.3-x86_64; Not found. Failed Both compat-libstdc++-33-3.2.3-x86 and compat-libcap1-1.10…

Read More
Clemens Bleile

Parameterized Views with SYS_CONTEXT in Oracle. How can the optimizer peek values?

By | Oracle | No Comments

There was a dicsussion a couple of years ago about a mssing feature in Oracle that the Optimizer is not peeking values when SYS_CONTEXT is being used in a predicate. I.e. specifically when using SYS_CONTEXT in Views to simulate passing parameters to views. See the following links concerning this topic: https://connor-mcdonald.com/2016/10/20/taking-a-peek-at-sys_context https://blog.jooq.org/2016/10/20/be-careful-when-emulating-parameterised-views-with-sys_context-in-oracle https://community.oracle.com/ideas/15826 E.g. take the example of Connor McDonald here: [email protected]@PDB1> create table t ( x varchar2(10), y char(100)); Table created. [email protected]@PDB1> [email protected]@PDB1> insert…

Read More
Franck Pachot

Amazon RDS Oracle in Multitenant

By | AWS, Oracle | 2 Comments

By Franck Pachot . AWS has just added the possibility to create your oracle Database as as CDB (Container Database), the “new” architecture of Oracle where an instance can manage multiple databases, adding a new level between the heavy instance and lightweight schema: At the time I’m writing this, I see it only in the “old” console (“original interface”) not in “new database creation flow”. It is displayed as a different Edition, however it is…

Read More
Franck Pachot

PostgreSQL on Oracle free tier ARM

By | Oracle, Postgres | 4 Comments

By Franck Pachot . This follows the previous post about the Oracle Cloud ARM compute shape just announced on May 25th. The processor is ARM v8.2 with LSE (atomic instructions) and PostgreSQL can benefit from it (see Dramatical Effect of LSE Instructions for PostgreSQL on Graviton2 Instances). I have installed GCC 11 in the previous post, on a Oracle Linux 7.9 image with comes with GCC 7. If you installed the Ubuntu 20.4 image, you…

Read More
Jérôme Dubar

Does it still make sense to deploy a virtualized HA ODA in 2021?

By | Database management, Hardware & Storage, Operation systems, Oracle | No Comments

Introduction Starting from version 19.11 of the Oracle Database Appliance software bundle, OLVM will definitely replace OVM server as virtualization engine. This change has quite a big impact as there will be no more virtualized specific deployment. Bare metal will come as a standard for all ODAs, and creating VMs for applications, or even databases, will be possible on top of that, for sure if you need them. And you can decide later to use…

Read More