Oracle

How to patch your ODA to 19.21?

Introduction Patch 19.21 is now available for Oracle Database Appliance series. Let’s find out what’s new and how to apply this patch. What’s new? The most important new component is Linux 8. X10 series were already running on Linux 8(…)

What is the fastest method to connect to an Oracle database?

There are still applications around, which do connect to the database, do some stuff and then disconnect again. I.e. for each and every operation a logon to the database is necessary. This produces unnecessary overhead and is expressed in a(…)

dbvisit StandbyMP with OracleSE2 – dbvnet port problem

I’m currently working on a customer project, where we have 2 old Lenovo Servers, one ODA X7-2M and another ODA X8-2M. In the new project, we are replacing the 2 old Lenovo Servers by 2 new ODA X9-2L. The production(…)

dbvisit StandbyMP with Oracle SE2 – switchover error with ORA-27125

After having recently deployed a new customer system running Oracle SE2 databases in Disaster Recovery environment using dbvisit StandbyMP v11.4.1 on Oracle Linux 8.8, I did some final test running a switchover. The switchover failed with following error: ORA-27125: unable(…)

dbvisit StandbyMP with Oracle SE2 – ERROR_CODE:808 Database in unknown mode (94). Setup cannot proceed.

I recently deployed a new installation at one customer with 2 linux servers and 2 Oracle SE2 databases with dbvisit StandbyMP v11 disaster recovery solution. I prepared the standby database using RMAN duplication method, and then just wanted to create(…)

ODA hybrid patching: 19.20/19.19

Introduction Patching your Oracle Database Appliance (ODA) is highly recommended: once a year being the minimum you could do. It prevents security risks, fixes some bugs and eventually provides new features. And it also keeps your appliance supported: according to(…)

Oracle Data Redaction or how to hide critical information

Oracle Data Redaction: What It Is and How to use it. A quick example usage case.

Add Oracle database server to Oracle Key vault (OKV) from scratch, only with RESTfull API.

Configure Oracle Database Server and it's Database with OKV using RESTfull API(…)

Easy PDB migration with ODA and DB Systems

Introduction Oracle 23c is not yet available on Oracle Database Appliance (ODA), but it should be ready in 2024. As 23c is the next Long Term release, 19c databases will probably migrate to 23c in the coming years. If you(…)

Manage SSH public keys with Oracle Key Vault (2/2)

Oracle Key Vault 21.7 introduce the SSH key support, a new type of endpoint(SSH server) and a new wallet type (SSH Wallet).