Principal Consultant PITSS - doag.org
Transcript of Principal Consultant PITSS - doag.org
Copyright 2012 PITSS GmbH www.pitss.com1
Jan‐Peter TimmermannPrincipal Consultant PITSS
Lesson Learned – Oracle Fusion Middleware Forms / Reports 11g
Copyright 2012 PITSS GmbH www.pitss.com2
Agenda
• Wer ist die Pitss
• Oracle Fusion Middleware 11gR1 / R2
• Im Laufe der Zeit
• Installationen
• Konfigurationen
• Bug‘s ?
Agen
da
Copyright 2012 PITSS GmbH www.pitss.com3
Forms und Reports Modernisierungsexperte
über 15 Jahre Erfahrung mit Oracle
Technologien
Oracle Gold Partner
Mitglied der Oracle Modernization
Alliance
Oracle Forms Migration Partner
PITSS America LLC PITSS GmbH Stuttgart/Bielefeldwww.pitssamerica.com www.pitss.de
www.pitss.com
Wer wir sind:PITSS GmbH
Geschichte
Copyright 2012 PITSS GmbH www.pitss.com4
PITSS Standorte
PITSS Region Südwest (HQ)
D-70567 [email protected].: +49 711 728 752-00
PITSS Region SüdostD-82515 [email protected].: +49 8171 21 62-10
PITSS Region NordD-33604 Bielefeld
[email protected].: +49 521 546 795-00
Troy (MI), USA
Milton Keynes, UK
Copyright 2012 PITSS GmbH www.pitss.com5
History
Oracle Fusion Middleware 11g Release 1
Oracle Weblogic Suite 11g
Oracle SOA Suite 11g
Oracle WebCenter Suite 11g
Oracle Identity Management 11g
History
OFM
Copyright 2012 PITSS GmbH www.pitss.com6
What is the Oracle Fusion Middleware (OFM)
• For years, Oracle is talking about the concept of merger
• First mention of the term occurred in 2006
• Many products have been added to the term "merger"
• With the launch in early July 2009, the first real "Fusion"
History
OFM
Copyright 2012 PITSS GmbH www.pitss.com7
What components OFM made up of
• Basics are the Weblogic Server Weblogic Standard Edition
Weblogic Enterprise Edition
Weblogic Suite
• Bundels Weblogic Enterprise Edition Oracle SOA Suite
Oracle Webcenter Suite
Oracle Identity Management
Web
logic
Copyright 2012 PITSS GmbH www.pitss.com8
What components OFM made up ofHistory
OFM
Copyright 2012 PITSS GmbH www.pitss.com9
OFM 11g ArchitectureWLS_REPORTS
Browser
opmnctl
Web
cach
e
HTT
P S
erve
r
mod_plsql
mod_cgi
mod_...
mod_...
mod_wl_ohs
mod_osso
mod_ossl
Oracle N
et Client
Reports Engine
DAD
netca / netmgr
Reports servlet
Forms Engine
Reports ServerUser
Admin.
http(s)
http(s)
telnetssh
WLS_FORMS
Forms servlet
J2EE App. DataSource
AdminServer
FM Control
WLS Console
OPMN
WLS Domain
Copyright 2012 PITSS GmbH www.pitss.com10
InstallationInstallatio
n
Copyright 2012 PITSS GmbH www.pitss.com11
Important LINKS
• Entry area Oracle® Fusion Middleware November 24, 2011 Oracle Fusion Middleware 11g Release 1 (11.1.1.6.0) Download, Installation, and Configuration Readme
Oacle Forms and Reports 11g Release 2 (11.1.2.0.0) Download, Installation, and Configuration Readme
Oracle Fusion Middleware 11g Release 1 (11.1.1.5.0) Download, Installation, and Configuration Readme
Oracle Fusion Middleware 11g Release 1 (11.1.1.4.0) Download, Installation, and Configuration Readme
• Important informations Oracle Fusion Middleware Supported System Configurations
Oracle Fusion Middleware System Requirements and Specifications
Oracle Documentation on the Oracle Technology Network (OTN)
http://docs.oracle.com/html/E25460_01/r2_fr_requirements.htm
Links
Copyright 2012 PITSS GmbH www.pitss.com12
Information FMW11gR1
• Update Guide for Portal, Forms, Reports and Discoverer http://docs.oracle.com/cd/E23943_01/upgrade.1111/e10130/toc.htm
• Quick Install Guide for Portal, Forms, Reports and Discoverer http://docs.oracle.com/cd/E23943_01/install.1111/e12003/toc.htm
• Installation Guide for Oracle Portal, Forms, Reports and Discoverer http://docs.oracle.com/cd/E23943_01/install.1111/e10421/toc.htm
Inform
atioin
Copyright 2012 PITSS GmbH www.pitss.com13
Information FMW11gR2
• Update Guide for Forms, Reports http://docs.oracle.com/cd/E24269_01/doc.11120/e23975/toc.htm
• Install Guide for Forms, Reports http://docs.oracle.com/cd/E24269_01/doc.11120/e23960/toc.htm
Upd
ate Guide
Copyright 2012 PITSS GmbH www.pitss.com14
Attention
Oracle® Fusion MiddlewareUpgrade Guide for Oracle Portal, Forms, Reports, and Discoverer11g Release 1 (11.1.1)E10130-04January 2011D
oku
Copyright 2012 PITSS GmbH www.pitss.com15
General procedure
• Download and installation JDK http://download.oracle.com/otn/java/jdk/6*
Download and installation of the Weblogic Servers http://download.oracle.com/otn/nt/middleware/11g/wls/
• Download and installation Oracle Fusion Middleware in thedeliberate release http://download.oracle.com/otn/linux/middleware/11g/111200/ofm_frmrpts_linux_11.1.2.0.0_64_disk1_1of1.zip
Gen
eral
Copyright 2012 PITSS GmbH www.pitss.com16
JDK 64Bit / blank
• When a 64‐bit operating system is used JVM needs to be 64Bit
Mixing of 32‐bit JVM with 64‐bit Oracle Fusion Middleware is not possible
• Blank in the Windows environment There mustn‘t be blanks under the pathes of Windows
e.g. setup.exe ‐jreLoc C:\Program Files\Middleware\jdk160_27
setup.exe ‐jreLoc C:\Progra~1\Middleware\jdk160_27
JDK ?
Copyright 2012 PITSS GmbH www.pitss.com17
Windows Umgebung
set CLASSPATH=set CommonProgramFiles=set CommonProgramFiles(x86)=set LD_LIBRARY_PATH=set Path=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;set ProgramFiles=set ProgramFiles(x86)=TEMP=C:\TempTMP=C:\TempcmdW
indo
ws E
NV
Copyright 2012 PITSS GmbH www.pitss.com18
Environment Variables
PATH Applies to: all installers for products with system components only on all platforms.If you are installing on a Windows operating system, see "Resolving PATH and Directory Issues on Windows" in the Oracle Fusion Middleware Release Notes for Microsoft Windows (32-Bit)or Oracle Fusion Middleware Release Notes for Microsoft Windows x64 for important additional information.This variable is automatically set by the installer and prepended with ORACLE_HOME\bin. In addition, you must have the appropriate version of the JDK installed on your system, and include the bin directory of the JDK at the beginning of the PATH variable definition.NOTE: make sure this variable does not contain a reference to any other Oracle home directory.
ENV
Copyright 2012 PITSS GmbH www.pitss.com19
Installation Weblogic Servers
• In the 64Bit environment take the „generic.jar“
• Call by „java –D64 –jar wls1036_generic.jar“
• Selection of middleware Home directories
• Selection of components to be installed
• Caution License note Weblogic Basic vs. Weblogic Suite
• In 32‐bit environment, there is only one “bin" including in the JDK
• Important JRockit is not certified for Forms/Reports
Installatio
n WLS
Copyright 2012 PITSS GmbH www.pitss.com20
Installation Weblogic ServerInstallatio
n
Copyright 2012 PITSS GmbH www.pitss.com21
Installation Weblogic ServerInstallatio
n
Copyright 2012 PITSS GmbH www.pitss.com22
Startup Weblogic
• Unter Unix/Linux Derivaten startet der Server recht langsam random number generator during start up
Because of the bug
Java somehow maps /dev/urandom file to /dev/random
• Best solution is to change $JAVA_HOME/jre/lib/security/java.security securerandom.source=file:/dev/./urandom
• Quelle: http://www.itonguard.com/20090313/weblogic‐starts‐slow/
Startup
Copyright 2012 PITSS GmbH www.pitss.com23
Prestart
• Zwei Arten von Prestart Formsweb.cfg
prestartRuntimes=true
prestartInit = 10
prestartMin = 5
prestartIncrement = 5
prestartTimeout = 2000
Zeitgesteuert Über die EM‐Console
Copyright 2012 PITSS GmbH www.pitss.com24
Prestart ZeitgesteuertPresart
Copyright 2012 PITSS GmbH www.pitss.com25
• Form Hangs When Acknowledging Security Warning ‐ The application's digital signature cannot be verified [ID 1328039.1] Modify the Web Configuration (formsweb.cfg).
archive=frmall.jar, mycustom1.jar, mycustom2.jar, etc... To archive=frmall.jar
webutilArchive=frmwebutil.jar, jacob.jar to webutilArchive=frmwebutil.jar
cache_archive_ex
cache_archive_ex=jacob.jar;preload, mycustom1.jar;preload,
• <PARAM NAME="ARCHIVE" VALUE="%archive%,%webUtilArchive%" > (or the existing line will be: <PARAM NAME="ARCHIVE" VALUE="%archive% > if not using webutil)<PARAM NAME="cache_archive_ex" VALUE="%cache_archive_ex%">java_archive="%archive%,%webUtilArchive%" (or the existing line will be: java_archive="%archive%" if not using webutil)cache_archive_ex="%cache_archive_ex%"
Form
s Han
gs
Copyright 2012 PITSS GmbH www.pitss.com26
Trace Informationen
export PATH=/u00/app/oracle/Middleware/FRHOME/jdk/bin:$PATH
export CLASSPATH=/u00/app/oracle/Middleware/FRHOME/jlib/frmxlate.jar:/u00/app/oracle/Middleware/FRHOME/forms/java/frmall.jar
java oracle.forms.diagnostics.Xlate datafile=forms_7461.trc outputfile=myfile.txt outputclass=WriteOutTEXT
java oracle.forms.diagnostics.Xlate datafile=forms_7461.trc outputfile=myfile.html outputclass=WriteOutHTML
java oracle.forms.diagnostics.Xlate datafile=forms_7461.trc outputfile=myfile.xml outputclass=WriteOutXML
Copyright 2012 PITSS GmbH www.pitss.com27
Java Version vorgeben (758823.1)
Selection of a specific JRE version ("1.5.0_18")
Selection of the latest JRE version from within a particular JRE family ("1.5*")
Selection of a particular JRE family or the latest JRE version on a particular PC ("1.5+")
<PARAM NAME="java_version" VALUE="%java_version%">
Java‐Version
Copyright 2012 PITSS GmbH www.pitss.com28
Debugen der Forms unter Linux
#!/bin/sh
/bin/env > /tmp/frmweb_syscalls_$$.env
/usr/bin/strace ‐aef ‐F ‐f ‐tt ‐e write=1,2 ‐s 2000 ‐o /tmp/frmweb_syscalls_$$.trc/u00/app/oracle/Middleware/FRHome/bin/frmweb $*
[debugTest]
allow_debug=true
serverURL=/forms/lservlet/debug
executable=frmweb_syscalls
lsof ‐a ‐p <pid>
Deb
ugForm
s / Linux
Copyright 2012 PITSS GmbH www.pitss.com29
Debug
• 13345 06:02:43.381693 setitimer(ITIMER_REAL, {it_interval={0, 0}, it_value={900, 0}}, NULL) = 013345 06:02:43.381761 write(7, "HTTP/1.1 200 OK\r\nContent‐length: 22\r\nSessid: ‐1\r\n\r\n_\34M\325\331\25\215,[b\4q\270|+}\200\271*z\370\240", 73) = 7313345 06:02:43.381877 setitimer(ITIMER_REAL, {it_interval={0, 0}, it_value={0, 0}}, NULL) = 013345 06:02:43.381985 setitimer(ITIMER_REAL, {it_interval={0, 0}, it_value={900, 0}}, NULL) = 013345 06:02:43.382044 read(7, "POST http://localhost:55069/webforms HTTP/1.1\r\nContent‐length: 0\r\nSessid: ‐1\r\necid: 004ukVW4Qlg7e5I5Ur5Eic0003RZ006h0M\r\n\r\n", 1024) = 12213345 06:02:43.398920 setitimer(ITIMER_REAL, {it_interval={0, 0}, it_value={0, 0}}, NULL) = 013345 06:02:43.399157 write(21, "\0\260\0\0\6\0\0\0\0\0\3^%\1!\1\5\376\377\377\377\377\377\377\377\1\10\376\377\377\377\377\377\377\377\1\r\376\377\377\377\377\377\377\377\376\377\377\377\377\377\377\377\0\1\1\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\376\377\377\377\377\377\377\377\0\0\0\0\0\0\0\0\376\377\377\377\377\377\377\377\376\377\377\377\377\377\377\377\376\377\377\377\377\377\377\377\0\0\376\377\377\377\377\377\377\377\376\377\377\377\377\377\377\377\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\10ROLLBACK\1\1\1\1\0\0\0\0\0\1\21\0\0\0\0\0", 176) = 17613345 06:02:43.399336 read(21, "\0G\0\0\6\0\0\0\0\0\10\1\6\4\317k\31|\1>\1\5\1\2\0\0\0\0\0\4\1\5\2\6\21\0\0\0\0\1\5\0‐\0\0\0\0\0\3\2\21:\1\3\0\3$\254\365\1!\0\0%\0\1\1\0\0\0\0", 8208) = 7113345 06:02:43.399768 write(21, "\0\r\0\0\6\0\0\0\0\0\3\t&", 13) = 1313345 06:02:43.399837 read(21, "\0\16\0\0\6\0\0\0\0\0\t\1\1\0", 8208) = 1413345 06:02:43.479820 setsockopt(21, SOL_SOCKET, SO_SNDTIMEO, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 013345 06:02:43.479988 setsockopt(21, SOL_SOCKET, SO_RCVTIMEO, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 013345 06:02:43.480088 write(21, "\0\n\0\0\6\0\0\0\0@", 10) = 1013345 06:02:43.480172 setsockopt(21, SOL_SOCKET, SO_KEEPALIVE, [0], 4) = 013345 06:02:43.480266 close(21) = 013345 06:02:43.480374 close(20) = 013345 06:02:43.480481 setitimer(ITIMER_REAL, {it_interval={0, 0}, it_value={900, 0}}, NULL) = 013345 06:02:43.480562 write(7, "DMS‐RTI:user=\nDMS‐RTI:db_string=\nDMS‐RTI:tns_entry=\n", 52) = 5213345 06:02:43.480655 setitimer(ITIMER_REAL, {it_interval={0, 0}, it_value={0, 0}}, NULL) = 013345 06:02:43.480809 write(11, "\n", 1) = 113345 06:02:43.480875 write(11, "# TEST:BLOCK.FIRM_ID\n", 23) = 2313345 06:02:43.480952 write(11, "ERROR FORMS_ERROR
\"Forms encountered unexpected signal 0\"\n", 58) = 58
Patch 15850550: MERGE REQUEST ON TOP OF 11.1.2.0.0 FOR BUGS 14673360 11879934 13869488
Patch
Copyright 2012 PITSS GmbH www.pitss.com30
LogFilesLog Files
Copyright 2012 PITSS GmbH www.pitss.com31
Fazit
• Immer noch „nur Forms“
• Derjenige der Oracle schreiben kann macht den Applikation Server
• Sizing wird nicht gemacht
• Try and Error …
• Zuviel Hardware
• Sicherheit ? Warum
Fazit
Copyright 2012 PITSS GmbH www.pitss.com32
Stellen Sie Ihre Fragen…Fragen
und
Antworten
Copyright 2012 PITSS GmbH www.pitss.com33
Danke für Ihre Aufmerksamkeit
PITSS GmbH :
Email: [email protected]: +49 172 215 1043Website: www.pitss.de
Kontakt
Copyright 2012 PITSS GmbH www.pitss.com34
ADF & APEX to go!ADF & APEX to go!Expertengespräche
ADF & APEX Previewer
am PITSS Stand 206
…im Anschluss an diesen Vortrag!Wir freuen uns auf Ihren Besuch!
ExpertengesprächeADF & APEX Previewer
am PITSS Stand 206
…im Anschluss an diesen Vortrag!Wir freuen uns auf Ihren Besuch!
Copyright 2012 PITSS GmbH www.pitss.com35
PITSS Vorträge auf der DOAG 2013
Zeit Raum Thema Referent13.00 ‐ 13.45 18 / Sydney Oracle Text – Ein vergessenes Feature in der Oracle DB Stephan La Rocca (PITSS)15.00 ‐ 13.45 20 / EG ADF, Forms und .NET – Alles vereint in einer
Handheld Scanner AppMadi Serban (PITSS)
16.00 ‐ 16.45 8 / Helsinki Dein Blogreader – die Top 20 Artikel zu SQL & PL/SQL Stephan La Rocca (PITSS)17.00 ‐ 17.45 8 / Helsinki Multiprocessing in PL/SQL – Der Weg aus dem Single
ThreadChristian Wille (PITSS)
17.00 ‐ 17.45 16 / Krakau Lesson Learned – Oracle Fusion Middleware Forms / Reports 11g
Jan‐Peter Timmermann (PITSS)
10.00 ‐ 10.45 11 / Oslo Wie kann ich meine (bestehende) Forms GUI moderner gestalten?
Daniel Kampf (PITSS)
11.00 ‐ 11.45 11 / Oslo Forms nach APEX 101 – Kann alles migriert werden? Fallbeispiele & Tests
Markus Salm, Nihad Haskovic (PITSS)
12.00 ‐ 12.45 11 / Oslo Dynamische Mehrsprachigkeit für Forms & Report Ronald Steiner (PITSS)13.00 ‐ 13.45 19 / EG Test & Pimp my Forms Application Nils Baranowski (PITSS),
Dr. Jürgen Menge (ORACLE)16.00 ‐ 16.45 11 / Oslo Forms‐Wissen trifft auf ADF Jan‐Peter Timmermann (PITSS)16.00 ‐ 16.45 17 / Hongkong Experten‐Panel: Mobile Computing Stephan La Rocca (PITSS),
Frank Nimphius (ORACLE)
13.00 ‐ 13.45 15 / Prag Das ABC der Forms-nach-ADF Migrationen –Beispiele & Live-Demo
Madi Serban, Bahar Us (PITSS)
16.00 ‐ 16.45 12 / Istanbul Performance managen ohne Performance Management Pack
Jan-Peter Timmermann (PITSS)
Die
nsta
g, 1
9.11
.201
3D
iens
tag,
19.
11.2
013
Mitt
woc
h, 2
0.11
.201
3M
ittw
och,
20.
11.2
013
Do,
21.
11.2
013
Do,
21.
11.2
013
Copyright 2012 PITSS GmbH www.pitss.com36
Next PITSS Event
Free PITSS Webinar22. Dec 2013 - Forms Strategy & Source Code AnalyticsDeutsch: 10.00 – 11.00 UhrEnglisch: 14.00 – 15.00 Uhr
Weitere Events finden Sie auf www.pitss.de
Free PITSS Webinar22. Dec 2013 - Forms Strategy & Source Code AnalyticsDeutsch: 10.00 – 11.00 UhrEnglisch: 14.00 – 15.00 Uhr
Weitere Events finden Sie auf www.pitss.de