如何查找oracle各种文件的版本号

Use the following information for the appropriate file type.

1 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)

2 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)

3 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 Header sqlscript.sql (Ex. grep Header arvsrtds.sql )

4 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)

5 lpc file version
   strings <executable name> | grep <file name> will return the version.

   CMCTCM
     cmlmcm.lpc 115.6.1159.5
     cmlacm.lpc 115.17.1159.10

   CMCMCW
     inltcl.lpc 115.7.11590.2
     inltcp.lpc 115.95.11590.15
     cmlmcw.lpc 115.15.1159.3
     cmlcfm.lpc 115.9.1159.2
     cmlwmx.lpc 115.4.1159.2
     cmlwsv.lpc 115.12.1159.4

   CMCACW
     inltcl.lpc 115.7.11590.2
     inltcp.lpc 115.95.11590.15
     cmlacw.lpc 115.20.1159.7
     cmlcfm.lpc 115.9.1159.2
     cmlwmx.lpc 115.4.1159.2
     cmlwsv.lpc 115.12.1159.4

   CMCLCW
     inltcl.lpc 115.7.11590.2
     cmllcw.lpc 115.28.1159.7
     cmlcfm.lpc 115.9.1159.2
     cmlwmx.lpc 115.4.1159.2
     cmlwsv.lpc 115.12.1159.4

   CMCCCM
     cmcccm.opc 115.6.1159.2

   CMCCCI
     cmlcci.lpc 115.4.1159.4

7 fmx and odf file
adident Header $BOM_TOP/forms/US/BOMFDBOM.fmx
adident Header $BOM_TOP/patch/115/odf/bomstrc.odf

8 Package Version

select text
from dba_source
where name='FND_USER_RESP_GROUPS_API' and line=2;

转载于:https://www.cnblogs.com/songdavid/articles/2510808.html