[ Date Index ][
Thread Index ]
[ <= Previous by date /
thread ]
[ Next by date /
thread => ]
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