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


Agenda

• Wer ist die Pitss

• Oracle Fusion Middleware 11gR1 / R2

• Im Laufe der Zeit

• Installationen

• Konfigurationen

• Bug‘s ?

Agen

da


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


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


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


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


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


What components OFM made up ofHistory

OFM


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


InstallationInstallatio

n


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


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


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


Attention

Oracle® Fusion MiddlewareUpgrade Guide for Oracle Portal, Forms, Reports, and Discoverer11g Release 1 (11.1.1)E10130-04January 2011D

oku


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


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 ?


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


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


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


Installation Weblogic ServerInstallatio

n


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


Prestart

• Zwei Arten von Prestart Formsweb.cfg

prestartRuntimes=true

prestartInit = 10

prestartMin = 5

prestartIncrement = 5

prestartTimeout = 2000

Zeitgesteuert Über die EM‐Console


Prestart ZeitgesteuertPresart


• 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


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


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


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


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


LogFilesLog Files


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


Stellen Sie Ihre Fragen…Fragen

und

Antworten


Danke für Ihre Aufmerksamkeit

PITSS GmbH :

Email: [email protected]: +49 172 215 1043Website: www.pitss.de

Kontakt


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!


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


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

principal consultant pitss - doag.org

Documents