Infrastructure at your Service

Category

Database Administration & Monitoring

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
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
Oracle Team

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
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