- 浏览: 319236 次
- 性别:
- 来自: 北京
文章分类
- 全部博客 (169)
- ORACLE EBS FORM开发 (39)
- ORACLE EBS业务 (18)
- ORACLE DB (13)
- ACCOUNTING (0)
- 休闲娱乐 (5)
- 开发自己 (1)
- OAF开发 (15)
- LINUX (2)
- ORACLE EBS文档 (1)
- 疑难杂症 (3)
- WEB ADI (2)
- 报表开发 (2)
- EBS有用SQL (8)
- ORACLE EBS开发 (5)
- ORACLE EBS DBA (15)
- EBS日常维护 (24)
- Oracle EBS workflow (2)
- Oracle EBS 个性化 (2)
- EBS常见接口表应用 (10)
- EBS标准API应用 (3)
- Oracle EBS 数据迁移 (2)
- Oracle EBS杂项技术荟萃 (1)
- EBS之事半功倍 (1)
- ORACLE EBS ALERT (1)
- OCP之路 (4)
最新评论
-
594597634:
楼主没有给解决方案啊
!我急求如何解决啊
亲历:JBO-25058 -
sjmei:
嗯,不错,学习了
PL/SQL NO_DATA_FOUND、SQL%NOTFOUND、SQL%ROWCOUNT -
maojieming:
做公交车,应该是“关门打X”
北京公交车一族必备绝技 -
hollysun:
现在功夫都练得炉火纯青了,独孤九剑~
北京公交车一族必备绝技 -
xyh:
还有一招:锁喉功,掐死你,捏死你
北京公交车一族必备绝技
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
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 Apps DBA 常用命令
2012-10-10 10:31 2486数据库启动监听 addlnctl.sh start i ... -
Oracle EBS Instance冷备份的方法
2012-10-10 10:32 921Oracle EBS Instance冷备份的方法( ... -
如何查看Oracle Apps的版本信息以及模块信息
2012-10-09 11:23 10471.如何查询EBS系统的版本信息Query: select ... -
查询EBS中应用URL的SQL语句
2012-10-09 10:13 1168SQL> SELECT A.PROFILE_OPT ... -
EBS中怎样监视打patch的进度
2012-10-09 10:10 851可以使用OAM来监控,但要保证web server st ... -
并发管理器(内部监控程序、并发管理器、事务处理管理器)
2012-04-10 15:13 2447Oracle EBS系统在后台通过运行大量“并发处理程序 ... -
EBS log
2012-04-10 15:00 935对于任何一个应用开 ... -
AWR信息查看
2012-04-17 10:05 1009SELECT W.*, D.NAME F ... -
Oracle EBS标准错误信息如何追踪 (Debug)
2011-07-16 10:51 1632调用EBS标准API的时候,可能会返回一些让人看不懂的错误,比 ... -
Oracle DBA在新环境下必须了解的事情
2011-07-16 10:38 929在这里,不谈那些大的方面,比如了解整个IT环境整体情况,假设你 ... -
Log file location for Oracle E-Business Suite R12
2011-07-16 10:27 896Log file location in Oracle E-B ... -
EBS打Patch通用步骤
2011-07-16 08:22 4942EBS打Patch通用步骤 检查已安装模块版本: SELEC ... -
Oracle EBS的版本演化
2011-04-25 12:01 918Oracle EBS的版本演化: 版本演化: 11——De ... -
ORACLE启动与用户密码修改
2011-03-08 11:50 877# $ su - oracle # $ sqlplus / n ...
相关推荐
ORACLE ebs 各个模块的表之间的关联关系,方便大家熟悉ebs系统的表结构
ORACLE EBS查看库存现有量SQL
Oracle EBS R12 升级 流程图
Oracle EBS 操作手册
个性化EBS标准OAF页面:替换VO添加客户化属性(VO基于EO的版本)、替换VO添加客户化属性(VO基于SQL的版本)。
系统优化是EBS DBA工作中很重要的一部分,对DBA的要求也非常高。EBS系统优化的过程是复杂的,要从存储设备、主机、数据库、应用系统、网络以及客户端等多层次入手。本文档主要探讨应用系统和数据库层的优化方案,而...
C:\Program Files\Oracle\JInitiator 1.3.1.21\bin\hotspot 下的 jvm.dll文件 老版本
修改EBS R12服务器域名的操作方法,包括AP服务器和DB服务器,域名、IP都可以改,改IP相对容易一些,改域名就要牵涉到很多配置,该文档都讲到了,按照上面介绍的操作错不了的。
不过,毕竟这个文档的年代已经较久,后来EBS较新版本中的内容可能没有,也可能新版本实际已有变化,故使用时若遇到有疑问的地方,最好和与系统捆绑在一起的在线帮助文档相比较,或与相应版本的“User Guide”的有关...
本文是面试华为oracle ebs的一些知识点,希望对你有所帮助
EBS工作流邮件配置流程,对于EBS很有好处
oracle ebs 多个应用节点安装,做F5前必看文档。提供单数据库节点,多个应用节点的安装。
R12 EBS 系统管理员 EBS administrator guide ORACLE
详细讲解ebs中发布webservice的步骤
包含EBS从R12版本到R12.2版本的一些改进特征
ebs报表里面实现二维码打印功能。
IE+Firefox浏览器下搭建EBS的Form环境,实现IE,Firefox下Form同时工作
EBS 财务凭证序列号的设置定义和分配
EBS R12 通知列表设置 通过个性化配置,实现通知列表首页展示