Oracle Forms and Reports 11gR2 Installation on Oracle Linux 6

目錄

一、安裝Oracle Linux. 3

1、基礎安裝選項... 3

2、安裝軟件包... 3

3、關閉防火牆和SELinux to Permissive. 4

4、停用空閒網卡... 4

5、修改/etc/hosts. 4

6、創建oracle用戶和組(如安裝Oracle Linux默認已創建) 4

7、創建安裝目錄和受權... 4

二、安裝JRockit 4

三、安裝Weblogic. 7

1、修改/home/oracle/.bash_profile. 7

2、安裝... 8

四、安裝Form&Report 11gR2. 13

1、解壓縮到同一目錄... 13

2、安裝... 13

五、配置Form.. 22

1、default.env: Runtime environment parameter definitions. 22

2、formsweb.cfg: Definitions of individual configurations. 23

3、tnsnames.ora: 23

4、Registry.dat 24

5、fmrweb.res: Key definition file for webforms. 24

6、Webutil Configuration. 26

7、Sign JAR Files. 26

六、配置Reports. 28

1、修改$FR_INST/config/reports/bin/reports.sh(文档 ID 1286220.1) 28

2、修改$FR_INST/config/FRComponent/frcommon/guicommon/tk/admin/Tk2Motif.rgb. 29

3、把字體文件copy到... 29

4、rwserver.conf & rwservlet.properties. 29

4、修改$FR_INST/config/FRComponent/frcommon/guicommon/tk/admin/uifont.ali 30

5、增加虛擬目錄httpd.conf 30

6、Creating a Boot Identity File. 30

7、Create Standalone Reports Server 29

8、Report Log. 30

七、編譯Form.. 31

1、修改frmcmp_batch.sh. 31

2、創建Form&Report工作目錄... 31

3、frmcmp_form.sh. 31

4、frmcmp_all.sh. 31

5、修改開機自啟任務/etc/rc.d/rc.local 32

6、開機自動啟動腳本startup.sh. 32

7、停用服務命令... 33

八、Report Server 环境变量动态切换(文档 ID 231051.1) 34

• 安裝Oracle Linux

1、基礎安裝選項

• Base System > Base
• Base System > Compatibility libraries
• Base System > Hardware monitoring utilities
• Base System > Large Systems Performance
• Base System > Network file system client
• Base System > Performance Tools
• Base System > Perl Support
• Servers > Server Platform
• Servers > System administration tools
• Desktops > Desktop
• Desktops > Desktop Platform
• Desktops > Fonts
• Desktops > General Purpose Desktop
• Desktops > Graphical Administration Tools
• Desktops > Input Methods
• Desktops > X Window System
• Development > Additional Development
• Development > Development Tools
• Applications > Internet Browser

2、安裝軟件包

掛載ISO文件

mount -o loop /u02/software/rhel-server-6.7-x86_64-dvd.iso /mnt

[root@ap ~]# vi /etc/yum.repos.d/cdrom.repo [mycdrom] name = mycdrom baseurl = file:///mnt gpgcheck = 0 enabled = 0

設置YUM安裝源

yum --enable repo=mycdrom install binutils -y

yum --enable repo=mycdrom install compat-libcap1 -y

yum --enable repo=mycdrom install compat-libstdc++-33 -y

yum --enable repo=mycdrom install compat-libstdc++-33.i686 -y

yum --enable repo=mycdrom install gcc -y

yum --enable repo=mycdrom install gcc-c++ -y

yum --enable repo=mycdrom install glibc -y

yum --enable repo=mycdrom install glibc.i686 -y

yum --enable repo=mycdrom install glibc-devel -y

yum --enable repo=mycdrom install glibc-devel.i686 -y

yum --enable repo=mycdrom install libaio -y

yum --enable repo=mycdrom install libaio-devel -y

yum --enable repo=mycdrom install libgcc -y

yum --enable repo=mycdrom install libstdc++ -y

yum --enable repo=mycdrom install libstdc++.i686 -y

yum --enable repo=mycdrom install libstdc++-devel -y

yum --enable repo=mycdrom install libXext.i686 -y

yum --enable repo=mycdrom install libXtst.i686 -y

yum --enable repo=mycdrom install openmotif -y

