dipl.-ing. peter anzenberger peter & partner

Welcome!Willkommen!

Добро пожаловать!

New Features Oracle AS & Forms 10g

Dipl.-Ing. Peter Anzenberger

Peter & Partner

[email protected]

Who is Peter & Partner

Network of Oracle Trainers, Consultants & Developers Regional Area: german speaking Area, Ukraina Languages: German, English, Spanish, Russian Oracle PartnerNetwork Member Partner Member of the Board of the AOUG Oracle Certified Professionals

DBA 7.3, 8.0, 8i, 9iDeveloper 6/6i, 9i

Judicial Sworn Experts for Data Processing Trainers for the Oracle University Lecturers at the University of Applied Sciences, Wels,

Austria Lecturers at the technical University, Cerson, Ukraina Speakers at national and international Conferences

Public Work

Presenter at international Conferences EOUG Conference 1998, Vienna, Austria ODTUG Conference 1999, Ft. Lauderdale, USA EOUG Conference 2000, Dubai City, Dubai ODTUG Conference 2001, Las Vegas, USA DOAG Conference 2003, Mannheim, BRD EOUG Focus Day, 2004, Zurich, Swiss

Presenter at AOUG Events Annual Conferences, Vienna, Austria Experts Meetings, Vienna, Austria

Published in several Magazines Object Spektrum,1998 Oracle News, 1997 – 1999

Oracle Tools

Oracle Database Server Version 4 to 9i, 10g

• WinNT, Win2000, WinXP• several Unix-Systems: HP-UX, True64, AIX, Linux, SG-Unix, Solaris,

…)

Oracle Developer Forms 2.0 to Oracle Developer 9i, 10g

Oracle Designer Version 2.1 to 9i, 10g

Internet Application Server & Oracle Portal OAS 4 to iAS 9i, 10g PL/SQL Web Tool Kit

New featuresOracle AS 10gOracle AS Forms 10gOracle Forms Developer 10g

Forms-Reports Services Installation forOracle Application Server 10g

YesOracleAS 10g Reports Services

YesOracleAS 10g Forms Services

YesOracleAS 10g Discoverer (includes

Discoverer Plus, Discoverer Viewer, and Discoverer Portlet Provider)

YesOracleAS 10g Personalization

YesYesOracleAS 10g Wireless

YesYesOracleAS 10g Portal

YesYesYesOracle Enterprise Manager

YesYesYesOracleAS 10g Web Cache

YesYesYesOracleAS 10g Container for J2EE

YesYesYesOracle HTTP Server

Business Intelligence and Forms

Portal and Wireless

J2EE and Web

Cache

Component

Hardware Requirementsfor Oracle Application Server 10g

CPU Pentium 450 MHz or better Memory

J2EE Web Cache 512 MB Portal and Wireless 1 GB Business Intillegence and Forms 1 GB OracleAS 10g Infrastructure 1 GB OracleAS 10g Developer Kit 256 MB

Disk Space J2EE Web Cache 480 MB Portal and Wireless 1.1 GB Business Intillegence and Forms 1.5 GB OracleAS 10g Infrastructure 3.14 GB OracleAS 10g Developer Kit 701 MB

Swap Space J2EE Web Cache 512 MB Portal and Wireless 512 MB Business Intillegence and Forms 1.1 GB OracleAS 10g Infrastructure 640 MB OracleAS 10g Developer Kit 512 MB

Oracle AS 10gNew Features

OracleAS 10g

BusinessIntelligence

Mobile &Wireless

Enterprise Portal

Web Services

B2B

Applications

Any Data Source

Application ServerApplication Server(Enterprise SOA Runtime)(Enterprise SOA Runtime)

OracleASOracleAS 1010gg

Application Dev. FrameworkApplication Dev. Framework

IntegrationIntegrationBrokerBroker

Grid ComputingGrid ComputingInfrastructureInfrastructure

PortalPortal

SSEECCUURRIITTYY&&

ID Mgmt.ID Mgmt.

