查看: 11063|回复: 8

[转载] Troubleshooting FRM-91500 When Compiling/ Generating Forms

[复制链接]
论坛徽章:
25
每日论坛发贴之星
日期:2005-05-23 01:01:10马上有对象
日期:2014-02-19 11:55:14马上有钱
日期:2014-02-19 11:55:14马上有房
日期:2014-02-19 11:55:14马上有车
日期:2014-02-19 11:55:142012新春纪念徽章
日期:2012-02-13 15:08:092012新春纪念徽章
日期:2012-02-13 15:08:092012新春纪念徽章
日期:2012-02-13 15:08:092012新春纪念徽章
日期:2012-02-13 15:08:092012新春纪念徽章
日期:2012-02-13 15:08:09
发表于 2005-8-4 14:28 | 显示全部楼层 |阅读模式
META-LINK: Doc ID:  Note:266731.1


[B]PURPOSE[/B]
-------
To provide some troubleshooting and solutions to the generic FRM-91500 error.  This is a generic error which can occur when compiling or generating forms application modules typically in a Unix environment.

[B]SCOPE & APPLICATION [/B]
-------------------  
This article applies to:  
Oracle 9iDS / 9iAS Rel 1 Forms 6i (6.0.8)  
Oracle 9iDS / 9iAS Rel 2 Forms 9i (9.0.2)
Oracle Developer Suite / Application Server Forms 10g (9.0.4)  

Platform : Unix  

Target Audience: Support Engineers, Consultants, System Administrators,  DBAs and Developers  

[B]FRM-91500 Unable to Start / Complete Build [/B]
------------------------------------------
The executables that can produce the FRM-91500 error are :   
Forms 9i / 10g Compiler : f90genm.sh or f90genm or f90gen
Forms 9i / 10g Builder : f90desm
Forms 6i Compiler : f60genm or f60gen   Forms 6i Builder : f60desm

The FRM-91500 error message is very generic, but it can have a number of  different causes. The error gives no clues as to begin troubleshooting. Typically, however, the fault lies in the environment/ operating system setup.  In this respect, the following settings should be checked and considered:
ORACLE_HOME and LD_LIBRARY_PATH
DISPLAY and Motif library version
NLS_LANG and the characterset used,
TERM and / or ORACLE_TERM


[B]Hints / Recommendations: [/B]
----------------------
1. There are example environment variable setup shell scripts supplied as part of the default Forms install e.g
Forms 6i:
Oracle 9iAS Rel 1  
$ORACLE_HOME/6iserver/
forms60.csh
or
forms60.sh


Choose a script and edit it so values for the ORACLE_HOME and DISPLAY settings are correct. Then run the script before issuing the f60gen or f60genm command e.g
unixprompt:>. ./forms60.sh

Forms 9i / 10g:
The environment setup is actually provided in the f90genm.sh shell script. Edit this shell script so values for the ORACLE_HOME and DISPLAY settings are correct. Then use f90genm.sh rather than f90genm or f90gen to compile  / generate forms modules.  

2. Check that the machine / environment complies with the  'System/ Software Requirements' as stated in the product Installation Guide  e.g

Oracle? Application Server 10g Installation Guide  10g (9.0.4) for Solaris Operating System (SPARC)  http://download-uk.oracle.com/do ... 904/install/toc.htm

Oracle? Application Server 10g Installation Guide 10g (9.0.4) for  AIX-Based Systems, hp HP-UX PA-RISC (64-bit), hp Tru64 UNIX, and Linux x86  http://download-uk.oracle.com/do ... 904/install/toc.htm

Oracle? Developer Suite Installation Guide  10g (9.0.4) for Windows, Linux, Solaris, and HP-UX  http://download-uk.oracle.com/do ... ore/install/toc.htm

Oracle9i Application Server Installation Guide Release 2 (9.0.2) for AIX-Based Systems, Compaq Tru64 UNIX,  HP 9000 Series HP-UX, and Linux Intel http://download-uk.oracle.com/do ... 902/install/toc.htm

Oracle9i Application Server Installation Guide Release 2 (9.0.2) for Sun SPARC Solaris http://download-uk.oracle.com/do ... 902/install/toc.htm

Oracle9i Developer Suite Installation Guide Release 2 (9.0.2) for Windows and UNIX http://download-uk.oracle.com/do ... 902/install/toc.htm

