Infrastructure at your Service

Category

Oracle

Jérôme Dubar

How long does it take to redeploy an ODA X8-2M?

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

Introduction One of the advantage of Oracle Database Appliance is its fast deployment. Most often, the initial setup of a lite ODA (with a reimaging) only takes half a day, from unboxing until a first test database is available. Trust me, it’s hard to do better. For some reason, for example if you need to patch to the latest release and you have some intermediate patch to apply before, or if you plan to change…

Read More
Christian Weinfurtner

Oracle 21c: Blockchain Tables

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

Oracle Blockchain Tables With Oracle Database 20c/21c the new feature Oracle Blockchain Tables has been introduced. Blockchain Tables enable Oracle Database users to create tamper-resistant data management without distributing a ledger across multiple parties. Database security can be improved by using Blockchain Tables to avoid user fraud and administrator fraud as well. One of the main characteristics of Oracle Blockchain Tables is that you can only append data. Table rows are chained using a cryptographic…

Read More
Clemens Bleile

Handling unified auditing spillover files on the standby-site

By | Oracle | No Comments

Switching to Oracle Unified Auditing may produce lots of data when e.g. auditing activities of the SYS-user. I.e. according the documentation you can do the following to audit similarly as in traditional auditing with audit_sys_operations=TRUE: SQL> CREATE AUDIT POLICY TOPLEVEL_ACTIONS ACTIONS ALL ONLY TOPLEVEL; SQL> AUDIT POLICY TOPLEVEL_ACTIONS BY SYS; REMARK1: You may check the Blog on traditional SYS-auditing here REMARK2: Tests done in this Blog were done with Oracle 19.9. Auditing toplevel operations were…

Read More
Frank Bléger

How to quickly download the new bunch of 21c Oracle Database documentation?

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

Last month, Oracle released its new 21c version of the database documentation. At that time, I was looking for a quick mean to get all the books of this so-called 21c Innovation Release. I could remember I used a script to get them all in one run. Quick look at google, remembered me I used the one from Christian Antognini which hasn’t been refreshed for a while. In this blog, I will provide you the…

Read More
Lazhar Felahi

Migrate Oracle Database 9.2.0.6 to Oracle 19c using GoldenGate

By | Application integration & Middleware, Database Administration & Monitoring, Oracle | No Comments

When a customer wanted to take the challenge to migrate an oracle database 9.2.0.6 (the prehistory in the Oracle world) to Oracle 19c using Oracle GodenGate, I saw more problems than add value for different reasons:  Oracle 9.2.0.6 database is out of support (final 9.2 patch was Oracle 9.2.0.8). The customer Operating Systems was AIX 7.4 and only Oracle GoldenGate 11.1.1.1.2 for Oracle 9.2 for AIX 5.3 is available on https://edelivery.oracle.com. The Patch 13606038: ORACLE…

Read More
Franck Pachot

Optimizer Statistics Gathering – pending and history

By | Oracle | No Comments

By Franck Pachot . This was initially posted to CERN Database blog on Wednesday, 12 September 2018 where it seems to be lost. Here is a copy thanks to web.archive.org Demo table I create a table for the demo. The CTAS gathers statistics (12c online statistics gathering) with one row and then I insert more rows: 10:33:56 SQL> create table DEMO as select rownum n from dual; Table DEMO created. 10:33:56 SQL> insert into DEMO…

Read More
Franck Pachot

Password rolling change before Oracle 21c

By | Oracle | One Comment

By Franck Pachot . You may have read about Gradual Password Rollover usage from Mouhamadou Diaw and about some internals from Rodrigo Jorge. But it works only on 21c which is only in the cloud, for the moment, in Autonomous Database and DBaaS (but here I’ve encountered some problems apparently because of a bug when using SQL*Net native encryption). But your production is not yet in 21c anyway. However, here is how you can achieve…

Read More
Franck Pachot

Oracle SPD status on two learning paths

By | Oracle | No Comments

By Franck Pachot . I have written a lot about SQL Plan Directives that appeared in 12c. They were used by default and, because of some side effects at the time of 12cR1 with legacy applications that were parsing too much, they have been disabled by default in 12cR2. Today, there are probably not used enough because of their bad reputation from those times. But for datawarehouses, they should be the default in my opinion….

Read More