Infrastructure at your Service

Category

Oracle

Jérôme Dubar

Why ODA reimaging doesn’t work on the first try?

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

Introduction Reimaging an ODA is a good practice for a lot of reasons. To make your ODA cleaner if it’s running for many years and if you patch regularly. To simplify patching because if you’re late you could have to apply multiple intermediate patches to reach the target version. Or simply because you need to change the configuration (for example network configuration) and you want to make things clean, and be sure that future patches…

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

When you change the UNDO_RETENTION parameter, the LOB segment’s retention value is not modified

By | Database Administration & Monitoring, Database management, Development & Performance, Hardware & Storage, Oracle | No Comments

Below, I will try to explain, a particular case for the general error : ORA-01555 snapshot too old error.. Normally, when we have this error, we are trying to adapt the retention parameters or to tune our queries. SQL> show parameter undo; NAME TYPE VALUE ———————————— ———– —————————— temp_undo_enabled boolean FALSE undo_management string AUTO undo_retention integer 3600 –extended from 900, undo_tablespace string UNDOTBS1 But, are some scenarios where the above rule is not working . We…

Read More
Lazhar Felahi

SQL Tuning – Mix NULL / NOT NULL Values

By | Development & Performance, Oracle | No Comments

One of the difficulty when writing a SQL query (static SQL) is to have in the same Where Clause different conditions handling Null Values and Not Null Values for a predica. Let’s me explain you by an example : Users can entered different values for a user field from an OBI report: – If no value entered then all rows must be returned. – If 1 value entered then only row(s) related to the filter…

Read More
Jérôme Dubar

How to patch your ODA lite to 18.3.0.0.0

By | Database Administration & Monitoring, Database management, Hardware & Storage, Oracle | No Comments

Even you don’t need 18c, or you’re not ready for this release, this patch will also update your 11gR2, 12cR1 and 12cR2 databases to the latest PSU available on ODA, it means for example the patchset from last July if you’re using 12cR1. Here is how to apply this latest patch for your ODA lite. In this example, the patch was applied on an X6-2S ODA running on previous release: 12.2.1.4.0. 1) Download the patch…

Read More
Petre Radut

Create a primary database using the backup of a standby database on 12cR2

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

The scope of this blog will be to show how to create a primary role database based on a backup of a standby database on 12cR2. Step1: We are assuming that an auxiliary instance has been created and started in nomount mode. rman target / restore primary controlfile from ‘backup_location_directory/control_.bkp’; exit; By specifying “restore primary” , will modify the flag into the controlfile, and will mount a primary role instance instead of a standby one….

Read More