For Oracle 9iAS / 9iDS Rel 1 documentation - see Documentation links on OTN
http://otn.oracle.com/documentation/ias_arch_9i.html
http://otn.oracle.com/documentation/ids_arch.html

In particular, be sure that the correct Motif packages are installed and  being used.

[B]ORACLE_HOME and LD_LIBRARY_PATH settings:[/B]
-----------------------------------------
ORACLE_HOME environment variable must refer to the directory structure where  Oracle Forms is installed e.g  
Oracle 9iAS Rel 2 BI Forms Middle Tier  
The LD_LIBRARY_PATH should then include $ORACLE_HOME/lib before any other  directories referenced in this setting

Useful Reference:  
Note:160656.1 Error FRM-91500 Using f60gen with ORACLE_HOME set to Database  Server directory.


[B]DISPLAY Setting and Motif version :[/B]
-----------------------------------
The DISPLAY environment variable must be set to a valid value when using  f60genm or f90genm / f90genm.sh.
Hint: Having set DISPLAY check that it works by running a simple x-windows  command such as xclock or xterm e.g
unixprompt:> xclock &

An xclock should appear on the monitor / device to which DISPLAY is pointing

Also beware some known issues with Motif library versions on Linux and  xVfb emulation software.
Useful References:  
Note:160450.1  FRM-91500 on Compiling a Form Needs DISPLAY Variable.
Note:262442.1  Error FRM-91500 Running Forms 9i Compiler (f90genm.sh)  on Linux x86.
Note:219756.1  Compiling Forms Using F60GENM Gives FRM-91500 When Using xVfb On AIX


[B]NLS_LANG - characterset Settings :  [/B]
-----------------------------------
This variable should be set to a valid NLS_LANG.  If WE8ISO8859P15 or UTF8 characterset are used some changes in the Tk2Motif.rgb file are required.

Useful References:  
Note:1075912.6  Troubleshooting FRM-91111
Note:210528.1   Trying to Generate a Form with WE8ISO8859P15 Character Set ails with FRM-91500

[B]TERM, ORACLE_TERM settings: [/B]
---------------------------
The ORACLE_TERM and/or TERM environment variable must be set to valid value  when using the character mode version of the compiler i.e f60gen / f90gen e.g

ORACLE_TERM=vt220; export ORACLE_TERM
TERM=vt220; export TERM  
Useful References:
Note:1071460.6 FRM-91500 Unable to Start or Complete the Build When Generating Form on UNIX Charactermode
Note:1069393.6 FRM-91500: WHEN GENERATING FORMS with Generator/Compiler
Note:230791.1  FRM-91500 Error When Generating Forms Using Admin  



---今天就遇到了.真衰---
论坛徽章:
25
每日论坛发贴之星
日期:2005-05-23 01:01:10马上有对象
日期:2014-02-19 11:55:14马上有钱
日期:2014-02-19 11:55:14马上有房
日期:2014-02-19 11:55:14马上有车
日期:2014-02-19 11:55:142012新春纪念徽章
日期:2012-02-13 15:08:092012新春纪念徽章
日期:2012-02-13 15:08:092012新春纪念徽章
日期:2012-02-13 15:08:092012新春纪念徽章
日期:2012-02-13 15:08:092012新春纪念徽章
日期:2012-02-13 15:08:09
 楼主| 发表于 2005-8-5 00:40 | 显示全部楼层
最后查出是NLS_LANG的问题.

现在滴情况是,偶自已做的两个middle-tier instances没有问题,将NLS_LANG设置为export NLS_LANG='SIMPLIFIED CHINESE_CHINA.UTF8',也可compile,
但另两个别人所clone的middle-tier instances设置了export NLS_LANG='SIMPLIFIED CHINESE_CHINA.UTF8'之后,就出以上错误.且若将NLS_LANG先unset一下,再compile则又无此问题.

FT. 又是哪个configuration file的问题.

使用道具 举报

回复
论坛徽章:
0
发表于 2005-8-5 09:40 | 显示全部楼层
我也有同样的问题, DISPLAY 没色成XTERM

使用道具 举报

