Home » RDBMS Server » Server Administration » patch question
patch question [message #53832] Mon, 14 October 2002 09:33 Go to next message
tt
Messages: 16
Registered: September 2000
Junior Member
How do you know which patches are installed on an Oracle database? Is there a command to figure that out? Thanks a lot...
Re: patch question [message #53841 is a reply to message #53832] Mon, 14 October 2002 14:56 Go to previous messageGo to next message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
On all platforms you can use the Installer and click on the "Installed Products" button. The list of the products and the current patches is listed there.

If you don't like the GUI, then on UNIX - $ORACLE_BASE/oraInventory/Patches

For Windows - c:program filesoracleinventorypatches

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Re: patch question [message #53865 is a reply to message #53832] Tue, 15 October 2002 09:51 Go to previous messageGo to next message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
SQL> select version from v$instance;

VERSION
-----------------
8.1.7.4.0

1 row selected.
Re: patch question [message #53881 is a reply to message #53865] Tue, 15 October 2002 14:52 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
That show the db instance version only. It doesn't show the binaries (SQL*Plus, RDBMS, SQL*Loader, Export, Import, Net8, etc.) versions.

Also in some patch levels not all the products in the Oracle installation are patched. The most correct one is to look at the Oracle Inventory list.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Previous Topic: End-of-communication ....
Next Topic: Extent rollback segment (ora 1562)
Goto Forum:
  


Current Time: Fri Sep 20 02:23:18 CDT 2024