Wednesday Jul 13, 2016

Oracle Application Express 5.0.4 was released on July 12, 2016

A new Oracle Application Express version was released on July 12, 2016

Several fixes were added to this new version.
Read more about the changes in the links below:

Full download
Release notes
Installation Guide

Thursday Jul 07, 2016

Oracle REST Data Services 3.0.6 released on July 6

A new Oracle REST Data Services version was released on July 6, 2016

Several fixes were added to this new version.
Read more about the changes in the links below:

Full download
Release notes and installation
New features

Wednesday Jul 06, 2016

Oracle Forms - Learn More

Oracle Forms has been one of the most widely used back-office application development technology for more than thirty years.
This proven technology has evolved over the years and still remains the technology of choice for thousands of developers worldwide.  

Want to find out more about Oracle Forms? Explore all these links:

For a more hands-on approach, check the Presentations and Tutorials section


  •    Oracle Forms 11g External Events (Chat demo)
  •     Oracle Forms 11g Calling a Web Service (SMS demo)
  •     Oracle Forms 11g JavaScript Integration (JS Menu demo)
  •     Oracle Forms 11g Using Enterprise Manager for Administration
  •     Oracle Forms 11g Creating and Managing Menu Modules
  •     Oracle Forms 10gR1 Creating a Master/Detail Form


  •     Grant Ronald and Gregor Rayman discuss the value of Oracle Forms 11g running on WebLogic Server
  •     Virtualize and Run Your Forms Applications in the Cloud

Oracle Forms and SOA

  •     Modernize Oracle Forms
  •     Executive Summary
  •     Migrate Forms
  •     The Hows and Whys
  •     Integrating Forms with SOA
  •     Calling a Web Service

Customers and Partners

  •     Customer Testimonials
  •     Partners
  •     Mobilizing Oracle Forms

Learn More

Wednesday Jun 29, 2016

Remote Diagnostic Agent (RDA) 8.12 and Diagnostic Assistant (DA) 2.11 now available!

Remote Diagnostic Agent (RDA) is a command-line diagnostic tool that includes a unified package of support diagnostics tools and preventive solutions. The data captured provides a comprehensive picture of any environment which aids in problem diagnosis.

Enhancements and installation instructions for RDA 8.12 can be found in  RDA Release Notes (Doc ID 414970.1)

You can download RDA from Knowledge Article 314422.1, the Main RDA page. Select the RDA zip file for your platform by clicking on the related link. Each zip file contains all the files you need, so only choose one to download.

This release of RDA is also bundled with the new Diagnostic Assistant (DA) 2.11 tool. DA is a command line interface framework designed to simplify and standardize the end user’s experience with various diagnostic tools. It provides a common, lightweight, extensible interface to multiple diagnostic collection tools (ADR, RDA, OCM, Explorer and others).

Refer to Diagnostic Assistant (Doc ID 201804.2) for more detailed information about DA 2.11 new release and functionalities.

For more information:

Remote Diagnostic Agent (RDA) – FAQ (Doc ID 330363.1)
Remote Diagnostic Agent (RDA) – Getting Started (Doc ID 314422.1)
Resolve Problems Faster! Use Remote Diagnostic Agent ( RDA ) – Fusion Middleware and WebLogic Server (Doc ID 1498376.1)

Wednesday Jun 22, 2016

Oracle Forms Released June 21, 2016

Oracle Forms has been released and is available for download on OTN.

This updated version of 12c includes several bug fixes and features enhancements.

Be sure to review the product documentation before installing.

Read more:

Friday Jun 10, 2016

SQL Developer Overview

Oracle SQL Developer is the Oracle Database IDE. A free graphical user interface, Oracle SQL Developer allows database users and administrators to do their database tasks in fewer clicks and keystrokes. A productivity tool, SQL Developer's main objective is to help the end user save time and maximize the return on investment in the Oracle Database technology stack.

SQL Developer supports Oracle Database 10g, 11g, and 12c and will run on any operating system that supports Java.

For the Developer
SQL Developer provides powerful editors for working with SQL, PL/SQL, Stored Java Procedures, and XML. Run queries, generate execution plans, export data to the desired format (XML, Excel, HTML, PDF, etc.), execute, debug, test, and document your database programs, and much more with SQL Developer.
For the DBA
SQL Develper isn't just for developers! Since version 3.0, the DBA Panel (available under the View menu) has provided database administrators a set of interfaces for their most critical tasks. SQL Developer will continue to add and enhance features for the DBA. Today,  SQL Developer's DBA panel provides support for:
  •     Data Pump
  •     Recovery Manager (RMAN)
  •     Oracle Auditing
  •     User and Role management
  •     Storage management, including the ability to add space to your tablespaces
  •     Resource Manager
  •     Diagnostic Pack features:Snapshots, Baselines, ADDM, ASH, AWR