yum --enable repo=mycdrom install openmotif22 -y

yum --enable repo=mycdrom install sysstat -y

yum --enable repo=mycdrom install ksh -y

3、關閉防火牆和SELinux to Permissive

4、停用空閒網卡

#ifconfig em2 down

#ifconfig em3 down

#ifconfig em3 down

5、修改/etc/hosts

127.0.0.1      localhost localhost.localdomain localhost4 localhost4.localdomain4

192.168.1.2  ap01.your.com ap01

6、創建oracle用戶和組(如安裝Oracle Linux默認已創建)

groupadd -g 1000 oinstall

useradd -u 1100 -g oinstall oracle

passwd oracle

7、創建安裝目錄和受權

mkdir -p /u01/app/oracle/middleware

chown -R oracle:oinstall /u01

chmod -R 775 /u01

• 安裝JRockit

chmod u+x jrockit-jdk1.6.0_45-R28.2.7-4.1.0-linux-x64.bin

./jrockit-jdk1.6.0_45-R28.2.7-4.1.0-linux-x64.bin

三、安裝Weblogic

1、修改/home/oracle/.bash_profile

# Middleware

export ORACLE_BASE=/u01/app/oracle

export MW_HOME=$ORACLE_BASE/middleware

export WLS_HOME=$MW_HOME/wlserver_10.3

export WL_HOME=$WLS_HOME

export ORACLE_HOME=$MW_HOME/fr_home

export ORACLE_INSTANCE=$MW_HOME/fr_inst

export FR_HOME=$ORACLE_HOME

export FR_INST=$ORACLE_INSTANCE

export DOMAIN_HOME=$MW_HOME/user_projects/domains/ClassicDomain

# Forms compilation

export PATH=.:$FR_INST/bin:$FR_HOME/bin:$FR_HOME/forms/mesg:$PATH

export LD_LIBRARY_PATH=$FR_HOME/jdk/jre/lib/amd64/native_threads:$FR_HOME/jdk/jre/lib/amd64:$FR_HOME/lib:$FR_HOME/jdk/jre/lib/amd64/server

export FORMS_BUILDER_CLASSPATH=$FR_HOME/jlib/

#export FORMS_PATH=[*** add the path to your forms ***]

#export REPORTS_PATH=[*** add the path to your reports here ***]

#export TWO_TASK=ORCL

export TNS_ADMIN=$FR_INST/config

export TERM=vt220

export ORACLE_TERM=$TERM

# Reports server: Adjust as required to allow forms to get the reports server name

# using "tool_env.getvar('REPORTS_SERVER_NAME', v_rep_server);"

# export REPORTS_SERVER_NAME=RptSvr_ap01_fr_inst

# Set to the appropriate JAVA_HOME.

export JAVA_HOME=$ORACLE_BASE/jrockit-jdk1.6.0_45-R28.2.7-4.1.0

export PATH=$JAVA_HOME/bin:$PATH

export CLASSPATH=/u02/java

As specified in MOS Note [ID 1487773.1], amend the "/etc/security/limits.d/90-nproc.conf" file, making the following change.

# From
*          soft    nproc     1024
#To
* - nproc 16384

2、安裝

$JAVA_HOME/bin/java -Xmx1024m -jar wls1036_generic.jar

四、安裝Form&Report 11gR2

1、解壓縮到同一目錄

$unzip ofm_frmrpts_linux_11.1.2.2.0_64_disk1_1of2.zip

$unzip ofm_frmrpts_linux_11.1.2.2.0_64_disk1_2of2.zip

2、安裝

$ ./runInstaller

五、配置Form

1、default.env: Runtime environment parameter definitions.

$DOMAIN_HOME/config/fmwconfig/servers/WLS_FORMS/applications/formsapp_11.1.2/config/default.env

$cp default.env default_un.env

添加 NLS_LANG=AMERICAN_AMERICA.UTF8

中文繁體AMERICAN_AMERICA.ZHT16BIG5

中文簡體AMERICAN_AMERICA.ZHS16GBK

CLASSPATH增加

