Patching Oracle databases with Nutanix NDB
Blog dbi services » Oracle
by Marc Wagner
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
Visit website
Migration from Non-CDB to Multitenant : CDB is using local undo, but no undo tablespace found in the PDB
Blog dbi services » Oracle
by Marc Wagner
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
Visit website
Migration from Non-CDB to Multitenant : Wallet Key Needed
Blog dbi services » Oracle
by Marc Wagner
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
Visit website
Physical Online Migration to ExaCC with Oracle Zero Downtime Migration (ZDM)
Blog dbi services » Oracle
by Marc Wagner
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
Visit website
Logical Offline Migration to ExaCC with Oracle Zero Downtime Migration (ZDM)
Blog dbi services » Oracle
by Marc Wagner
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
Visit website
Oracle ZDM Migration – java.security.InvalidKeyException: invalid key format
Blog dbi services » Oracle
by Marc Wagner
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
Visit website
How to create a Backup Report in EM Cloud Control 13c
Blog dbi services » Oracle
by Frank Bléger
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
Visit website
How to patch your ODA to 19.21?
Blog dbi services » Oracle
by Jérôme Dubar
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
Visit website
What is the fastest method to connect to an Oracle database?
Blog dbi services » Oracle
by Clemens Bleile
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
Visit website
Dbvisit StandbyMP with OracleSE2 – dbvnet port problem
Blog dbi services » Oracle
by Marc Wagner
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
Visit website

Follow Blog dbi services » Oracle on FeedSpot

Continue with Google
Continue with Apple
OR