System Upgrades


Oracle releases upgrades from time to time, and these always come with extensive instructions. Be aware that although some are easy, some take quite a bit of care. For your own sanity , keep meticulous track of what versions you have on your database. There are compatibility issues among versions and application software, and it is the DBA's responsibility to make sure all the parts fit. Yes, it is also the DBA who sometimes has to push the users and developers to test new releases. It's a tough job.

Caution

If you are using Internet Explorer to download files, be sure to read the note at the end of this chapter. It may save you some grief !


Oracle uses a five-digit numbering schema for its releases, as follows :

graphics/12fig01.gif

Now let's use something you learned about in Chapter 10: the data dictionary. To find the versions of what you have installed, run the data dictionary view PRODUCT_COMPONENT_VERSION, which will give you the following information about your Oracle components :

PRODUCT_COMPONENT_VERSION View

Name

Type

Null?

Product

VARCHAR2(64)

 

Version

VARCHAR2(64)

 

Status

VARCHAR2(64)

 


Guerrilla Oracle
Guerrilla Oracle: The Succinct Windows Perspective
ISBN: 0201750775
EAN: 2147483647
Year: 2003
Pages: 84

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net