How to find out which version of Oracle running on Linux? - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

Adamsom · 12-29-2009, 05:44 AM

Hi All,

I want to find out which version of Oracle is running of my ubuntu/RHEL machine using unix command or a piece of Java code..
Does oracle runs jst like other unix cmds in /bin

giteshtrivedi · 01-11-2010, 01:57 PM

Hi,

Go to /etc/oratab file and just check which user is owner of Oracle. Just login as same user (owner of Oracle) and use following command.

$sqlplus /nolog
SQL>connect /as sysdba
connected
SQL>select * from v$version;