回复
论坛徽章:
25
每日论坛发贴之星
日期:2005-05-23 01:01:10马上有对象
日期:2014-02-19 11:55:14马上有钱
日期:2014-02-19 11:55:14马上有房
日期:2014-02-19 11:55:14马上有车
日期:2014-02-19 11:55:142012新春纪念徽章
日期:2012-02-13 15:08:092012新春纪念徽章
日期:2012-02-13 15:08:092012新春纪念徽章
日期:2012-02-13 15:08:092012新春纪念徽章
日期:2012-02-13 15:08:092012新春纪念徽章
日期:2012-02-13 15:08:09
 楼主| 发表于 2005-8-5 15:13 | 显示全部楼层
最后加上TK90_UNKNOWN这个environment variable最省事了.

使用道具 举报

回复
论坛徽章:
0
发表于 2005-8-6 08:07 | 显示全部楼层
FORM 编译以后, 我试了运行, 第一个FORM 很正常, 输入USERID/PASSWORD 与DATABASE NAME 后, 就出现空白, 十么也没有, 没有CALL 第二个FORM, 哪儿的问题?

使用道具 举报

回复
论坛徽章:
25
每日论坛发贴之星
日期:2005-05-23 01:01:10马上有对象
日期:2014-02-19 11:55:14马上有钱
日期:2014-02-19 11:55:14马上有房
日期:2014-02-19 11:55:14马上有车
日期:2014-02-19 11:55:142012新春纪念徽章
日期:2012-02-13 15:08:092012新春纪念徽章
日期:2012-02-13 15:08:092012新春纪念徽章
日期:2012-02-13 15:08:092012新春纪念徽章
日期:2012-02-13 15:08:092012新春纪念徽章
日期:2012-02-13 15:08:09
 楼主| 发表于 2005-8-6 08:59 | 显示全部楼层
1. 确认form能成功编译.
2. 单独地运行此form看是否行?
3. 查看$ORACLE_HOME/forms90/server/*.env 中有没有正确地设置.
ORACLE_HOME
TNS_NAME
ORA_NLS33
NLS_LANG
J2EE_HOME
CLASSPATH
PATH
FORMS90_PATH
FORMS90_OUTPUT
FORMS90_TRACE_PATH


BTW: forms架构比较简单,我遇到的问题多出在环境变量上.

使用道具 举报

回复
论坛徽章:
0
发表于 2005-8-6 11:02 | 显示全部楼层
一般需要查看那些LOG FILE?

使用道具 举报

回复
论坛徽章:
25
每日论坛发贴之星
日期:2005-05-23 01:01:10马上有对象
日期:2014-02-19 11:55:14马上有钱
日期:2014-02-19 11:55:14马上有房
日期:2014-02-19 11:55:14马上有车
日期:2014-02-19 11:55:142012新春纪念徽章
日期:2012-02-13 15:08:092012新春纪念徽章
日期:2012-02-13 15:08:092012新春纪念徽章
日期:2012-02-13 15:08:092012新春纪念徽章
日期:2012-02-13 15:08:092012新春纪念徽章
日期:2012-02-13 15:08:09
 楼主| 发表于 2005-8-6 12:30 | 显示全部楼层
server side:  
<ORACLE_HOME>/j2ee/OC4J_BI_FORMS/application-deployments/forms90app/OC4J_BI_Forms_default_island_1/application.log


client side:
Java console.

使用道具 举报

回复
论坛徽章:
0
发表于 2005-8-10 06:19 | 显示全部楼层
我现在编译完, 也可以LOGIN 到下一个FORM, 但是LOGIN SCREEN, DATABASE 原来是LOV, 可选,  现在不是LOV, 要自己输了DATABASE NAME , 哪的问题?

使用道具 举报

回复

您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

TOP技术积分榜 社区积分榜 徽章 团队 统计 知识索引树 积分竞拍 文本模式 帮助
  ITPUB首页 | ITPUB论坛 | 数据库技术 | 企业信息化 | 开发技术 | 微软技术 | 软件工程与项目管理 | IBM技术园地 | 行业纵向讨论 | IT招聘 | IT文档
  ChinaUnix | ChinaUnix博客 | ChinaUnix论坛
CopyRight 1999-2011 itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有 联系我们 
京ICP备09055130号-4  北京市公安局海淀分局网监中心备案编号:11010802021510 广播电视节目制作经营许可证:编号(京)字第1149号
  
快速回复 返回顶部 返回列表