Originally posted by stecal
select * from v$version;
v$version view doesn't give any specifics on OS. To find what kinda installation you have for oracle, type in at command prompt in $O_H/bin directory

$file oracle
oracle: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, not stripped