Sejng Up the Oracle APEX Listener (Now ORDS)

57 Pages·2015·12.47 MB·English

Se#ng
 Up
 the
 Oracle
 APEX
 Listener
 (Now

ORDS)
 for
 ProducAon
 Environments

Dietmar
 Aust

Opal-­‐ConsulAng,
 Köln

www.opal-­‐consulAng.de
Opal
 ConsulAng

► Dipl.-­‐Inform.
 Dietmar
 Aust,
 Freelance
 Consultant

▪  Master's
 Degree
 in
 Computer
 Science
 (MSCS)

► Building
 Oracle
 based
 Web
 ApplicaAons
 since
 1997

▪  Portal,
 Forms,
 Reports,
 OWA
 Toolkit,
 now
 APEX!

► 1997-­‐2000:
 Consultant
 at
 Oracle
 Germany

► Since
 09/2000:
 Freelance
 Consultant,
 Since
 2006
 –
 APEX

only!

► Blog:
 h_p://daust.blogspot.com/

► Regular
 presenter
 at
 Oracle
 conferences
 (ODTUG,
 DOAG,

OOW)

► Author
 of
 the
 JasperReportsIntegraAon
 toolkit

▪  h_p://www.opal-­‐consulAng.de/tools

Setting Up the Oracle APEX Listener (Now ORDS) for Production
23.06.2015 Page 2
Environments
Why
 And
 What?

Setting Up the Oracle APEX Listener (Now ORDS) for Production
23.06.2015 Page 3
Environments
Why
 And
 What?

► WHY?

► Infrastructure
 for
 Oracle
 APEX
 produc,on
 environments
 o4en
 poorly

configured:

▪  SAll
 use
 the
 embedded
 PL/SQL
 gateway

▪  ORDS
 connecAon
 pool
 not
 properly
 configured

► People
 find
 it
 hard
 to
 implement
 the
 recommended
 setup
 with
 an
 Apache

h_p
 server
 and
 ORDS,
 because
 it
 seems
 to
 be
 complicated

► My
 personal
 interest:

▪  Want
 to
 have
 a
 step-­‐by-­‐step
 guide
 to
 implement
 the
 recommended
 architecture

▪  Want
 to
 have
 a
 presentaAon
 to
 educate
 my
 clients
 regarding
 the
 architecture

and
 the
 best
 setup

Setting Up the Oracle APEX Listener (Now ORDS) for Production
23.06.2015 Page 4
Environments
Why
 And
 What?

► WHAT?

► Set
 up
 a
 produc,on
 environment
 for
 our
 Oracle
 APEX
 instance.

► CharacterisAcs

▪  Fits
 80%
 of
 deployments

▪  Intranet
 usage
 mainly

▪  “Basic”
 security
 measures
 and
 good
 performance

► The
 proposed
 setup
 is
 flexible
 and
 can
 be
 extended
 in
 order
 to
 saAsfy
 more

elaborate
 requirements
 for
 higher
 security
 and
 even
 be_er
 performance

Setting Up the Oracle APEX Listener (Now ORDS) for Production
23.06.2015 Page 5
Environments
Agenda

Setting Up the Oracle APEX Listener (Now ORDS) for Production
23.06.2015 Page 6
Environments
Agenda

► Understanding
 the
 Architecture

► InstallaAon

▪  Ords
 Standalone,
 Tomcat
 8
 only,
 Apache
 h_p
 server
 in
 front
 of
 Tomcat

► OpAmizaAons

▪  Caching,
 enforcing
 SSL,
 URL
 rewriAng

► Use
 Cases

▪  Password
 change
 db
 user,
 database
 server
 change

► Monitoring

▪  Performance
 and
 errors

► Advanced
 ConfiguraAons

▪  SSO,
 REST
 style
 URLs
 with
 APEX

Setting Up the Oracle APEX Listener (Now ORDS) for Production
23.06.2015 Page 7
Environments
Understanding
 the

Architecture

Setting Up the Oracle APEX Listener (Now ORDS) for Production
23.06.2015 Page 8
Environments
Understanding
 the
 Architecture

Overview
 and
 Components

http http JDBC
Oracle
https AJP SQLNet
Browser Webserver PL/SQL Gateway Oracle DB
Serve static files
 Translate URL 
 APEX: 

SSL termination
 /ords/f?p=100:1 
 Execute Logic
Cache / Proxy
 => 

&
Compression
 call to stored 

... procedure Generate HTML
Apache Http Server,
 ORDS

Oracle 11.1.0.7 

Nginx, 
 mod_plsql

and higher
IIS / Windows
 dbms_epg

Apache Tomcat, 
 ...

Oracle XE 11g
Oracle XML DB
Setting Up the Oracle APEX Listener (Now ORDS) for Production
23.06.2015 Page 9
Environments
Understanding
 the
 Architecture

Consequences
 /
 Insights

► The
 WORK
 is
 done
 IN
 THE
 DATABASE

► The
 Webserver
 and
 PL/SQL
 gateway
 don’t
 need
 a
 lot
 of
 processing
 power,

most
 of
 the
 Ame
 idle

Setting Up the Oracle APEX Listener (Now ORDS) for Production
23.06.2015 Page 10
Environments