By Franck Pachot . sqlplus / as sysdba oradebug setmypid oradebug unlimit oradebug hanganalyze 3 oradebug dump ashdumpseconds 30 oradebug dump systemstate 266 oradebug tracefile_name Your Oracle database – production DB, of course – is hanging. All users are blocked. You quickly check the obvious suspects (archivelog destination full, system swapping, etc.) but it’s something else. Even you, the Oracle…
LOBs (Large OBjects) first appeared in Oracle 7 and were created to store large amount of data such as document files, video, pictures, etc. Today, we can store up to 128 TB of data in a LOB, depending on the DB_BLOCK_SIZE parameter settings. In this posting, I will show you how to load LOB files into the Oracle database and…
The concept of Multitenant databases, which was introduced with Oracle 12c in June 2013, allows to run several databases on a single instance. Oracle presents this feature as a good solution for Oracle patching. The reason behind it is that it is now possible to unplug a container database (called PDB) from its original container (called CDB), in order to…
Oracle DBAAS (Database As a Service) offers a good solution for on demand access to software and infrastructure. In this posting, I will describe the DBAAS implementation with Enterprise Manager Cloud 12c. Why Database as a Service is interesting When a developer team needs a new database, the system administrator has to configure the host, the storage administrator has to…
The choice of the correct character set before you create an Oracle 12c database is an important decision. You have to know the type of data you have to store and the languages needed by the Oracle database. Oracle recommends to choose Unicode for its universality and compatibility. It supports all written languages and most of the technical and scientific…
Among the Oracle 12c new features there is the addition of an uninstall tool encapsulated in the Oracle database binaries. There is no more the necessity to download the deinstallation tool for Oracle products (deinstall utility). In this blog I propose an overview of this tool and its functionnalities.
I was surprised to see that Oracle WebTier 12c release has been available from OTN since June 2013. It comes with big changes. I guess that marketing Oracle Database 12c encouraged the outcome of newer versions of Oracle Middleware products such as Oracle WebLogic Server 12.1.2, Oracle Coherence 12.1.2, and Oracle WebTier 12.1.2. Oracle WebTier 12.1.2 includes the following features:…
This blog explains how to install Oracle Audit Vault and Database Firewall (AVDF) 12.1.1.1.0 on VirtualBox step-by-step. The configuration will be covered in a second blog. Download AVDF Binaries First of all, download the binaries on support.oracle.com: https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?_afrLoop=140865428570210&patchId=16965974&_afrWindowMode=0&_adf.ctrl-state=1a5l4hvifo_4 Patch 16965974: 12.1.1.1.0 FULL INSTALL IMAGES FOR ORACLE AUDIT VAULT AND DATABASE FIREWALL There are three files: 1. Audit Vault Server 2.…
In a previous article, I have shown how to configure two servers in order to deploy a two-nodes 12c cluster. This time, I am going to describe the Grid Infrastructure 12c installation process using Oracle Universal Installer (OUI). We assume that cluvfy tool has returned no errors (see previous blog). Install Grid Infrastructure Connect as grid and launch the Oracle…
La version 12c d’Oracle Grid Infrastructure introduit de nombreuses nouveautés dans le support d’ACFS, le système de fichiers clusterisés d’Oracle. Nous abordons dans ce posting la capacité d’ACFS d’être le système de fichier de votre base de données ainsi que sa capacité de mise en œuvre des snapshots. Rappel sur ACFS Ce système de fichier est apparu avec la version 11.2 du…
Grid infrastructure 12c has recently been released. In this posting, I will show that the installation prerequisites are quite similar between Grid Infrastructure 11g and 12c. We will see parts of them during a review for the deployment of Grid Infrastructure on a two nodes RAC database cluster. Server hardware requirements Let’s see the hardware part. Grid infrastructure 12.1 Grid…
Oracle Database 12c offers several enhancements for partitioning. In a previous blog posting, I talked about reference partitioning enhancements. This post will present other enhancements in relation to general partitioning. Asynchronous index maintenance With Oracle database, a global index becomes UNUSABLE when dropping or truncating the partition on which this index points, until the clause UPDATE GLOBAL INDEXES is used.…
