How to find out which Oracle version is installed on Unix

There are actually a couple of ways to do this. For versions prior to
8i, there’s a utility in the $ORACLE_HOME/orainst called ‘inspdver’.
This will list each product and version on your server. You can also
inspect the file $ORACLE_HOME/orainst/unix.rgs.

With Oracle 8i, you can run the Oracle Universal Installer, then click
Installed Products at the beginning.

Another way is to run the following SQL:

SELECT * FROM PRODUCT_COMPONENT_VERSION ;