/u01/app/oracle/middleware/fr_home/forms/java/frmall.jar:/u01/app/oracle/middleware/fr_home/jdk/jre/lib/rt.jar:/u01/app/oracle/middleware/fr_home/forms/java/jxl.jar:/u01/app/oracle/middleware/fr_home/forms/java/excel.jar

PATH增加

/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin

2、formsweb.cfg: Definitions of individual configurations.

$DOMAIN_HOME/config/fmwconfig/servers/WLS_FORMS/applications/formsapp_11.1.2/config/formsweb.cfg

[mydb]

envFile=default_un.env

workingDirectory=/u02/unmis/forms

form=MENU.fmx

pageTitle=My Application Title

width=1024

height=768

separateFrame=true

lookAndFeel=Oracle

colorScheme=blaf

WebUtilArchive=jacob.jar,frmwebutil.jar

WebUtilLogging=off

WebUtilLoggingDetail=normal

WebUtilErrorMode=Alert

WebUtilDispatchMonitorInterval=5

WebUtilTrustInternal=true

WebUtilMaxTransferSize=16384

baseHTML=webutilbase.htm

baseHTMLjpi=webutiljpi.htm

archive=frmall.jar,myico.jar,DirectPrint.jar,frmgeneric_laf.jar,frmmain.jar,frmoracle_laf.jar,frmresources.jar,icepdf-core.jar,icepdf-pro-intl.jar,icepdf-pro.jar,icepdf-viewer.jar,pdfbox-1.7.0.jar,FormsGraph.jar,timeout.jar

jpi_download_page=http://java.sun.com/javase/downloads/index.jsp

jpi_classid=clsid:CAFEEFAC-0016-0000-FFFF-ABCDEFFEDCBA

jpi_codebase=http://ap01.your.com:8888/forms/java/j2se16045.exe#Version=1,6,0,45

jpi_mimetype=application/x-java-applet;jpi-version=1.6.0

3、tnsnames.ora:

$FR_INST/config/tnsnames.ora

MYDB =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = MYDB)

    )

  )

4、Registry.dat

$DOMAIN_HOME/config/fmwconfig/servers/WLS_FORMS/applications/formsapp_11.1.2/config/forms/registry/oracle/forms/registry

修改default.icons.iconpath=/forms/java

 

5、fmrweb.res: Key definition file for webforms.

$FR_INST/config/FormsComponent/forms/admin/resource/US/fmrweb_utf8.res

9    : 0 : "Tab"            : 1  : "Next Field"

9    : 1 : "Shift+Tab"      : 2  : "Previous Field"

116  : 0 : "F5"             : 3  : "Clear Field"

38   : 0 : "Up"             : 6  : "Up"

40   : 0 : "Down"           : 7  : "Down"

33   : 0 : "PageUp"         : 12 : "Scroll Up"

34   : 0 : "PageDown"       : 13 : "Scroll Down"

69   : 2 : "Ctrl+E"         : 22 : "Edit"

10   : 0 : "Return"         : 27 : "Return"

#76   : 2 : "Ctrl+L"         : 29 : "List of Values"

#115  : 0 : "F4"             : 32 : "Exit"

114  : 0 : "F3"             : 73 : "Duplicate Field"

115  : 0 : "F4"             : 64 : "Duplicate Record"

75   : 2 : "Ctrl+K"         : 35 : "Show Keys"

#83   : 2 : "Ctrl+S"         : 36 : "Commit"

121   : 0 : "F10"         : 36 : "Commit"

118  : 1 : "Shift+F7"       : 61 : "Next Primary Key"

#117  : 0 : "F6"             : 62 : "Clear Record"

117  : 0 : "F6"             : 65 : "Insert Record"

38   : 2 : "Ctrl+Up"        : 63 : "Delete Record"

#117  : 1 : "Shift+F6"       : 64 : "Duplicate Record"

#40   : 2 : "Ctrl+Down"      : 65 : "Insert Record"

119  : 1 : "Shift+F8"       : 66 : "Next Set of Records"

1005 : 0 : "Down"           : 67 : "Next Record"

1004 : 0 : "Up"             : 68 : "Previous Record"

#118  : 0 : "F7"             : 69 : "Clear Block"

118  : 0 : "F7"             : 76 : "Enter Query"

#66   : 2 : "Ctrl+B"         : 70 : "Block Menu"

