| What is the easy way to one can find the Oracle client version on his/her machine [message #202211] |
Wed, 08 November 2006 14:39  |
Dobson1954
Messages: 18
Registered: October 2006
Location: US
|
Junior Member |
|
|
We are going for major upgrades on existing applications in our organization. Most of our applications are oracle client dependent. So we would like to know the oracle versions on user machines. How can end user can easily find out the oralce client version on his/her machine.(Our users are using oracle 6, 7, 8, 8i and 9i clients)
Appreciate your ideas.
Thanks
|
|
|
|
|
|
|
|
| Re: What is the easy way to one can find the Oracle client version on his/her machine [message #202386 is a reply to message #202211] |
Thu, 09 November 2006 07:59  |
Dobson1954
Messages: 18
Registered: October 2006
Location: US
|
Junior Member |
|
|
I am not able to see in Control Panel >> Add/Remove programs. I don't think so Universal installer available with Oracle 6 and 7 versions.
I am looking for the easiest way to user himself can findout the oracle version on his machine.
I am thinking of tnsping utility. If we tnsping the at command prompt it will give the oracle version on user machine. But tnsping utility might have different naming convension in older versions. For example
With oracle 8 --> tnsping80.exe
with oracle 8i --> tnsping.exe
with oracle 9i --> tnsping.exe
Does anybody know exact tnsping utility exe in oracle 6 and 7?
Please let me know if there are any other easiest way user can find oracle version on his/her machine.
Thank you.
|
|
|
|
|
|
|
|
|
|
| Re: What is the easy way to one can find the Oracle client version on his/her machine [message #202984 is a reply to message #202211] |
Mon, 13 November 2006 08:15 |
Dobson1954
Messages: 18
Registered: October 2006
Location: US
|
Junior Member |
|
|
Hi,
Looking into registry (regedit) is not be the right option for end users. Because end users may not have admin rights on their machine, so they could not get into the registry.
SQLPLUS -? and SQLPLUS -v is giving the sqlplus version assosiated with corresponding oracle database, but not the oracle db version. I think with oracle8, sqlplus engine version is 3.1.3.5.1
Is there a way to get the get the document which shows the Oracle db and assosiated utilities versions and release dates?
Thanks.
|
|
|
|
|
|
| Re: What is the easy way to one can find the Oracle client version on his/her machine [message #203257 is a reply to message #202211] |
Tue, 14 November 2006 08:54 |
Dobson1954
Messages: 18
Registered: October 2006
Location: US
|
Junior Member |
|
|
We have lot different applications based on different versions of oracle and some of these applications are legacy applications so won't compatable with 9i and 10g. No body has much idea which users is using which application and we have approximately 4000 users. Atleast this point of time we wanted to collect all the data from the users and also upgrading one of our application. We want to make sure this application won't effect the other applications which users were using.
Thank you.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: What is the easy way to one can find the Oracle client version on his/her machine [message #207697 is a reply to message #207373] |
Wed, 06 December 2006 12:02 |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
It's very common to have multiple Oracle homes on a machine - usually with different versions. Most large organizations can scan the inventory of PC's to form a database of who has what.
The date and filesize of a specific file can usually be correlated back to the version. Our organization defines which binaries form part of the Ora client package, so sqlplus*.exe isn't necesarily there. Once you know what file to look for - you could just do a dir /s filename on each drive.
The oracle home used is often determined by oracle.key in the directory where the executable is run - rather than the order of homes in the path. ODBC connections have more of a dependency on order of the homes in the path from what I recall...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