SSYYSSTTEEMMSS

Mgmt.Mgmt.

Transparent Application Failover (TAF) Automatic session migration

Fast-Start Fault Recovery™ Automatic failure detection and recovery

Multi-tier Failover Notification (FaN) Speeds end-to-end application failover time

Grid Provides High Availability

> 15 mins> 15 mins

< 12 secs< 12 secs

15 mins15 mins

< 4 secs< 4 secsWithout FaN

With FaNWithout FaN

With FaN

RAC Failover AS Detection Total DowntimeRAC Failover AS Detection Total Downtime

< 8 secs*< 8 secs*

< 8 secs*< 8 secs*

View/Search

Compare

Track Changes

ReferenceConfigurations

Analyze

Install/Clone

Configure

Deploy

Patch

LiveLink

Oracle.com

Product Updates

Patches

ProductConfiguration

OracleInventory

SoftwareConfigurations

HardwareConfigurations

Discover

GridControl

Provision

Over 20% of downtime is attributable to human configuration errors

Grid Automates Software Provisioning

Installation and Configuration

Usability Improvements Pre-requisite checks

• System patches, user privileges, shared memory

Logging and troubleshooting enhancements• Improved error messages, Log files in one place

Easy to understand installation flows Flexibility

Multiple Farm association per middle tier host Multiple user installations on same host Almost all ports can be configured pre/post install

Installation and Configuration

Infrastructure Installation Enhancements More install options

• All in one, ID mgmt only, metadata only

Use existing database for metadata repository Forms and Reports without Infrastructure installation

option Cluster aware installations for HA configurations Secure access to Oracle Internet Directory during

install

System Monitoring & Management

• OracleAS Console: Enhanced Administration Console

• Consistent web-based management for the entire Application Server platform– Centralized management for ports, logs and J2EE

applications deployed– IP Address, Host Name, Domain Name change support– Validation of configuration changes

Security and Identity Management

• External Authentication Mechanisms– Microsoft Windows, iPlanet plugins

• OID integration with Active Directory Server• Oracle9iAS Single Sign-On (SSO)

– Multi-level Authentication (uname or SSL)– Automatic login for Windows authenticated users– Flexible Deployment Options

– (RAC, Geographical distributed, DMZ, etc.)

Oracle Forms 10gNew Features

Choose Oracle Forms Version

Oracle Forms 6i Let you have the same fmb for c/s and Web Requires Oracle9iAS V1.0.2

Oracle9i Forms / Oracle Forms 10g (9.0.4) Only Web runtime Might need a little more work for upgrade The latest features WebUtil makes upgrade easier Oracle Developer Suite install is enough for testing Oracle9iAS V2.0 / OracleAS 10g for deployment

Platform Integration

Application Server IntegrationApplication Server Integration Internet deployment with the Forms Listener Servlet

and OC4J Single Sign-on with Oracle Login Server LDAP support with Oracle Internet Directory Easy management with Enterprise Manager

Database IntegrationDatabase Integration Character semantic support (new Oracle9i feature)

Environment IntegrationEnvironment Integration Timezone support Automatic Language detection

New Focus Areas for Forms

Integration Single Sign-On OEM management New Servlet

architecture Openness and interoperability

Java integration XML Forms Launch Web pages from Forms

Development productivity Improve and customize user interface New GUI components New debugger 19

Manageability

OracleForms

Openness

Security

Standard Deployment

JavaJava

Enterprise Enterprise ManagerManager

SSO LDAPSSO LDAP

Apache & OC4JApache & OC4J

XMLXML Web Web ServicesServices

The Forms Listener Servlet

Replaces Separate Forms Listener Process Broad Range of Firewalls/Proxies Supported Supports HTTP/1.1 or HTTP/1.0 Native JVM Internet Explorer 5.x Internet Support Uses Oracle Containers for J2EE (OC4J) or

mod_jserv

The Forms Listener Servlet Architecture

Client Side Firewall/Proxy

Server Side Firewall/Proxy

