Infrastructure at your Service

Franck Pachot

Unplug an Encrypted PDB (ORA-46680: master keys of the container database must be exported)

By | Oracle | No Comments
 

 In the Oracle Database Cloud DBaaS you provision a multitenant database where tablespaces are encrypted. This means that when you unplug/plug the pluggable databases, you also need to export /import the encryption keys. You cannot just copy the wallet because the wallet contains all CDB keys. Usually, you can be guided by the error messages, but this one needs a little explanation and an example.

Read More
David Barbarin

SQL Server on Linux and logging

By | Database Administration & Monitoring | No Comments
 

 On Windows world, SQL Server logs information both into the SQL Server error log and the Application log. Both automatically timestamp all recorded events. Unlike the SQL Server error log, the Windows application log provides an overall picture of events that occur globally on the Windows operating system. Thus, regarding the encountered issues taking a look at such event logs – by using either the Windows event viewer or the Get-EventLog PowerShell cmdlet – may be very helpful to figure…

Read More
Morgan Patou

Alfresco DevCon 2018 – Day 2 – Big files, Solr Sharding and Minecraft, again!

By | Application integration & Middleware, Entreprise content management | No Comments
 

 Today is the second day of the Alfresco DevCon 2018 and therefore yes, it is already over, unfortunately. In this blog, I will be continuing my previous one with sessions I attended on the afternoon of the day-1 as well as day-2. There were too many interesting sessions and I don’t really have the time to talk about all of them… But if you are interested, all the sessions were recorded (as always) so wait…

Read More
Morgan Patou

Alfresco DevCon 2018 – Day 1 – ADF, ADF and… ADF!

By | Application integration & Middleware, Entreprise content management | 2 Comments
 

 Here we are, the Alfresco DevCon 2018 day-1 is over (well except for the social party)! It’s been already 2 years I attended my last Alfresco event (BeeCon 2016, first of its name (organized by the Order of the Bee)) because I wasn’t able to attend the second BeeCon (2017) since it happened on the exact dates of our internal dbi xChange event. Yesterday was the DevCon 2018 day-0 with the Hack-a-thon, the full day…

Read More
Nicolas Penot

Oracle Application Container: a Swiss Use case

By | Database Administration & Monitoring | No Comments
 

 Here we want to start a business in Switzerland in 3 different areas and make it easy to start a new market area as soon as required by that business. We are going to use the Application Container feature in order to: Have a dedicated PDB for each marker with shared and local metadata and data Roll out frequently data model and code to add features in a central manner with one command We have…

Read More
David Barbarin

Moving tables ONLINE on filegroup with constraints and LOB data

By | Database Administration & Monitoring | No Comments
 

 Let’s start this new week by going back to a discussion with one of my customers a couple of days ago about moving several tables into different filegroups. Let’s say that some of them contained LOB data. Let’s add to the game another customer requirement: moving all of them ONLINE to avoid impacting the data availability during the migration process. The concerned tables had schema constraints as primary key and foreign keys and non-clustered indexes as well. So a pretty common schema we may deal with daily at…

Read More
Franck Pachot

Spectre/Meltdown on Oracle Public Cloud UEK – PIO

By | Oracle | 2 Comments
 

 The Spectre and Meltdown is now in the latest Oracle UEK kernel, after updating it with ‘yum update': [opc@PTI ~]$ rpm -q –changelog kernel-uek | awk ‘/CVE-2017-5715|CVE-2017-5753|CVE-2017-5754/{print $NF}’ | sort | uniq -c 43 {CVE-2017-5715} 16 {CVE-2017-5753} 71 {CVE-2017-5754} As I did on the previous post on AWS, I’ve run quick tests on the Oracle Public Cloud.

Read More
Marc Wagner

RMAN debugging during catalog import

By | Database management, Oracle | No Comments
 

 In this post I would like to share how I have been able to troubleshoot and solve a catalog import issue using RMAN debug function. As we can see, the error message provided by RMAN is not very helpful. oracle@vmtestoradg1:/home/oracle/ [RCAT12C] rman catalog rcat/manager Recovery Manager: Release 12.2.0.1.0 connected to recovery catalog database RMAN> import catalog rcat/manager@RCAT11G; Starting import catalog at 05-JAN-2018 14:11:45 connected to source recovery catalog database RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE…

Read More
Marc Wagner

ORACLE 11g to 12c RMAN catalog migration

By | Database management, Oracle | One Comment
 

 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 11.2.0.4.0 oracle@vmtestoradg1:/home/oracle/ [RCAT12C] sqh SQL*Plus: Release 12.2.0.1.0   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
Marc Wagner

Automatic start/stop for CONTROL-M v9

By | Unclassified | No Comments
 

 In this post, I would like to share how to implement automatic Start and Stop for CONTROL-M/Server, CONTROL-M/Agent and CONTROL-M/EM running on Oracle linux 7 individual servers, by implementing some updates in the existing BMC procedure and script. The CONTROL-M should be running version 9 and we are using the internal PostgreSQL database. The user created for CONTROL-M/Server and CONTROL-M/Agent environment is ctmuser, the user created for CONTROL-M/EM environment is emuser. BMC CONTROL-M Workload Automation…

Read More
Mouhamadou Diaw

Automatic Data Optimization Part II : StorageTiering

By | Database Administration & Monitoring | No Comments
 

 In first a previous blog, we saw how Automatic Data Optimization can be used to compress data under predefined conditions. In this blog we will see that another possible action with ADO is to move data to another storage. Indeed we will demonstrate how it is possible to move a table to another tablespace based on predefined conditions. We are using oracle a 12.1.0.2 non-CDB database. Let’s considerer following table ARTICLE in the tablespace USERS…

Read More