Infrastructure at your Service

All Posts By

Oracle Team

Oracle Team

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
Oracle Team

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
Oracle Team

An always free 4 vCPU 3.0 GHz 24 GB RAM on OCI

By | Cloud | 5 Comments

By Franck Pachot . Oracle Cloud free tier is already outstanding since OOW19 with two VMs and two databases that you can leave always running without any risk of being billed or seeing them stopped. I use them daily. And it goes to another level on May 25th with the announce of the ARM Ampere Altra 80 cores processor running at 3.0 GHz. Because on your free tier, one of those two VMs can be…

Read More
Oracle Team

El Carro: The Oracle Operator for Kubernetes

By | Kubernetes, Oracle | One Comment

By Franck Pachot . Google Cloud, Open Source and Oracle Databases… what seems to be a paradox is possible, thanks to cloud providers who contribute to open infrastructure. The idea is to use Operators (custom resource controllers on Kubernetes) to automate the Oracle Database operations in a standard, open and portable way. If you ever attempted to run Oracle Database on containers, trying to keep up with the DevOps approach, you know that it requires…

Read More
Oracle Team

Delphix and upgrading the clones (Oracle)

By | Postgres | No Comments

By Franck Pachot . Delphix is a tool for easy cloning of databases. The idea is that all is automated: the user can create a clone, rewind or refresh it with one click. However, I was suprised that the following common scenario is not managed by the Delphix engine: You clone from production, say Oracle 12c You upgrade the clone, say Oracle 19c You test there You refresh the clone from production, obviously being back…

Read More
Oracle Team

An example of ORA-01152: file … was not restored from a sufficiently old backup

By | Oracle | One Comment

By Franck Pachot . Oracle Error: ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01152: file … was not restored from a sufficiently old backup ORA-01110: data file … This error is one of the most misunderstood recovery error. It can happen in different case but I have here a simple example to reproduce it, with some comments and queries to see the state. I run an example to avoid long theory…

Read More
Oracle Team

Some Artificial Intuition in Oracle SQL_ID?

By | Oracle | One Comment

By Franck Pachot . This post is something I discovered by chance when writing about tagging SQL statement with recognizable comments. We know that Oracle is introducing more and more artificial intelligence and machine learning in the database engine, but here is the first time I see something where random or hash values seems to bring some meaning. There are two common ways to run a query and find it in V$SQL: add some tag…

Read More
Oracle Team

ORA-32635: not a single cell reference predicate

By | Database Administration & Monitoring | No Comments

By Franck Pachot . I spent 30 minutes to try to understand this error with a query that I’ve run in many environments for years. So if you google it you may arrive here and the solution may be checking whether you have NLS_COMP=LINGUISTIC SQL> alter session set nls_comp=linguistic; Session altered. SQL> alter session set nls_language=french; Session modifiee. SQL> select * from ( 2 select 42 snap_id,’TM’ type,’DB time’ name,0 microseconds from dual 3 )…

Read More
Oracle Team

Foreign Keys in MySQL, SQL, NoSQL, NewSQL

By | MySQL, Oracle, Postgres | No Comments

By Franck Pachot . In the NoSQL times, it was common to hear thinks like “SQL is bad”, “joins are bad”, “foreign keys are bad”. Just because people didn’t know how to use them, or they were running on a database system with a poor implementation of it. MySQL was very popular because easy to install, but lacking on many optimization features that you find in other open source or commercial databases. Sometimes, I even…

Read More
Oracle Team

Oracle – testing resource manager plans?

By | Database Administration & Monitoring, Oracle | 3 Comments

By Franck Pachot . I never remember that in order to use instance caging you need to set a Resource Manager Plan but don’t need to set CPU_COUNT explicitly (was it the case in previous versions?). Here is how to test it quickly in a lab. SQL> startup force ORACLE instance started. SQL> show spparameter resource_manager_plan SID NAME TYPE VALUE ——– —————————– ———– —————————- * resource_manager_plan string SQL> show spparameter cpu_count SID NAME TYPE VALUE…

Read More