For the Application Architect & Data Modeler
Oracle SQL Developer includes a complete data modeling solution with Oracle SQL Developer Data Modeler (SDDM) running inside the application (also available as a standalone and free installation.) SDDM supports:
  •     Logical, relational, physical, dimensional modeling
  •     Data Flow Diagrams
  •     DDL scripting
  •     Importing from data dictionaries, DDL scripts, Oracle Designer Repositories, and ERwin
  •     a Reporting Repository
  •     Versioning of your designs via Subversion
  •     Comparing models with generation of ALTER scripts
  •     a powerful search and reporting utility

For the Web Application Developer and Administrator Oracle SQL Developer allows you to administer Oracle Rest Data Services and for creating and altering your RESTful services.

Oracle SQL Developer integrates with Oracle APEX, allowing you to browse applications and perform other Application Express activities. With Oracle SQL Developer you can browse, export and import, drop or deploy applications. There are a selection of Application Express reports and you can create your own custom reports.

Third Party Database Migrations
Formerly available in the Migration Workbench, Oracle SQL Developer is now the primary migration platform for moving your 3rd Party databases to Oracle Database. Users can connect to Access, SQL Server, Sybase ASE, DB2, or Teradata and walk a wizard-driven process to move their objects, data, and applications to Oracle.

Major Features
Below is a summary of several capabilities for SQL Developer.
  •     Create Connections
  •     Browse Objects
  •     Create Objects
  •     Modify Objects
  •     Query and Update Data
  •     Export Data and DDL and Import Data
  •     Schema Copy and Compare
  •     Process Commands
  •     Edit PL/SQL
  •     Run and Debug PL/SQL
  •     Run and Create Reports
  •     PL/SQL Unit Testing
  •     Data Modeler Viewer
  •     Migrate from Third Party Databases
  •     Version Files
  •     Review the Robust IDE

Learn More about SQL Developer using these sections: 
  • Getting Started
  • What is Oracle SQL Developer?
  • Online Demonstrations
  • Tutorials and Oracle By Examples
  • White Papers and Supporting Documents
  • SQL Developer Feature List
  • SQL Developer Certifications
  • SQL Developer Architecture
  • Pricing, Support & Licensing Questions
  • SQL Developer Release History
  • Statement of Direction
  • SQL*Plus Commands

For additional information, consult the official pages:

Tuesday May 31, 2016

What's New for Oracle Database Cloud - Database as a Service

Keep up with the latest features released for Database as a Service by consulting the official page for 'What's New in Database as a Service'

This document describes what's new in Oracle Database Cloud - Database as a Service. It's organized by the date a specific feature or capability became available.

How you gain access to a new feature depends on which part of Database as a Service the feature is added to:

  • Feature added to the Oracle Database Cloud Service console

    When a new feature is added to the web-based Oracle Database Cloud Service console, you gain immediate access to the feature. The feature is available to existing service instances and those created after the availability date. You don't need to perform or request an upgrade to be able to use the new feature.

  • Feature added to the cloud tooling available locally on service instances

    When a new feature is added to the cloud tooling available locally on service instances, you do need to update the cloud tooling on existing service instances to take advantage of the new feature. For information about updating this tooling, see Updating the Cloud Tooling on a Database as a Service Instance in Using Oracle Database Cloud - Database as a Service.

  • Feature added to base image used to create service instances

    Some features are available only in service instances you create after the feature becomes available. For those features the base image that first contained the feature is noted in the item listing in this document. To find out the base image version for a service instance, see Finding Out the Base Image Version of a Database as a Service Instance at the end of this document.

For the current month - May 2016 - these features were added:

  • Oracle Data Guard available
  • Backup and recovery available through the console
  • Updated version of Oracle REST Data Services
  • Oracle GlassFish Server removed 

Monday May 16, 2016

ORDS 3.0.5 is now available

A new Oracle REST Data Services version was released on May 9, 2016.

One of the changes brought by this version is the HTTPS Support for standalone mode.
Standalone Mode now supports HTTPS either by generating a self signed certificate or using a provided certificate. HTTPS can be configured using the installer when ORDS starts in standalone mode.
  • The default self signed certificate is valid for 365 days and will be regenerated if expired the next time ORDS is started.
  • If using an existing certificate, a DER encoded private key is required.
  • It is recommended to use Java 8 in order for Jetty to use the most recent cipher suites to establish secure connections.
Read more about the new version in the links below:

Thursday May 12, 2016

Learn more about Application Express

Application Express enables you to design, develop and deploy beautiful, responsive, database-driven applications using only your web browser. 

If you have the Oracle Database, you already have Application Express.

Since 2004, Application Express has been a fully supported and no-cost feature of the Oracle Database. 

Using Application Express as a platform, thousands of customers have created applications that range from small opportunistic solutions to enterprise-wide mission critical systems.

Below is a summary of useful materials that can help any Application Express Developer or User to learn more about Application Express

Subscribe to the Oracle Application Express YouTube Channel here.
There is also a video playlist within Oracle Learning Library here.

