Oracle Archives - Blog dbi services

Oct 12 2018

How to migrate Grid Infrastructure from release 12c to release 18c

By Petre Radut | Application integration & Middleware, Database Administration & Monitoring, Database management, Oracle | No Comments

Oracle Clusterware 18c builds on this innovative technology by further enhancing support for larger multi-cluster environments and improving the overall ease of use. Oracle Clusterware is leveraged in the cloud in order to provide enterprise-class resiliency where required and dynamic as well as online allocation of compute resources where needed, when needed. Oracle Grid Infrastructure provides the necessary components to manage high availability (HA) for any business critical application. HA in consolidated environments is no…

Oct 08 2018

From Oracle to Postgres with the EDB Postgres Migration Portal

By Joël Cattin | Database Administration & Monitoring, Database management, Postgres | No Comments

EnterpriseDB is a valuable actor in PostgreSQL’s world. In addition to provide support, they also deliver very useful tools to manage easily your Postgres environments. Among these we can mention EDB Enterprise Manager, EDB Backup & Recovery Tool, EDB Failover Manager, aso… With this post I will present one of the last in the family, EDB Postgres Migration Portal, a helpful tool to migrate from Oracle to Postgres. To acces to the Portal, use your…

Sep 24 2018

SQL Plan stability in 11G using stored outlines

By Petre Radut | Database Administration & Monitoring, Database management, Development & Performance, Oracle | No Comments

Plan stability preserves execution plans in stored outlines. An outline is implemented as a set of optimizer hints that are associated with the SQL statement. If the use of the outline is enabled for the statement, then Oracle Database automatically considers the stored hints and tries to generate an execution plan in accordance with those hints (Oracle documentation). Oracle Database can create a public or private stored outline for one or all SQL statements. The…

Aug 23 2018

RMAN catalog upgrade, why, when and how

By Marc Wagner | Database Administration & Monitoring | No Comments

One of our customer has been initially creating a RMAN catalog on an Oracle database release 12.1.0.2.0 and was now intending to register new Oracle 12.2.0.1.0 databases. Registering the databases will be failing with errors : PL/SQL package RCAT.DBMS_RCVCAT version 12.01.00.02 in RCVCAT database is too old RMAN-06429: RCVCAT database is not compatible with this version of RMAN

Aug 20 2018

A tribute to Natural Join

By Oracle Team | Oracle | No Comments

By Franck Pachot . I know that lot of people are against the ANSI join syntax in Oracle. And this goes beyond the limits when talking about NATURAL JOIN. But I like them and use them quite often. Why is Natural Join bad? Natural join is bad because it relies on column names, and, at the time of writing the query, you don’t know which columns will be added or removed later. Here is an…

Aug 20 2018

Running PLSQL as SYSDBA through DEFINER-rights?

By Clemens Bleile | Database Administration & Monitoring, Database management | No Comments

Recently I got an interesting request: The customer wanted to allow the application installation routine to create a guaranteed restore point without giving it all required privileges to do so. So the idea was to encapsulate creating and dropping a guaranteed restore point in a PLSQL package and granting the application owner the permission to execute the package. The problem with that approach is that SYSDBA-privileges are required to create a guaranteed restore point and…

Aug 16 2018

The size of Oracle Home: from 9GB to 600MB

By Oracle Team | Oracle | No Comments

By Franck Pachot . This is research only and totally unsupported. When building docker images to run Oracle Database in a container, we try to get the smallest image possible. One way is to remove some subdirectories that we know will not be used. For example, the patch history is not used anymore once we have the required version. The dbca templates can be removed as soon as we have created the database… In this…

Aug 15 2018

Easily manage dual backup destination with RMAN

By Jérôme Dubar | Database Administration & Monitoring, Database management, Oracle | No Comments

Backup on disk with RMAN is great. It’s fast, you can set as many channels as your platform can handle for faster backups. And you can restore as fast as you can read and write files on disk with these multiple channels. As far as you’re using Enterprise Edition because Standard Edition is stuck to a single channel. Disk space is very often limited and you’ll probably have to find another solution to keep backups…

Aug 14 2018

ODA database been stuck in deleting status

By Marc Wagner | Database Administration & Monitoring | No Comments

Facing an internal inconsistency in the ODA derby database is very painful (see https://blog.dbi-services.com/oda-lite-what-is-this-odacli-repository/ for more info about the derby database). I have recently faced a case where the database deletion was failing and the database remained then in “Deleting” status. Connecting directly to the internal derby database and doing some self cleaning is very risky and should be performed at your own and known risk. So, in most of the case, a database inconsistency issue…

Oracle Archives - Blog dbi services

How to migrate Grid Infrastructure from release 12c to release 18c

From Oracle to Postgres with the EDB Postgres Migration Portal

SQL Plan stability in 11G using stored outlines

RMAN catalog upgrade, why, when and how

A tribute to Natural Join

Running PLSQL as SYSDBA through DEFINER-rights?

The size of Oracle Home: from 9GB to 600MB

Easily manage dual backup destination with RMAN

ODA database been stuck in deleting status

Categories

Recent articles

Tag Cloud

Blog Roll

EXPERTISE IN DATABASE & MIDDLEWARE

TRAININGS IN DATABASE & MIDDLEWARE

USEFUL INFORMATION