Infrastructure at your Service

Oracle 11g Archives - Blog dbi services

Petre Radut

Control File issues on duplicating with non patched Oracle version.

By | Database Administration & Monitoring, Oracle | No Comments

Introduction : RMAN has the ability to duplicate, or clone, a database from a backup or from an active database. It is possible to create a duplicate database on a remote server with the same file structure, or on a remote server with a different file structure or on the local server with a different file structure. For some old and  non patched Oracle versions such as that earlier than , the duplicate (from…

Read More
Pierre Sicot

Oracle 18c clone PDB and Transparent Data Encryption

By | Database Administration & Monitoring | No Comments

Let’s do some tests with the Oracle 18c new feature in creating PDB clone with DBCA. Unfortunately, this feature does not work when you have TDE enabled. Just to remember, with Oracle 12.2 we had the possibility to create PDBs with dbca just from PDBseed to from unplugged PDBs: Now in version 18c we can create PDBs from existing PDBs as follows (for this test TDE is disabled): You can choose the Pluggable Database you want…

Read More
David Hueber

ODA migration challenges: Non-OMF to OMF + to

By | Database Administration & Monitoring | One Comment

To do some application and performances tests, I had to copy a database from a third party Linux server to an ODA X7-2M. Looks pretty simple on the paper, but 2 small challenges came into the game. The first was that of course the source database was in Non-OMF while ODA works fully in OMF. The second was that the source database is running which is not supported and cannot be installed on the…

Read More
Marc Wagner

ORACLE 11g to 12c RMAN catalog migration

By | Database management, Oracle | 2 Comments

This is a small migration demo of a 11g catalog (RCAT11G) to a new 12c catalog (RCAT12c). Demo databases environments have been easily managed thanks to DBI DMK tool. oracle@vmreforadg01:/home/oracle/ [RCAT11G] sqh SQL*Plus: Release oracle@vmtestoradg1:/home/oracle/ [RCAT12C] sqh SQL*Plus: Release   Current configuration Displaying the list of databases registered in the RCAT11g catalog. SQL> select instance_name from v$instance; INSTANCE_NAME —————- RCAT11G SQL> select * from rcat.rc_database;     DB_KEY  DBINC_KEY       DBID NAME     RESETLOGS_CHANGE# RESETLOGS ———-…

Read More
Mouhamadou Diaw

Grid Infrastructure PSU: My Opatch version check is failing

By | Database Administration & Monitoring | No Comments

Last day I was configuring grid infrastructure for a standlone server. After the installation, I decided to apply the Patch Set Update (Includes Database PSU – 16742216 In the documentation it is marked You must use the OPatch utility version or later to apply this patch. Verifying my opatch version, I see that I have to update it [root@ ]# ./OPatch/opatch version Invoking OPatch OPatch Version: So I download…

Read More
Clemens Bleile

Enable 10046 Tracing for a specific SQL

By | Development & Performance | 10 Comments

Available methods to enable 10046 trace are described in My Oracle Support Note 376442.1. You can enable 10046-tracing – on session level (alter session) – for other sessions (e.g. with oradebug, the package DBMS_MONITOR or DBMS_SYSTEM) What is not covered with the methods above is the possibility to trace a specific SQL-statement, which runs “somewhen” in the future on the database. E.g. a SQL, which runs during a next batch job. With the introduction of…

Read More

Oracle DBA Essentials Workshop – Patchset Available

By | Database Administration & Monitoring | No Comments

We have Upgrade our Environment Oracle DBA Essentials Workshop of release to From now on, you can operates the various subjects on the new release. In this article, I present you the procedure to be followed for the upgrade of your database: Update DMK to the version 14-10 Upgrade database Install Oracle Patchset and PSU Update DMK 14-10 The first step it’s update Data Management Kit, included dmk_sql. We need to Download,…

Read More
Joël Cattin

“FRA full” alerts flood the Alert Log

By | Database Administration & Monitoring | 4 Comments

We discovered a strange behavior in the Alert Log when the Fast Recovery Area (FRA) is full and the database wants to write something inside it (for example an archivelog). This case concern Oracle databases and higher. Here is a demo with a 12c database ( : First, to reproduce the behavior, I set a very small size to the FRA : SQL> alter system set db_recovery_file_dest_size = 1M; System altered. SQL> As you can see, the…

Read More
Pierre Sicot

statistics_level parameter

By | Database management | No Comments

With Enterprise Manager Cloud Control 12c configuring and using the compliance standard utility allows us to discover events we should not have seen in other ways. Today at a customer’s site I discovered the following message:   The configuration Best Practice for Oracle Database discovered the statistics_level parameter was set to the value ALL.   By selecting the Violation in the Configuration Best Practice for Oracle Database, we can display the message:     By…

Read More
Franck Pachot

Index on trunc(date) – do you still need old index?

By | Database management, Oracle | 6 Comments

By Franck Pachot . Sometimes we have to index on ( trunc(date) ) because a SQL statement uses predicate on it instead of giving a range from midnight to midnight. When you do that you probably keep the index on the column. That’s two indexes to maintain for DML. Do we need it? I’ll show a feature that appeared in (info from oracle-l) so let’s set the optimizer to behave as before that feature….

Read More