Re: Retrieve Oracle Version

Depending on your setup, you could rsh as Oracle around all of your servers and run something like the following:

export ORACLE_SID=<dbname>
sqlplus /nolog
connect / as sysdba;
select * from v$version;
exit;

No passwords required :) Received on Mon Jun 13 2005 - 04:51:10 CDT