Infrastructure at your Service

Category

Oracle

Mouhamadou Diaw

Patching ODA HA from 19.8 to 19.10

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

In this blog I am describing the steps to patch an ODA HA from the version 19.8 to version 19.10. The patching was done with a customer. Thanks to Pierre. The name of the servers were changed The ODA is an X8-HA with following nodes -server-aa -server-ab Before starting the patches, be sure that you have enough space on / /u01 and /opt filesystems. Below the state of our filesystems [[email protected] Downloads]# df -h /…

Read More
Jérôme Dubar

Is it possible to switch a service between 2 pluggable databases?

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

Introduction In an Oracle database, services have multiple purposes: identifying group of users prior authenticating them enabling/disabling access to a database for particular groups managing preferred nodes on a RAC configuration redirecting users to the primary after a switchover/failover when using Data Guard or Dbvisit Standby redirecting read only connections to Standby database with Active Guard option A customer asked me if services could be used for switching between PDBs without modifying client’s connexion, for…

Read More
Franck Pachot

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
Dieter Henig

Rename your DB clone completely

By | Database Administration & Monitoring, Database management, Oracle | 2 Comments

Introduction Have you ever renamed your database? When you cloned a DB, you probably started it with a new name and cloning (duplicating) with RMAN provided a new DBID, right? So why should we need to rename a DB? There may be several reasons: due to changed company rules, you need to rename all your DBs After a restore you need to run the DB with another name After a snapshot clone, (see my recent…

Read More
Dieter Henig

Clone a Terabyte Database in Seconds

By | Database Administration & Monitoring, Database management, DevOps, Hardware & Storage, Oracle | One Comment

Introduction Have you ever cloned a database using RMAN? Have you ever gotten the advice not to clone during daytime to avoid performance downgrade on the entire storage or network? For a proof of concept, we wanted to evaluate a Pure Storage array in terms of feasibility and speed of database cloning by using storage-based snapshot technology. First, I want to mention that PureStorage produces Storage devices in several sizes, all based on NVMe devices…

Read More
Franck Pachot

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
Lazhar Felahi

Oracle Data Integrator Cloud

By | Application integration & Middleware, Cloud, Database Administration & Monitoring, Enterprise content management, Oracle | No Comments

Data and applications integration is always a technical challenge for most of the companies. All data integration tool ensures that information is timely, accurate, and consistent across complex systems. Oracle Data Integrator (ODI) is different than traditional data integration tools in the sense it integrates data in a different orders. ODI is known as en E-LT because it Extracts data from the source system and Loads and Transforms data into the target system while traditional…

Read More
Clemens Bleile

Adding nmon to Oracle OSWatcher

By | Oracle | No Comments

nmon (nmon is short for Nigel’s performance Monitor for Linux on POWER, x86, x86_64, Mainframe & now ARM (Raspberry Pi)) is a nice tool to monitor a Linux system. Originally it came from the AIX-platform, where it is very popular. I asked myself if I can add nmon to the OSWatcher framework to automatically gather nmon data. It is actually possible. Here’s what I did: First I installed nmon: In my case (Oracle Enterprise Linux…

Read More
Franck Pachot

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
Franck Pachot

Oracle – testing resource manager plans?

By | Database Administration & Monitoring, Oracle | No 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