D&C Lug - Home Page
Devon & Cornwall Linux Users' Group

[ Date Index ][ Thread Index ]
[ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] Query version of Oracle



Hatton, Peter wrote:
The easiest way to find out the version of oracle running is to start
 SQL Plus from the Oracle tools, and enter the username, password and
 the hoststring. (If they are available to you)  The command line 
program is sqlplus, but it's been a while since I've done oracle on a
 unix/linux box.

Normally, SQL plus reports the version it's running, but if it 
doesn't type this command into SQL plus.

select * from v$version where banner like 'Oracle%';

Oracle's own start-up scripts (dbstart?) use to grep the version string
out of the start up
of one of the standard commands - plsql probably. So you probably don't
need to go that far.

I remember this as whichever tool it was wasn't part of the minimal
install on HP-UX which led to me having to fix the start-up scripts so
they could figure out what version they were -
sigh - all that money and it doesn't even install properly.

Similiarly it logs the version, and SGA parameters on start-up, to it's
log file.

Why do you need to know Alex? As Oracle can emulate earlier versions of
itself - based on config - so it isn't always a straight forward
question. Similarly I've had boxes with multiple versions of Oracle
running at different releases (don't go there except for weird upgrade
paths).

Attachment: pgp00079.pgp
Description: PGP signature


Lynx friendly