Infrastructure at your Service
This week, I tried to install a GoldenGate environment to make some test. The installation was good and simple. Firstly I tested the normal capture mode and all worked correctly. In a second time, I wanted try to use the integrated capture mode. When arrived the time to register my extract in the database, I have received an error. GGSCI (goldengate as [email protected]) 2> register extract test database ERROR: Cannot register or unregister EXTRACT TEST…
By Franck Pachot . I’ll present How to read an AWR report next month at UKOUG TECH15 and the first recommendation after checking Average Active Sessions is to verify that we are not in a CPU starvation situation. Here is a little demo to show how it looks like in an AWR report.
A customer asks me, what is the collation for System Center products? Do we have a general collation for all products? And what is the BP for Tempdb? And how work the licencing for SQL Server in System Center (is SQL Server included)??? I answer just “OK, OK, I understand, I wil check those points…” I search those information on Microsoft TechNet website, blogs, presentation, etc.. and I think that it is interesting to share…
By Franck Pachot . When you want to minimize the backup or restore duration, you can parallelize RMAN operations by allocating multiple channels. If you are in cluster, you can open channels from several nodes. Let’s see why, how, and a strange issue: need to set cell_offload_processing=false even if not on Exadata.
When we upgraded our ADTS 6.7 SP2 into 7.2 we realized how great the new version was! Intro The 7.2 version changed its entire structure and cleared many useless dependencies such as Adlib. Now every files and configurations are stored in one only place! Before we had files dispersed in C:\Documentum, in Program File\Documentum, in Program Files(x86)\Adlib and so on. How do you want to find yourself with this structure! Now, everything is located under…
By Franck Pachot . I’ve tested a little thing for a customer, and as usual I spool the result into a blog post in case it helps others. Not all replication software – at least in their current version – can manage both different target structure (which is often the main reason for logical replication) and keep up with new DDL on the source (which you can’t avoid – applications evolves). Let’s see how smart…
For last week, the SQL Server 2016 Community Technology Preview 3.0 has been available with a lot of enhancements on new features. All info about CTP3 are on SQL Server Blog here. I wrote some weeks ago, a blog about JSON Support in SQL Server 2016: SQL Server 2016: native support for JSON With this new CTP version, JSON support has new enhancements and especially the OPENJSON function. When I wrote my blog, this option…
Les journĂ©es SQL Server se dĂ©rouleront dans un mois Ă Paris dans les locaux de Microsoft. L’agenda n’a Ă©tĂ© qu’en parte dĂ©voilĂ© mais c’est avec plaisir que je peux dores et dĂ©jĂ vous annoncer que dbi services sera de la partie cette annĂ©e encore en tant que speaker et sponsor de l’Ă©vĂ©nement. Pour ma part j’aurai le plaisir de vous y retrouver une fois de plus autour d’une session In-memory 2016 avec notamment les index…
By Franck Pachot . Remember my first try of Oracle cloud when Larry Ellison announced the Cloud in june? This week at OOW15 Larry Ellison announced that IBM is not a competitor anymore for them, then I checked IBM Cloud: IBM Bluemix offers IaaS, PaaS and SaaS. As I did in my first trial for Oracle, I’m testing the simplest DB2 ‘SQL Database service’.
Oracle EM Cloud Control 12c (CC12c) – Repeat alert notification In your EM installation, CC12c will notify your different administrators when specific incidents, events, or problems occurs. But from standard configuration, you will receive only one warning or critical notification/alert … until the Clear or an Acknowledge of the alert. Some times and for different reasons (human error, email was deleted, Mail server issues, …) you can lost or forgot this alert. Hummm this is…
By Franck Pachot . You are reading and learning from blogs about oracle technology? I would like to encourage everybody to be a blogger as well.
The last Week end Oracle has proceeded to a new upgrade into the Oracle Cloud. For the Data Region EMEA Oracle Database Public Cloud Services had maintenance on : Oracle Java Cloud Service Oracle Database Cloud Service Unfortunately it is impossible to know what specific changes have been made in the Cloud and currently there is no exhaustive list available from Oracle Cloud Team. Here we will see the principal changes on the Oracle Database…