HTTP Listener

Forms ServerRuntime

Listener Servlet

All the requests go through the HTTP Listener

HTTP/HTTPS

INTERNET

Forms Listener Servlet - Benefits

No Extra Process to Manage (Forms Listener) Uses Standard Load Balancing inc. Hardware Supports Authenticating Proxies No Extra SSL Certificate Required - Uses

Webserver’s Only “Standard” Ports Opened Through Firewall Multiple Runtime Environments on One Server

New Features In Oracle AS Forms 10g (9.0.4)

Oracle AS 10g FormsForms and Reports only installationJava 1.4 SupportForms Enterprise Manager

enhancementsRuntime pre-startURL SecuritySingle Sign-On enhancements

We remember: iAS 9i

Business Intelligence and Forms installation requires an Oracle9iAS Infrastructure.

However, you can choose to deinstall theOracle9iAS Infrastructure after Business Intelligence and Forms is installed.

Database 9i (Rel. 1) was created

AS 10g: New Installation Option

Oracle Forms and Oracle Reports only Contains HTTP Server and J2EE Does not contain Infrastructure

Ships as separate CD with Oracle Application Server


When you install Oracle Application Server Formsand Reports Services installation you'll have access to these features:Oracle Application Server Forms ServicesOracle Application Server Reports ServicesOracle HTTP ServerOracle Containers for Java (OC4J)Oracle Application Server Web CacheOracle Enterprise ManagerOracle Process and Management Notification (OPMN)Distributed Configuration Management (DCM)


Restrictions The Oracle Application Server Forms and Reports Services

installation provides no Infrastructure services, such as Single Sign-On or Identity Management integration.

Furthermore, it is not possible to associate or link this installation with an Infrastructure at a future point in time.

If you later wish to take advantage of Infrastructure features --such as Single Sign-On -- you'll need to install an instance of Oracle Application Server with Business Intelligence and Forms, and move your applications to this new installation.


Differences Between This Install Type and the Full Oracle Application Server 10g Release In terms of the functionality of Forms and Reports Services, there

is no difference between this install type and the full Oracle Application Server.

The major difference is that this option does not require the Infrastructure components to be installed. The advantage is that the architecture is more lightweight, simple, and easier to configure and manage.

On the other hand, by its nature, this install type cannot deliver all of the features and functionality of the full Oracle ApplicationServer, such Single Sign-On functionality or integration with products like Oracle Portal.


SupportSupport and platform certification will be the same as

for the full Oracle Application Server 10g.There will be no separate specific patchsets for the

Forms and Reports Services installation. The strategy is to have Oracle Application Server patchsets which can be applied to any installation, including this one.

LicensingThe licensing for this installation type is the same as for

Oracle Application Server with Business Intelligenceand Forms.

How to upgrade Oracle 9iAS Rel 2 (9.0.2) BI Forms Install to Forms/ Reports 10g (9.0.4) 'standalone' release? This can be achieved entirely by manual configuration

of Forms and Reports Services 10g so that it is similar to, or the same as, the previous Oracle 9iAS Rel 2 (9.0.2) Forms and Reports setup. Alternatively use the OracleAS Upgrade Assistant,

which is installed with Oracle Application Server Forms / Reports Services 10g (9.0.4). For more detailed information reference: Oracle Application Server 10g Forms and Reports

Services Upgrade Guide 10g (9.0.4)

Is there specific documentation for the Oracle Application Server Forms / Reports Services 10g (9.0.4.0.0) 'standalone' ?Yes - Oracle Application Server 10g Forms and

Reports Services Online Documentation Library 10g (9.0.4) Refer also to the main OracleAS 10g documentation The functionality, configuration and administration is

the basically the same as for any Oracle Application Server 10g middle tier.

Java 1.4 Support

Oracle Forms support for Java SDK 1.4 on the client and server

Allows integration of new features in J2SE 1.4 Support of Sun’s Java Plugin

Oracle AS 10g Enterprise Manager

