Infrastructure at your Service

 
David Diab

Documentum – Remote Content Server Decommission

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

I already experienced the installation of a remote Content Server but it was my first decommissioning, and as usual the decommission is faster than the installation 😉 by the way, read this blog if you missed how to install a remote Docbase 🙂 First step is to delete all remote Docbases, then delete DocBroker, and at the end uninstall the Content Server. In my case, I have 4 Content Servers (ser, ser-0, ser-01, ser-1) and…

Read More
Pascal Brand

Configuring Oracle DB data source in JBoss EAP 7.1

By | Application integration & Middleware | No Comments

Introduction This blog explains how to install and use an Oracle database JDBC driver in JBoss EAP 7.1 standalone instance and in a domain deployment. Oracle JDBC driver installation The first step is to install the JDBC driver in the JBoss installation. This can be done copying the files to the right directory or using the JBoss CLI to do the install properly. I will use the JBoss CLI script for this. Start the JBoss…

Read More
Alain Lacour

APEX Connect 2019 – Day 3

By | Application integration & Middleware, Database Administration & Monitoring | No Comments

For the last conference day, after the Keynote about “JavaScript, Why Should I Care?” by Dan McGhan , I decided to attend some JavaScript learning sessions to improve myself and presentations on following topics: – How to hack your APEX App… (only for testing) – What you need to know about APEX validations I also got the chance to have a 1:1 talk with Anthony Rayner to expose some wishes about APEX and talk about…

Read More
Alain Lacour

APEX Connect 2019 – Day 2

By | Application integration & Middleware, Database Administration & Monitoring | No Comments

The day first started with a 5K fun run. After the Keynote about “APEX: Where we have come from and where we’re heading: Personal insights on Application Express from the Development Team” by John Snyders, Anthony Rayner and Carsten Czarski explaining their work on APEX and some upcoming features, I decided to attend presentations on following topics: – Know your Browser Dev Tools! – APEX Devops with Database tooling – Klick, Klick, Test – Automated…

Read More
Alain Lacour

APEX Connect 2019 – Day 1

By | Application integration & Middleware, Development & Performance, Oracle | No Comments

This year again the APEX connect conference spans over three days with mixed topics around APEX, like JavaScript, PL/SQL and much more. After the welcome speech and the very funny and interesting Keynote about “PL/SQL: A Career Built On Top Of PL/SQL – 25 years of Coding, Sharing, and Learning” by Martin Widlake, I decided to attend presentations on following topics: – Oracle Text – A Powerful Tool for Oracle APEX Developers – Make It…

Read More
Mouhamadou Diaw

Oracle 19C : Exporting and Importing Broker Configuration

By | Database Administration & Monitoring, Oracle | No Comments

Up to Oracle 19c, there was no automatic way to backup the configuration of the broker. One solution was to manually copy all executed instructions in a file. With Oracle 19c, there is now the possibility to export and to import the configuration of the broker. Indeed the new EXPORT CONFIGURATION command will enable to save the metadata contained in the broker configuration file to a text file. This can be very useful if I…

Read More
Mouhamadou Diaw

Oracle 19C : Dynamic Change of Fast-Start Failover Target

By | Database Administration & Monitoring, Oracle | No Comments

Oracle 19C is now available on premise. There are lot of new features. One for the Data Guard Broker is that now we can dynamically change the fast-start failover target to a specified member in the list without disabling the fast-start failover. I have tested this new feature and is describing this in this blog I am using 3 servers with Oracle Linux The Data Guard is already built and the broker is already configured…

Read More
Stéphane Savorgnano

How to migrate from on-premise to an Azure SQL Database

By | Cloud, Database management | No Comments

As a SQL Server DBA we have the habit to migrate databases from an instance to another one or to a new environment. But migrate a database from on-premise to the Azure Cloud is an operation that we don’t deal with every day. As a reminder, Azure SQL Database is a relational database-as-a-service (DBaaS) which gives the ability to manage your databases directly from the Cloud with the performance of your choose, reliability, security and…

Read More
Michael Hein

Unable to add physical standby database

By | Database Administration & Monitoring | No Comments

Recently I tried to setup some new physical standby databases and got the following strange message: DGMGRL> ADD DATABASE “XXXX” as connect identifier is “XXXX” maintained as physical; Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added Often you can read, that you have to check parameter log_archive_dest_2 on primary side. But this error message can also occur if log_archive_dest_2 on standby site points to another standby database. Solution is following command on standby…

Read More