Blog dbi services » Oracle
1,316 FOLLOWERS
The dbi services blog represents the point of view of our consultants regarding various IT technologies mainly Oracle.
Blog dbi services » Oracle
1w ago
A few years back I had the great opportunity to test Nutanix NDB, at that time called Nutanix Era, and I had written a few blogs about provisioning Oracle databases, taking snapshot, log catchup, cloning a database, restoring a database, aso… and see interaction with Oracle Database itself. But I was not able, at that time, to test the patching of Oracle databases. I recently had the chance to get a new environment and I finally had the opportunity to test the patching of Oracle databases. I would like to share with you my experience and show you how easy the patching is with Nutanix NDB. You ..read more
Blog dbi services » Oracle
3w ago
During a past migration test from on-premises to ExaCC, I faced a pdb violation, stating, CDB is using local undo, but no undo tablespace found in the PDB, after having run noncdb_to_pdb.sql script.
Read more: Migration from Non-CDB to Multitenant : CDB is using local undo, but no undo tablespace found in the PDB Explanation
The problem comes from the fact that the non-cdb source is a single instance Database (cluster_database=false), which is converted to a PDB hosted in a RAC CDB, therefore having 2 instances for the PDB, but there is only one UNDO tablespace. Please see below how to quickly ..read more
Blog dbi services » Oracle
3w ago
I have been recently able to make several migration tests from On-Premises to Exadata, and during some of my tests I faced a PDB_PLUG_IN_VIOLATIONS with cause been “Wallet Key Needed” when converting a migrated Non-CDB to PDB.
Read more: Migration from Non-CDB to Multitenant : Wallet Key Needed Explanation
This violation comes from the fact that the source Non-CDB database migrated on the Exadata from On-Premises was encrypted. The message is clear, the source wallet needs to be exported and imported in the new PDB after having run noncdb_to_pdb.sql script.
SQL> select name, cause, type, m ..read more
Blog dbi services » Oracle
1M ago
A while ago I had been testing and blogging about ZDM, see my previous articles. And I finally had the chance to implement it at one of our customer to migrate on-premises database to Exadata Cloud @Customer. After having been implementing Logical Offline migration with ZDM, see my previous article, https://www.dbi-services.com/blog/logical-offline-migration-to-exacc-with-oracle-zero-downtime-migration-zdm/, I had the opportunity to implement a Physical Online Migration and testing it with one database taken as pilot. In this article I would like to share with you my experience I could get fro ..read more
Blog dbi services » Oracle
1M ago
A while ago I had been testing and blogging about ZDM, see my previous articles. And I finally had the chance to implement it at one of our customer to migrate on-premises database to Exadata Cloud @Customer. In this article I would like to share with you my experience migrating an on-premises database to ExaCC using ZDM Logical Offline Migration with a backup location. We intended to use this method, as mandatory one for small Oracle SE2 databases, and preferred one for huge Oracle SE2 databases.
Read more: Logical Offline Migration to ExaCC with Oracle Zero Downtime Migration (ZDM) Naming co ..read more
Blog dbi services » Oracle
1M ago
ZDM tool migration requires SSH Passwordless Login without passphrase between ZDM Host, the source and the target. Configuring appropriate keys might still result in a java security exception on this one. In this blog I will tell you how to deal with such a problem. I faced this problem implementing ZDM to migrate On-Premise Database to new ExaCC at one of our customer.
Read more: Oracle ZDM Migration – java.security.InvalidKeyException: invalid key format Setting up SSH Passwordless Login
First of all we need to create the private and public key on the ZDM Host.
From the ZDM host, with zdmuse ..read more
Blog dbi services » Oracle
2M ago
Wanted to make sure your Oracle databases were secured and be informed in case of backup problems?
This blog describes how to quickly get a report sent out on a daily-basis and make it work in Enterprise Manager 13cR5.
1st Activate gathering of additional metrics
We first need to activate the automatic gathering of additional metrics.
From Targets -> Databases -> Click on the target database
On the database home page “Cluster Database” drop down menu, navigate to Monitoring > Metrics and Collection Settings:
Click on the ‘Other Collected Items’ tab:
Scroll down and search for ‘High ..read more
Blog dbi services » Oracle
2M ago
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 with a dedicated patch (19.20.0.1), but older ODAs were stuck with Linux 7 since years.
This version also brings latest 19c RU to database and grid homes (bug and security fixes). 23c is not yet available on ODA and 21.8 is proposed as DB System only. Note that 21c being an innovation release, its main purpose if for testing some 23c features.
Nothing really new ..read more
Blog dbi services » Oracle
2M ago
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 high percentage of DB time taken by “connection management call elapsed time” in the Oracle time model. In case the application cannot be changed and a lot of connections are happening per second, then the question is on what is the fastest method to connect to an Oracle database?
I do want to compare 3 different methods on how connects to the DB are handle ..read more
Blog dbi services » Oracle
3M ago
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 database, let’s call it DB01, is a Standard Edition database with dbvisit Standby as Disaster Recovery solution. During each project, we take the opportunity to upgrade dbvisit Stanby software to last available version. In 2022, I then upgraded dbvisit from v8 to v10, and recently to v11.
dbvisit Standby upgrade to v10
In 2022, when upgrading dbvisit Standby from v8 to v10, I faced ..read more