Database Administration & Monitoring, Oracle 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, Database management, Development & Performance, Hardware & Storage, Oracle 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(…)
Application integration & Middleware, Database Administration & Monitoring, Database management, Oracle 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, Oracle Control File issues on duplicating with non patched Oracle version. 18.07.2018 by Oracle Team Introduction : RMAN has the ability to duplicate, or clone, a database from a backup or from an active database. It is possible to create a duplicate database on a remote server with the same file structure, or(…)
Database Administration & Monitoring Oracle 18c clone PDB and Transparent Data Encryption 30.04.2018 by Oracle Team Let’s do some tests with the Oracle 18c new feature in creating PDB clone with DBCA. Unfortunately, this feature does not work when you have TDE enabled. Just to remember, with Oracle 12.2 we had the possibility to create PDBs with(…)
Database Administration & Monitoring ODA migration challenges: Non-OMF to OMF + 11.2.0.3 to 11.2.0.4 27.02.2018 by David Hueber To do some application and performances tests, I had to copy a database from a third party Linux server to an ODA X7-2M. Looks pretty simple on the paper, but 2 small challenges came into the game. The first was(…)
Database management, Oracle ORACLE 11g to 12c RMAN catalog migration 12.01.2018 by Marc Wagner This is a small migration demo of a 11g catalog (RCAT11G) to a new 12c catalog (RCAT12c). Demo databases environments have been easily managed thanks to DBI DMK tool. oracle@vmreforadg01:/home/oracle/ [RCAT11G] sqh SQL*Plus:(…)
Database Administration & Monitoring Grid Infrastructure 11.2.0.3 PSU: My Opatch version check is failing 08.07.2017 by Oracle Team Mouhamadou Diaw Last day I was configuring grid infrastructure 11.2.0.3 for a standlone server. After the installation, I decided to apply the Patch Set Update 11.2.0.3.7 (Includes Database PSU 11.2.0.3.7) – 16742216 In the documentation it is marked(…)
Database Administration & Monitoring, Development & Performance, Oracle Enable 10046 Tracing for a specific SQL 05.02.2016 by Clemens Bleile Available methods to enable 10046 trace are described in My Oracle Support Note 376442.1. You can enable 10046-tracing – on session level (alter session) – for other sessions (e.g. with oradebug, the package DBMS_MONITOR or DBMS_SYSTEM) What is not(…)
Database Administration & Monitoring Oracle DBA Essentials Workshop – Patchset 11.2.0.4 Available 10.11.2015 by Oracle Team We have Upgrade our Environment Oracle DBA Essentials Workshop of release 11.2.0.3 to 11.2.0.4. From now on, you can operates the various subjects on the new release. In this article, I present you the procedure to be followed for(…)