Oracle 9ias Configuration Run Form, Report

xiaoxiao2021-03-06  46

Installation Configuration Application Server Operating System

Install Oracle 9ias Enterprise Edition

1 Oracle 9i Application Server INFRASTRUCTRURE;

Among them: Oracle 9ias Infrastructure Instance Name: Ora9ias_IS; Password: Ora9ias

Installation directory: d: / ora9is

2 Oracle 9ias Application Server (Business Intelligence and Forms);

Among them: Oracle 9ias Instance Name: Ora9ias; Password: Ora9ias

Installation directory: d: / ora9ias

Installation application

New directory in D disk, directory name: apps, reptmp

Copy all developed .fmx, .mmx, .rdf, .rep to the apps directory.

Configure Oracle Form Server (Form Server)

NO.1 Modify the configuration file of Oracle Http Server: httpd.conf.

This file is usually in the D: / Ora9ias / Apache / Apache / Conf directory.

1. Find "" string, similar to add:

Alias ​​/ Apps / "D: / Apps /"

Alias ​​/ Web_code / "D: / Ora9ias / Forms90 / Java /"

2, add new Oracle HTTP Server listening port: 80

Find "Listen 4446" and add:

Listen 80

No.2 Restart Oracle HTTP Server:

Inside Oracle Enterprise Management Web Console

The address in the IE browser is generally: http: // xxxxx: 1810 /

Note: This address is related to the host name of the installation Oracle9IAS.

Username: IAS_ADMIN; Password: XXXXXX (password entered between users when installed ORA9IAS)

In the system component of Application Server: Ora9ias.xxxx, "HTTP Server" is selected, click the [Restart] button, and press the prompt.

Test Oracle Http Server: http: // xxxxx

No. 3 Opens the formSweb.cfg file below the D: / Ora9ias / Forms90 / Server directory, add the following: Add the following:

[apps]

Envfile = apps.env

Form = logon.fmx (Note: Here is the entrance program for your Form application)

NO.4 New Environment Files below D: / Ora9ias / Forms90 / Server directory: Apps.env. The content of this file is as follows:

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 in the registry, add the following content:

Forms90_path d: / apps

Reports_path D: / apps

Reports_TMP D: / RePTMP

No.6 copy jinit1319.exe:

Copy the JINITIATOR directory below the apps directory, copy the jinit1319 .exe file to this directory;

NO.7 setup program's entry:

Create new index.htm, and modify the content, the modified content is as follows:

