Infrastructure at your Service

 
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
Stéphane Savorgnano

How to create an Azure SQL Database

By | Cloud, SQL Server | No Comments

Azure SQL Database is a relational database-as-a-service (DBaaS) which gives us the possibility to create application with a performant database without to take care of the relying infrastructure. Azure SQL Database is based on the latest stable version of Microsoft SQL Server Database Engine. We have the choose between 2 purchasing models: a vCore-based purchasing model and a DTU-based (Database Throughput Unit) purchasing model. 3 Deployment options possible: single database: has its own set of…

Read More
Mouhamadou Diaw

Oracle 18c Grid Infrastructure on Windows Server

By | Database Administration & Monitoring, Oracle | No Comments

Oracle Grid Infrastucture can be installed on Windows platform. The steps are the same that on other platforms. In this blog we are going to install Oracle GI 18c on Windows 2016.I have two disks on my server Disk 0 : for the system Disk 1 : for the ASM I am using a VirtualBox virtual machine. We suppose that the grid infrastructure sofware is already downloaded and decompressed in the grid home. Like on…

Read More
Daniel Westermann

Creating PostgreSQL users with a PL/pgSQL function

By | Database Administration & Monitoring | No Comments

Sometimes you might want to create users in PostgreSQL using a function. One use case for this is, that you want to give other users the possibility to create users without granting them the right to do so. How is that possible then? Very much the same as in Oracle you can create functions in PostgreSQL that either execute under the permission of the user who created the function or they run under the permissions…

Read More
Clemens Bleile

Direct NFS, ODM 4.0 in 12.2: archiver stuck situation after a shutdown abort and restart

By | Database Administration & Monitoring, Database management | No Comments

A customer had an interesting case recently. Since Oracle 12.2. he got archiver stuck situations after a shutdown abort and restart. I reproduced the issue and it is caused by direct NFS since running ODM 4.0 (i.e. since 12.2.). The issue also reproduced on 18.5. When direct NFS is enabled then the archiver-process writes to a file with a preceding dot in its name. E.g. .arch_1_90_985274359.arc When the file has been fully copied from the…

Read More