How to see if a patch is installed [message #55838] |
Wed, 19 February 2003 08:50 |
Maria
Messages: 57 Registered: August 1999
|
Member |
|
|
Hi there
I have a oracle client, which is not running and I would like to see if a patch is installed, I do know at database level you can do a query select * from v$version, but I can't use sqlplus, is there a qay to see if the load of the client was a patch
Thanks
Maria
|
|
|
Re: How to see if a patch is installed [message #55839 is a reply to message #55838] |
Wed, 19 February 2003 12:53 |
Sanjay
Messages: 236 Registered: July 2000
|
Senior Member |
|
|
Fireup SQLPlus and connect to the database. The first 2 lines after you connect tells the version of the sqlplus client you are using. (And then the other lines tell the version of the DB you are connecting to).
eg.
SQL*Plus: Release 9.2.0.1.0 - Production on Wed Feb 19 14:35:59 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.4.0 - 64bit Production
|
|
|
Re: How to see if a patch is installed [message #55845 is a reply to message #55838] |
Thu, 20 February 2003 00:32 |
Trifon Anguelov
Messages: 514 Registered: June 2002
|
Senior Member |
|
|
You are not telling us what is your OS, so I will give you generic answer.
I doubt any Oracle client can run ever. Only RDBMS can be mounted and open, not the clients. They just connect to the database.
However, every Oracle client was installed and patched with OUI, which keeps its information in its inventory. On UNIX that would be: $ORACLE_BASEoui on Windows: C:Program FilesOracleoui
Look in these directories and you will see for each component the patch and version inofrmation.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|