Application Name </ Title> </ HEAD></p> <p><Body bgcolor = "# ffffff"></p> <p><Font face = "Verdana, Arial, Helvetica" Size = 2></p> <p><div align = "center"></p> <p><center></p> <p><Table border = 0 cellpadding = 0 Cellspacing = 0 width = 100% height = "100%"></p> <p><Tr></p> <p><TD BGCOLOR = "# ffffff" colspan = 1 rowspan = 1 valign = "middle" align = "center"> <img border = "0" src = "apps.jpg"> </ td></p> <p></ TR></p> <p></ TABLE></p> <p></ center></p> <p></ div></p> <p><P></p> <p><! - forms applet definition (start) -></p> <p><Object classid = "CLSID: cafecafe-0013-0001-0009-abcdefabcdef"</p> <p>Codebase = "http: // xxxxx: 7780 / apps / jinitiator / jinit1319.exe # version = 1, 3, 1, 9"</p> <p>Width = "1024"</p> <p>HEIGHT = "740"</p> <p>HSPACE = "0"</p> <p>VSpace = "0"></p> <p><Param name = "type" value = "Application / X-jinit-applet; version = 1.3.1.9"></p> <p><Param name = "codebase" value = "/ forms90 / java"></p> <p><Param name = "code" value = "oracle.forms.Engine.main> <param name =" archive "value =" / web_code / f90all_jinit.jar "></p> <p><Param name = "serverURL" value = "/ formfs90 / limited"></p> <p><Param name = "networkretries" value = "2"></p> <p><Param name = "serveraggs"</p> <p>Value = "Module = logon.fmx"></p> <p><Param name = "separateframe" value = "true"></p> <p><Param name = "splashscreen" value = "no"></p> <p><Param name = "lookandfeel" value = "Oracle"></p> <p><Param name = "colorscheme" value = "titanium"></p> <p><Param name = "serverapp" value = "apps"></p> <p><Comment></p> <p><Embed Type = "Application / X-JINIT-Applet; Version = 1.3.1.9"</p> <p>Java_code = "Oracle.Forms.Engine.main"</p> <p>Java_codebase = "/ forms90 / java /"</p> <p>Java_archive = "/ Web_code / f90all_jinit.jar"</p> <p>Width = 1024</p> <p>HEIGHT = 740</p> <p>ServerURL = "/ forms90 / l90servlet? IFCFS = / forms90 / f90servlet? config = apps"</p> <p>Serverargs = "Module = logon.fmx"</p> <p>ServerApp = "apps"</p> <p>LOOKANDFEEL = "Oracle"</p> <p>Colorscheme = "Titanium"></p> <p><! - java_showprogress = "true" -></p> <p>Splashscreen = "no"</p> <p>Background = "7backgr.gif"</p> <p>SeparateFrame = "True"</p> <p><! - latencyCheck = "true" -></p> <p>Pluginspage = "http://xxxx/jinit/doc/us/jinit_download.htm"></p> <p><Noembed></p> <p></ Comment></p> <p></ Noembed> </ embed></p> <p></ Object></p> <p><! - Forms Applet Definition (End) -> </ body></p> <p></ Html></p> <p>No.8 Set the alias that connects the database:</p> <p>In this oracle_home, next to a new NET8 alias, the connection string used in your application</p> <p>NO.9 Restart the server;</p> <p>NO.10 Access:</p> <p>Access to the washing center scheduling report system via http: //xxxxx/APPS/index.htm.</p> <p>Configure Oracle Report Server (Report Server)</p> <p>NO.1 installation:</p> <p>The rep_apps here has been established when installing, you need to enter OEM Web Console</p> <p>Run on the server: rwserver -install rep_apps autostart = yes</p> <p>No.2 Configuring config files:</p> <p>Modify the rep_apps.conf file below the D: / ORA9IAS / Reports / Conf directory.</p> <p><? XML Version = '1.0' encoding = 'ISO-8859-1'?></p> <p><! Doctype server public "- // Oracle Corp.//dtd Reports Server Configuration // En" File: / D: /ora9ias/reports/dtd/rwserverconf.dtd "></p> <p><server></p> <p><! - Compatible Version = "6i" / -></p> <p><cache class = "oracle.reports.cache.rwcache"></p> <p><proty name = "cachesize" value = "500" /></p> <p><Property Name = "Cachedir" Value = "D: / Ora9ias / Reports / Cache" /></p> <p><! - proty name = "maxcachefilenumber" value = "max number of cache files" / -></p> <p><! - proty name = "ignoreparameters" value = "parameter names to be ion, sepated by comma ','" / -></p> <p></ cache></p> <p><! - please do not change the id for reports engine .--></p> <p><! - The class specifies Below is Subclass of _EngineClassImplbase and ustements EngineInterface .--></p> <p><engine id = "rweng" class = "oracle.reports.Engine.EngineImpl" initengine = "1" maxngine = "20" minengine = "1" eNGLIFE = "20" maxidle = "30" callbacktimeout = "60000" engineeresponsetimeout = "15"> <property name = "SourceDir" value = "d: / apps" /></p> <p><Property Name = "Tempdir" Value = "D: / ReptMP" /></p> <p></ engine></p> <p><! - Environment id = "rwenvid" -></p> <p><! - envvariable name = "nls_lang" value = "simplified chinese_china.zhs16GBK" / -></p> <p><! - / environment -></p> <p><! - engine id = "rwurleng" class = "oracle.reports.urlengine.urlengineImpl" initengine = "1" maxngine = "20" MINENGINE = "1" eNGLIFE = "5" maxidle = "30" callbacktimeout = "60000 "/ -></p> <p><jobtype = "report" EngineID = "rweng" /></p> <p><! - jobtype = "rwurl" EngineID = "rwurplay" / -></p> <p><Notification ID = "Mailnotify" class = "Oracle.reports.server.mailnotify"></p> <p><Property Name = "succnotefile" value = "succnote.txt" /></p> <p><property name = "failNotefile" value = "failnote.txt" /></p> <p></ notification></p> <p><logbo = "alljobs" /></p> <p><! - jobStatusRepository class = "Oracle.reports.server.jobrepositorydb"></p> <p><Property Name = "repositoryConn" value = "repo_db_username / repo_db_password @ repo_db_tnsname" confidential = "yes" encrypted = "no" /></p> <p></ jobstatusrepository -></p> <p><! - trace traceopts = "trace_all" / -> <connection maxconnect = "20" idletimeout = "15"></p> <p><orbclient id = "rwclient" publickeyfile = "clientpub.key" /></p> <p><cluster publickeyfile = "serverpub.key" privatekeyfile = "serverpri.key" /></p> <p></ connection></p> <p><queue maxueuesize = "10000" /></p> <p><! - identifier confidential = "yes" encrypted = "no"> scott / tiger </ identifier -></p> <p><! - pluginparam name = "mailserver">% mailserver_name% </ pluginparam -></p> <p><! - pluginparam name = "proxy" type = "file"> proxyinfo.xml </ pluginparam -></p> <p><pluginparam name = "xmlpds" type = "file"> xmlpds.conf </ pluginparam></p> <p><pluginparam name = "jdbcpds" type = "file"> jdbcpds.conf </ pluginparam></p> <p><Pluginparam name = "textpds" type = "file"> textpds.conf </ pluginparam></p> <p><Identifier Confidential = "YES" Encrypted = "YES"> rwzagu2vkuvl19 / y3bmveg == </ identifier></p> <p></ server></p> <p>NO.3 Restart the server;</p> <p>No.4 Test Report Server;</p> <p>Test whether the Report Server is installed by the following address.</p> <p>http: // xxxxx / reports / rwservlet / showenv? Server = rep_apps</p> <p>If you cannot access by http: // xxxxx, you may only use IP address to access.</p></div><div class="text-center mt-3 text-grey"> 转载请注明原文地址:https://www.9cbs.com/read-81252.html</div><div class="plugin d-flex justify-content-center mt-3"></div><hr><div class="row"><div class="col-lg-12 text-muted mt-2"><i class="icon-tags mr-2"></i><span class="badge border border-secondary mr-2"><h2 class="h6 mb-0 small"><a class="text-secondary" href="tag-2.html">9cbs</a></h2></span></div></div></div></div><div class="card card-postlist border-white shadow"><div class="card-body"><div class="card-title"><div class="d-flex justify-content-between"><div><b>New Post</b>(<span class="posts">0</span>) </div><div></div></div></div><ul class="postlist list-unstyled"> </ul></div></div><div class="d-none threadlist"><input type="checkbox" name="modtid" value="81252" checked /></div></div></div></div></div><footer class="text-muted small bg-dark py-4 mt-3" id="footer"><div class="container"><div class="row"><div class="col">CopyRight © 2020 All Rights Reserved </div><div class="col text-right">Processed: <b>0.036</b>, SQL: <b>9</b></div></div></div></footer><script src="./lang/en-us/lang.js?2.2.0"></script><script src="view/js/jquery.min.js?2.2.0"></script><script src="view/js/popper.min.js?2.2.0"></script><script src="view/js/bootstrap.min.js?2.2.0"></script><script src="view/js/xiuno.js?2.2.0"></script><script src="view/js/bootstrap-plugin.js?2.2.0"></script><script src="view/js/async.min.js?2.2.0"></script><script src="view/js/form.js?2.2.0"></script><script> var debug = DEBUG = 0; var url_rewrite_on = 1; var url_path = './'; var forumarr = {"1":"Tech"}; var fid = 1; var uid = 0; var gid = 0; xn.options.water_image_url = 'view/img/water-small.png'; </script><script src="view/js/wellcms.js?2.2.0"></script><a class="scroll-to-top rounded" href="javascript:void(0);"><i class="icon-angle-up"></i></a><a class="scroll-to-bottom rounded" href="javascript:void(0);" style="display: inline;"><i class="icon-angle-down"></i></a></body></html><script> var forum_url = 'list-1.html'; var safe_token = 'jbwrrjYd_2B94MN81bJszX_2FKI446ZOp2PCR9vluF3w1DtQrctYeBt59YMLXRi4dYfUgpWwyggUdxYnIlNXigRiRw_3D_3D'; var body = $('body'); body.on('submit', '#form', function() { var jthis = $(this); var jsubmit = jthis.find('#submit'); jthis.reset(); jsubmit.button('loading'); var postdata = jthis.serializeObject(); $.xpost(jthis.attr('action'), postdata, function(code, message) { if(code == 0) { location.reload(); } else { $.alert(message); jsubmit.button('reset'); } }); return false; }); function resize_image() { var jmessagelist = $('div.message'); var first_width = jmessagelist.width(); jmessagelist.each(function() { var jdiv = $(this); var maxwidth = jdiv.attr('isfirst') ? first_width : jdiv.width(); var jmessage_width = Math.min(jdiv.width(), maxwidth); jdiv.find('img, embed, iframe, video').each(function() { var jimg = $(this); var img_width = this.org_width; var img_height = this.org_height; if(!img_width) { var img_width = jimg.attr('width'); var img_height = jimg.attr('height'); this.org_width = img_width; this.org_height = img_height; } if(img_width > jmessage_width) { if(this.tagName == 'IMG') { jimg.width(jmessage_width); jimg.css('height', 'auto'); jimg.css('cursor', 'pointer'); jimg.on('click', function() { }); } else { jimg.width(jmessage_width); var height = (img_height / img_width) * jimg.width(); jimg.height(height); } } }); }); } function resize_table() { $('div.message').each(function() { var jdiv = $(this); jdiv.find('table').addClass('table').wrap('<div class="table-responsive"></div>'); }); } $(function() { resize_image(); resize_table(); $(window).on('resize', resize_image); }); var jmessage = $('#message'); jmessage.on('focus', function() {if(jmessage.t) { clearTimeout(jmessage.t); jmessage.t = null; } jmessage.css('height', '6rem'); }); jmessage.on('blur', function() {jmessage.t = setTimeout(function() { jmessage.css('height', '2.5rem');}, 1000); }); $('#nav li[data-active="fid-1"]').addClass('active'); </script>