At a customer, I received an incident saying that on D2 a document is found by browsing and not found using normal search. The root cause seems to be easy: The Document isn’t indexed?! Not really, you will see it wasn’t easy to find đ
Read More
In the previous blog I showed you how to decommission a remote Content Server by deleting remote Docbase(s) and Docbroker(s). In fact, when I tried to delete remote Docbases I encounter a strange behavior, and it wasn’t easy to find the root cause!
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…
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…
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…
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…
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…
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…
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…
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…
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…
A few days ago I had the interesting mission to build a two Node Patroni Postgres 9.6 Cluster using etcd in our openDB Appliance environment. Sounds easy, one leader, one secondary, both running etcd, that’s it. But that’s only the first impression.