Menu
I am in terminal in Redhat 5.5 and I need to find out which version of Oracle is installed. I am pretty new at Linux, but I have searched Google for a while and I can't find what I need. I have to locate which version is installed via terminal. I found the Oracle files, but I can't seem to find the version.
852
Go to $ORACLE_HOME/oui/bin . Start Oracle Universal Installer. Click Installed Products to display the Inventory dialog box on the Welcome screen. Select an Oracle Database product from the list to check the installed contents.
Description. You can check the Oracle version by running a query from the command prompt. The version information is stored in a table called v$version. In this table you can find the version information for Oracle, PL/SQL, etc.
From the Start menu, select All apps, then Oracle - HOMENAME, then Oracle Installation Products, then Universal Installer. In the Welcome window, click Installed Products to display the Inventory dialog box. To check the installed contents, find the Oracle Database product in the list.
Enter in sqlplus (you'll see the version number)
# su - oracle
oracle# sqlplus
OR
echo $ORAHOME
Will give you the path where Oracle installed and path will include version number.
OR
Connect to Oracle DB and run
select * from v$version where banner like 'oracle%';
As the user running the Oracle Database one can also try $ORACLE_HOME/OPatch/opatch lsinventory which shows the exact version and patches installed.
For example this is a quick oneliner which should only return the version number:
$ORACLE_HOME/OPatch/opatch lsinventory | awk '/^Oracle Database/ {print $NF}'
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
