You can also use the utility to retrieve a full list of patches, with their corresponding IDs, for a given Oracle home. How do I know if Oracle patch is installed? Use the OPatch lsinventory utility to determine the current patch version for any given Oracle home in the system.
Also, just running SQL plus should give you the version. The path will probably contain the version number. How do I find Oracle version in Linux? select * from v$version where banner like ‘oracle%’ Assuming your Oracle user is just ‘oracle’ you can login and check the path based on your ORAHOME variable. In this table you can find the version information for Oracle, PL/SQL, etc. The version information is stored in a table called v$version. How do I check Oracle version? You can check the Oracle version by running a query from the command prompt. How To Check Oracle Version In Toad? You can find the Oracle version by issuing a simple SQL statement.
