PARAMETRI ZA PROMENU KONEKCIJE NA DRUGU BAZU ILI MENJANJE PASSWORD a
ako se `kacimo` na drugu bazu potrebno je uraditi sledeca 3 koraka
$ORACLE_HOME/network/admin/tnsname.ora --- dodati connection string za bazu na koju se kacimo
$ORACLE_HOME/forms/app.ini --- parametri za bazu na koju se kacimo
$ORACLE_HOME/reports/conf/cgicmd.dat --- zadnja linija poseduje connection parameter
ERP.war --- edituj *.xml na bazu koju se kacis
i naravno potrebno je iskopirati forme
PODESAVANJE APPLICATION SERVERA
podesi prvo .bash_profile
Podesi file tnsname.ora koji se nalazi
$ORACLE_HOME/network/admin/tnsname.ora ---sluzi da bi appsrv mogao da se poveze sa bazom i izgleda ovako
(primer) >>> POGLEDAJ SLIKU <<<
============================================================
# tnsnames.ora Network Configuration File: /oracle/as10g/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
REP_APPSRV134_AS10G.KNJAZ.CO.SR =
(ADDRESS = (PROTOCOL = tcp)(HOST = appsrv134)(PORT = 1950))
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = appsrv134.knjaz.co.sr)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)
knjaz11 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 10.1.11.100)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = knjaz11)
)
)
razvoj2015 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 10.1.11.166)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = razvoj2015)
)
)
==============================================================
Napomena: boldirani text se menja u zavisnosti od parametara za koju bazu radite
( HOSTS se setuje kada se podesava network card na OS )
$ORACLE_HOME/forms/app.ini ---ovaj file izvorno ne stoji na ovom mestu ---napravi ga--- i izgleda ovako >>> VIDI <<<
(primer)
======================
[KNJAZ11]
user=ops$ta*******
password=k*******
database=knjaz11
rep_key=key_knjaz
======================
[RAZVOJ_11g2]
user=ops$ta*******
password=raz15
database=razvoj2015
rep_key=key_knjaz
======================
PODESAVANJE PARAMETARA VEZANIH ZA FORMS SERVER
$ORACLE_HOME/forms/server/formsweb.cfg ---sadrzi parametre vezane za izgled od mnogih opcija bitno je promeniti sledece
kompletna podesavanja formsweb.cfg snimljeni u PDF >>>
[webutil]
WebUtilArchive=frmwebutil.jar,jacob.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
baseHTMLjinitiator=webutiljini.htm
baseHTMLjpi=webutiljpi.htm
archive_jini=frmall_jinit.jar,unifor.jar
archive=frmall.jar,unifor.jar
lookAndFeel=oracle
[knjaz]
WebUtilArchive=frmwebutil.jar,jacob.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
baseHTMLjinitiator=webutiljpi.htm
baseHTMLjpi=webutiljpi.htm
archive_jini=frmall_jinit.jar
archive=frmall.jar,unifor.jar,osb.jar,uk.co.mmscomputing.device.twain.jar,iText-2
.1.7.jar
lookAndFeel=oracle
$ORACLE_HOME/forms/server/default.env ---sadrzi podatke o putanjama koje koristi appsrv >> VIDI SLIKU <<
(primer)
==================================================================================================================
# $Id: default.env 26-apr-2005.16:59:08 sujain Exp $
# default.env - default Forms environment file, Solaris version
#
# This file is used to set the Forms runtime environment parameters.
# If a parameter is not defined here, the value used will be that defined
# in the environment in which the servlet engine (OC4J or JServ) was started.
#
# NOTES
# 1/ The Forms installation process should replace all occurrences of
# <percent>FORMS_ORACLE_HOME<percent> with the correct ORACLE_HOME
# setting, and all occurrences of <percent>O_JDK_HOME<percent> with
# the location of the JDK (usually $ORACLE_HOME/jdk).
# 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.
#
NLS_LANG=AMERICAN_AMERICA.AL32UTF8
ORACLE_HOME=/oracle/as10g
#
# Search path for Forms applications (.fmx files, PL/SQL libraries)
#
FORMS_PATH=/oracle/as10g/forms:/oracle/iis/AD:/oracle/iis/AP:/oracle/iis/CM:/oracle/iis/CO:/oracle/iis/ARH:/oracle/iis/FN:/oracle/iis/NB:/oracle/iis/OD:/oracle/iis/PL:/oracle/iis/PM:/oracle/iis/PR2:/oracle/iis/PZ:/oracle/iis/PZ2:/oracle/iis/RO:/oracle/iis/TR:/oracle/iis/ZA2
# webutil config file path
WEBUTIL_CONFIG=/oracle/as10g/forms/server/webutil.cfg
# Disable/remove this variable if end-users need access to the query-where
# functionality which potentially allows them to enter arbitrary SQL
# statements when in enter-query mode.
FORMS_RESTRICT_ENTER_QUERY=FALSE
# Java class path
# This is required for the Forms debugger
# You can append your own Java code here)
# frmsrv.jar, repository.jar and ldapjclnt10.jar are required for
# the password expiry feature to work(#2213140).
#
CLASSPATH=/oracle/as10g/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar:/oracle/as10g/jlib/repository.jar:/oracle/as10g/jlib/ldapjclnt10.jar:/oracle/as10g/jlib/debugger.jar:/oracle/as10g/jlib/ewt3.jar:/oracle/as10g/jlib/share.jar:/oracle/as10g/jlib/utj.jar:/oracle/as10g/jlib/zrclient.jar:/oracle/as10g/reports/jlib/rwrun.jar:/oracle/as10g/forms/java/frmwebutil.jar
#
# The PATH setting is not required for Forms if the Forms executables are
# in <ORACLE_HOME>/bin. However, it is required if Graphics applications
# are called from Forms applications.
#
PATH=/oracle/as10g/bin
#
# Settings for Reports
# -------------------------------
# NOTE: This setting is only needed if Reports applications
# are called from Forms applications
# However, because of bug 2336698 where a report is started from
# a forms debugger session with an already running JVM, then
# the report's class path should also be included in the forms
# class path.
# We no longer need to set REPORTS_CLASSPATH as forms will
# always start the JVM before calling reports.
#
#
# Settings for Graphics
# -------------------------------
# NOTE: These settings are only needed if Graphics applications
# are called from Forms applications
#
#
# Please uncomment the following and put the correct 6i
# oracle_home value to use Graphics applications.
#
#ORACLE_GRAPHICS6I_HOME=<your Graphics 6i oracle_home here>
#
# Search path for Graphics applications
#
GRAPHICS60_PATH=
#
# Settings for Forms tracing and logging
# -----------------------------------------------
# Note: This entry has to be uncommented to enable tracing and
# logging.
#FORMS_TRACE_PATH=<FORMS_ORACLE_HOME>/forms/server
#
# System settings
# ---------------
# You should not normally need to modify these settings
#
#
# Path for shared library objects
# This is highly platform (if not machine) specific ! At install time
# <percent>LD_LIBRARY_PATH<percent> should be replaced with the
# actual value of the LD_LIBRARY_PATH environment variable (at install
# time). That should ensure we have the paths for such necessities as
# the motif and X11 libraries.
# Explanations:
# - Reports needs the path for libjava.so
# (.../jre/lib/sparc)
# - Forms needs two paths to the jre, for libjvm.so and libhpi.so
# - In JDK 1.4.1 the location of libjvm.so is lib/sparc (there is no
# classic directory) so we do not include the .../classic directory
# below. There are other versions of libjvm.so (in directories server,
# client and hotspot) but we will use the version in lib/sparc for now.
#
LD_LIBRARY_PATH=/oracle/as10g/lib:/oracle/as10g/jdk/jre/lib/i386:/oracle/as10g/jdk/jre/lib/i386/server:/oracle/as10g/jdk/jre/lib/i386/native_threads:/tmp/OraInstall2009-04-30_01-37-17PM/jre/1.4.2/lib/i386/client:/tmp/OraInstall2009-04-30_01-37-17PM/jre/1.4.2/lib/i386:/tmp/OraInstall2009-04-30_01-37-17PM/jre/1.4.2/../lib/i386:/usr/lib
==================================================================================================================
$ORACLE_HOME/forms/java/oracle/forms/registry/Registry.dat file u kome se naznacuje koje ce se boje koristiti font za forms itd.
Default.fontMap.defaultSize=850 ----smanjuje font da bi bio pregledan meni
Default.icons.iconpath=ico - naznacujes formsu da ces koristiti male slicice sa ico extenziom
App.ui.lovButtons=true - sluzi da se prikazu LOV dugmici na formama
App.ui.requiredFieldVA=true - sluzi da se naznace na formama obavezna polja
App.ui.requiredFieldVABGColor=255.255.0 - naznacuje boju obaveznih polja
Parametri su sledeci: >> VIDI SLIKU <<
===================================================================================================================================
oracle.classById.271=oracle.forms.handler.JavaContainer
oracle.classById.272=oracle.forms.handler.TabControl
oracle.classById.273=oracle.forms.handler.ComboBoxItem
oracle.classById.274=oracle.forms.handler.TreeItem
oracle.classById.281=oracle.forms.handler.PopupHelpItem
#
# Defaults for the Font details, all names are Java Font names. Each of
# these parameters represents the default property to use when none is
# specified.
#
# defaultFontname represents the default Java fontName.
# defaultSize represents the default fontSize. Note that the size is
# multiplied by 100 (e.g. a 10pt font has a size of 1000).
# defaultStyle represents the default fontStyle, PLAIN or ITALIC.
# defaultWeight represents the default fontWeight, PLAIN or BOLD.
#
default.fontMap.defaultFontname=Dialog
default.fontMap.defaultSize=850
default.fontMap.defaultStyle=PLAIN
default.fontMap.defaultWeight=PLAIN
#
# Default Font Face mapping.
#
# appFontname represents a comma delimited list of Application Font Names.
# javaFontname represents a comma delimited list of Java Font Names.
#
# The number of entries in the appFontname list should match the number in
# the javaFontname list. The elements of the list are comma separated and
# *all* characters are taken literally, leading and trailing spaces are
# stripped from Face names.
#
# Note that this file uses the Java 1.1 Font names in order to be able to
# handle the NLS Plane (BUG #431051)
#
default.fontMap.appFontnames=Courier New,Courier,courier,System,Terminal,Fixed,Fixedsys,Times,Times New Roman,MS Sans Serif,Arial
default.fontMap.javaFontnames=MonoSpaced,MonoSpaced,MonoSpaced,Dialog,MonoSpaced,Dialog,Dialog,Serif,Serif,Dialog,SansSerif
#
# The Application Level icon files are relative to the DOCUMENTBASE
# example: icons/
# or an absolute URL.
# example: http://www.forms.net/~luser/d2k_project/
#
default.icons.iconpath=http://10.1.11.134:7778/forms/java/ico/
default.icons.iconextension=gif
#
# Application level settings to control UI features
#
app.ui.lovButtons=true
app.ui.requiredFieldVA=true
# The background color is specified as an RGB triple.
app.ui.requiredFieldVABGColor=255,255,0
===================================================================================================================================
-
/oracle/as10g/forms/admin/resource/US/fmrweb.res
-
$ORACLE_HOME/forms/admin/resource/US/fmrweb_utf8.res
Ova dva fajla treba preimenovati u nesto drugo: kao na primer
fmrweb.res.orig
fmrweb_utf8.res.orig
A zatim druga dva fajla koja se zovu:
fmrpcweb.res
fmrpcweb_utf8.res
Preimenovati tako da dobiju imena
fmrweb.res
fmrweb_utf8.res
rep_hostname_ASsid.conf sam preimenovao preko WINSCP-a u rep_appsrv134_as10g.conf
$ORACLE_HOME/reports/conf/rep_hostname_ASsid.conf --- ovaj file je najbitniji za report server i u njegovom nazivu su hostname servera kao i sid appsrv koji smo instalirali i tu se podesavaju putanje u kojima se nalaze reporti i to u sledecoj liniji:
======================================================================================================================== <?xml version = '1.0' encoding = 'ISO-8859-1'?>
<!DOCTYPE server PUBLIC "-//Oracle Corp.//DTD Reports Server Configuration //EN" "file:/home/oracle/oracleas_10g/reports/dtd">
<server version="10.1.2.0.2">
<!--Please do not change the id for reports engine.-->
<!--The class specifies below is subclass of _EngineClassImplBase and implements EngineInterface.-->
<cache class="oracle.reports.cache.RWCache">
<property name="cacheSize" value="300"/>
<!--property name="cacheDir" value="your cache directory"-->
<!--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>
<engine id="rwEng" class="oracle.reports.engine.EngineImpl" initEngine="3" maxEngine="15" minEngine="1" engLife="200" maxIdle="30" callbackTimeOut="90000">
<property name="sourceDir" value="/oracle/iis/AD:/oracle/iis/AP:/oracle/iis/CM:/oracle/iis/ARH:/oracle/iis/CO:/oracle/iis/FN:/oracle/iis/NB:/oracle/iis/OD:/oracle/iis/PL:/oracle/iis/PM:/oracle/iis/PR2:/oracle/iis/PZ:/oracle/iis/PZ2:/oracle/iis/RO:/oracle/iis/RO/report:/oracle/iis/TR/report:/oracle/iis/PZ/report:/oracle/iis/TR:/oracle/iis/ZA2"/>
<!--property name="tempDir" value="your reports temp directory"/-->
<!--property name="keepConnection" value="yes"/-->
</engine>
<engine id="rwURLEng" class="oracle.reports.urlengine.URLEngineImpl" initEngine="1" maxEngine="1" minEngine="0" engLife="50" maxIdle="30" callbackTimeOut="60000"/>
<!--security id="rwSec" class="oracle.reports.server.RWSecurity">
<property name="securityUserid" value="%PORTAL_DB_USERNAME%/%PORTAL_DB_PASSWORD%@%PORTAL_DB_TNSNAME%" confidential="yes" encrypted="no"/>
<property name="oidEntity" value="%REPORTS_OID_ENTITY%"/>
</security-->
<!--destination destype="oraclePortal" class="oracle.reports.server.DesOraclePortal">
<property name="portalUserid" value="%PORTAL_DB_USERNAME%/%PORTAL_DB_PASSWORD%@%PORTAL_DB_TNSNAME%" confidential="yes" encrypted="no"/>
</destination-->
<destination destype="ftp" class="oracle.reports.plugin.destination.ftp.DesFTP">
<!--property name="proxy" value="proxyinfo.xml"/-->
</destination>
<destination destype="WebDav" class="oracle.reports.plugin.destination.webdav.DesWebDAV">
<!--property name="proxy" value="proxyinfo.xml"/-->
</destination>
<!-- By default server will use rwnetwork.conf as network config file
Use this element to override the same -->
<!--networkConfig file="rwnetwork.conf"></networkConfig-->
<job jobType="report" engineId="rwEng"/>
<job jobType="rwurl" engineId="rwURLEng"/>
<notification id="mailNotify" class="oracle.reports.server.MailNotify">
<property name="succnotefile" value="succnote.txt"/>
<property name="failnotefile" value="failnote.txt"/>
</notification>
<!--notification id="wfNotify" class="oracle.reports.server.WorkflowNotify">
<property name="connStr" value="%WF_DB_USERNAME%/%WF_DB_PASSWORD%@%WF_DB_TNSNAME%" confidential="yes" encrypted="no"/>
</notification-->
<log option="noJob"/>
<!--jobStatusRepository class="oracle.reports.server.JobRepositoryDB">
<property name="repositoryConn" value="repo_db_username/repo_db_password@repo_db_tnsname" confidential="yes" encrypted="no"/>
</jobStatusRepository-->
<!--trace traceOpts="trace_all"/-->
<connection maxConnect="200" idleTimeOut="30">
<orbClient id="RWClient" publicKeyFile="clientpub.key"/>
</connection>
<queue maxQueueSize="1000"/>
<!--jobRecovery auxDatFiles="yes"/-->
<!--
The value of the 'identifier' element is encrypted and is of the form SERVERACCESSKEY_USER/SERVERACCESSKEY_PASSWORD
SERVERACCESSKEY_USER and SERVERACCESSKEY_PASSWORD in <server>.conf and targets.xml
file should match for Reports EM pages to display data correctly.
Corresponding entries of username and password in targets.xml:
<Property NAME="Password" VALUE="SERVERACCESSKEY_PASSWORD" ENCRYPTED="FALSE"/>
<Property NAME="UserName" VALUE="SERVERACCESSKEY_USER" ENCRYPTED="FALSE"/>
-->
<identifier confidential="yes" encrypted="yes">ZgZCDkywAUaHwMnb+A6YTgsbUXx9qOFiL5G7P4F1OXmpoabua8hFJ87il54UICHRgBkBKvhcWzQJ9fjHoA4Tp/LAxwQhrXG00odDCWksecuw41NAJpwopXIDBm0G8SyDFlAZ5w1/ozSqZpDSusIoUPacHUYD/vE4e44KnezLLfe8u0ehF1JeR3ditjYN+UHedKnUVcQhNUPIEEWSqCa8boyqUhtRlW40XXrh54fMTUyLyriBed6yT23x/m1NLpMSHDo3RnIDI8ev7tNG5iblp5OoGRNgfQxg8XvfxrR681r7Cpf+gcUf4dwhbNxQaIqmCUcJMNBdd7iOxyMPH68k/FOFoTkRJ3XLVGiNXA4A5QtSu1J3FwwFVtOWCJUmnUy8xjgJmUFQrqHYMssAqzyDaZ9qFQqWEXr0qAa12PKYf0XhOS1luvCf8onT49mclj3vUGxn</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>
</server>
========================================================================================================================
otvori WinSCP
$ORACLE_HOME/reports/conf/rwservlet.properties --- ovde su podesavanja reports servera i najbitnije da su sledeci parametri setovani: >> VIDI SLIKU <<
===================================================================================================================
SERVER_IN_PROCESS=YES
RELOAD_KEYMAP=YES
#DIAGNOSTIC=YES
#TRACEOPTS=TRACE_ALL
#TRACEFILE=rwservlet.trc
#TRACEMODE=TRACE_REPLACE
#SERVER=<reports_server_name>
#IMAGEURL=http://<web_server_name>:<port_num>/reports/rwservlet
KEYMAPFILE=cgicmd.dat
#DBAUTH=RWDBAUTH.HTM
#SYSAUTH=RWSYSAUTH.HTM
#ERRORTEMPLATE=RWERROR.HTM
#COOKIEEXPIRE=30
#ENCRYPTIONKEY=reports9i
#DIAGBODYTAGS=<reports_servlet_help_file_title>
#DIAGHEADTAGS=<reports_servlet_help_file_body_tag>
#HELPURL=<url_of_customized_help_file_for_reports_servlet>
#SINGLESIGNON=YES
OID_ENTITY=%REPORTS_OID_ENTITY%
#ALLOWHTMLTAGS=NO
#REPORTS_NETWORK_CONFIG=rwnetwork.conf
#OIDCON_INIT=10
#OIDCON_INCREMENT=10
#OIDCON_TIMEOUT=0
SERVER=rep_appsrv_oracleas_10g
===================================================================================================================
$ORACLE_HOME/reports/conf/cgicmd.dat --- file koji sadrzi connection string koji koristi reports server (zadnje 2 linije )
bez podesenog fajla , stampa nece da radi
===================================================================================================================
; 1. Multiple keys in this file MUST be separated by an EXTRA empty line.
; 2. Extra spaces are ignored. Multi-line entries allowed.
; 3. Lines starting with ";" character are treated as a comments.
; 4. Comments within a key or key value are NOT allowed.
; 5. NLS language support is provided and can be used (encoding should match the one
; used in HTML request - no language conversion of any kind is attempted.
; 6. For %P special parameter, HTML format is by default mapped to the HTMLTABLE format in this release.
; The HTML format in the future may be mapped to the HTMLCSS format.
;
;;;;;;;;;;;; Example Key Entries
; Example 1: Run a simple breakb report and output to HTML
orqa: report=breakb.rdf destype=cache desformat=html server=repserver
; Example 2: prompt for userid the first time, then use database userid stored in the cookie subsequently.
report_defaultid: report=breakb.rdf destype=cache desformat=html server=repserver
; Example 3: use %D to require user authentication every time
report_secure: report=breakb.rdf destype=cache desformat=html server=repserver %D
; Example 4: Take all arguments from URL and send it to the reports server
run: %*
; Example 5: Run breakb report with HTML parameter form.
breakbparam : report=breakb.rdf destype=cache desformat=html server=repserver userid=scott/tiger@mydb %P
; Example 6: take all URL arguments, and also generate a HTML parameter form
runp: %* %P
; Example 7: Run an Express Report. Replace <MYHOST> with the name of the machine running the Express server. The
; builder on-line help explains the rest of the parameters (the /sl, st etc. etc.)
express: report=my_expr_rep express_server="server=ncacn_ip_tcp:<MYHOST>/sl=1/st=1/ct=0/sv=1/" desformat=htmlcss userid=scott/tiger@mydb destype=cache server=repserver
;;;;;;;;;;;; Keys for Reports Demos
; Using default/in-process server.
; JSPs
charthyperlink_ias: userid="scott/tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=%DBHOSTNAME%)(PORT=%DBPORT%))(CONNECT_DATA=(SID=%DBSID%)))" %*
charthyperlink_ids: userid=scott/tiger@ %*
barcodeweb: userid=oe
parmformjsp: userid=oe
tutorial: userid=oe
; Paper Reports
xmldata: userid=oe report=inventory_report.rdf destype=cache p_filelocation="http://%HOSTNAME%:%OC4JPORT%/reports/examples/xml_pds/scripts/" desformat=pdf
barcodepaper: userid=oe report=shippingmanifest.rdf destype=cache desformat=pdf
distributionpaper: userid=oe report=inventory_report_dist.rdf distribute=yes destination=exampledistribution.xml
pdfenhancements: userid=oe report=utf8test.rdf destype=cache desformat=pdf
knjaz: role=app_all/app_bba %*
;;;;;;;;;;;;
#key_knjaz: userid=ops$tanasko/kmdba11@knjaz11 %* -- ako se kacimo na produkciju ENABLE ovu liniju
key_knjaz: userid=ops$tanasko/raz15@razvoj2015 %*
=================================================================================================================================
nakon ovih koraka treba restartovati appsrv iz njegovog enterprise manager-a koji se pokrece iz browsera i to na url:
http://hostname:1156/ --- gde je hostname ime ili ip adresa servera gde je instaliran appsrv
=================================================================================================================================
sve zelene oznacene strelice na gore, pokazuju da je svaka komponenta appsrv podignuta uspesno i da su podesavanja u redu
=================================================================================================================================
Sledeca bitna stvar je podesiti ERP, javinu uniform aplikaciju koja prvenstveno sluzi za prebacivanje podataka iz aplikacije u Microsoft excel i to se radi iz enterprise managera na sledeci nacin:
SKINI ODAVDE ERP.war -- sve je konfigurisano ( `gadja` na razvoj 2015 ) , moze odma upload
Da nije konfigurisan treba da se :
Podesi ERP.war file u kojem se podesava connection string za bazu i to na sledeci nacin, unutar ERP.war otvori ga pomocu RAR-a pa / WEB-INF / nalazi se file koji se zove web.xml i izgleda ovako:
=================================================================================================================================
<context-param>
<param-name>host</param-name>
<param-value>10.1.11.166</param-value> --izabere se IP na koji se kacis
</context-param>
<context-param>
<param-name>sid</param-name>
<param-value>razvoj2015</param-value> -- upisi SID
</context-param>
<context-param>
<param-name>uname</param-name>
<param-value>ops$tan*****</param-value> -- unesi UserName
</context-param>
<context-param>
<param-name>passw</param-name>
<param-value>******</param-value> -- unesi password
</context-param>
<context-param>
<param-name>port</param-name>
<param-value>1521</param-value> -- unesi port
</context-param>
<context-param>
<param-name>app_ini_path</param-name>
<param-value>/oracle/dev10g/forms90/app.ini</param-value> -- lokacija app.ini
</context-param>
<context-param>
<param-name>excelpath</param-name>
<param-value>/oracle/iis/excel_templates/</param-value>
</context-param>
=================================================================================================================================
Parametri pokazuju :
username
password
sid baze
putanju do excel template
putanju do file app.ini.
=================================================================================================================================
Kada je file podesen kako treba pristupa se deploy- ovnju aplikacije ERP i to iz enterprise managera na sledeci nacin:
Pokrene se:
1. url http://hostname:1156/
2. OC4J_BI_Forms
3. tab Applications i na njemu ima dugme Deploy WAR file
4. ucita se ERP.war file sa diska koji smo podesili
a) Application Name : ERP
b) Map to URL: /ERP
klikne se na dugme deploy, ostavi se par sekundi da se ucita java aplikacija i EM da poruku
aplicaation has been deployed sucsessfuly
Nakon toga ce se oboriti sam appsrv i treba ga podignuti iz EM na dugme start all
U direktorijum $ORACLE_HOME/j2ee/OC4J_BI_Forms/applications/ERP/ERP kopirati direktorijum izvestaji koji sluzi za prikazivanje uputstava u aplikaciji
Podesavanje webutil servisa za koriscenje slika u aplikaciji sastoji se iz nekoliko bitnih fajlova kao i iz podesavanja odredjenih parametara od kojih su najbitniji:
Kopiranje direktorijuma webutil u $ORACLE_HOME/forms
Kopiranje:
uniform.jar
Jacob.jar
frmwebutil.jar
na putanju $ORACLE_HOME/forms/java
Kod oracle application server 10g pa nadalje veci deo bitnih putanja za webutil je vec po default podesen pa ne treba nesto dodatno podesavati osim sto treba dodati u file $ORACLE_HOME/forms/server/formsweb.cfg liniju:
archive=frmall.jar,unifor.jar
$ORACLE_HOME/forms/server/default.env linija :
CLASSPATH=/……….$ORACLE_HOME/forms/java/uniform.jar: $ORACLE_HOME/forms/java/frmwebutil.jar
Onda se pristupa sign-ovanju jar fileova i to se radi na sledeci nacin
Lociraj se $ORACLE_HOME/forms/webutil pokrece se sledeca komanda ( ako nece, dodeli permisions celom webutil folderu na 775 )
./sign_webutil.sh /oracle/as10g/forms/java/jacob.jar
./sign_webutil.sh /oracle/as10g/forms/java/frmwebutil.jar na linuxu za windows se pustaju isto samo umesto sign_webutil.sh pusta se sign_webutil.bat file
/oracle/as10g/forms/server --- bez ovoga nece da ti radi
=================================================================================================================================
Posle ovih setovanja webutil radi
=================================================================================================================================
U slucaju da se ovaj appsrv koristi kao razvojni treba jos i podesiti
$ORACLE_HOME/bin/frmcmp.sh --- primer obelezen crvenom
14 i 15 linija
******************************
ORACLE_HOME=/oracle/as10g
export ORACLE_HOME
******************************
23 i 24 linija
FORMS_PATH=/oracle/iis/AD:/oracle/iis/AP:/oracle/iis/CM:/oracle/iis/CO:/oracle/iis/FN:/oracle/iis/NB:/oracle/iis/OD:/oracle/iis/PL:/oracle/iis/PM:/oracle/iis/PR2:/oracle/iis/PZ:/oracle/iis/PZ2:/oracle/iis/RO:/oracle/iis/TR:/oracle/iis/ZA2
export FORMS_PATH
***************************
ove linije otkomentarisati i podesiti forms path kao u default.env file
34 linija
ORACLE_SID=razvoj2014; export ORACLE_SID
******************************
64 linija
$ORACLE_HOME/bin/frmcmp $* Userid=ops\$tanasko/km14@razvoj2014
*****************************
Podesavanje CUPS za stampu se radi na sledeci nacin:
Iz backupa se pokupi ceo direktorium cups i kopira se na masinu gde je instaliran appsrv u direktorium /etc/cups i to kao root user i u file $ORACLE_HOME/bin/rwlpr.sh --- doda se sledeca linija na vrhu file ispod iskomentarisanih linija
dodaj u 12 - tu liniju
export PATH=$PATH:/usr/bin
$ORACLE_HOME/reports/printers/dflt.prt ---vrednosti prepraviti na sledece parametre:
height 72
width 132
time se postize da se stampa preko cupsa na stampace prosiri na ceo list
Tako se namesta service cups za stampu on se podize kao service na linuxu inace moze mu se pristupiti i preko
url: http://hostname:631/ za dalje podesavanje stampaca modifikaciju i kontrolu stampe sve moze web putem na ovoj adresi
Preuzmi fajl delay.html sa \\10.1.10.82\oraclebackup\delay.html na lokaciju /oracle/as10g/Apache/Apache/htdocs
kada ovo zavrsite potrebno je namestit DISPLAY na linuxu i podesiti za ORACLE usera bash profile koji se nalazi na putanji /home/oracle/.bash_profile
prvo DISPLAY namestamo na sledeci naci:
putty -em se connectujemo kao root na server na kojem je instaliran appsrv i kazemo sledece:
startx &
kada batch obrada stane pritisnemo enter i unesemo sledece
DISPLAY=127.0.0.1:0.0
export DISPLAY
xhost +
Server ce javiti poruku server access control disabled. client can access from any host
/home/oracle/.bash_profile menjamo vi editorom i u njega upisujemo sledece:
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export DISPLAY=127.0.0.1:0.0
time je namesten mehanizam za compile
za slucaj da nece da se `nakaci` na bazu problem je u :
a `ubili smo paket AP_MAIL_API
*****************************************************************************************
paket AP_KORISNIK_API
AP_FORMA_API
login_ldap
deo iz koda
if l_retval = 0 then
return 'ok!';
else
if l_retval = 49 then
return 'fail!';
else
return 'ok!';
/*ap_mail_api.send_mail('sasa.djuric@knjaz.co.rs',
'Greska prilikom logovanja!',
'Korisnik: ' || p_username || chr(13) ||
chr(10) || 'Domen: ' || p_domain || chr(13) ||
chr(10) || 'Greska: ' || l_retval);*/
return 'fail!';
end if;
end if;
END;
end ap_korisnik_api;
