查找EBS各模块组件version
来源:互联网 发布:迅雷看看 mac 编辑:程序博客网 时间:2024/05/29 14:59
How to Find version
1. How to find Apps Version (11i/R12/12i)
>> Connect to database as user apps
SQL> select release_name from apps.fnd_product_groups;
Output would be like 12.0.4 or 11.5.10.2
2. Web Server/Apache or Application Server in Apps 11i/R12
>> Log in as Application user, set environment variable and run below:
$IAS_ORACLE_HOME/Apache/Apache/bin/httpd –version
Output for 11i should be like :
Server version: Oracle HTTP Server Powered by Apache/1.3.19 (Unix)
Server built: Jan 26 2005 11:06:44 (iAS 1.0.2.2.2 rollup 5)
Output for R12 should be like :
Server version: Oracle-Application-Server-10g/10.1.3.0.0Oracle-HTTP-Server
Server built: Dec 4 2006 14:44:38
3. Forms & Report version (aka developer 6i) in 11i
>> Log in as Application user, set environment variable and run below query:
$ORACLE_HOME/bin/f60run | grep Version | grep Forms
Output would be like :
Forms 6.0 (Forms Runtime) Version 6.0.8.25.2 (Production)
Check fourth character in version 25 which means Forms 6i patchset 16 (25-9)
4. Forms & Report version in R12/12i
>> Log in as Application user, set environment variable and run below query:
$ORACLE_HOME/bin/rwrun | grep Release
Output should be like:
Report Builder: Release 10.1.2.2.0
You can safely ignore warnings
5. Oracle Jinitiator in 11i/R12/12i
>> Log in as Application user, set environment variable and run below query:
grep jinit_ver_comma $CONTEXT_FILE
(Default is Java Plug-In for R12/12i )
6. Oracle Java Plug-in in 11i/R12/12i
>>Log in as Application user, set environment variable and run below query:
grep plugin $CONTEXT_FILE
7. File Version on file system
>>adident Header <filename>
Or
strings <file_name> | grep Header
Here adident is AD Utility (Oracle Apps) and strings is Unix utility
8. Version of pld file
>> *.pld are source code of *.pll which are inturn source of *.plx. *.pll is in $AU_TOP/resource and to find its version check
adident Header $AU_TOP/resource/<filename>.pll
IGSAU012.pll:
$Header IGSAU012.pld 115.1.115100.1 2004/04/01 05:40:18 appldev ship $
Or
strings $AU_TOP/resource/<filename>.pll | grep -i header
FDRCSID(’$Header: IGSAU012.pld 115.1.115100.1 2004/04/01 05:40:18 appldev ship $’);
9. OA Framework Version
>> http:// hostname.domainName:port/OA_HTML/OAInfo.jsp (Only for 11i); Log in as Application user, set environment variable and run below query:
adident Header $FND_TOP/html/OA.jsp
adident Header $OA_HTML/OA.jsp
output for both should look like
$Header OA.jsp 115.60 2006/03/31 00:47:28 atgops1 noship $
120.21 means OA Framework Version (coming soon..)
115.60 means OA Framework Version (coming soon..)
115.56 means OA Framework Version (coming soon..)
115.36 means OA Framework Version 5.7
115.27 means OA Framework Version 5.6E
115.26 means OA Framework Version 5.5.2E
10. Discoverer Version for 11i (3i or 4i)
>> Log in as Application user, set environment variable and run below query:
$ORACLE_HOME/bin/disc4ws | grep -i Version
Discoverer Version for 11i or R12 (10g AS) >> Check under Application Server Section as 10g AS Discoverer is on standalone.
11. Workflow Version with Apps
>> Connect to Database as apps user
SQL> select TEXT Version from WF_RESOURCES where NAME = ‘WF_VERSION’;
Output like 2.6.0 means workflow version 2.6.0
12. Oracle Single Sign On
>> Connect to database which holds SSO repository:
SQL>select version from orasso.wwc_version$;
13. Oracle Internet Directory
>> There are two components in OID (Software/binaries & Schema/database)
>>> To find software/binary version
$ORACLE_HOME/bin/oidldapd –version
output should look like
oidldapd: Release 10.1.4.0.1 - Production on thu sep 11 11:08:12 2008
Copyright (c) 1982, 2006 Oracle. All rights reserved.
>>> To find Schema Version/ database use
ldapsearch -h <hostname> -p <port> -D “cn=orcladmin” -w “<password>” -b “” \
-s base “objectclass=*” orcldirectoryversion
and output should be like
version: 1
dn:
orcldirectoryversion: OID 10.1.4.0.1
or
Run following query in database
SQL> select attrval from ods.ds_attrstore where entryid = 1 and attrname = ‘orcldirectoryversion’;
Output should be like OID 10.1.4.0.1
14. Application Server
>> Oracle Application Server (Prior to Oracle WebLogic Server)
If application server is registered in database (Portal, Discoverer) check from database:
SQL> select * from ias_versions;
Or
SQL>select * from INTERNET_APPSERVER_REGISTRY.SCHEMA_VERSIONS;
AOC4J (Oracle Container for J2EE)
Set ORACLE_HOME
cd $ORACLE_HOME/j2ee/home
java -jar oc4j.jar -version
15. Oracle Portal
>> SQL> select version from portal.wwc_version$;
16. Database Component
I) Oracle Database
To find database version:
SQL> select * from v$version;
Or
All component version in database:
$ORACLE_HOME/OPatch/opatch lsinventory -detail
17. Oracle Enterprise Manager
>> Metalink Note 605398.1: How to find the version of the main EM components
18. Unix Operating System
Solaris -> cat /etc/release
Red Hat Linux -> cat /etc/redhat-release
- 查找EBS各模块组件version
- ebs version upgrade note
- ebs各模块名称及英文缩写
- [ORACLE EBS]1. Get the EBS version
- 如何增加EBS模块?
- oracle ebs模块名称
- EBS应收模块表
- EBS启用configurator模块
- Oracle EBS 各模块中文名称及英文缩写
- ORACLE EBS各模块中文名称及英文缩写对照
- EBS R12 AR模块设置
- EBS财务模块表结构
- EBS查找功能所在的菜单sql
- Oracle EBS环境下查找数据源
- Oracle EBS开发查找数据源(续)
- 查询EBS安装产品组件及版本
- EBS 各模块数据传送至总帐 需要运行的请求
- EBS 各模块数据传送至总帐 需要运行的请求
- 线程属性(2)
- Stack基础知识1
- hdu_2602
- linux的时间与时钟中断处理
- yii框架学习(一)
- 查找EBS各模块组件version
- Android + NDK + cygwin 编程
- resolv.conf文件配置相关的案例
- WPF下TextBox允许多行文本的设置
- python 新手入门+概括
- 求取点云法向量
- 如何提高上百万条的数据库查询速度
- Linux服务器中部署配置apache,tomcat,jdk,mysql
- poj 2352 Stars