Fully Managed by Oracle Enterprise Manager (EM)

Monitor & Manage Forms Processes CPU, Memory, IP

Address, User Name, Connect Time, Kill sessions

Enable Runtime Diagnostics User specific trace

configuration Live Trace info


Configuration formsweb.cfg formstrace.cfg

Environment default.env


Forms Utility page Support for additional

functional capabilities not yet accessible on other pages

Runtime Pre-Start

Key feature for enterprise applications Pre-starting Forms runtimes for defined

applications Pre-start Forms runtime engines when starting

Oracle Application Server New parameters in formsweb.cfg file

prestartRuntimes = [false | true] prestartInit = number of initially spawned

runtime engines prestartMin = minimum number of runtime

engines pre-started Part II and III in next major release

Schedule pre-start intervals

Oracle AS Forms Services URL Security

Restrict parameters on the Forms URL Prevent users from changing application

start parametersAvoid denial of service attacks

New formsweb.cfg parameterrestrictedParamURL= [list of restricted

parameters]Can be set at the application level

Forms Single Sign-On authentication

Web Client

Forms Servlet

HTTP Server

mod_osso

Oracle LoginServer

1.

2.

4.

5.

6.

http request

authentication request

Oracle 9iAS V2

authentication info

set cookie

sso_cookie

3. Login Dialog

SSO user

SSO password

Forms Single Sign-On database authentication

Forms RuntimeEngine

Forms ListenerServlet

Forms Servletmod_osso6.

Oracle Internet Directory

7.

8.9.

sso_user/apps name

username/password@database

sso_cookie

connectinfo

formsweb.cfg SSO Parameters

New SSO parameters to set in “User Parameters” section for global effect “Named Configuration” section for local effect

ssoMode=[true | false] Determines if application requires SSO authentication

ssoDynamicResourceCreate=[true | false] Defines if user is allowed to dynamically create RAD resource if

missing in OID Uses DAS HTML form by default

formsweb.cfg SSO Parameters

ssoCancelURL Defines where the user gets directed to if they press

the cancel button in the DAS HTML form Allows you to provide help

ssoErrorURL Allows custom handling of the situation where the

Resource Access Descriptor for the requested application isn’t found in OID

Makes sure that users don’t create new RAD resources because of typos in the request URL

New In Forms Developer

Single-Sign-On Enhancments Byte/Character Semantics Timezone Support Image Support Java API XML Converter Development Productivity Runtime Improvements Translation Hub

Single-Sign-On Enhancments

Support of Default RAD sources Created in DAS for all OID users All users use same database connection. This is

recommended for applications with their own account management

Get_Application_Property() SSO parameters User Distinguished Name (DN) Subscriber DN

Forms application "config" parameter

Single Sign-On Integration

Code Free Single Sign-On integration Integration of new and existing Forms Web applications

Use Oracle Internet Directory (OID) as password store Map database user to Single Sign-On user Store credentials per user and application

Access to Single Sign-On Username in Forms Built-in application property sso_userid added

Byte/Character Semantics – The Problem

Declare a Variable to hold a 5 Character StringUS7ASCII

varchar2(5) 11 22 33 44 55

JA16SJISvarchar2(10) 11 22 33 44 55

UTF8varchar2(20) 11 22 33

Oracle9i Character Semantics

Character Semantics Introduced With Oracle 9i Variables Can be Sized in Characters Or Bytes e.g.

myVar VARCHAR2(10 CHAR); myFixedVar CHAR(10 BYTE);

Forms 6i and Oracle 8i: use BYTE Semantics Oracle9i Forms and up: supports Byte or

Character In PL/SQL For item length definitions

Timezone Support

Timezone Support

Perth7:41pm

London12:41pm

(BST)

UTC11:41amLA

4:41am

So What Time is it?

Where’s the Database?

Where am I? Where are you? Is this your time or my

time? What about Daylight

Savings? Ambiguous Times

Timezone Support

Apply conversion to all DateTime Fields For an Application Define

Local (Client Browser) TimeZone Database Server TimeZone

