Category Archives: Oracle

Bug: OLVM 4.3.10 upgrade might paint you into a corner

Oracle Linux VM comes with a nice feature that regularly checks for updates and allows you to deploy them in a rolling fashion to your cluster. Virtual machines are migrated away from one KVM host which is then upgraded and rebooted. Afterwards, the previously migrated machines are moved back to the upgraded host and the procedure runs again for the next host.

Which is nice, as long as everything works out…

Continue reading

Error: OVMAPI[5431] when running ovmd

This is more of a note to myself in case I’ll search the net for this error message again. Interestingly, there was nothing to be found on either MOS or duckduckgo/google/…

After starting ovmd to use its capabilities to transmit the IP addresses to the OVM Manager, I encountered the following errors:

[root@myvm ~]# systemctl status ovmd
● ovmd.service - Oracle VM guest daemon
   Loaded: loaded (/usr/lib/systemd/system/ovmd.service; enabled; vendor preset: enabled)
   Active: active (running) since Tue 2021-01-26 14:22:25 CET; 5min ago
 Main PID: 5431 (ovmd)
   CGroup: /system.slice/ovmd.service
           └─5431 /usr/sbin/ovmd

Jan 26 14:22:23 myvm OVMAPI[5431]: No ovmapi providers found. Aborting

Jan 26 14:22:23 myvm OVMAPI[5431]: OVMAPI_Register (attempt 29) failed with code 1.  VMAPI is not active.
Jan 26 14:22:24 myvm OVMAPI[5431]: No ovmapi providers found. Aborting
Jan 26 14:22:24 myvm OVMAPI[5431]: OVMAPI_Register (attempt 30) failed with code 1.  VMAPI is not active.
Jan 26 14:22:25 myvm OVMAPI[5431]: No ovmapi providers found. Aborting
Jan 26 14:22:25 myvm OVMAPI[5431]: OVMAPI_Register (attempt 31) failed with code 1.  VMAPI is not active.
Jan 26 14:22:25 myvm OVMAPI[5431]: OVMAPI_Subscribe failed with code 1

Cause and solution were pretty simple, though: ovmd needed additional packages to register with ovmapi: xenstoreprovider and python-simplejson.

So, when installing ovmd, try to provide all packages it might need in one go:

[root@myvm ~]# yum install libovmapi xenstoreprovider ovmd python-simplejson

...

Complete!
[root@myvm ~]# systemctl restart ovmd
[root@myvm ~]# systemctl status ovmd
● ovmd.service - Oracle VM guest daemon
   Loaded: loaded (/usr/lib/systemd/system/ovmd.service; enabled; vendor preset: enabled)
   Active: active (running) since Tue 2021-01-26 14:32:06 CET; 3s ago
  Process: 6692 ExecStart=/usr/sbin/ovmd $OVMD_ARGS (code=exited, status=0/SUCCESS)
  Process: 6686 ExecStartPre=/usr/sbin/modprobe ovmapi (code=exited, status=0/SUCCESS)
 Main PID: 6695 (ovmd)
   CGroup: /system.slice/ovmd.service
           └─6695 /usr/sbin/ovmd

Jan 26 14:32:05 myvm systemd[1]: Stopping Oracle VM guest daemon...
Jan 26 14:32:05 myvm systemd[1]: Starting Oracle VM guest daemon...
Jan 26 14:32:06 myvm systemd[1]: Started Oracle VM guest daemon.
Jan 26 14:32:06 myvm ovmd[6695]: main: Successfully registered session with VMAPI
Jan 26 14:32:06 myvm ovmd[6695]: main: Writing pid-file /var/run/ovmd.pid

DBMS_SCHEDULER Jobs not running on 12.2 (Windows)

4605619232_03d6aa0776

Source: canned muffins. CC-BY-2.0

Just a short heads-up for those who might run into similar issues and having a hard time finding the root cause:

I just ran into a bug on a Windows 12.2.0.1 DB with the 190416 Bundle Patch: A newly scheduled job just wouldn’t run, and a query on DBA_SCHEDULER_JOBS revealed that other jobs (even Oracle’s own jobs) had not run in a while.

Continue reading