#34   : 1 : "Shift+PageDown" : 71 : "Next Block"

#33   : 1 : "Shift+PageUp"   : 72 : "Previous Block"

#116  : 1 : "Shift+F5"       : 73 : "Duplicate Field"

#119  : 0 : "F8"             : 74 : "Clear Form"

119  : 0 : "F8"             : 77 : "Execute Query"

120  : 0 : "F9"             : 29 : "List of Values"

#122  : 0 : "F11"            : 76 : "Enter Query"

#122  : 2 : "Ctrl+F11"       : 77 : "Execute Query"

69   : 3 : "Shift+Ctrl+E"   : 78 : "Display Error"

80   : 2 : "Ctrl+P"         : 79 : "Print"

123  : 0 : "F12"            : 80 : "Count Query"

85   : 2 : "Ctrl+U"         : 81 : "Update Record"

121  : 3 : "Shift+Ctrl+F10" : 82 : "Function 0"

112  : 3 : "Shift+Ctrl+F1"  : 83 : "Function 1"

113  : 3 : "Shift+Ctrl+F2"  : 84 : "Function 2"

114  : 3 : "Shift+Ctrl+F3"  : 85 : "Function 3"

115  : 3 : "Shift+Ctrl+F4"  : 86 : "Function 4"

116  : 3 : "Shift+Ctrl+F5"  : 87 : "Function 5"

117  : 3 : "Shift+Ctrl+F6"  : 88 : "Function 6"

118  : 3 : "Shift+Ctrl+F7"  : 89 : "Function 7"

119  : 3 : "Shift+Ctrl+F8"  : 90 : "Function 8"

120  : 3 : "Shift+Ctrl+F9"  : 91 : "Function 9"

113  : 0 : "F2"             : 95 : "List Tab Pages"

72   : 2 : "Ctrl+H"         : 30 : "Help"

6、Webutil Configuration

Download the "jacob.jar" (v1.14.3) file from JACOB - Java COM Bridge - Browse Files at SourceForge.net.

Unzip the contents of the file.

Copy the "jacob.jar" to the "$FR_HOME/forms/java" directory.

Copy the "jacob-1.14.3-x86.dll" to the "$FR_HOME/forms/webutil/win32" directory.

Copy the "jacob-1.14.3-x64.dll" to the "$FR_HOME/forms/webutil/win64" directory.

Sign the "jacob.jar" file. (Step 7)

Add "$FR_HOME/forms/java/frmall.jar" to the CLASSPATH entry in the "default.env" file. This should be done with Enterprise Manager, but it works fine if you manually edit the file. If you use custom environment files, you should add it to those also.

default_un.env 修改CLASSPATH增加

/u01/app/oracle/middleware/FR_home/forms/java/frmall.jar:/u01/app/oracle/middleware/FR_home/jdk/jre/lib/rt.jar

修改webutil.cfg

/u01/app/oracle/middleware/fr_inst/config/FormsComponent/forms/server

#NOTE: By default the file transfer is disabled as a security measure

transfer.database.enabled=TRUE

transfer.appsrv.enabled=TRUE

transfer.appsrv.workAreaRoot=

transfer.appsrv.accessControl=TRUE

#List transfer.appsrv.read.<n> directories

transfer.appsrv.read.1=/u02/temp

#List transfer.appsrv.write.<n> directories

transfer.appsrv.write.1=/u02/temp

7、Sign JAR Files

Edit the "$FR_INST/bin/sign_webutil.sh" file, setting the appropriate values. If you want to generate a new certificate and keystore you must enter the following information, adjusted as desired.

DN_CN="myserver.example.com"

DN_OU="My Department"

DN_O="My Company"

DN_L="My City"

DN_ST="My State"

DN_C=GB

KEYSTORE_PASSWORD=password1

JAR_KEY_PASSWORD=password1

VALIDDAYS=3600

If you created a keystore for securing your managed servers, you can reuse that by editing the following settings to match the details of your existing keystore.

KEYSTORE=/home/oracle/keystore/identity.jks

KEYSTORE_PASSWORD=password123

JAR_KEY=selfsigned

JAR_KEY_PASSWORD=password123

Issue to the following command to sign the specified JAR file. In this case it is the jacob.jar file.

