Oracle 9iAS配置运行FORM、Report
Oracle 9iAS配置运行FORM、Report 安装配置应用服务器操作系统安装Oracle 9iAS 企业版① Oracle 9i Application Server Infrastructure ;
其中:Oracle 9iAS Infrastructure Instance Name :ora9ias_is;口令:ora9ias
安装目录:d:\Ora9is
② Oracle 9iAs Application Server (Business Intelligence and Forms) ;
其中:Oracle 9iAS Instance Name :ora9ias;口令:ora9ias
安装目录:d:\Ora9ias
安装应用在D盘新建目录,目录名:apps,reptmp
将所有开发好的.fmx,.mmx,.rdf,.rep拷贝到apps目录下。
配置Oracle FORM Server(表单服务器)No.1修改Oracle Http Server的配置文件:httpd.conf。该文件一般在D:\Ora9ias\Apache\Apache\conf目录下。
1、查找“<IfModule mod_alias.c>”字符串,类似添加:
Alias /apps/ "d:\apps/"
Alias /web_code/ "d:\ora9ias\forms90\java/"
2、添加新的Oracle Http Server 的监听端口:80
查找“Listen 4446”,在其下类似添加:
Listen 80
No.2重新启动Oracle Http Server:在Oracle Enterprise Management web Console 里面
在IE浏览器中地址一般为:http://xxxxx:1810/
注意:该地址与安装oracle9ias的主机名有关。
用户名:ias_admin;密码:xxxxxx(既用户在安装ora9ias时输入的密码)
在Application Server:ora9ias.xxxxx的系统组件中选中“Http Server”,点击【重新启动】按钮,按提示操作。
测试Oracle Http server:http://xxxxx
No.3 打开位于d:\ora9ias\Forms90\server 目录下面的Formsweb.cfg 文件,在文件的末尾添加以下内容:[apps]
envFile=apps.env
form=logon.fmx(注意:这里是你的form应用的入口程序)
No.4 在d:\ora9ias\Forms90\server 目录下面 新建一个环境文件:apps.env 。该文件的内容如下:ORACLE_HOME=D:\ora9ias
FORMS90_PATH=D:\ora9ias\forms90; D:\apps
PATH=D:\ora9ias\bin;D:\ora9ias\jdk\jre\bin\server
GRAPHICS60_PATH= D:\apps
FORMS90_TRACE_PATH=D:\ora9ias\forms90\server
FORMS90=D:\ora9ias\forms90
CLASSPATH=D:\ora9ias\jlib\debugger.jar;D:\ora9ias\jlib\ewt3.jar;D:\ora9ias\jlib\share.jar;D:\ora9ias\jlib\utj90.jar;D:\ora9ias\forms90\java\f90jdapi.jar
REPORTS_CLASSPATH=D:\ora9ias\jlib\zrclient.jar;D:\ora9ias\reports\jlib\rwrun.jar
NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
No.5在注册表里面的HKEY_LOCAL_MACHINE\ORACLE\HOME1,添加以下的内容: FORMS90_PATH d:\apps
REPORTS_PATH d:\apps
REPORTS_TMP d:\REPTMP
No.6拷贝jinit1319.exe:在apps目录下面新建JINITIATOR目录,拷贝jinit1319 .exe 文件到该目录;
No.7设置程序的入口:新建index.htm,并修改其中的内容,修改后的内容如下:
<HTML>
<HEAD><TITLE>应用名称</TITLE></HEAD>
<BODY BGCOLOR="#FFFFFF" >
<FONT FACE="Verdana, Arial, Helvetica" SIZE=2>
<div align="center">
<center>
<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH=100% height="100%">
<TR>
<TD BGCOLOR="#FFFFFF" COLSPAN=1 ROWSPAN=1 VALIGN="middle" align="center"><img border="0" src="http://doc.readmen.com/9/apps.jpg"></TD>
</TR>
</TABLE>
</center>
</div>
<P>
<!-- Forms applet definition (start) -->
<OBJECT classid="clsid:CAFECAFE-0013-0001-0009-ABCDEFABCDEF"
codebase="http://xxxxx:7780/apps/jinitiator/jinit1319.exe#Version=1,3,1,9"
WIDTH="1024"
HEIGHT="740"
HSPACE="0"
VSPACE="0">
<PARAM NAME="TYPE" VALUE="application/x-jinit-applet;version=1.3.1.9">
<PARAM NAME="CODEBASE" VALUE="/forms90/java">
<PARAM NAME="CODE" VALUE="oracle.forms.engine.Main" >
<PARAM NAME="ARCHIVE" VALUE="/web_code/f90all_jinit.jar" >
<PARAM NAME="serverURL" VALUE="/forms90/l90servlet?ifcfs=/forms90/f90servlet?config=apps">
<PARAM NAME="networkRetries" VALUE="2">
<PARAM NAME="serverArgs"
VALUE="module=logon.fmx">
<PARAM NAME="separateFrame" VALUE="true">
<PARAM NAME="splashScreen" VALUE="no">
<PARAM NAME="lookAndFeel" VALUE="Oracle">
<PARAM NAME="colorScheme" VALUE="titanium">
<PARAM NAME="serverApp" VALUE="apps">
<COMMENT>
<EMBED type="application/x-jinit-applet;version=1.3.1.9"
java_CODE="oracle.forms.engine.Main"
java_CODEBASE="/forms90/java/"
java_ARCHIVE="/web_code/f90all_jinit.jar"
WIDTH=1024
HEIGHT=740
serverURL="/forms90/l90servlet?ifcfs=/forms90/f90servlet?config=apps"
serverArgs="module=logon.fmx"
serverApp="apps"
lookAndFeel="oracle"
colorScheme="Titanium">
<!-- java_showprogress="true" -->
splashScreen="no"
background="7backgr.gif"
separateFrame="true"
<!-- latencycheck="true"-->
pluginspage="http://xxxxx/jinit/doc/us/jinit_download.htm">
<NOEMBED>
</COMMENT>
</NOEMBED></EMBED>
</OBJECT>
<!-- Forms applet definition (end) -->
</BODY>
</HTML>
No.8设置连接数据库的别名:在该Oracle_Home 下面新建一个Net8 别名,你应用中所用的连接字符串
No.9重新启动服务器;No.10访问:通过http://xxxxx/apps/index.htm可以访问到洗选中心调度报表系统。
配置Oracle Report Server(报表服务器) No.1安装: 这里的rep_apps在安装时已经建立,你需要进入OEM WEB Console查看
在服务器端运行:rwserver –install rep_apps autostart=yes
No.2配置config文件:修改d:\ora9ias\reports\conf目录下面的rep_apps.conf 文件。
<?xml version = '1.0' encoding = 'ISO-8859-1'?>
<!DOCTYPE server PUBLIC "-//Oracle Corp.//DTD Reports Server Configuration //EN" "file:/D:/ora9ias/reports/dtd/rwserverconf.dtd">
<server>
<!--compatible version="6i"/-->
<cache style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-layout-grid-align: none" align=left <property name="cacheSize" value="500"/>
<property name="cacheDir" value="d:\ora9ias\reports\cache"/>
<!--property name="maxCacheFileNumber" value="max number of cache files"/-->
<!--property name="ignoreParameters" value="parameter names to be ignored in constructing cache key, separated by comma ','"/-->
</cache>
<!--Please do not change the id for reports engine.-->
<!--The class specifies below is subclass of _EngineClassImplBase and implements EngineInterface.-->
<engine id="rwEng" initEngine="1" maxEngine="20" minEngine="1" engLife="20" maxIdle="30" callbackTimeOut="60000" engineResponseTimeOut="15">
<property name="sourceDir" value="d:\apps"/>
<property name="tempDir" value="d:\reptmp"/>
</engine>
<!--environment id="rwEnvId"-->
<!--envVariable name="NLS_LANG" value="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"/-->
<!--/environment-->
<!--engine id="rwURLEng" initEngine="1" maxEngine="20" minEngine="1" engLife="5" maxIdle="30" callbackTimeOut="60000"/-->
<job jobType="report" engineId="rwEng"/>
<!--job jobType="rwurl" engineId="rwURLEng"/-->
<notification id="mailNotify" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-layout-grid-align: none" align=left <property name="succnotefile" value="succnote.txt"/>
<property name="failnotefile" value="failnote.txt"/>
</notification>
<log option="AllJobs"/>
<!--jobStatusRepository style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-layout-grid-align: none" align=left <property name="repositoryConn" value="repo_db_username/repo_db_password@repo_db_tnsname" confidential="yes" encrypted="no"/>
</jobStatusRepository-->
<!--trace traceOpts="trace_all"/-->
<connection maxConnect="20" idleTimeOut="15">
<orbClient id="RWClient" publicKeyFile="clientpub.key"/>
<cluster publicKeyFile="serverpub.key" privateKeyFile="serverpri.key"/>
</connection>
<queue maxQueueSize="10000"/>
<!--identifier confidential="yes" encrypted="no">scott/tiger</identifier-->
<!--pluginParam name="mailServer">%MAILSERVER_NAME%</pluginParam-->
<!--pluginParam name="proxy" type="file">proxyinfo.xml</pluginParam-->
<pluginParam name="xmlpds" type="file">xmlpds.conf</pluginParam>
<pluginParam name="jdbcpds" type="file">jdbcpds.conf</pluginParam>
<pluginParam name="textpds" type="file">textpds.conf</pluginParam>
<identifier confidential="yes" encrypted="yes">RwZAGU2vKUvL19/Y3BmVEg==</identifier>
</server>
No.3重新启动服务器; No.4测试报表服务器;通过以下的地址测试Report Server是否正确安装,
http://xxxxx/reports/rwservlet/showenv?server=rep_apps
如果用http://xxxxx不能访问,可能只能用IP地址访问。