asked on

how to check the version of the oracle client

Hi..

a very basic question..

Can you tell which command or method to use to find the oracle client version install on a client machine. the database server is a dedicated machine.

Regards

Tony Giangreco

There should be an Oracle client icon on the lower right corner of the screen. Right click it and select About or other selection on it. It should provide the version number.

If that cannpt be found, gop to Start, All programs, Oracle and there should be a selection that allows you to find the same info.

Also, go to Add/Remove programs on XP or Programs and Features on Win7. Scrool down to Oracle and the version will be listed on the right side.

AmmarDJ

ASKER

do you know of any command?

Tony Giangreco

Start > Run > regedit > HKLM > Software > Oracle
Check the Inst_loc entry value which will be the software installed location.

ASKER CERTIFIED SOLUTION

Guy Hengel [angelIII / a3]

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

awking00

Are you just looking for select * from v$version?

Naveen Kumar

Oracle client version will also be shown when you log into database with your sql*plus client.

if you need the oracle database version, then you can check V$version view after logging into the database.. this is just one way and there are other ways as well to find the same.

Franck Pachot

Hi, you can find the client version with

genezi -v

Open in new window

(in ORACLE_HOME/bin) even if you don't have sqlplus installed.
Regards,
Franck.