How To Find Oracle Application File Versions [ID 125922.1]

How To Find Oracle Application File Versions [ID 125922.1]
	Modified 17-NOV-2010 Type HOWTO Status ARCHIVED

· goal: How to find Oracle Application file versions

· fact: Oracle Applications

fix:

Use the following information for the appropriate file type.

FORM

1. Use \Help Version

2. Or Help, About Oracle Applications (when using 10SC)

3. adident (Ex. adident Header ARXTWINS.fmx)

4. strings -a form.frm | grep Revision (Ex. strings -a POXPOMPO.frm |

grep Revision)

REPORT

cd $AR_TOP/reports

1. adident Header report.rdf (Ex. adident Header ARBARL.rdf)

2. strings -a report.rdf | grep Header (Ex. strings -a ARBARL.rdf |

grep Header)

SQL

1. more sqlscript.sql (Ex. more arvstrd.sql)

The version will be in a line that starts with �REM $Header�, and

should be one of the

first lines in the .sql file.

2. grep �$Head� sqlscript.sql (Ex. grep �$Head� arvsrtds.sql )

BIN or EXECUTABLE

An executable in the bin directory will contain numerous C code modules,

each with its own version. All of the following examples use ident or strings,

but

the difference is what you grep for.

1. Get ALL file versions contained in the executable.

adident Header executable (Ex. adident Header RACUST)

strings -a executable | grep Header (Ex. strings -a RACUST |

grep Header)

2. Get ALL of the product specific file versions.

adident Header executable (Ex. adident Header RACUST)

strings -a executable | grep Header

(Ex. strings -a RACUST | grep Header)

3. Get only the version of a specified module.

strings -a executable | grep module (Ex. strings -a RAXTRX |

grep raaurt)

4. A Collection of class file versions

from the directory where the classfile exists in a command prompt run the following:

strings -a Classname.class | grep Header

ORACLE REPORTS

To find the version of Oracle Reports the customer is using:

1. From the operating system type �r20run�, �r25run�, or �r30run� (etc),

depending on Reports version: (find this executable in their $ORACLE_HOME/bin

directory). Then use the

menu patch Help, About Oracle Reports.

RDBMS

1. Use \Help Version

2. Or Help, About Oracle Applications (when using 10SC)

3. Get into SQL*Plus using any userid/password. You will get a string that

gives you the database and PL/SQL version being used.

C. Finding Version Numbers (VMS)

Finding versions on a VMS system is not quite as clean. Use the following

format for finding the version on any file.

FORMAT:

search/format=nonulls/highlight=reverse file

string_you_are_looking_for

or

search/format=nonulls/highlight=blink file string_you_are_looking_for

EXAMPLE:

search/format=nonulls/highlight=reverse RAXSKI.RDF $Header

This will give you quite a few lines of output, but the $Header string will

be in a black box. If you use highlight=blink, then it will blink.

SENDING OUTPUT TO A FILE:

search/format=nonulls/highlight=reverse/output=file.lis file string

Example

search/format=nonulls/highlight=reverse/output=output.lis RAXSKI.RDF $

Header

2. Get ALL of the product specific file versions.

strings -a executable | grep �Header: product_short_name�

3. Get only the version of a specified module.

strings -a executable | grep module

ORACLE REPORTS

From the form, select Help, About Oracle Reports.

RDBMS

1. Use \Help Version

2. Or Help, About Oracle Applications

3. Get into SQL*Plus using any userid/password. You will get a string that

tells you the PL/SQL version and data