Monday, September 23, 2024

SQL*Plus Stopped Working in Ubuntu 24 (Noble Numbat)

After the upgrade to Ubuntu 24 (Noble Numbat), Oracle's SQL*Plus stopped working and started throwing this error:

sqlplus: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

Many thanks to https://askubuntu.com/users/367548/user3032965 for solving this problem in the comment at https://askubuntu.com/a/1526423.  For ubuntu 24.04 and later, the name for libaio1 has changed!  The solution is to create a symbolic link from the new name to the old name:

sudo ln -s /usr/lib/x86_64-linux-gnu/libaio.so.1t64 /usr/lib/libaio.so.1

In my situation, "libaio1t64" was already installed.  SQL*Plus started working again after I created the symbolic link.

No comments:

Post a Comment