如何查找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;