求oracle 10g ias formserver 和 report server for linux 配置文档??

hmfjacky

最初由 jc20031010 发布
[B]
Right!

在 AS ORACLE_HOME/bin 下，有一个叫 *batch* 啥的，我记不清了，那就是让你从新编译 FORMS 的。 明天上班时，我再查一查！ [/B]

大大，小弟在目錄只找到frmcmp_batch，frmcmp_batch.sh  這兩個檔案，但是不知道這麼用法呢??

jc20031010

最初由 hmfjacky 发布
[B]

大大，小弟在目錄只找到frmcmp_batch，frmcmp_batch.sh  這兩個檔案，但是不知道這麼用法呢?? [/B]

呵呵，大概是 frmcmp_batch.sh， 大概是这样：

frmcmp_batch.sh  username/password@资料库DB source=yourform.fmb  type=FORMS.

就这么试，用错了，系统会告你正确的 syntax.

hmfjacky

最初由 jc20031010 发布
[B]
呵呵，大概是 frmcmp_batch.sh， 大概是这样：

frmcmp_batch.sh  username/password@资料库DB source=yourform.fmb  type=FORMS.

就这么试，用错了，系统会告你正确的 syntax. [/B]

小弟執行下列
[oracle@host2 bin]$ ./frmcmp_batch.sh homn/homn@test soruce=/u01/app/oracle/Ora
Home_2/forms/form9i/test.fmb type=FORMS
出現：
./frmcmp_batch.sh: line 57: /u01/app/oracle/OraHome_1/bin/frmcmp_batch: No such file or directory


Ora_Home_1 是database 10g 目錄
Ora_Home_2是 AS 10g for form service 目錄，
我將database 10g 和AS 10g同時安裝在RHEL4 版本上，為什麼上面錯誤訊息會
跑出 ‧‧‧‧/OraHome_1/bin/frmcmp_batch: No such file or directory

jc20031010

呵呵，把 frmcmp_batch.sh 打开，把那个 frmcmp_batch 的 path 修改一下。 做前，先留个备份。

hmfjacky

最初由 jc20031010 发布
[B]呵呵，把 frmcmp_batch.sh 打开，把那个 frmcmp_batch 的 path 修改一下。 做前，先留个备份。 [/B]

我重新將frmcmp_batch.sh的ORACLE_HOME
設定為AS 目錄，先前是預設database目錄，難怪抓不到目錄，後來執行出現下列訊息：
FRM-91500: Unable to start/complete the build.

小弟frmcmp_batch.sh 設定如下：
#!/bin/sh
# frmcmp_batch.sh - executable Bourne shell script to run the Forms Compiler
#                   (Generator) in batch mode after setting up the required
#                   environment
#
# NOTES
# 1/ The Forms installation process should replace
#    <percent>FORMS_ORACLE_HOME<percent> with the correct ORACLE_HOME
#    setting.  Please make these changes manually if not.
# 2/ Some of the variables below may need to be changed to suite your needs.
#    Please refer to the Forms documentation for details.
#

# Set ORACLE_HOME if not set in the calling environment:
#ORACLE_HOME=${ORACLE_HOME:-/u01/app/oracle/OraHome_2}
ORACLE_HOME=/u01/app/oracle/OraHome_2
export ORACLE_HOME
  # Search path for Forms applications (.fmb &.fmx files, PL/SQL libraries)
  # If you need to include more than one directory, they should be colon
  #
  FORMS_PATH=$ORACLE_HOME/forms/form9i
  # You may need to set one or more of TNS_ADMIN, TWO_TASK or ORACLE_SID
  # to connect to database
  export TNS_ADMIN
  TWO_TASK=homn/homn@test; export TWO_TASK
  #
  # System settings
  # ---------------
  # Note: the current directory is always searched by default
  #
  FORMS_PATH=$ORACLE_HOME/forms/form9i
  # You may need to set one or more of TNS_ADMIN, TWO_TASK or ORACLE_SID
  # to connect to database
  export TNS_ADMIN
  TWO_TASK=homn/homn@test; export TWO_TASK
  #
  # System settings
  # ---------------
  # You should not normally need to modify these settings.
  #
  if [ `uname -s` = 'SunOS' ]; then
    LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/jdk/jre/lib/sparc:$ORACLE_HO
ME/jdk/jre/lib/sparc/native_threads:$LD_LIBRARY_PATH
    export LD_LIBRARY_PATH
  elif [ `uname -s` = 'HP-UX' ]; then
    SHLIB_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/jdk/jre/lib/PA_RISC:$ORACLE_HOME/
jdk/jre/lib/PA_RISC/server:$SHLIB_PATH
      export SHLIB_PATH
  elif [ `uname -s` = 'Linux' ]; then
    LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/jdk/jre/lib/i386/server:$ORACL
E_HOME/jdk/jre/lib/i386/native_threads:$ORACLE_HOME/jdk/jre/lib/i386:$LD_LIBRARY
_PATH
    export LD_LIBRARY_PATH
  elif [ `uname -s` = 'SunOs' ]; then
    LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/jdk/jre/lib/sparc:$ORACLE_HO
ME/jdk/jre/lib/sparc/native_threads:$LD_LIBRARY_PATH
    export LD_LIBRARY_PATH
  else
    LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/jdk/jre/lib/sparc:$ORACLE_HOME
/jdk/jre/lib/sparc/native_threads:$LD_LIBRARY_PATH
      export LD_LIBRARY_PATH
  fi
$ORACLE_HOME/bin/frmcmp_batch $*

hmfjacky

各位大大，有沒有人對frmcmp、frmcmp_batch 這兩支程式有了解的??小弟目前卡在不知如何用這兩程式編譯form 6i 程式碼，小弟在此跪求各位大大多多指導，謝謝。

jc20031010

May I ask if frmcmp_batch.sh, frmcmp_batch executable?

hmfjacky

謝謝各位大大，另外我在oracle 網站找到一些用法，但是try 還是不行，用法敘述：
frmcmp userid=xxx/xxx@myDB batch=yes module=$i module_type=form
compile_all=yes window_state=minimize


frmcmp_batch.sh module=$file userid=<your connect string> compile_all=yes

hmfjacky

小弟今天加入兩個設定：
export TERM=vt220
export ORACLE_TERM=vt220

再重新編譯：
[oracle@host2 bin]$ ./frmcmp_batch.sh module=test.fmb userid=homn/homn@test comp
ile_all=yes module_type=form
Forms 10.1 (Form Compiler) Version 10.1.2.0.2 (Production)

Forms 10.1 (Form Compiler): Release  - Production

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Oracle Database 10g Release 10.2.0.1.0 - Production
PL/SQL Version 10.1.0.4.2 (Production)
Oracle Procedure Builder V10.1.2.0.2 - Production
Oracle Virtual Graphics System Version 10.1.2.0.0 (Production)
Oracle Multimedia Version 10.1.2.0.2 (Production)
Oracle Tools Integration Version 10.1.2.0.2 (Production)
Oracle Tools Common Area Version 10.1.2.0.2
Oracle CORE     10.1.0.4.0      Production

FRM-10043: Cannot open file.


Form not created

jc20031010

问题： 你的 test.fmb 哪来的，是不是 AS 10g 自带的？

建议你在你的 linux server 上装一个 DS (developer suite). 我怀疑你的 Forms 可能是老的版本。

Good Luck!