Infrastructure at your Service

Category

Oracle

Franck Pachot

Oracle MAA reference architecture and HA, DR, RTO, RPO

By | Oracle | No Comments

By Franck Pachot . I may have mentioned in some previous blog post that, in my opinion, the names of Oracle Database features make sense on the vendor product management context more than in a user context. I’m not saying that it is good or bad. There are so many features, that can be combined, and that evolved for many years. The possible use cases is unlimited. What I see customers doing in Europe is…

Read More
Marc Wagner

How to migrate High Availability databases on an ODA?

By | Oracle | One Comment

Through this blog, I would like to show, with a real customer case, how I have been migrating databases in High Availability environment on an ODA. High Availability using Data Guard for Oracle Enterprise Edition or dbvisit for Oracle Standard Edition 2. One of the advantage here would be to use the Standby Database as fallback in case there would be some application issue with new database version. Although, I would expect that for any…

Read More
Marc Wagner

How to synchronize the appliance registry metadata on an ODA?

By | Database Administration & Monitoring, Oracle | No Comments

Databases administration on a Bare Metal ODA will be done as root user by running odacli commands : odacli create-database to create a database odacli upgrade-database to upgrade a database between major releases odacli move-database to move databases from one Oracle home to another of the same database version odacli update-dbhome to update a specific RDBMS home to the latest patch bundle version etc… The odacli commands will do the needful and at the end…

Read More
Clemens Bleile

Oracle DML (DELETE) and the Index Clustering Factor

By | Oracle | No Comments

As a consultant working for customers, I’m often in the situation that I have an answer to a problem, but the recommended solution cannot be implemented due to some restrictions. E.g. the recommendation would be to adjust the code, but that is not feasible. In such cases you are forced to try to help without code changes. Recently I was confronted with the following issue: A process takes too long. Digging deeper I could see…

Read More
Mouhamadou Diaw

Duplicate Database on ODA X4

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

The ODA X4 is still in use for some customers. The last time I was asked to validate the backups . Let me explain the context. Actually the backups are done via RMAN on local in a NFS share. After these backups are backep up by Netback on tape. The goal was just to validate that the backups done by Netback can be used to restore if needed. So the backup teams restored the backups…

Read More
Franck Pachot

What is Object Storage?

By | AWS, Cloud, Oracle | No Comments

By Franck Pachot . I’ve always been working with databases. Before the cloud era, the most abstract term was “data”. A variable in memory is data. A file is data. A block of disk contains data. We often created a ‘/data’ directory to put everything that is not binaries and configuration files. I’ll always remember when I did that while working in Dakar. My colleagues were laughing for minutes – my Senegalese followers will understand…

Read More
Mouhamadou Diaw

Oracle 20c Data Guard : Standardization of Client-Side Broker Files

By | Database Administration & Monitoring, Database management, Oracle | One Comment

In an Oracle 20c Data Guard environment with a broker configured we can have following files called client-side broker files -The observer configuration file : observer.ora -The observer log file -The observer runtime datafile: fsfo.dat -The fast-start failover callout scripts (new feature in Oracle 20c) Before Oracle 20c, there was no default location for these files. Starting with Oracle 20c, now we can define a default location for all these files by setting an environment…

Read More
Franck Pachot

Troubleshooting performance on Autonomous Database

By | Oracle | No Comments

By Franck Pachot . On my Oracle Cloud Free Tier Autonomous Transaction Processing service, a database that can be used for free with no time limit, I have seen this strange activity. As I’m running nothing scheduled, I was surprised by this pattern and looked at it by curiosity. And I got the idea to take some screenshot to show you how I look at those things. The easiest performance tool available in the Autonomous…

Read More
Mouhamadou Diaw

Reimaging an ODA to 19.8 Part II

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

In my previous blog, I described the steps to deploy an ODA 19.8 by reimaging. The ODA was reimaged with the latest available version 19.8 but some components were not up-to-dated. [[email protected] ~]# odacli describe-component System Version ————— 19.8.0.0.0 Component Installed Version Available Version —————————————- ——————– ——————– OAK 19.8.0.0.0 up-to-date GI 19.8.0.0.200714 up-to-date DCSAGENT 19.8.0.0.0 up-to-date ILOM 4.0.4.38.a.r132148 4.0.4.51.r134837 BIOS 52020500 52021300 OS 7.8 up-to-date FIRMWARECONTROLLER VDV1RL02 VDV1RL04 FIRMWAREDISK 1120 1102 HMP The patch was…

Read More