`

查看ebs的各个组件的版本

阅读更多
How to find the OAF related application version;

http[s]://<host>:<port>/OA_HTML/OAInfo.jsp


How to find the file version of *.java and *.class

for FILE in `find . -name '*.class' -print`
do
echo $FILE
strings -a $FILE | grep -i header: | cut -c1-78
done > $HOME/javaver.txt






Below you will find commonly asked questions about various component Version in Oracle Applications & way to find them which might be helpful in Apps DBA Job. Most of these are for Unix / Linux.

Q: How to find Oracle Applications Web Server Version ?
Q: How to find Version of Apache used with oracle apps 11i ?

Log to Application tier as Operating System Usually called as APPLMGR ; go to location $IAS_ORACLE_HOME/Apache/Apache/bin and run command
./httpd -version
You will see output like

Server version: Oracle HTTP Server Powered by Apache/1.3.19 (Unix)
Server built: Dec 6 2005 14:59:13 (iAS 1.0.2.2.2 rollup 5)
Which means you are on iAS Version 1.0.2.2.2 with patchset rollup 5 with Apache Version 1.3.19


Server version: Oracle-Application-Server-10g/10.1.2.0.2 Oracle-HTTP-Server

Above is output If you have installed 10g Application Server with 11i

Q: How to find Jinitiator Version ?

Check for file like appsweb_SID_HOSTNAME.cfg under $OA_HTML/bin defined by environment variable FORMS60_WEB_CONFIG_FILE & search for entry like jinit_ver_name , you will see entry like
jinit_ver_name=Version=1,3,1,23
which means Jinitiator version is 1.3.1.23 ; if your version is 1.3.1.18 you will see entry like 1,3,1,18

Q: How to find Forms Version in 11i ?
Login to forms from frontend , on top menu bar of forms click on "Help" & Select "About Oracle Applications" go to "Forms Server " section. You should see entry like below depending on your forms version
Oracle Forms Version : 6.0.8.26.0
Which mean you are on forms version 6.0.8.26 . If you want to know whats your forms patchset level then subtract 9 from fourth digit which means for above case form patchset 17 is applied.

Q: How to find Forms Version in Apps from command Line ?
Enter "f60gen" on Forms Server and check for first line in output like
Forms 6.0 (Form Compiler) Version 6.0.8.26.0 (Production)
This confirms that you are on forms server version 6.0.8.26.0 and patch set 17. ( Patch Set = Fourth Digit - 9)

Q: How to find Version of any file in Oracle Apps 11i ? or
Q: How to find any Reports Version 11i ? or

In Oracle Applications under ad utilities there is utility called as adident Used for Identification purpose or to find out file version use
adident Header <filename>
for ex. inorder to to find file version of one AR form i.e. ARXGLCOR.fmx
adident Header ARXGLCOR.fmx
You should see output like
$Header APPSTAND.fmb 115.33 2002/04/04 11:13:40 pkm ship
$ $Header ARXGLCOR.fmb 115.15 2005/01/31 13:48 mraymond ship
Which means above form executable consist of two forms whose version is 115.33 & 115.15 resp. Similarly you can use adident to find version of any report in 11i.

Q: How to find Operation System Version (Unix/Linux) ?

For solaris use command
uname -a
You will see output like
For Solaris SunOS servername 5.8 Generic_117350-23 sun4u sparc SUNW,Sun-Fire-V240
For RedHat Linux use command
cat /etc/*release*
You will see output like
Red Hat Enterprise Linux AS release 3 (Taroon Update 6)

Which means you are on Solaris 5.8 or Linux AS 3 resp.
Q: How to find if your Operating System is 32 bit or 64 Bit ?

For solaris use command
isainfo -v
If you see out put like
32-bit sparc applications
That means your O.S. is only 32 bit but if you see output like

Q: How to find Operating System version ?

For solaris use command
uname -a
You will see output like
For Solaris SunOS servername 5.8 Generic_117350-23 sun4u sparc SUNW,Sun-Fire-V240
For RedHat Linux use command
cat /etc/*release*
You will see output like
Red Hat Enterprise Linux AS release 3 (Taroon Update 6)

Which means you are on Solaris 5.8 or Linux AS 3 resp.
Q: How to find if your Operating System is 32 bit or 64 Bit ?

For solaris use command
isainfo -v
If you see out put like
32-bit sparc applications
That means your O.S. is only 32 bit but if you see output like


64-bit sparcv9 applications
32-bit sparc applications
above means your o.s. is 64 bit & can support both 32 & 64 bit applications


Q: Can I run 64 bit application on 32 bit Operating system ?

You can run 32 bit application (like oracle application server, web server, all oracle application server are 32 bit ) on both 32 /64 bit operating system but a 64 bit application like 64 bit database can run only on 64 bit operating system.

Q How to find if your database is 32 bit or 64 bit(Useful in applying Patches) ?


execute "file $ORACLE_HOME/bin/oracle" , you should see output like
/u01/db/bin/oracle: ELF 64-bit MSB executable SPARCV9 Version 1
which means you are on 64 bit oracle
If your oracle is 32 bit you should see output like
oracle: ELF 32-bit MSB executable SPARC Version 1
Now you know what should be bit of patch to download

Q: How to find OUI version ?


OUI stands for Oracle Universal Installer. In order to find Installer version you have to execute ./runInstaller -help ( From OUI location)
You will get output like
Oracle Universal Installer, Version 10.1.0.4.0 Production Copyright (C) 1999, 2005, Oracle. All rights reserved.
That means OUI version in above case is 10.1.0.4
OUI location is $ORACLE_HOME/oui/bin

Q: How to find Database version ?


SQL> select * from v$version;
The command returns the release information, such as the following:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
PL/SQL Release 9.2.0.7.0 - Production
CORE 9.2.0.7.0 Production
TNS for 32-bit Windows: Version 9.2.0.7.0 - Production
NLSRTL Version 9.2.0.7.0 - Production

Q: How to find Oracle Workflow Cartridge Release Version ?

Log in to the database as the owf_mgr user and issue
select wf_core.translate('WF_VERSION') from dual;


Q: How to find opatch Version ?

opatch is utility to apply database patch , In order to find opatch version execute
"$ORACLE_HOME/OPatch/opatch version"
You should see output like OPatch Version: 1.0.0.0.52 which means your opatch version is 1.0.0.0.52

64-bit sparcv9 applications
32-bit sparc applications
above means your o.s. is 64 bit & can support both 32 & 64 bit applications

Q. How to find Version of Apps 11i ?
Run following SQL from apps user ;
SQL> select RELEASE_NAME from fnd_product_groups;
You should see output like
RELEASE_NAME
-----------------------
11.5.10.2
Which means you are on Apps Version 11.5.10.2
Q: Can I run 64 bit application on 32 bit Operating system ?

You can run 32 bit application (like oracle application server, web server, all oracle application server are 32 bit ) on both 32 /64 bit operating system but a 64 bit application like 64 bit database can run only on 64 bit operating system.

Q How to find if your database is 32 bit or 64 bit(Useful in applying Patches) ?

execute "file $ORACLE_HOME/bin/oracle" , you should see output like
/u01/db/bin/oracle: ELF 64-bit MSB executable SPARCV9 Version 1
which means you are on 64 bit oracle
If your oracle is 32 bit you should see output like
oracle: ELF 32-bit MSB executable SPARC Version 1
Now you know what should be bit of patch to download


Q How to Discoverer Version installed with Apps ?

Discoverer with Apps installed in ORACLE_HOME same as 806 is usually 3i or 4i. To find Version login to Application Tier & go to $ORACLE_HOME/discwb4/bin and execute
strings dis4ws | grep -i 'discoverer version'
You should see output like
Discoverer Version:Session 4.1.47.09.00
Which means you are on discoverer 4i version 4.1.47.09
分享到:
评论

相关推荐

    王重东Oracle-EBS R12DBA维护笔记

    系统架构介绍通常包括了Oracle EBS的各个组件及其相互之间的交互作用。 2. **Oracle EBS R12安装** 在安装章节中,王重东可能详细描述了EBS R12的安装流程,包括操作系统准备、数据库准备、注册客户应用、EBS启动...

    Oracle EBS R12安装手册-For Linux

    安装手册中的各个章节详细讲解了不同版本的EBS R12的安装以及升级步骤。比如,用户可以按照手册中的步骤从EBS R12.1.1版本升级到12.1.3版本,或者对EBS数据库从**.*.*.*升级到**.*.*.*版本。此外,手册也包含了对于...

    深入浅出oracle ebs之核心功能(mfg)

    Oracle EBS(Enterprise Business Suite)是Oracle公司提供的一套全面的企业资源规划(ERP)解决方案,其在制造行业的应用尤其广泛,覆盖了从物料管理、生产计划到成本控制等各个环节。本文将从标题和描述出发,深入...

    深入浅出oracle EBS之核心功能(MFG).pdf

    - Review Profile(查看配置文件):检查BOM的相关设置,包括版本控制、有效性等。 - View Indented BOM(查看缩进BOM):以缩进的形式查看产品结构,帮助用户了解各组件之间的层次关系。 - Modify Component...

    oracle ebs 11i系统安装与维护

    2. 创建文件系统:为各个组件创建独立的文件系统,如ORACLE_HOME,用于存放软件和数据文件。 3. 解压软件包:将下载的压缩包解压到对应的文件系统中。 4. 配置响应文件:根据企业的具体需求,定制安装响应文件...

    EBS系统基础配置

    ### EBS系统基础配置知识点详解 ...以上内容详细介绍了Oracle EBS系统的基础配置知识,涵盖了从系统环境准备到基本操作的各个环节。通过学习这些知识点,初学者可以快速掌握如何配置和使用Oracle EBS系统的基本功能。

    oracle ebs Split An Order Line

    文档中提供的链接(***)是Oracle的支持门户,这是一个重要的资源,可以获取关于Oracle EBS产品以及各个组件如Order Management和OE_ORDER_PUB包的最新信息和解决方案。 总之,Oracle EBS的订单行分割功能是为了...

    EBS系统设计汇报PPT课件.pptx

    3. **开发准备**:8月15日至9月15日,主要任务包括开发环境搭建、厂商培训、公共组件开发、上游数据交换标准制定、技术架构确定和硬件方案选择。 4. **EBS系统设计理念**: - **SBU概念**:EBS系统引入了Strategy ...

    oracle_EBS_表结构

    - **OPERATION_SEQ_NUM (NUMBER)**:操作序列号,用于定义组装过程中各个组件的顺序。 - **COMPONENT_ITEM_ID (NUMBER)**:组件项ID,标识了具体的组件。 - **ITEM_NUM (NUMBER)**:项目编号,用于标识某个组件。 - ...

    oracle+ebs+开发集合(form+report)

    1. **数据库设计**: 学习EBS中的实体关系模型,了解各个模块的关键表和它们之间的关联。 2. **性能优化**: 通过理解表结构,可以更好地编写SQL查询,避免全表扫描,提升查询性能。 3. **自定义开发**: 在进行Form和...

    oracle ebs r12 PROd

    R12是EBS的一个重要版本,提供了许多增强的功能和性能优化。 系统安装涉及多个层面,包括硬件配置、操作系统安装与配置以及EBS R12软件本身的安装和后续配置。以下是对这些知识点的详细说明: 1. **系统硬件准备**...

    EBS12-Preparing For Your Installation-EDU41CFY.pdf

    Rapid Install主要负责安装和配置Oracle Applications系统的各个部分,包括数据库、应用服务器以及一系列技术栈组件。其中,数据库组件是Oracle Database 10g Release 2 (10.2.0.2),它为EBS12提供了数据存储和管理...

    深入浅出Oracle EBS之Workflow实例详解

    Oracle E-Business Suite (EBS) 中的工作流(Workflow)是一项核心的技术组件,它主要用于管理EBS中的业务流程,包括但不限于通知与审批控制、账户按规则自动创建等过程。从R11i版本开始,模块间的协调也有部分通过...

    Oracle+EBS+Forms开发指南(中级)

    - **设计阶段**:根据需求绘制Folder的结构图,并规划好各个组件之间的交互逻辑。 - **创建Folder**:在 **Developer** 工具中创建一个新的Folder,并定义其基本属性,如名称、描述等。 - **组件添加**:向Folder中...

    深入浅出_Oracle+EBS+Forms开发指南(中级)

    3. **维护翻译**:持续更新和维护各个语言版本的翻译准确性。 **2.3 数据多语言开发步骤** 在Oracle EBS中,数据本身也需要支持多语言。实现这一目标的具体步骤包括: 1. **设计多语言数据模型**:在数据库设计...

    ORACLE EBS

    - **定义配置规则**:接下来要设定各个组件之间的相互依赖关系,比如某些选项必须与其他选项同时选择或不能同时选择。 - **测试配置**:通过预览功能来检查配置是否符合预期,并进行必要的调整。 2. **价格策略...

    ORACLE_EBS财务全模块操作手册中文版.doc

    系统配置和安装包括设置系统参数、创建数据库连接、安装必要的组件等步骤。同时,用户需要了解系统快捷键和通配符的使用,以提高操作效率。 系统快捷键是指在系统中可以使用的快捷键,能够快速地完成某些操作。例如...

Global site tag (gtag.js) - Google Analytics