More details on each section can be found on the official page for: Oracle Application Express Learn More

Thursday Apr 21, 2016

Future Direction for Application Express (APEX) and the Oracle HTTP Server (OHS) / Mod_plsql

Starting with the 12.1.3 Oracle HTTP Server (OHS), the mod_plsql feature has been deprecated.  

As outlined in the Oracle Fusion Middleware documentation, OHS - mod_plsql will not be included with the 12.2 version of the database or the 12.2 Oracle HTTP Server.

This deprecation notice only affects future product direction for the Oracle HTTP Server, and the mod_plsql will continue to be supported according to the dates defined in the Fusion Middleware Lifetime Support Policy document.

For the future, Oracle recommends moving to Oracle REST Data Services (formerly known as Oracle  APEX Listener) as an alternative to mod_plsql. Oracle REST Data Services is a J2EE-based servlet which offers increased functionality including enhanced security, and file caching.

Oracle REST Data Services (ORDS) is a free product provided under Oracle Technology Network License Terms
To run in a supported configuration, ORDS has to be installed into Oracle WebLogic Server (WLS), Oracle Glassfish or Apache Tomcat. 

Read more details about this topic in :
Note 1945619.1 - Future Direction for Application Express (APEX) and the Oracle HTTP Server (OHS) / Mod_plsql
Note 1576588.1 - Oracle Web Tier - Statement of Direction. 

Monday Mar 21, 2016

Application Express in the Cloud

Did you know?
Oracle Application Express can be used in the Cloud.

The Oracle Database Cloud Service is available in several different offerings. Database Schema Service (the schema-based APEX service) offering provides HTTPS access to the Oracle Database and is targeted at developers. Database as a Service and Virtual Image (the dedicated database instance service) are well suited for customers needing a full database or SQL*Net connectivity.

The following figure illustrates the architectural differences between these offerings:

Sign up for a trial account at:

Read all about what Application Express offers in the Cloud in this FAQ

Monday Mar 07, 2016

ORDS 3.0.4 was released

A new ORDS version was released on March 3, 2016

Useful links:

Full download
Release notes and installation
Bugs fixed

Also, read more about the new features of this version in here

Tuesday Mar 01, 2016

New features overview for Oracle Forms 12c

A new features overview for Oracle Forms 12c has recently been released.

In this new white paper, detailed information can be found on several important topics:

Forms Runtime and Integration Features 

  • Oracle BI-Publisher Integration
  • System Events
  • Audio Playback
  • Single Sign-out
  • Client Deployment
  • Custom Text on Logon and Password Change Dialogs
  • Tab Labels with Images
  • Record Counter
  • Item Level Mouse Cursor (Pointer)
  • Setting Max Event Wait Programmatically
  • Client IP Address
  • Form Query-Only Mode
  • Oracle Diagnostic Logging and Forms MESSAGE Built-in
  • JVM Controller
  • Custom Color Schemes
  • New Applet Parameters
  • New Environment Variables

Forms Design Time and Utility Features

  • Builder Preferences
  • Module Converter
  • Product Documentation and Community
  • Java Developer API (JDAPI)
  • WebUtil without OLE

Read more about each feature in Oracle Forms 12c New Features White Paper.

Tuesday Jan 12, 2016

Just Released! Apex 5.0.3 - SQL Developer 4.1.3 - ORDS 3.0.3

Quite right in sync with the year change, we have a bunch of product updates.
New releases are in place

Find all details - new features, fix list, downloads - on the related product sites following the links above.

Tuesday Jan 05, 2016

Oracle Forms and Reports Builders in 12c

In Fusion Middleware 12c, Oracle Forms product introduces a new installation option named 'Forms Builder Only'.
This option offers the ability to install only the Forms Builder and its associated utilities. No runtime or related components will be installed.
This lighter weight installation option will be helpful when a runtime environment is not needed.

All the steps needed to configure Forms Builder Standalone 12c are presented in

Chapter 2.4.9 Configuring Form Builder Standalone 12c Using the Configuration Wizard

Apart from the 'Form Builder Only', Forms Builder can installed as part of 'Forms and Reports Deployment' option as shown below.

On the other side, Reports Builder can only be obtained as part of 'Forms and Reports Deployment' option illustrated above.

Read more about Oracle Forms and Reports 12c version in:

Oracle Forms and Reports 12c (12.2.1) Download and Readme
Oracle Forms and Reports 12c (12.2.1) - Overview
Oracle® Fusion Middleware Publishing Reports to the Web with Oracle Reports Services
Oracle® Fusion Middleware Oracle Reports User's Guide to Building Reports
Oracle® Fusion Middleware System Requirements and Specifications12c (12.2.1)


This is the official blog of the Proactive Support Team for Developer Tools: Oracle Forms, Oracle Reports, Apex, SQLDeveloper, ... . Find information about our activities, publications, product related information and more.


Follow @psdDevTools on Twitter


« July 2016