How to find which version of Oracle is installed on a Linux server

Hi,

There are several ways to find which version of Oracle is installed on a Linux server.
And, one of the easiest method is as follows:-

1. Connect to the Oracle DB via Oracle SQL developer

2. Open SQL Worksheet against any of the schema

3. Type the below query:

select * from v$version where banner like 'Oracle %';

The response will be something like below:-

4. From the above result, you can see that the DB version is 11.2.0.4.0

5. Done!!