Weird Oracle SQL 11 sporadic crash after PVE 6->7 migration

topdiff

New Member
Dec 1, 2022
1
0
1
Hi folks, I've been using proxmox to great satisfaction this last year as my main hypervisor, but I've been having a very weird specific issue with an old Oracle 11g Database inside an Ubuntu 12.04 VM that's part of a legacy system that needs to keep running (It's always those, isn't it?). The VM is a bone stock default VM, default CPU, i440fx machine type, ZFS storage.
Basically, it was hosted on an older PVE 6.x (the final packages for 6) server we're trying to decommission and repurpose, and it all ran fine there for years; however, once migrating to the new shiny new VM host running PVE7, with the same exact configuration - it was copied from the old server, along with the ZFS pool - I'm having the database just crash on me periodically with ORA-600 errors. Luckily the old server hasn't been formatted yet, so I gave it a couple of days to run from there with no issues.
Today, I backupped on the old hypervisor and restored on the new one, thinking maybe it was a problem with the ZFS transfer, but no dice. Instance keeps shutting down periodically.
Last thing I tried was changing machine type to pc-i440fx-6.2 (trying to mimic the older QEMU version in PVE 6.2) but no dice, it's crashed once already. I'm about to try specifying a CPU type for it (possibly Haswell, where it was hosted before?) but other than that I'm out of ideas. Has anyone ever dealt with something like this?
 
Have you tried running your exact ORA-600 error (the additional parameters) through Oracle's ORA-600 tool? It would be interessting to see.

You can also upgrade your never-supported configuration to any Oracle Linux Version from 6 to 8 in order to try to fix it, but I have to say that I've never encountered a Linux or Oracle bug while changing hypervisors and we did this a lot. Yet hey ... Ubuntu crap ... I faced so many errors with Ubuntu in the past that I stopped using it.
 

About

The Proxmox community has been around for many years and offers help and support for Proxmox VE, Proxmox Backup Server, and Proxmox Mail Gateway.
We think our community is one of the best thanks to people like you!

Get your subscription!

The Proxmox team works very hard to make sure you are running the best software and getting stable updates and security enhancements, as well as quick enterprise support. Tens of thousands of happy customers have a Proxmox subscription. Get yours easily in our online shop.

Buy now!