How to find which version of Oracle is installed on a Linux server (In terminal) [closed] How to find which version of Oracle is installed on a Linux server (In terminal) [closed] linux linux

How to find which version of Oracle is installed on a Linux server (In terminal) [closed]


linux oracle rhel

Enter in sqlplus (you'll see the version number) 

# su - oracleoracle# 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%';

linux oracle rhel

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}'

linux oracle rhel

Login as sys user in sql*plus. Then do this query: 

select * from v$version;

or

select * from product_component_version;

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last