$ $FR_INST/bin/sign_webutil.sh $FR_HOME/forms/java/jacob.jar

If you attempt to re-sign a JAR file that is already signed, it will contain multiple signatures in the "META-INF" directory, which will probably result in the following error.

sun.security.validator.ValidatorException: PKIX path validation failed:

  java.security.cert.CertPathValidatorException: signature check failed

To fix this, unpack the JAR, remove the signatures from the "META-INF" directory and re-pack the JAR. The following example shows how this can be done for the "jacob.jar" file.

mkdir $FR_HOME/forms/java/temp

cd $FR_HOME/forms/java/temp

export MYJAR=jacob.jar

unzip ../$MYJAR

rm -f META-INF/*.SF META-INF/*.DSA  META-INF/*.MF

# You may need to remove more, so visually check.

$JAVA_HOME/bin/jar -cvf $MYJAR *

mv $MYJAR ..

rm -Rf *

cd ..

rmdir $FR_HOME/forms/java/temp

Once you've stripped the signatures from the JAR file you will need to resign it.

I've combined this method, along with the signing of the JAR file into following script, which I save as "resign_jars.sh".

mkdir $FR_HOME/forms/java/temp

cd $FR_HOME/forms/java/temp

function sign_jar {

  export MYJAR=$1

  unzip ../$MYJAR

  rm -f META-INF/*.SF META-INF/*.DSA META-INF/*.MF

  # You may need to remove more, so visually check.

  $JAVA_HOME/bin/jar -cvf $MYJAR *

  mv $MYJAR ..

  rm -Rf *

  $FR_INST/bin/sign_webutil.sh $FR_HOME/forms/java/$MYJAR

}

sign_jar frmall.jar

sign_jar frmgeneric_laf.jar

sign_jar frmmain.jar

sign_jar frmoracle_laf.jar

sign_jar frmresources.jar

sign_jar frmwebutil.jar

sign_jar jacob.jar

# Add any custom JARs into the list.

# sign_jar images.jar

cd ..

rmdir $FR_HOME/forms/java/temp

This will strip and resign any JAR file passed as a parameter to the "sign_jar" function.

六、配置Reports

1、修改$FR_INST/config/reports/bin/reports.sh(文档 ID 1286220.1)

增加

DISPLAY=:1.0; export DISPLAY

修改

REPORTS_DEFAULT_DISPLAY=NO;

NLS_LANG=AMERICAN_AMERICA.UTF8;

2、修改$FR_INST/config/FRComponent/frcommon/guicommon/tk/admin/Tk2Motif.rgb

增加

Tk2Motif*fontMapCs: iso8859-1=UTF8

3、把字體文件copy到

$FR_INST/reports/fonts

4、Create Standalone Reports Server

opmnctl createcomponent -adminUsername weblogic -adminHost apv1.your.com -adminPort 7001 –oracleHome $FR_HOME -oracleInstance $FR_INST -instanceName fr_inst -componentName repserver_mydb -componentType ReportsServerComponent

opmnctl deletecomponent -adminUsername weblogic -adminHost apv1.your.com -adminPort 7001 –oracleHome $FR_HOME -oracleInstance $FR_INST -instanceName fr_inst -componentName repserver_mydb -componentType ReportsServerComponent

4、rwserver.conf & rwservlet.properties

#$DOMAIN_HOME/config/fmwconfig/servers/WLS_REPORTS/applications/reports_11.1.2/configuration

/u01/app/oracle/middleware/fr_inst/config/ReportsServerComponent/ repserver_mydb

修改rwserver.conf

<property name="cacheDir" value="/u02/cache"/>

<property name="maxCacheFileNumber" value="50"/>

<engine class="oracle.reports.engine.EngineImpl" engLife="50" id="rwEng" maxEngine="50" minEngine="1" classPath="/u01/app/oracle/middleware/fr_home/reports/jlib:/u01/app/oracle/middleware/fr_home/reports/jlib/oraclebarcode.jar:/u01/app/oracle/middleware/fr_home/reports/jlib/core-1.7.jar:/u01/app/oracle/middleware/fr_home/reports/jlib/javase-1.7.jar:/u01/app/oracle/middleware/fr_home/reports/jlib/qrgen-1.2.jar" jvmOptions="-Dsun.java2d.pmoffscreen=false">

<property name="sourceDir" value="/u02/unmis/reports"/>

<property name="tempDir" value="/u02/temp"/>

  <!--property name="keepConnection" value="yes"/-->

</engine>

<engine class="oracle.reports.urlengine.URLEngineImpl" engLife="50" id="rwURLEng" maxEngine="50" minEngine="0" classPath="/u01/app/oracle/middleware/fr_home/reports/jlib:/u01/app/oracle/middleware/fr_home/reports/jlib/oraclebarcode.jar:/u01/app/oracle/middleware/fr_home/reports/jlib/core-1.7.jar:/u01/app/oracle/middleware/fr_home/reports/jlib/javase-1.7.jar:/u01/app/oracle/middleware/fr_home/reports/jlib/qrgen-1.2.jar" jvmOptions="-Dsun.java2d.pmoffscreen=false"/>

 <queue maxQueueSize="1000"/>

 <!--jobRecovery auxDatFiles="yes"/-->

 <identifier encrypted="no">weblogic/weblogic11g</identifier>

 <pluginParam name="mailServer" value="%MAILSERVER_NAME%">

修改$DOMAIN_HOME/config/fmwconfig/servers/WLS_REPORTS/applications/reports_11.1.2/configuration/rwservlet.properties

<webcommandaccess>L1</webcommandaccess>

4、修改$FR_INST/config/FRComponent/frcommon/guicommon/tk/admin/uifont.ali

"Arial Unicode MS"..... = "ARIALUNI.TTF"

"MingLiU"..... = "ARIALUNI.TTF"

"新細明體"..... = "ARIALUNI.TTF"

"細明體"..... = "ARIALUNI.TTF"

"Code 128"..... = "CODE128.TTF"

"C39HrP36DmTt"..... = "V100020.TTF"

"Symbol"..... = "ARIALUNI.TTF"

5、增加虛擬目錄httpd.conf

$FR_INST/config/OHS/ohs1

增加虛擬目錄

Alias /cache/ "/u02/cache/"

6、Creating a Boot Identity File

When running in production mode, starting a server requires the credentials you provided while creating the domain. Using a boot identity file prevents you from having to type in the username/password each time the server is started.

Create a file called "boot.properties" with the following contents.

username=weblogic

password=mypassword

Save the file under the "$MW_HOME/user_projects/domains/<domain-name>/servers/<server-name>/security" directory. The managed server will now start and stop without needing credentials.

8、Report Log

$DOMAIN_HOME/servers/WLS_REPORTS/logs/reports

$FR_INST/diagnostics/logs/ReportsServerComponent/

七、編譯Form

1、修改frmcmp_batch.sh

$cd $FR_INST/bin

$cp frmcmp_batch.sh frmcmp_batch_un.sh

修改frmcmp_batch_un.sh增加

  unset LANG

  NLS_LANG=AMERICAN_AMERICA.UTF8;

  export NLS_LANG

ORACLE_TERM=vt220

export ORACLE_TERM

2、創建Form&Report工作目錄

mkdir -p /u02/unmis/forms

mkdir -p /u02/unmis/reports

mkdir -p /u02/cache

mkdir -p /u02/temp

3、frmcmp_form.sh

frmcmp_batch_un.sh userid=oadba/oadba@undb batch=yes module=$1 module_type=form compile_all=yes window_state=minimize

4、frmcmp_all.sh

#compile_forms.sh

for i in `ls *.fmb`

do

echo Compiling Form $i ....

frmcmp_batch_un.sh userid=oadba/oadba@undb batch=yes module=$i module_type=form compile_all=yes window_state=minimize

done

5、修改開機自啟任務/etc/rc.d/rc.local

增加

ifconfig eth1 down

ifconfig eth2 down

ifconfig eth3 down

export HOME=/root

vncserver

sleep 3

export DISPLAY=:1.0

xhost +

su - oracle -c ". /home/oracle/startup.sh"

6、開機自動啟動腳本startup.sh

# Middleware

export ORACLE_BASE=/u01/app/oracle

export MW_HOME=$ORACLE_BASE/middleware

export WLS_HOME=$MW_HOME/wlserver_10.3

export WL_HOME=$WLS_HOME

export ORACLE_HOME=$MW_HOME/fr_home

export ORACLE_INSTANCE=$MW_HOME/fr_inst

export FR_HOME=$ORACLE_HOME

export FR_INST=$ORACLE_INSTANCE

export DOMAIN_HOME=$MW_HOME/user_projects/domains/ClassicDomain

# Forms compilation

export PATH=.:$FR_INST/bin:$FR_HOME/bin:$FR_HOME/forms/mesg:$PATH

export LD_LIBRARY_PATH=$FR_HOME/jdk/jre/lib/amd64/native_threads:$FR_HOME/jdk/jre/lib/amd64:$FR_HOME/lib:$FR_HOME/jdk/jre/lib/amd64/server

export FORMS_BUILDER_CLASSPATH=$FR_HOME/jlib/

#export FORMS_PATH=[*** add the path to your forms ***]

#export REPORTS_PATH=[*** add the path to your reports here ***]

#export TWO_TASK=ORCL

export TNS_ADMIN=$FR_INST/config

export TERM=vt220

export ORACLE_TERM=$TERM

# Reports server: Adjust as required to allow forms to get the reports server name

# using "tool_env.getvar('REPORTS_SERVER_NAME', v_rep_server);"

#export REPORTS_SERVER_NAME=rep_wls_reports_ol6-forms_asinst_1

# Set to the appropriate JAVA_HOME.

export JAVA_HOME=$ORACLE_BASE/jrockit-jdk1.6.0_45-R28.2.7-4.1.0

export PATH=$JAVA_HOME/bin:$PATH

#######################################################################

# Start NodeManager

nohup $WLS_HOME/server/bin/startNodeManager.sh > /dev/null 2>&1 &

# Start WebLogic Domain

nohup $DOMAIN_HOME/bin/startWebLogic.sh > /dev/null 2>&1 &

sleep 60

# Start the managed Servers

nohup $DOMAIN_HOME/bin/startManagedWebLogic.sh WLS_FORMS > /dev/null 2>&1 &

nohup $DOMAIN_HOME/bin/startManagedWebLogic.sh WLS_REPORTS > /dev/null 2>&1 &

sleep 60

# Start anything remaining using OPMN

$FR_INST/bin/opmnctl startall

7、停用服務命令

# Stop anything remaining using OPMN

$FR_INST/bin/opmnctl stopall

# Stop the managed Servers

$DOMAIN_HOME/bin/stopManagedWebLogic.sh WLS_FORMS

$DOMAIN_HOME/bin/stopManagedWebLogic.sh WLS_REPORTS

# Stop WebLogic Domain

$DOMAIN_HOME/bin/stopWebLogic.sh

八、Report Server 环境变量动态切换(文档 ID 231051.1)

1、修改$FR_INST/config/ReportsServerComponent/repserver_undb/rwserver.conf

    增加

    <environment id="myEnv">

       <envVariable name="NLS_DATE_LANGUAGE" value="TRADITIONAL CHINESE"/>

       <envVariable name="NLS_LANG" value="AMERICAN_AMERICA.ZHT16MSWIN950"/>

       <envVariable name="TK_UNKNOWN" value="/u01/app/oracle/middleware/fr_inst/config/FRComponent/frcommon/guicommon/tk/admin/ZHT"/>

     </environment>

    修改

<engine class="oracle.reports.engine.EngineImpl"  ……  defaultEnvId="myEnv">

2、copy $FR_INST/config/FRComponent/frcommon/guicommon/tk/admin/ Tk2Motif.rgb到$FR_INST/config/FRComponent/frcommon/guicommon/tk/admin/ZHT

修改$FR_INST/config/FRComponent/frcommon/guicommon/tk/admin/ZHT/Tk2Motif.rgb

Tk2Motif*fontMapCs: iso8859-1=ZHT16MSWIN950

参考：

8.2 Reports Server Configuration File

R12:REP-3000 When Character Set Is ZHS16GBK - dbblog - 博客园

NLS

SIMPLIFIED CHINESE_CHINA.ZHS16GBK

Traditional Chinese_Taiwan.ZHT16BIG5

AMERICAN_AMERICA.UTF8

九、Patch

[oracle@ap02 software]$ unzip p17930316_111220_Linux-x86-64.zip 
Archive:  p17930316_111220_Linux-x86-64.zip
   creating: 17930316/
  inflating: 17930316/README.txt     
   creating: 17930316/etc/
   creating: 17930316/etc/xml/
  inflating: 17930316/etc/xml/ShiphomeDirectoryStructure.xml  
  inflating: 17930316/etc/xml/GenericActions.xml  
   creating: 17930316/etc/config/
  inflating: 17930316/etc/config/actions.xml  
  inflating: 17930316/etc/config/deploy.xml  
  inflating: 17930316/etc/config/inventory.xml  
   creating: 17930316/files/
   creating: 17930316/files/bin/
  inflating: 17930316/files/bin/genshlib  
[oracle@ap02 software]$ cd 17930316/
[oracle@ap02 17930316]$ /u01/app/oracle/middleware/fr_home/OPatch/opatch apply
Oracle Interim Patch Installer version 11.1.0.9.11
Copyright (c) 2013, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/middleware/fr_home
Central Inventory : /home/oracle/oraInventory
   from           : /u01/app/oracle/middleware/fr_home/oraInst.loc
OPatch version    : 11.1.0.9.11
OUI version       : 11.1.0.9.0
Log file location : /u01/app/oracle/middleware/fr_home/cfgtoollogs/opatch/17930316_Aug_11_2015_15_24_18/apply2015-08-11_15-24-17PM_1.log


OPatch detects the Middleware Home as "/u01/app/oracle/middleware"

Applying interim patch '17930316' to OH '/u01/app/oracle/middleware/fr_home'
Verifying environment and performing prerequisite checks...
All checks passed.
Backing up files...

Patching component oracle.developer.forms.compiler, 11.1.2.2.0...

Verifying the update...
Patch 17930316 successfully applied
Log file location: /u01/app/oracle/middleware/fr_home/cfgtoollogs/opatch/17930316_Aug_11_2015_15_24_18/apply2015-08-11_15-24-17PM_1.log

OPatch succeeded.

[oracle@ap02 software]$ unzip p18178044_111220_Linux-x86-64.zip 
Archive:  p18178044_111220_Linux-x86-64.zip
   creating: 18178044/
  inflating: 18178044/README.txt     
   creating: 18178044/etc/
   creating: 18178044/etc/xml/
  inflating: 18178044/etc/xml/ShiphomeDirectoryStructure.xml  
  inflating: 18178044/etc/xml/GenericActions.xml  
   creating: 18178044/etc/config/
  inflating: 18178044/etc/config/actions.xml  
  inflating: 18178044/etc/config/deploy.xml  
  inflating: 18178044/etc/config/inventory.xml  
   creating: 18178044/files/
   creating: 18178044/files/lib/
  inflating: 18178044/files/lib/libfrmjapi.so.0  
 
[oracle@ap02 OPatch]$ cd /u01/software/18178044/
 [oracle@ap02 18178044]$  /u01/app/oracle/middleware/fr_home/OPatch/opatch apply
Oracle Interim Patch Installer version 11.1.0.9.11
Copyright (c) 2013, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/middleware/fr_home
Central Inventory : /home/oracle/oraInventory
   from           : /u01/app/oracle/middleware/fr_home/oraInst.loc
OPatch version    : 11.1.0.9.11
OUI version       : 11.1.0.9.0
Log file location : /u01/app/oracle/middleware/fr_home/cfgtoollogs/opatch/18178044_Aug_11_2015_13_59_45/apply2015-08-11_13-59-44PM_1.log


OPatch detects the Middleware Home as "/u01/app/oracle/middleware"

Applying interim patch '18178044' to OH '/u01/app/oracle/middleware/fr_home'
Verifying environment and performing prerequisite checks...
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/middleware/fr_home')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...

Patching component oracle.developer.forms.buildapi, 11.1.2.2.0...

Verifying the update...
Patch 18178044 successfully applied
Log file location: /u01/app/oracle/middleware/fr_home/cfgtoollogs/opatch/18178044_Aug_11_2015_13_59_45/apply2015-08-11_13-59-44PM_1.log

OPatch succeeded.