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

linux oracle rhel
PolarisUser picture PolarisUser · Jun 4, 2012 · Viewed 230.2k times · Source

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.

Answer

Rahul picture Rahul · Jun 4, 2012

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%';

Related questions

libaio.so.1: cannot open shared object file

I have a simple test program that when I run I get: ./hello: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory I link it like this: $(CC) $(CCFLAGS) -o hello hello.…

Read More
sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

Please suggest a solution for solving this issue?? While giving the command: sqlplus /nolog the error that occurred: sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

Read More
Logrotate to clean up date stamped files

I'm currently trying to work out a method of tidying up Oracle Recover log files that are created by Cron... Currently, our Oracle standby recover process is invoked by Cron every 15mins using the following command: 0,15,30,45 * * * * /data/tier2/scripts/recover_…

Read More