Infrastructure at your Service

Category

Oracle

Mouhamadou Diaw

Dbvisit 9: Adding datafiles and or tempfiles

By | Database Administration & Monitoring, Oracle | No Comments

One question I was asking is if the standby_file_management parameter is relevant in a Dbvisit environment with Oracle Standard Edition. I did some tests and I show here what I did. We suppose that the Dbvisit is already set and that the replication is fine [[email protected] trace]$ /u01/app/dbvisit/standby/dbvctl -d dbstd -i ============================================================= Dbvisit Standby Database Technology (9.0.08_0_g99a272b) (pid 19567) dbvctl started on dbvisit1: Fri Jan 17 16:48:16 2020 ============================================================= Dbvisit Standby log gap report for…

Read More
Mouhamadou Diaw

Dbvisit Standby 9 : Do you know the new snapshot feature?

By | Database Administration & Monitoring, Oracle | No Comments

Dbvisit snapshot option is a new feature available starting from version 9.0.06. I have tested this option and in this blog I am describing the tasks I have done. The configuration I am using is following dbvist1 : primary server dbvist 2 : standby server orcl : oracle 19c database We suppose that the dbvisit environment is already set and the replication is going fine. See previous blog for setting up dbvisit standby First there…

Read More
Jérôme Dubar

Focus on 19c NOW!

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

Introduction For years, Oracle used the same mechanism for database versioning. A major version, represented by the first number. And then a release number, 1 for the very first edition, and a mature and reliable release 2 for production databases. Both of them having patchsets (the last number) and regular patchset updates (the date optionally displayed at the end) to remove bugs and to increase security. Jumping from release 1 to release 2 required a…

Read More
Mehdi Bada

First day at DOAG 2019 Conference

By | Database Administration & Monitoring, Oracle | No Comments

This year I have the opportunity to take place at one of the most popular Oracle conferences, the DOAG. In the meantime, I have the chance to give a talk on Thursday about Docker containers. Yes! Because at DOAG we are not only speaking about Oracle products. I’m really impressed by the quality of the presentations. I followed 4 presentations, on different subjects/technologies and the quality of them was very good. David Hueber, OCI vs…

Read More
Jérôme Dubar

A day of conferences with the Swiss Oracle User Group

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

Introduction I’m not that excited with all these events arround Oracle technologies (and beyond) but it’s always a good place to learn new things, and maybe the most important, discover new ways of thinking. And regarding this point, I was not disappointed. Franck Pachot: serverless and distributed database Franck talked about scaling out, it means avoid monoliths. Most of the database servers are this kind of monoliths today. And he advises us to think microservices….

Read More
Jérôme Dubar

odacli create-database error DCS-10802: Insufficient disk space on file system: database

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

Introduction I was reimaging an X6-2M ODA after various patching troubles, and everything was fine. After several databases created, the next ones could no more be created. DCS-10802: Insufficient disk space on file system: database. Expected free space (MB): {1}, available space (MB): {2} I’ve spent some time on it, and finally found the cause of the problem. And the solution. Context After successfully reimaged an X6-2M ODA with 18.5, and applied the patch for…

Read More
Clemens Bleile

Creating archived redolog-files in group dba instead of oinstall

By | Database management, Oracle | No Comments

Since Oracle 11g files created by the database belong by default to the Linux group oinstall. Changing the default group after creating the central inventory is difficult. In this Blog I want to show how locally created archived redo can be in group dba instead of oinstall. One of my customers had the requirement to provide read-access on archived redo to an application for logmining. To ensure the application can access the archived redo, we…

Read More
Mouhamadou Diaw

Oracle 19c : Point-In-Time Recovery in a PDB

By | Database Administration & Monitoring, Oracle | 2 Comments

Point-In-Time Recovery is also possible in a multitenant environment. As in Non-CDB, a recovery catalog can be used or not. In this blog we will see how to recover a dropped tablespace in a PDB. We will also see the importance of using a recovery catalog or not. A PITR of a PDB does not affect remaining PBDs. That means that while doing a PITR in PDB, people can use the other PDBs. In this…

Read More
Jérôme Dubar

ODA X8-2: the new generation

By | Database Administration & Monitoring, Hardware & Storage, Oracle | 2 Comments

Introduction ODA X7-2 marked the maturity of the Oracle Database Appliance evolution, with 3 models suitable for nearly all customers using Oracle databases. The X7-2M was my favorite, with a lots of cores available (and restrainable), enough memory for dozens of databases, and strong storage performance and capacity (with a maximum of 50TB RAW NVMe). And taking up only 1U of space in your rack. Today, 2 years later, Oracle just introduced the new generation…

Read More