Conversion in Both Directions Handled Automatically

Built-in also Provided For Manual Conversion

Automatic Environment Detection

Browser Timezone If timezone support is being used and local timezone not

explicitly defined in config, environment or url Browser Language

Automatically pick the correct application from the Forms Services Configuration file if language code is appended to app name e.g. CONFIG=HR

[HR]

… ;Default version of app

[HR.DE]

… ; German Configuration

[HR.FR]

… ; French Configuration

Image Support

Design time image Support for GIF and JPGNew environment variable UI_ICON_EXTENSION

• ICO• GIF• JPG

UI_ICON to set icons path

Java Forms API

Manipulate Forms Modules (FMB, OLB, MMB, PLL) outside of the Builder.

Create, Change, Compile Make Global Changes Build Utilities e.g. Batch Compile, Diff Custom Documentation and Impact Analysis

Compliments the existing C API

Forms to XML Converter

Alternative text format to FMT files Full Roundtrip Support Ideal for:

Impact Analysis Custom Reporting Programmatic manipulation

Called from Java Programs or Standalone Forms2XML / “iff2xml90” XML2Forms / “ifxml2f90” XMLValidator / “ifcmlv90”

Sample XML

<Module version="90000500"

xmlns="http://xmlns.oracle.com/Forms">

<FormModule Name="ONEBLOCK"

MenuModule="DEFAULT&SMARTBAR"

Title="MODULE1">

<Coordinate RealUnit="3"

DefaultFontScaling="true"

CoordinateSystem="1"

CharacterCellWidth="5"

CharacterCellHeight="14"/>

<Block Name="EMP"

RecordsDisplayCount="5"

QueryDataSourceName="emp"

ScrollbarWidth="9"

ScrollbarLength="135">

.....

</Block>

<ObjectGroup Name="OBJECT_GROUP">

<ObjectGroupChild Name="EMP" Type="Block"/>

</ObjectGroup>

</FormModule>

</Module>

Demo

Forms to XML Converter

Development Productivity

Productivity in Application Testing and DebuggingProductivity in Application Testing and Debugging Debug your Forms applications easily with the new remote debugger Run your Form in a browser from the development environment Runtime improvements

Productivity in Application TranslationProductivity in Application Translation New translation tool: TranslationHub

Productivity in Versioning and SCMProductivity in Versioning and SCM Native integration with Oracle9i SCM for impact analysis and version

control

The New Debugger

Integrated into the Forms Builder Debug from within your build environment

Debug Forms Applications as they Run on the Web

Run Directly in Debug Mode or Attach to Remote Session Debug a user’s session “live”!

Remote Debugging

User

Developer

HeyI’ve got a Problem!!!

Send me yourDebuggingInformation

Debugger Features

Set Breakpoints and Make Changes Directly in the PL/SQL Editor

Improved Debug Facilities Watches Break on Exception Package Variables Drill down through Records and Arrays

Debug Console with Dock-able Windows

The New Debugger

One Button Run

Run From Builder Directly into a Web Browser PJCs and JavaBeans Fully Functional when

Running in Browser Run in Debug Mode directly from Builder

Runtime Improvements

List Of ValuesNon Blocking Long Lists Population Can be

Cancelled during at Any Time Status Bar Shows number of

rows as population proceeds

Runtime Improvements

One-Time Where Clause Temporary addition to the Where Clause

for a Block Discarded after execution Allows bind variable use Save DB Resources by reusing cursors in the SGA

Shared SQL Area New Application Property - Version

Returns the Version Number of the Forms Services

Translation Hub

Replacement for OTB and OTM Use it to translates Oracle Forms and Reports

Proven technology Oracle Forms and Reports only Migration path from OTB/OTM:

Upgrade Forms 6i module to Oracle9i/10g Forms Create translation project by importing strings

TranslationHub - Translation Views

Outline Hierarchical WYSIWYG Output

Terminology

dipl.-ing. peter anzenberger peter & partner

Documents