BE SHARING

Oracle 18c

Oracle 18c – select from a flat file

04.06.2020 by Oracle Team

By Franck Pachot . This post is the first one from a series of small examples on recent Oracle features. My goal is to present them to people outside of Oracle and relational databases usage, maybe some NoSQL players.

Database Administration & Monitoring

Migrating Oracle database from windows to ODA

01.10.2019 by Marc Wagner

Nowadays I have been working on an interesting customer project where I had to migrate windows oracle standard databases to ODA. The ODAs are X7-2M Models, running version 18.5. This version is coming with Red Hat Enterprise Linx 6.10 (Santiago).

Database Administration & Monitoring

Oracle 18c Grid Infrastructure on Windows Server

27.04.2019 by Mouhamadou Diaw

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(…)

Database Administration & Monitoring

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

18.03.2019 by Oracle Team

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(…)

Database Administration & Monitoring

Strange behavior when patching GI/ASM

26.11.2018 by Oracle Team

I tried to apply a patch to my 18.3.0 GI/ASM two node cluster on RHEL 7.5. The first node worked fine, but the second node got always an error...

Database Administration & Monitoring

Schema only account with Oracle 18.3

20.10.2018 by Oracle Team

With Oracle 18.3, we have the possibility to create schemas without a password. Effectively in a perfect world, we should not be able to connect to application schemas. For security reasons it is a good thing that nobody can connect(…)

Application integration & Middleware

How to migrate Grid Infrastructure from release 12c to release 18c

12.10.2018 by Oracle Team

Oracle Clusterware 18c builds on this innovative technology by further enhancing support for larger multi-cluster environments and improving the overall ease of use. Oracle Clusterware is leveraged in the cloud in order to provide enterprise-class resiliency where required and dynamic(…)

Database Administration & Monitoring

PDB Snapshot Carousel Oracle 18.3

02.10.2018 by Oracle Team

A new feature with Oracle 18c is the PDB snapshot carousel. As indicated by its name a PDB snapshot is a copy of a PDB at a specific point in time. You have the possibility to create up to eight(…)

Database Administration & Monitoring

Oracle 18c DataGuard : Rman RECOVER STANDBY DATABASE

15.08.2018 by Mouhamadou Diaw

With Oracle Database 18c, we can now refresh a standby database over the network using one RMAN command, RECOVER STANDBY DATABASE. The RECOVER STANDBY DATABASE command restarts the standby instance, refreshes the control file from the primary database, and automatically(…)

Oracle

18c runInstaller -silent

12.08.2018 by Oracle Team

By Franck Pachot . You find two different 'runInstaller' under an Oracle Home. The old one, the Oracle Universal Installer, in $ORACLE_HOME/oui/bin. And the new one, in $ORACLE_HOME directly. They have the same name but are completely different. The old(…)