As already mentioned in my blog “Oracle 18 XE is available” the XE version includes the multitenant database option. So you can create up to three pluggable databases. But in this case it doesn’t matter if it is an “ordinary” PDB, a Proxy PDB or an Application Root.
Oracle 18 XE and Multitenant Blogbeitrag lesen »
Oracle XE has many features and options which even most of the Oracle Enterprise Edition customers do not have access to (see Oracle 18 XE is available). In this blog I will go into the details about the installation and configuration.
Oracle 18 XE – First Impressions Blogbeitrag lesen »
On october 19th 2018 the wait had an end. Finally a new version of the free Oracle Database “Oracle Database 18c Express Edition short Oracle 18 XE has been released.
Oracle 18 XE is available! Blogbeitrag lesen »
As most of you probably already know, the installation of Grid Infrastructure has changed with Oracle 12.2. The software has to be unpacked in the GRID_HOME and installed from there. In conjunction with this change the Oracle Inventory or more precise inventory.xml file (mostly in the directory /u01/app/oraInventory/ContentsXML) has been changed as well. Up to Version 12.1 the nodes for all installed components (e.g. GI, Database, Client, etc.) have been listed in the NODE_LIST. But since 12.2 this information is no longer available. More information can be found in MOS: 12.2: Oracle inventory does not have references for cluster nodes (Doc ID 2264757.1).
Oracle 12.2 Grid Inventory without NodeList Blogbeitrag lesen »
Data Guard is easy! Every Oracle database with a certain value for the business should be protected with a standby database. How you can set up a standby environment for Standard Edition Two will be covered in a dfiferent blog. Today the goal is to create a Data Guard configuration fast, easy and repeatable.
Data Guard is easy Blogbeitrag lesen »
With Release 11g Oracle introduced the concept of the Automatic Diagnostic Repository (ADR) which is an independent directory structure for all kinds of logs and traces for the database, listener and other Oracle products. The directory diag is located in $ORACLE_BASE so you should ensure that that variable has been set to the correct directory. If it’s not set the files will be stored in $ORACLE_HOME/diag.
Automatic Diagnostic Repository Management Blogbeitrag lesen »
