Wersja EBS-a jest w tabeli\u00a0FND_PRODUCT_GROUPS<\/p>\n
SELECT g.RELEASE_NAME, g.* FROM APPS.FND_PRODUCT_GROUPS g;<\/pre>\n
\nWeb Server\/Apache or Application Server in Apps 11i\/R12
\nLog in as Application user, set environment variable and run below query $IAS_ORACLE_HOME\/Apache\/Apache\/bin\/httpd -version<\/p>\n
Forms & Report version in R12\/12i
\nLog in as Application user, set environment variable and run below query
\n$ORACLE_HOME\/bin\/rwrun | grep Release<\/p>\n
Oracle Jinitiator in 11i\/R12\/12i
\n Log in as Application user, set environment variable and run below query
\ngrep jinit_ver_comma $CONTEXT_FILE<\/p>\n
(Default is Java Plug-In for R12\/12i )<\/p>\n
Oracle Java Plug-in in 11i\/R12\/12i
\nA. Log in as Application user, set environment variable and run below query
\ngrep plugin $CONTEXT_FILE.<\/p>\n
File Version on file system
\nadident Header
\nor
\nstrings | grep Header
\nHere adident is AD Utility (Oracle Apps) and strings is Unix utility.<\/p>\n
Version of pld file
\n*.pld are source code of *.pll which are inturn source of *.plx. *.pll is in $AU_TOP\/resource and to find its version check
\nadident Header $AU_TOP\/resource\/.pll
\nIGSAU012.pll:
\n$Header IGSAU012.pld 115.1.115100.1 2004\/04\/01 05:40:18 appldev ship $
\nor
\nstrings $AU_TOP\/resource\/.pll | grep -i header
\nFDRCSID(\u2019$Header: IGSAU012.pld 115.1.115100.1 2004\/04\/01 05:40:18 appldev ship $\u2019);<\/p>\n
Workflow Version with Apps
\nselect TEXT Version from WF_RESOURCES where NAME = \u2018WF_VERSION\u2019;<\/p>\n
Identity Management component Version\/Release Number
\nOracle Single Sign On
\nselect version from orasso.wwc_version$;
\nOracle Internet Directory
\nThere are two component in OID (Software\/binaries & Schema\/database)<\/p>\n
To find software\/binary version
\n$ORACLE_HOME\/bin\/oidldapd -version<\/p>\n
To find Schema Version\/ database use
\nldapsearch -h -p -D \u201ccn=orcladmin\u201d -w \u201c\u201d -b \u201c\u201d \\ -s base \u201cobjectclass=*\u201d orcldirectoryversion <\/p>\n
select attrval from ods.ds_attrstore where entryid = 1 and attrname = \u2018orcldirectoryversion\u2019;<\/p>\n
Application Server
\nOracle Application Server 10g Rel 3 (10.1.3.X)
\ncat $ORACLE_HOME\/config\/ias.properties | grep Version
\nVersion=10.1.3.0.0 <\/p>\n
For Oracle Application Server 10.1.2 (Prior to Oracle WebLogic Server)
\nIf application server is registered in database (Portal, Discoverer) check from database
\nselect * from ias_versions;
\nor
\nselect * from INTERNET_APPSERVER_REGISTRY.SCHEMA_VERSIONS;<\/p>\n
AOC4J (Oracle Container for J2EE)
\nSet ORACLE_HOME
\ncd $ORACLE_HOME\/j2ee\/home
\njava -jar oc4j.jar -version <\/p>\n
Oracle Portal
\nselect version from portal.wwc_version$; <\/p>\n
Database Component
\nTo find database version
\nselect * from v$version;
\nor
\nAll component version in database
\n$ORACLE_HOME\/OPatch\/opatch lsinventory -detail<\/p>\n
Unix Operating System
\nSolaris -> cat \/etc\/release
\nRed Hat Linux -> cat \/etc\/redhat-release<\/p>\n","protected":false},"excerpt":{"rendered":"
Wersja EBS-a jest w tabeli\u00a0FND_PRODUCT_GROUPS SELECT g.RELEASE_NAME, g.* FROM APPS.FND_PRODUCT_GROUPS g;<\/p>\n","protected":false},"author":38,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[40,97],"tags":[113],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/737"}],"collection":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/38"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=737"}],"version-history":[{"count":5,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/737\/revisions"}],"predecessor-version":[{"id":1060,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/737\/revisions\/1060"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=737"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=737"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=737"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}