H
Viewing Oracle Application Server Release Numbers

This appendix describes how to view Oracle Application Server release numbers.

It contains the following topics:

• Release Number Format

• Viewing Oracle Application Server Installation Release Numbers

• Viewing Component Release Numbers

• Viewing Oracle Internet Directory Release Numbers

• Viewing Metadata Repository Release Numbers

  Note: Oracle recommends you keep a log of all one-off patches applied to your Oracle Application Server installations.

H.1 Release Number Format

To understand the release level nomenclature used by Oracle, examine the example of an Oracle release number shown in Figure H-1.

Figure H-1 Example of an Oracle Release Number

Text description of the illustration asadm001.gif

Major Oracle Platform Number

This is the most general identifier. It represents a major new edition (or version) of the Oracle database server, Oracle Application Server, or Oracle9iDS, and indicates that the release contains significant new functionality.

Database Maintenance Release Number

This digit represents a maintenance release level. Some new features may also be included.

Application Server Release Number

This digit reflects the release level of Oracle Application Server.

Component Specific Release Number

This digit identifies a release level specific to a component. Different components can have different numbers in this position depending upon, for example, component patch sets or interim releases.

Platform Specific Release Number

This digit identifies a platform specific release.

H.2 Viewing Oracle Application Server Installation Release Numbers

All Oracle Application Server installations have a release number. This number is updated when you apply a patch set release or upgrade the installation.

You can view the release number of an Oracle Application Server installation using Oracle Universal Installer, as follows:

1. Launch Oracle Universal Installer:

   ORACLE_HOME/oui/bin/runInstaller.sh
   
   

2. Click Installed Products to open the Inventory Page.

3. In the Inventory Page, expand Oracle Homes. You will see entries for all installations on your host.

4. Expand the Oracle Home entry for the installation you are interested in.

5. You will see an entry with the release number for your original installation, followed by entries for any patch sets that have been applied.

H.3 Viewing Component Release Numbers

All Oracle Application Server components have a release number and many contain services that have release numbers. These numbers may be updated when you apply a patch set release or upgrade the installation.

You can view the release number of components and their services in the following ways:

• On the Filesystem

• Using Oracle Universal Installer

On the Filesystem

You can view component release numbers as follows:

cd ORACLE_HOME/inventory
ls -d Components*/*/*

Using Oracle Universal Installer

If you installed Oracle Application Server using Oracle Universal Installer, you can view component release numbers as follows:

1. Launch Oracle Universal Installer:

   ORACLE_HOME/oui/bin/runInstaller.sh
   
   

2. Click Installed Products to open the Inventory Page.

3. In the Inventory Page, expand Oracle Homes. You will see entries for all installations on your host.

4. Expand the Oracle Home entry for the installation you are interested in.

5. You will see an entry with the release number for your original installation, followed by entries for any patch sets that have been applied.

6. Expand the initial entry to view the component release numbers at installation time. If you have subsequent patch set entries, expand them to see the component release numbers updated for each patch set.

H.4 Viewing Oracle Internet Directory Release Numbers

Oracle Internet Directory has a server release number, which is the version of the binaries. It also has schema and context versions. All of these numbers correspond to the Oracle Application Server installation release number up through the third digit. These numbers may be updated when you apply a patch set release or upgrade the installation.

Viewing the Oracle Internet Directory Server Release Number

The Oracle Internet Directory server release number is the version of the binaries. You can view the Oracle Internet Directory server release number as follows:

1. Make sure the ORACLE_HOME environment variable is set.

2. Run the following command:

   ORACLE_HOME/bin/oidldapd -version
   

Viewing the Oracle Internet Directory Schema and Context Versions

You can view the Oracle Internet Directory schema and context versions in this file:

ORACLE_HOME/ldap/schema/versions.txt

The contents of this file are kept up-to-date, however, you can also query the schema and context release from Oracle Internet Directory, just to be sure.

To view the schema version:

1. Make sure the ORACLE_HOME environment variable is set.

2. Run the following command:

   ORACLE_HOME/bin/ldapsearch -h oid_host -p oid_port -D "cn=orcladmin" -w 
   orcladmin_password -b "cn=base,cn=oracleschemaversion" -s base 
   "objectclass=*" orclproductversion
   
   

   The output will be in this form:

   cn=BASE,cn=OracleSchemaVersion
   orclproductversion=90400
   
   

To view the context version:

1. Make sure the ORACLE_HOME environment variable is set.

2. Run the following command:

   ORACLE_HOME/bin/ldapsearch -h oid_host -p oid_port -D "cn=orcladmin" -w 
   orcladmin_password -b "cn=oraclecontext" -s base "objectclass=*" orclversion
   
   

   The output will be in this form:

   cn=oraclecontext
   orclversion=90400
   

H.5 Viewing Metadata Repository Release Numbers

Metadata Repositories have the following release numbers:

• Database release number

  This is the Oracle9i database release number.

• Metadata Repository Container release number

  This is the release number for the Metadata Repository--this number is equal to the Oracle Application Server installation release number.

• Schema release numbers

  The Oracle Application Server schemas in the Metadata Repository have release numbers. These numbers do not necessarily correspond to Oracle Application Server release numbers or database release numbers.

Viewing the Database Release Number

The Metadata Repository is an Oracle9i database that has a release number. This number is updated when you apply a patch set release or upgrade the database.

You can view the Metadata Repository release number using SQL*Plus as follows (you can be connected to the database as any user to issue these commands):

SQL> COL PRODUCT FORMAT A35
SQL> COL VERSION FORMAT A15
SQL> COL STATUS FORMAT A15
SQL> SELECT * FROM PRODUCT_COMPONENT_VERSION;

PRODUCT	VERSION	STATUS
-----------------------------------	---------------	----------------
NLSRTL	9.0.1.5.0	Production
Oracle9i Enterprise Edition	9.0.1.5.0	Production
PL/SQL	9.0.1.5.0	Production
TNS for Solaris:	9.0.1.4.0	Production

Viewing Metadata Repository Container and Schema Release Numbers

You can view the Metadata Repository Container release number, as well as schema release numbers, using SQL*Plus as follows (you must log in as a user with SYSDBA privileges):

SQL> COL COMPONENT_NAME FORMAT A35
SQL> COL ID FORMAT A15
SQL> COL VERSION FORMAT A15
SQL> SELECT * FROM IAS_VERSIONS;

COMPONENT_NAME	ID	VERSION
-----------------------------------	---------------	----------------
Metadata Repository Container	mrc	9.0.4.0.0
Oracle Ultrasearch	ultrasearch	9.0.4
Oracl9i Workflow	workflow	2.6.3

IAS_VERSIONS is a public synonym to a view owned by the INTERNET_APPSERVER_REGISTRY user. If the above query returns an error, it may be because:

• There was an error in seeding one or more components

• Not all of the components whose underlying tables are read by the view are present in the database

Either case indicates that the database is not properly seeded to be a Metadata Repository.

To get the same result by querying the underlying table:

SQL> SELECT * FRIM INTERNET_APPSERVER_REGISTRY.SCHEMA_VERSIONS;