Determining what patch level is needed

I am using Oracle 8.1.7 on Windows 2000. Oracle recommends that we have the Oracle patch (or hotfix) level up to...

date. How will I find out what patch level (hotfix) I need? For example, from to, I was able to see when connecting to Oracle, but I had to install the latest hotfix for some functions to work from to But after applying the hotfix I could not see the effects. It is still showing In Unix, we have the command called 'which' followed by file name, but in Windows, I do not know what it is. Can you help me find out?

There is no exact what of determining which hotfixes were applied. You can't query a view or anything like that to make an accurate determination. You could issue queries like the following:

ORA9I SQL> select * from v$version;

Oracle9i Enterprise Edition Release -
PL/SQL Release - Production
CORE       Production
TNS for Solaris: Version - Production
NLSRTL Version - Production

ORA9I SQL> select comp_name,version from dba_registry;

COMP_NAME                      VERSION
Oracle9i Catalog Views
Oracle9i Packages and Types
JServer JAVA Virtual Machine
Oracle9i Java Packages
Oracle XDK for Java  
Oracle Workspace Manager

6 rows selected.

However, if your patch or hotfix does not directly touch a particular component, then its version will not get updated. The best way to know for sure is to keep a log of all actions taken on the database. This type of log should be part of the DBA's documentation for all instances.

This was first published in September 2003

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.



Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: