Feed aggregator

Central State University Enrolls Oracle Cloud to Help More Students Get Degrees

Oracle Press Releases - Wed, 2018-09-19 07:00
Press Release
Central State University Enrolls Oracle Cloud to Help More Students Get Degrees Leading Ohio University first to deploy Oracle Student Management to reach, retain and foster the success of non-traditional learners

Redwood City, Calif—Sep 19, 2018

Central State University has selected Oracle Student Management to help increase degree attainment and open educational opportunity to all students. Part of the Oracle Student Cloud suite, the technology will empower Central State to better reach, enroll, and ensure the success of students in its upcoming Distance Learning Program. In addition, select Oracle University classes will be added to the program in Fall 2019 broadening the university’s curriculum with new 21st-century technology skills that will further prepare students for the modern workforce.

Central State has an esteemed history of extending learning opportunities to diverse communities. Founded in 1887, Central State is one of 19 1890 Land-Grant institutions in the United States. Today, as an internationally growing university, it aims to be a premier institution with excellence in teaching and learning that embraces diversity and produces graduates with the knowledge, skills, and dispositions to make valuable contributions in a global society.

Central State realized that a modern technology approach was needed to reach more students and provide them the opportunity to learn on the time, schedule, and pace that best meets their unique needs and lifestyle. Oracle Student Management will play a critical role in helping the University not only attract new students to its Distance Learning program, but also provide the proactive intelligence needed to improve retention and success rates across the entire University. Central State also plans to add additional Oracle Cloud technologies over time to further improve operational efficiency and deliver an engaging, personalized student experience.

“Increasing student enrollment, improving retention, and speeding time to a degree are core priorities for Central State,” said Dr. Cynthia Jackson- Hammond, President and Chief Executive Officer, Central State University. “We understand that every student is different and has pressures of work and life that often derail their path. With Oracle Student Management, we will be able to further reach and support those students through our upcoming Distance Learning Program, ensuring they achieve the degree they need to better their employment opportunities.”

Enhancing the traditional capabilities of student information systems (SIS), Oracle Student Management helps transform the student experience with capabilities for recruiting, engagement, support, and management. Leveraging emerging technologies and built in automation, the offering delivers the insights universities need to anticipate student needs and monitor progress more proactively, illuminate the right path to better academic outcomes, and empower student success. The Oracle Student Cloud suite is designed to support a variety of business models, from a straightforward “pay to enroll” to managing complex academic requirements, providing the right footprint for each university’s unique needs.

“Delivering both traditional and non-traditional academic programs effectively requires institutions to be more visionary and have the right solutions to execute that vision,” said Vivian Wong, Oracle’s group vice president of Higher Education Development. “Oracle is partnering with Central State on their Student Cloud journey, to ensure both the University and the students themselves have the advanced tools, touchpoints, and knowledge they need to advance degree achievement.”

To further enhance Central State’s Distance Learning Program, new Oracle University classes will be added to the online course curriculum. As part of the Oracle Workforce Development Program (WDP), initial courses will center around advancing skills in Oracle Database, SQL and Java and will be available for workforce, government, military, corporate, and other non-traditional students.

Contact Info
Katie Barron
Kristin Reeves
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at oracle.com.


Oracle and Java are registered trademarks of Oracle and/or its affiliates.

Talk to a Press Contact

Katie Barron

  • +1.202.904.1138

Kristin Reeves

  • +1.925.787.6744

[BLOG] Oracle EBS (R12) Financial: Production Based Depreciation in Fixed Assets

Online Apps DBA - Wed, 2018-09-19 05:51

✔What is Depreciation ✔What are the fixed assets ✔Production Based Depreciation in Fixed Assets & much more… Check at https://k21academy.com/financial13 ✔What is Depreciation ✔What are the fixed assets ✔Production Based Depreciation in Fixed Assets & much more… Check at https://k21academy.com/financial13

The post [BLOG] Oracle EBS (R12) Financial: Production Based Depreciation in Fixed Assets appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

How to allow private connectivity across organizations(GCP)?

Surachart Opun - Wed, 2018-09-19 02:41
It's interesting, when you would like to allow private connectivity across two VPC networks that they belong to the different project/organization on Google Cloud Platform (GCP).

As google document that we can use VPC Network Peering? VPC Network Peering is a decentralized or distributed approach to multi-project networking. Additional, it works with Compute Engine, Kubernetes Engine,and App Engine flexible environments.

I did a lab about Virtual Private Cloud (VPC) Network Peering. There shows to do VPC Network Peering between VPC networks in the same project. So, I would like to see how it works on across organizations.

Example: On My Organization (my project), I would like to connect server (Private IP Address) on another Organization (another project).

As a subnet CIDR prefix in one peered VPC network cannot overlap with a subnet CIDR prefix in another peered network. So, both VPC networks must have the different CIDR prefix.

My Organization [myproject] {ubuntu-test, default/} <======> No organization [qwiklabs-gcp***]{privatenet-us-vm/}

On No organization [qwiklabs-gcp***]: VPC network name is "privatenet".


My Organization [myproject]: I used "default" VPC and default firewall.

Then, starting to create "VPC Network Peering".

- To create "VPC Network Peering" on myproject:
Networking => "VPC network" => "VPC network peering".
Click "Create Peering Connection".  name = "peering-to-lab".
Note: you must know Project ID and VPC network name for network destination.

It should show "Waiting for peer network to connect".

-  To create "VPC Network Peering" on another Project: On No organization [qwiklabs-gcp***], "Create Peering Connection".  name = "peering-to-mygcp".

After clicking "Create". It should show "Connected" on both projects (if configuration corrects) like.

On myproject:

- Finally, test connection: ssh to my vm and test (ssh) connection to {privatenet-us-vm/}.
Note: (as firewall allow icmp/ssh). No need to do on firewall.

opun@ubuntu-test:~$ ssh
opun@'s password:
Linux privatenet-us-vm 4.9.0-8-amd64 #1 SMP Debian 4.9.110-3+deb9u4 (2018-08-21) x86_64
The programs included with the Debian GNU/Linux system are free software;
the exact distribution terms for each program are described in the
individual files in /usr/share/doc/*/copyright.
Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
permitted by applicable law.
Last login: Wed Sep 19 06:22:05 2018 from
Could not chdir to home directory /home/opun: No such file or directory
$ w
 06:22:55 up 43 min,  2 users,  load average: 0.00, 0.00, 0.00
USER     TTY      FROM             LOGIN@   IDLE   JCPU   PCPU WHAT
opun     pts/1       06:22    1.00s  0.00s  0.00s w ************Reference: https://cloud.google.com/vpc/docs/vpc-peering
Categories: DBA Blogs

#Exasol Database whoami

The Oracle Instructor - Wed, 2018-09-19 02:03

This little script displays some useful meta-information:

SQL_EXA> create schema myschema;
EXA: create schema myschema;

Rows affected: 0

SQL_EXA> create or replace script whoami as
 output('Current User: '.. tostring(exa.meta.current_user))
 output('Current Schema: '.. tostring(exa.meta.current_schema))
 output('Session ID: '.. tostring(exa.meta.session_id))
 output('Database Version: '.. tostring(exa.meta.database_version))
 output('Number of Nodes: '.. tostring(exa.meta.node_count))
EXA:create or replace script whoami as...

Rows affected: 0
SQL_EXA> col output for a40;
COLUMN   output ON
FORMAT   a40
SQL_EXA> execute script whoami with output;
EXA: execute script whoami with output;

Current User: SYS
Current Schema: MYSCHEMA
Session ID: 1612024483893367379
Database Version: 6.1.0-alpha1
Number of Nodes: 1

5 rows in resultset.

All available metadata is documented here (Chapter 3. Concepts -> 3.6 UDF scripts).

Categories: DBA Blogs


Tom Kyte - Tue, 2018-09-18 21:26
Hi Tom, I installed Oracle Database 11G in the folder (E:\DB11)and successfully imported a user to it. But when you install the developer 10G IN FOLDER(E:\DEV10). and TRY TO DO a user import into the database ORACLE 11G, i am receiving the follo...
Categories: DBA Blogs

Collection to retrieve data as pipelined taking more time even the query taking lesser time

Tom Kyte - Tue, 2018-09-18 21:26
Hi sir, Have facing issue with the time. The query which is used in dynamic cursor type like 'open for select" taking 550 ms but the output we used as collection passing as pipelined value. At that time it's taking more time like 50 s. Please give...
Categories: DBA Blogs

Need script to compare table data of same table in different oracld databases

Tom Kyte - Tue, 2018-09-18 21:26
Hi, I have a requirement where table1 exists in 2 diiferent oracle dbs . I need to write a shell script or pl sql block which would compare every column of the table in db 1 and db2 and give following output from unix. It should be able to take any ...
Categories: DBA Blogs

Selection from union view by table identifier

Tom Kyte - Tue, 2018-09-18 21:26
Hi, I have a view like <code>create view V_TAB as (select 1 as id, value from TAB1 union all select 2 as id, value from TAB2 ); </code> I would expect Oracle be able to optimize the following query and execute a selection only on one tabl...
Categories: DBA Blogs

Oracle Utilities Customer To Meter/Customer Care And Billing is available

Anthony Shorten - Tue, 2018-09-18 19:03

Oracle Utilities Customer To Meter and Oracle Utilities Customer Care And Billing are now available for download from Oracle eDelivery Cloud. These new releases are based upon Oracle Utilities Application Framework with new and updated functionality.

For details of the release, refer to the release notes and documentation available from Oracle eDelivery Cloud and Oracle Utilities Help Center.

Inbound Web Services - REST Services

Anthony Shorten - Tue, 2018-09-18 14:43

In Oracle Utilities Application Framework V4., the Inbound Web Services object has been extended to support both SOAP and REST based services. This has a lot of advantages:

  • Centralized web services registration. The interface Application Programming Interface (API) are now centralized in the Inbound Web Services object. This means you can manage all your programmatic interfaces from a single object. This helps when using the Web Service Catalog used for Oracle Integration Cloud Service as well as any API management capabilities.
  • Isolation from change. One of the major features of the REST capability within Inbound Web Services is the the URI is no longer fixed but can be different from the underlying service. This means you can isolate your interface clients from changes.
  • Standardization. The Inbound Web Services object has inherent standards that can be reused across both SOAP and REST based services. For example, the ConfigTools object model can be directly wired into the service reducing time.
  • Reduced cost of maintenance. One of the features of the new capability is to group all your interfaces into a minimal number of registrations. This reduces maintenance and allows you to control groups of interfaces easily.

The Inbound Web Services now supports two Web Service Classes:

  • SOAP - Traditional XAI and IWS based services based around the SOAP protocol. These services will be deployed to the Oracle WebLogic Server.
  • REST - RESTful based services that are now registered for use. These services are NOT deployed as they are used directly using the REST execution engine.

Inbound Web Service Business Object

For REST Services, a new optimized maintenance function is now available. This facility has the following capabilities:

  • Multiple Services in one definition. It is now possible to define multiple REST services in one registration. This reduces maintenance effort and the interfaces can be enabled and disabled at the Inbound Web Service level. Each REST Service is regarded as an operation on the Inbound Web Service.
  • Customizable URI for service. The URL used for the REST Service can be the same or different than the operation.
  • Business Object Support. In past releases, Business Objects were not supported. In this release, there are some limited support for Business Objects. Refer to the Release Notes and online documentation for clarification of level of support.
  • Open API Support.  This release introduces Open API support for documenting the REST API.

For example, the new Inbound Web Services maintenance function for REST is as follows:

Example REST Inbound Web Service definition

Active REST Services are available to the REST execution engine.

Open API (OAS3) Support has been introduced which provides the following:

  • Documentation of the API in various formats. The documentation of the REST based API based upon the meta data stored in the product.
  • Ability to authorize Inbound Web Services directly in Open API. It is possible to authorize the API directly from the Open API documentation. Developers can check the API prior to making it active.
  • Multiple formats supported. Developers can view payloads in various formats including Model format.
  • Ability to download the API. You can download the API directly from the documentation in Open API format. This allows the API to be imported into Development IDE's.
  • Ability to testing inline. Active API's can be tested directly into the documentation.

The following are examples of the documentation:

API Header including Authorization (Note: Server URL is generic as this server is NOT active).

Open API Support - Authorization

Operation/API List:

Open API Support - URL List

Request API with inbuilt testing facility:

Open API Support - API Request

Response API with response codes:

Open API Support - API Response

Model Format:

Open API Support - Model List

For more information about REST support, refer to the online documentation or Web Services Best Practices (Doc Id: 2214375.1) from My Oracle Support.

Oracle Retail Industry Forum 2018 Convenes European Retail Leaders to Share Insights and Strategies for Continued Growth and Innovation

Oracle Press Releases - Tue, 2018-09-18 10:00
Press Release
Oracle Retail Industry Forum 2018 Convenes European Retail Leaders to Share Insights and Strategies for Continued Growth and Innovation Over 110 European Retailers from 26 Countries Expected to Attend Conference in Budapest

Redwood Shores, Calif.—Sep 18, 2018

Oracle Retail will convene a European community of retail leadership at the Oracle Retail Industry Forum (ORIF) in Budapest Hungary with a program tailored for retailers by retailers and an opportunity for strategic networking to continue discussions on strategies and successes.

“Oracle Retail Industry Forum is about bringing together our retail community to foster continued growth and innovation. We are pleased to showcase local customer success stories. Within the forum, we highlight real software, delivering real value,” said Chris James, vice president of Europe, Oracle Retail.

At Oracle Retail Industry Forum, retail executives gather to share deep domain expertise and best practices on the mission-critical applications that are core to their businesses and their success. Program content is focused on customers providing perspectives on identifying and overcoming complex industry challenges.

Retail speakers include:

  • Delphine Brabant, Head of Buying/Product IT Department, ÏDKIDS Community

  • Bhavesh Chavda, Enterprise Architect, John Lewis

  • Andrew Parr, IT Director, Wyevale

  • Mathilde Paul, Chef de Projet Chez, Auchan

  • Piotr Pawlowski, Strategic IT Director, CCC, S.A

Retail continues to be mercurial as consumers react and adapt to technological developments, in order to help customers navigate shifting attitudes and customer behaviors Oracle will reveal the findings of a global consumer research report.

“For us, the Oracle Retail Industry Forum is a critically important event because the focus on the European community. We view Oracle as an important partner and our collaboration with Oracle is a key part of our strategy,” said Platinum Sponsor Gabor Tozser, Chief Executive Officer, Quickborn. “Oracle’s solutions have the capabilities that we believe are supporting critical retail capabilities without which retailers will not succeed today.”

Oracle will be joined by 11 strategic solution integrators as sponsors for ORIF in Budapest. These partners contribute to and help deliver success within our community. Our partner community includes platinum sponsor Quickborn; gold sponsors Accenture, Logic, Retail Consult and Veltio; and Adyen, Cognira, First Friday, HRS, OLR and SkillNet as silver sponsors. 

For more information about how Oracle is committed to empowering organizations through best-in-class, industry-specific business solutions, visit oracle.com/retail. To learn more about Oracle Retail Industry Forum 2018, go to www.oracle.com/goto/orif18. Registration is limited to retailers and our sponsor community.

Contact Info
Matt Torres
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

About Oracle Retail

Oracle provides retailers with a complete, open, and integrated suite of best-of-breed business applications, cloud services, and hardware that are engineered to work together and empower commerce. Leading fashion, grocery, and specialty retailers use Oracle solutions to anticipate market changes, simplify operations and inspire authentic brand interactions. For more information, visit our website at www.oracle.com/retail.


Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Matt Torres

  • 4155951584

[BLOG] Introduction to Hadoop Security

Online Apps DBA - Tue, 2018-09-18 07:07

Security is one of the important things that anyone working on Hadoop or wish to learn Hadoop should know. Visit: https://k21academy.com/hadoop18 and learn about: ✔Hadoop Security Overview ✔Why is security important for Hadoop ✔ What Kerberos is and how it relates to Hadoop & much more… Security is one of the important things that anyone […]

The post [BLOG] Introduction to Hadoop Security appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Oracle Leads the Market with Growth by Revenue in iPaaS

Oracle Press Releases - Tue, 2018-09-18 07:00
Press Release
Oracle Leads the Market with Growth by Revenue in iPaaS Oracle iPaaS market share by revenue grew 270 percent between 2016 and 2017, according to Gartner report1

Redwood Shores, Calif.—Sep 18, 2018

Oracle today announced that it has achieved the highest market share by revenue in Gartner’s “Market Share Analysis: Integration Platform as a Service, Worldwide, 2017” report1. This report follows Oracle being named a Leader in Gartner’s 2018 “Magic Quadrant for Enterprise Integration Platform as a Service” report2 in April.

“We believe our market share demonstrates the value Oracle Cloud Platform delivers to thousands of enterprises every day,” said Amit Zavery, executive vice president of development, Oracle Cloud Platform. “Our comprehensive iPaaS offering has eliminated the barriers between various Oracle and third-party ERP, HCM, and CX applications to provide a seamlessly connected business spanning cloud and on-premises. This comprehensive and easy-to-use offering, combined with strong synergy with the rest of the Oracle Cloud portfolio, continues to help our customers successfully transform and evolve their businesses by leveraging modern integration technologies, including artificial-intelligence and machine learning-powered services.”

“GE leverages Oracle Integration Cloud to streamline commercial, fulfilment, operations and financial processes of our Digital unit across multiple systems and tools, while providing a seamless experience for our employees and customers,” said Kamil Litman, vice president of software engineering, GE Digital. “Our investment with Oracle has enabled us to significantly reduce time to market for new projects, and we are excited about Oracle’s autonomous cloud capabilities.”

Oracle’s iPaaS offerings include Oracle Integration Cloud, Oracle Data Integration Platform Cloud and Oracle SOA Cloud, all part of Oracle Cloud Platform. Oracle Integration Cloud is a simple and powerful integration platform targeting ad hoc integrators with tools such as process automation, while Oracle SOA Cloud delivers a high-control platform for specialist integrators. With more than 100 adapters, customers can quickly integrate and scale Oracle, third-party, and on-premises applications, APIs, people and devices. Additionally, Oracle has many other cross-PaaS offerings that can be combined with Oracle’s iPaaS services to deliver greater productivity.  Those services include Oracle Data Integration Platform Cloud, to support real-time data streaming, batch data processing, and enterprise data quality and governance; and Oracle API Platform Cloud, for API-first design and management. Oracle API Platform Cloud, leveraging Apiary’s unique API-first design tool used by over 300,000 developers and 400,000 APIs, is designed to eliminate the complexities associated with transforming on-premises API solutions into the cloud, so companies can thrive in the digital economy.

Oracle also previously announced autonomous capabilities across its entire Oracle Cloud Platform portfolio, including application and data integration. This includes self-defining integrations that help customers rapidly automate business processes across different SaaS and on-premises applications, as well as self-defining data flows with automated data lake and data prep pipeline creation for ingesting data (streaming and batch).

1. Gartner, “Market Share Analysis: Integration Platform as a Service, Worldwide, 2017,” by Bindi Bhullar, Massimo Pezzini, Keith Guttridge, Elizabeth Golluscio, Eric Thoo, August 7 2018

2. Gartner, “Magic Quadrant for Enterprise Integration Platform as a Service,” by Keith Guttridge, Massimo Pezzini, Eric Thoo, Bindi Bhullar, Betty J. Zakheim, April 18, 2018

Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings or other designation. Gartner research publications consist of the opinions of Gartner’s research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.

Contact Info
Nicole Maloney
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.


Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Nicole Maloney

  • 1.650.506.0806

Oracle Forms V Oracle APEX Check List

Tom Kyte - Tue, 2018-09-18 03:06
Oracle Forms has some strength and is still the best BackOffice tool from ORACLE from my Point of view. Here are some issues that I miss with APEX. Maybe you already have these Options in 18.x.? Can you check this list: 1. 100% accessiblity for...
Categories: DBA Blogs

Display blob pdf

Tom Kyte - Tue, 2018-09-18 03:06
Dear, I have table lob_table( id number ,doc blob ,namefile varchar (200)) I would like to display blob doc who is pdf file and print it in sqldeveloper. i have create this procedure is it corrects ? CREATE OR REPLACE PROCEDURE PROC2 AS...
Categories: DBA Blogs

Java9 new features

Yann Neuhaus - Tue, 2018-09-18 01:52


Java9 is on its way now, in this blog I’ll talk about the new features I found interesting, the performances and so on.

Configure Eclipse for Java9

Prior to Eclipse Oxygen 4.7.1a, you’ll have to configure eclipse a little bit to make it run your Java9 projects.

Add in eclipse.ini after –launcher.appendVmargs

C:\Program Files\Java\jdk-9.0.4\bin\javaw.exe


Still in eclipse.ini add:



You should have something like this:

C:\Program Files\Java\jdk-9.0.4\bin\javaw.exe
New Features  Modules

Like a lot of other languages, and in order to obfuscate a little more the code, java is going to use Modules. It simply means that you’ll be able to make your code requiring a specific library. This is quite helpful for small memory device that do not need the whole JVM to be loaded. You can have a list of available modules here.

When creating a module, you’ll generate a file called module-info.java which will be like:

module test.java9 {
	requires com.dbiservices.example.engines;
	exports com.dbiservices.example.car;

Here my module requires the “engines” module and exports the “car” module. This allows to only load classes related to our business and not some side libraries, it will help managing memory more efficiently but also requires some understanding regarding the module system. In addition, it creates a real dependency system between jars, and prevent using public classes that were not supposed to be exposed through the API. It prevents some strange behavior when you have duplicates entries, like several jar versions in the classpath. All non-exported modules will be encapsulated by default


Java9 now provides a JShell, like other languages you can now execute java code through a java shell command prompt. Simply starts jshell from the JDK in the bin folder:

jshellThis kind of tool can greatly improve productivity for small tests, you don’t have to create small testing classes anymore. Very useful for regular expressions testing for example.


The old http api is being upgraded finally. It now supports WebSockets and HTTP/2 protocol out of the box. For the moment the API is placed in an incubator module, that mean it can still change a little, but you can start playing with like following:

import jdk.incubator.http.*;
public class Run {

public static void main(String[] args) throws IOException, InterruptedException {
  HttpClient client = HttpClient.newHttpClient();
  HttpRequest req = HttpRequest.newBuilder(URI.create("http://www.google.com"))
  HttpResponse<String> resp = client.send(req, HttpResponse.BodyHandler.asString());

You’ll have to setup module-info.java accordingly:

module test.java9 {
	requires jdk.incubator.httpclient;
 Private interface methods

Since Java 8, an interface can contain behavior instead of only a method signature. But if you have several methods doing quite the same thing, usually you can refactor those methods into a private one. But default methods in java 8 can’t be private. In Java 9 you can add private helper methods to interfaces which can solve this issue:

public interface CarContract {

	void normalMethod();
	default void defaultMethod() {doSomething();}
	default void secondDefaultMethod() {doSomething();}
	private void doSomething(){System.out.println("Something");}

The private method “doSomething()” is hidden from the exposure of the interface.

 Unified JVM Logging

Java 9 adds a handy feature to debug the JVM thanks to logging. You can now enable logging for different tags like gc, compiler, threads and so on. You can set it thanks to the command line parameter -Xlog. Here’s an example of the configuration for the gc tag, using debug level without decoration:


And the result:

ConcGCThreads: 2
ParallelGCThreads: 8
Initialize mark stack with 4096 chunks, maximum 16384
Using G1
GC(0) Pause Young (G1 Evacuation Pause) 24M->4M(254M) 5.969ms
GC(1) Pause Young (G1 Evacuation Pause) 59M->20M(254M) 21.708ms
GC(2) Pause Young (G1 Evacuation Pause) 50M->31M(254M) 20.461ms
GC(3) Pause Young (G1 Evacuation Pause) 84M->48M(254M) 30.398ms
GC(4) Pause Young (G1 Evacuation Pause) 111M->70M(321M) 31.902ms

We can even merge info:


Which results to this:

Heap region size: 1M
Minimum heap 8388608  Initial heap 266338304  Maximum heap 4248829952
GC(0) Heap before GC invocations=0 (full 0):
GC(0)  garbage-first heap   total 260096K, used 24576K [0x00000006c2c00000, 0x00000006c2d007f0, 0x00000007c0000000)
GC(0)   region size 1024K, 24 young (24576K), 0 survivors (0K)
GC(0)  Metaspace       used 6007K, capacity 6128K, committed 6272K, reserved 1056768K
GC(0)   class space    used 547K, capacity 589K, committed 640K, reserved 1048576K
GC(0) Eden regions: 24->0(151)
GC(0) Survivor regions: 0->1(3)
GC(0) Old regions: 0->0
GC(0) Humongous regions: 0->0
GC(0) Heap after GC invocations=1 (full 0):
GC(0)  garbage-first heap   total 260096K, used 985K [0x00000006c2c00000, 0x00000006c2d007f0, 0x00000007c0000000)
GC(0)   region size 1024K, 1 young (1024K), 1 survivors (1024K)
GC(0)  Metaspace       used 6007K, capacity 6128K, committed 6272K, reserved 1056768K
GC(0)   class space    used 547K, capacity 589K, committed 640K, reserved 1048576K
GC(1) Heap before GC invocations=1 (full 0):
GC(1)  garbage-first heap   total 260096K, used 155609K [0x00000006c2c00000, 0x00000006c2d007f0, 0x00000007c0000000)
GC(1)   region size 1024K, 152 young (155648K), 1 survivors (1024K)
GC(1)  Metaspace       used 6066K, capacity 6196K, committed 6272K, reserved 1056768K
GC(1)   class space    used 548K, capacity 589K, committed 640K, reserved 1048576K
GC(1) Eden regions: 151->0(149)
GC(1) Survivor regions: 1->3(19)

There are other new features not detailed here, but you can find a list here.


Cet article Java9 new features est apparu en premier sur Blog dbi services.

Configure AFD with Grid Infrastructure software (SIHA & CRS) from very beginning.

Yann Neuhaus - Tue, 2018-09-18 01:04

Introduction :

Oracle ASM Filter Driver (Oracle ASMFD) simplifies the configuration and management of disk devices by eliminating the need to rebind disk devices used with Oracle ASM each time the system is restarted.
Oracle ASM Filter Driver (Oracle ASMFD) is a kernel module that resides in the I/O path of the Oracle ASM disks. Oracle ASM uses the filter driver to validate write I/O requests to Oracle ASM disks.

In this blog I will explain how to setup a Grid Infrastructure software within AFD on an architecture SIHA or CRS

Case1. You want to configure AFD from very beginning (no UDEV, no ASMLib) with SIHA, Single Instance High Availability installation (former Oracle Restart)

Issue :

If we want to use AFD driver from very beginning, we should use Oracle AFD to prepare some disks for the ASM instance,
The issue is coming from the fact that AFD will be available just after the installation (can be configured before the installation)!

Solution :

Step1. Install GI stack in software only mode


Step2. Run root.sh when is prompted, without any other action(do not execute generated script rootUpgrade.sh)

Step3. Run roothas.pl to setup your HAS stack

[root] /u01/app/grid/product/12.2.0/grid/perl/bin/perl -I /u01/app/grid/product/12.2.0/grid/perl/lib -I /u01/app/grid/product/12.2.0/grid/crs/install /u01/app/grid/product/12.2.0/grid/crs/install/roothas.pl

Step4. As root user proceed to configure AFD

 /u01/app/grid/product/12.2.0/grid/bin/crsctl stop has -f
/u01/app/grid/product/12.2.0/grid/bin/asmcmd afd_configure
/u01/app/grid/product/12.2.0/grid/bin/crsctl start has

Step5.  Setup AFD string to discover new devices , as grid user

 /u01/app/grid/product/12.2.0/grid/bin/asmcmd afd_dsset '/dev/sd*'

Step6. Label new disk as root

 /u01/app/grid/product/12.2.0/grid/bin/asmcmd afd_label DISK1 /dev/sdb1

Step7. As grid user, launch ASMCA , to create your ASM instance, based on the diskgroup created on the new labeled disk , DISK1



Step8. Display AFD driver  within HAS stack.



Case2. You want to configure AFD from very beginning (no UDEV, no ASMLib) with CRS : Cluster Ready Services

Issue :

By installing on software-only mode, you will just copy and relink the binaries.
No wrapper scripts are created as (crsctl or clsecho).
The issue consists that AFD needs wrapper scripts and not the binaries (crsctl.bin).

Solution :

Step1.Do it on all nodes.

Install Grid Infrastructure on the all nodes of the future cluster in the mode “Software-only Installation”.


Step2. Do it on all nodes.

After the installation the wrapper scripts are not present. You can copy from any other installation (SIHA too) or use a cloned home.

After getting the two scripts , modify the variables inside them to be aligned with your current system used for installation:

ORA_CRS_HOME=/u01/app/grid/product/12.2.0/grid  --should be changed
MY_HOST=dbi1 –should be changed
CRF_HOME=/u01/app/grid/product/12.2.0/grid –should be changed

Step3. Do it on all nodes

Configure AFD :

[root@dbi1 grid]# /u01/app/grid/product/12.2.0/grid/bin/asmcmd afd_configure
AFD-627: AFD distribution files found.
AFD-634: Removing previous AFD installation.
AFD-635: Previous AFD components successfully removed.
AFD-636: Installing requested AFD software.
AFD-637: Loading installed AFD drivers.
AFD-9321: Creating udev for AFD.
AFD-9323: Creating module dependencies - this may take some time.
AFD-9154: Loading 'oracleafd.ko' driver.
AFD-649: Verifying AFD devices.
AFD-9156: Detecting control device '/dev/oracleafd/admin'.
AFD-638: AFD installation correctness verified.
Modifying resource dependencies - this may take some time.

Step4. Do it only on the first node.

Scan & label the new disks using AFD.

/u01/app/grid/product/12.2.0/grid/bin/asmcmd afd_label DISK1 /dev/sdb1
/u01/app/grid/product/12.2.0/grid/bin/asmcmd afd_label DISK1 /dev/sdc1
/u01/app/grid/product/12.2.0/grid/bin/asmcmd afd_label DISK1 /dev/sdd1
[root@dbi1 grid]# /u01/app/grid/product/12.2.0/grid/bin/asmcmd afd_scan
[root@dbi1 grid]# /u01/app/grid/product/12.2.0/grid/bin/asmcmd afd_lsdsk

Label                     Filtering   Path


DISK1                       ENABLED   /dev/sdb1

DISK2                       ENABLED   /dev/sdc1

DISK3                       ENABLED   /dev/sdd1

Step5. Do it on the other nodes.

Scan and display the disks on the other nodes of the future cluster. No need to label them again.

[root@dbi2 grid]# /u01/app/grid/product/12.2.0/grid/bin/asmcmd afd_scan
[root@dbi2 grid]# /u01/app/grid/product/12.2.0/grid/bin/asmcmd afd_lsdsk
Label                     Filtering   Path
DISK1                       ENABLED   /dev/sdb1
DISK2                       ENABLED   /dev/sdc1
DISK3                       ENABLED   /dev/sdd1

Step6. Do it on 1st node

Run the script config.sh as oracle/grid user



Step7. Do it on 1st node

Setup the connectivity between all the future nodes of the cluster and follow the wizard.


Step8. Do it on 1st node

You will be asked to create a ASM diskgroup.

Normally without doing previous steps , will not be possible , as no udev no ASMLib no AFD configured. So no labeled disks for that step.



Step9. Do it on 1st node

Change discovery path to ‘AFD:*’and should retrieve the disks labeled on the previous step.


Step10. Do it on 1st node

Provide AFD labeled disks to create the ASM disk group for the OCR files.Uncheck “Configure Oracle ASM Filter Driver”


Step11. Do it on 1st node

Finalize the configuration as per documentation.


Additionally, another way (easier ) to install/configure ASM Filter Driver you can find here :

Summary : Using the scenarios described above , we can configure Grid Infrastructure stack within AFD on  a SIHA or CRS architecture.


Cet article Configure AFD with Grid Infrastructure software (SIHA & CRS) from very beginning. est apparu en premier sur Blog dbi services.

Oracle Utilities Application Framework V4. Release

Anthony Shorten - Mon, 2018-09-17 18:05

Oracle Utilities Application Framework V4. based products will be released over the coming months. As with past release the Oracle Utilities Application Framework has been enhanced with new and updated features for on-premise, hybrid and cloud implementations of Oracle Utilities products.

The Oracle Utilities Application Framework continues to provide a flexible and wide ranging set of common services and technology to allow implementations the ability to meet the needs of their customers.  The latest release provides a wide range of new and updated capabilities to reduce costs and introduce exciting new functionality. The products ships with a complete listing of the changes and new functionality but here are some highlights:

  • Improved REST Support - The REST support for the product has been enhanced in this release. It is now possible to register REST Services in Inbound Web Services as REST. Inbound Web Services definitions have been enhanced to support both SOAP and REST Services. This has the advantage that the registration of integration is now centralized and the server URL for the services can be customized to suit individual requirements. It is now possible to register multiple REST Services within a single Inbound Web Services to reduce costs in management and operations. Execution of the REST Services has been enhanced to use the Registry as the first reference for a service. No additional deployment effort is necessary for this capability. A separate article on this topic will provide additional information.
  • Improved Web Registry Support for Integration Cloud Service - With the changes in REST and other integration changes such as Categories and supporting other adapters, the Web Service Catalog has been expanded to add support REST and other services directly for integration registration for use in the Oracle Integration Cloud.
  • File Access Adapter - In this release a File Adapter has been introduced to allow implementations to parameterize all file integration to reduce costs of management of file paths and ease the path to the Oracle Cloud. In Cloud implementations, an additional adapter is available to allow additional storage on the Oracle Object Storage Cloud to supplement cloud storage for Oracle Utilities SaaS solutions. The File Access Adapter includes an Extendable Lookup to define alias and physical location attributes. That lookup can then be used an alias for file paths in Batch Controls, etc.. A separate article on this topic will provide additional information.
  • Batch Start/End Date Time now part of Batch Instance Object - In past releases the Batch Start and End Dates and times where located as data elements with the thread attributes. This made analysis harder to perform. In this release these fields have been promoted as reportable fields directly on the Batch Instance Object for each thread. This will improve capabilities for reporting performance of batch jobs. For backward compatibility, these fields are only populated for new executions. The internal Business Service F1-GetBatchRunStartEnd has been extended to support the new columns and also detect old executions to return the correct values regardless.
  • New Level of Service Algorithms - In past releases, Batch Level Of Service required the building of custom algorithms for checking batch levels. In this release additional base algorithms for common scenarios like Total Run Time, Throughput and Error Rate are now provided for use. Additionally, it is now possible to define multiple Batch Level Of Service algorithms to model complex requirements. The Health Check API has been enhanced to return the Batch Level Of Service as well as other health parameters. A separate article on this topic will provide additional information.
  • Job Scope in DBMS_SCHEDULER interface - The DBMS_SCHEDULER Interface allowed for specification Batch Control and Global level of parameters as well as at runtime. In this release, it is possible to pre-define parameters within the interface at the Job level, allowing for support for control of individual instances Batch Controls that are used more than once across chains.
  • Ad-hoc Recalculation of To Do Priority - In the past release of the Oracle Utilities Application Framework an algorithm to dynamically reassess ad recalculate a To Do Priority was introduced. In this release, it is possible to invoke this algorithm in bulk using the new provided F1-TDCLP Batch Control.  This can be used with the algorithm to reassess To Do's to improve manual processing.
  • Introduction of a To Do Monitor Process and Algorithm - One of the issues with To Do's in the field has been that users can forget to manually close the To Do when the issue that caused the condition has been resolved. In this release a new batch control F1-TDMON and a new Monitor algorithm on the To Do Type has been added so that logic can be introduced to detect the resolution of the issue can lead to the product automatically closing the To Do.
  • New Schema Editor - Based upon feedback from partners and customers, the usability and capabilities of the Schema Editor have been improved to provide more information as part of the basic views to reduce rework and support cross browser development.
  • Process Flow Editor - A new capability has been added to the Oracle Utilities Application Framework to allow for complex workflows to be modeled and fully capable workflow introduced. This includes train support (including advanced navigation), saving incomplete work support, branching and object integration. This process flow editor was introduced internally successfully to use for our cloud automation in the Oracle Utilities Cloud Services Foundation and has now been introduced, in a new format, for use across the Oracle Utilities Application Framework based products. A separate article on this topic will provide additional information.
  • Improved Google Chrome Support - This release introduces extensive Google Chrome for Business support. Check the availability with each of the individual Oracle Utilities Application Framework based products.
  • New Cube Viewer - In the Oracle Utilities Market Settlements product we introduced a new Cube Viewer to embed advanced analytics into our products. That capability has been made generic and now included in the Oracle Utilities Application Framework so that products and implementations can now build their own cube analytical capabilities. In this release a series of new objects and ConfigTools objects have been introduce to build Cube Viewer based solutions. Note: The Cube Viewer has been built to operate independently of Oracle In-Memory Database support but would greatly benefit from use with Oracle In-Memory Database. A separate article on this topic will provide additional information.
  • Object Erasure Support - To support various data privacy regulations introduced across the world, a new Object Erasure capability has been introduced to manage the erasure or obfuscation of master objects within the Oracle Utilities Application Framework based products. This capability is complementary to the Information Lifecycle Management (ILM) capability introduced to manage transaction objects within the product. A number of objects and ConfigTools objects have been introduced to allow implementations to add Object Erasure to their implementations. A separate article on this topic will provide additional information.
  • Proactive Update ILM Switch Support - In past release, ILM eligibility and the ILM switch was performed in bulk exclusively by the ILM batch processes or using the Automatic Data Optimization (ADO) feature of the Oracle Database. To work more efficiently, it is now possible use the new BO Enter Status plug-in and BO Exit Status plug-in to proactively assess the eligibility and set the ILM switch as part of processing, thus reducing ILM workloads.
  • Mobile Framework Auto Deploy Support - This releases includes a new optional parameter to auto deploy mobile content automatically when a deployment is saved. This can avoid the extra manual deployment step, if desired.
  • Required Indicator on Legacy Screens - In past releases, the required indicator, based upon meta data, has been introduced for ConfigTools based objects, in this release it has been extended to Oracle Utilities Application Framework using legacy screens built using the Oracle Utilities SDK or custom JSP (that confirm to the standards required by the Oracle Utilities Application Framework). Note: Some custom JSP's may contain logic to prevent the correct display the required indicator.
  • Oracle Identity Manager integration improved - In this release the integration with Oracle Identity Manager has been improved with multiple adapters supported and the parameters are now located as a Feature Configuration rather than properties settings. This allows the integration setup to be migrated using Configuration Migration Assistant.
  • Outbound Message Mediator Improvements - In previous releases, implementations were required to use the Outbound Message Dispatcher (F1-OutmsgMediator) business services to send an outbound message without instantiating it but where the outbound message Business Object pre-processing algorithms need to be executed.  This business service orchestrated a creation and deletion of the outbound message, which is not desirable for performance reasons. The alternate business service Outbound Message Mediator (F1-OutmsgMediator) routes a message without instantiating anything, so is preferred when the outbound message should not be instantiated.  However, the Mediator did not execute the Business Object pre-processing algorithms.  In this release the Mediator business service has been enhanced to also execute the Business Object pre-processing algorithms.
  • Deprecations - In this release a few technologies and capabilities will be removed as they were announced in previous releases. These include:
    • XAI Servlet/MPL - After announcing the deprecation of XAI and MPL in 2012, the servlet and MPL software are no longer available in this release. XAI Objects are retained for backward compatibility and last minute migrations to IWS and OSB respectively.
    • Batch On WebLogic - In the Oracle Cloud, batch threadpools were managed under Oracle WebLogic. Given changes to the architecture over the last few releases, the support for threadpools is no longer supported. As this functionality was never released for use on-premise customers, this change does not have any impact to on-premise customers.
    • WebLogic Templates - With the adoption of Oracle WebLogic 12.2+, the necessity of custom WebLogic templates was no longer necessary. It is now possible to use the standard Fusion Middleware templates supplied with Oracle WebLogic with a few manual steps. These additional manual steps are documented in the new version of the Installation Guide supplied with the product. Customers may continue to use the Domain Builder supplied with Oracle WebLogic to build custom templates post Oracle Utilities Application Framework product installation. Customers should stop using the Native Installation or Clustering whitepaper documentation for Oracle Utilities Application Framework V4. and above as this information is now inside the Installation Guide directly or Oracle WebLogic 12.2.1.x Configuration Guide (Doc Id: 2413918.1) available from My Oracle Support.

A number of additional articles will be published over the next few weeks going over some of these topics as well as updates to key whitepapers will be published.

Q1 FY19 GAAP EPS UP 13% TO $0.57 and NON-GAAP EPS UP 18% TO $0.71

Oracle Press Releases - Mon, 2018-09-17 14:21
Press Release
Q1 FY19 GAAP EPS UP 13% TO $0.57 and NON-GAAP EPS UP 18% TO $0.71 Fusion Cloud ERP Customer Count Nearly 5,500, NetSuite Cloud ERP Customer Count Over 15,000

Redwood Shores, Calif.—Sep 17, 2018

Oracle Corporation (NYSE: ORCL) today announced fiscal 2019 Q1 results. Total Revenues were $9.2 billion, up 1% in U.S. dollars and up 2% in constant currency, compared to Q1 last year. Total Cloud Services and License Support plus Cloud License and On-Premise License revenues were up 2% to $7.5 billion. Cloud Services and License Support revenues were $6.6 billion, while Cloud License and On-Premise License revenues were $867 million. Without the strengthening of the U.S. dollar compared to foreign currencies, Oracle’s reported GAAP and non-GAAP Total Revenues would have been $66 million higher, and Earnings Per Share would have been 1 cent higher.

GAAP Operating Income was up 1% to $2.8 billion and GAAP Operating Margin was 30%. Non-GAAP Operating Income was up 1% to $3.8 billion and non-GAAP Operating Margin was 41%. GAAP Net Income was up 6% to $2.3 billion and non-GAAP Net Income was up 10% to $2.8 billion. GAAP Earnings Per Share was up 13% to $0.57 while non-GAAP Earnings Per Share was up 18% to $0.71.

Short-term deferred revenues were up 2% to $10.3 billion compared to a year ago. Operating Cash Flow was up 5% to $15.5 billion during the trailing twelve months.

“We are off to an excellent start with Q1 non-GAAP earnings per share growing 19% in constant currency,” said Oracle CEO, Safra Catz. “That strong earnings per share growth rate increases my confidence that we will deliver on another fiscal year of double-digit non-GAAP earnings per share growth.”

“The vast majority of ERP applications running in the cloud are either Oracle Fusion or Oracle NetSuite systems,” said Oracle CEO, Mark Hurd. “In the first quarter, we increased our market share as customers continued to buy Oracle Fusion ERP to replace their existing SAP and Workday ERP systems. The Oracle Fusion ERP customer count is now nearly 5,500, while the NetSuite ERP customer count is over 15,000. Virtually every analyst ranks Oracle as the market leader in cloud ERP.”

“The Oracle Autonomous Database is now available on our second generation, highly-secure “Bare-Metal” cloud infrastructure,” said Oracle CTO, Larry Ellison. “Oracle’s Autonomous Database is faster, easier-to-use, more reliable, more secure and much lower cost than Amazon’s databases. And Oracle is the only database that can automatically patch itself while running to protect your data from data theft. These are just some of the reasons why Amazon uses the Oracle database to run its business.”

The Board of Directors increased the authorization for share repurchases by $12.0 billion. The Board of Directors also declared a quarterly cash dividend of $0.19 per share of outstanding common stock. This dividend will be paid to stockholders of record as of the close of business on October 16, 2018, with a payment date of October 30, 2018.

Q1 Fiscal 2019 Earnings Conference Call and Webcast

Oracle will hold a conference call and webcast today to discuss these results at 2:00 p.m. Pacific. You may listen to the call by dialing (816) 287-5563, Passcode: 425392. To access the live webcast, please visit the Oracle Investor Relations website at http://www.oracle.com/investor. In addition, Oracle’s Q1 results and fiscal 2019 financial tables are available on the Oracle Investor Relations website.

A replay of the conference call will also be available by dialing (855) 859-2056 or (404) 537-3406, Passcode: 6387377.

Contact Info
Ken Bond
Oracle Investor Relations
Deborah Hellinger
Oracle Corporate Communciations
About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE: ORCL), visit www.oracle.com/ or contact Investor Relations at investor_us@oracle.com or (650) 506-4073.


Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

“Safe Harbor” Statement

Statements in this press release relating to Oracle's future plans, expectations, beliefs, intentions and prospects, including statements regarding the growth of our non-GAAP EPS are all “forward-looking statements” and are subject to material risks and uncertainties. Many factors could affect our current expectations and our actual results, and could cause actual results to differ materially. We presently consider the following to be among the important factors that could cause actual results to differ materially from expectations: (1) Our cloud strategy, including our Oracle Software as a Service, Platform as a Service, Infrastructure as a Service and Data as a Service offerings, may not be successful. (2) If we are unable to develop new or sufficiently differentiated products and services, integrate acquired products and services, or enhance and improve our existing products and support services in a timely manner, or price our products and services to meet market demand, customers may not purchase or subscribe to our software, hardware or cloud offerings or renew software support, hardware support or cloud subscriptions contracts. (3) Enterprise customers rely on our cloud, license and hardware offerings and related services to run their businesses and significant coding, manufacturing or configuration errors in our cloud, license and hardware offerings and related services could expose us to product liability, performance and warranty claims, as well as cause significant harm to our brand and reputation, which could impact our future sales. (4) If the security measures for our products and services are compromised and as a result, our customers’ data or our IT systems are accessed improperly, made unavailable, or improperly modified, our products and services may be perceived as vulnerable, our brand and reputation could be damaged and we may experience legal claims and reduced sales. (5) Our business practices with respect to data could give rise to operational interruption, liabilities or reputational harm as a result of governmental regulation, legal requirements or industry standards relating to consumer privacy and data protection. (6) Economic, political and market conditions can adversely affect our business, results of operations and financial condition, including our revenue growth and profitability, which in turn could adversely affect our stock price. (7) Our international sales and operations subject us to additional risks that can adversely affect our operating results. (8) We have a selective and active acquisition program and our acquisitions may not be successful, may involve unanticipated costs or other integration issues or may disrupt our existing operations. A detailed discussion of these factors and other risks that affect our business is contained in our U.S. Securities and Exchange Commission (SEC) filings, including our most recent reports on Form 10-K and Form 10-Q, particularly under the heading “Risk Factors.” Copies of these filings are available online from the SEC or by contacting Oracle Corporation’s Investor Relations Department at (650) 506-4073 or by clicking on SEC Filings on Oracle’s Investor Relations website at http://www.oracle.com/investor. All information set forth in this press release is current as of September 17, 2018. Oracle undertakes no duty to update any statement in light of new information or future events. 

Talk to a Press Contact

Ken Bond

  • +1.650.607.0349

Deborah Hellinger

  • +1.212.508.7935

User Session lost using ADF Application

Yann Neuhaus - Mon, 2018-09-17 11:45

In one of my missions, I was involved in a new Fusion Middleware 12C ( installation with an ADF application and an Oracle report server instance deployments .
This infrastructure is protected using an Access Manager Single Sign on Server.
In Production, the complete environment is fronted by a WAF server ending the https.
On the TEST The complete environment is fronted by a SSL reverse proxy ending the https.

In the chosen architecture, all Single Sign On request goes directly through the reverse proxy to the OAM servers.
The Application requests and the reports requests are routed through a HTTP server having the WebGate installed.

Below is an extract of the SSL part of the reverse Proxy configuration:
# SSL Virtual Host
ServerName https://mySite.com
ErrorLog logs/ssl_errors.log
TransferLog logs/ssl_access.log
HostNameLookups off
ProxyPreserveHost On
ProxyPassReverse /oam http://appserver.example.com:14100/oam
ProxyPass /oam http://appserver.example.com:14100/oam
ProxyPassReverse /myCustom-sso-web http://appserver.example.com:14100/myCustom-sso-web
ProxyPass /myCustom-sso-web http://appserver.example.com:14100/myCustom-sso-web
ProxyPass /reports http://appserver.example.com:7778/reports
ProxyPassReverse /reports http://appserver.example.com:7778/reports
ProxyPass /myApplication http://appserver.example.com:7778/myApplication
ProxyPassReverse /myApplication http://appserver.example.com:7778/myApplication
# SSL configuration
SSLEngine on
SSLCertificateFile /etc/httpd/conf/ssl/myStite_com.crt
SSLCertificateKeyFile /etc/httpd/conf/ssl/mySite_com.key

HTTP Server Virtual hosts:
# Local requests
Listen 7778
<VirtualHost *:7778>
ServerName http://appserver.example.com:7778
# Rewrite included for OAM logout redirection
RewriteRule ^/oam/(.*)$ http://appserver.example.com:14100/oam/$1
RewriteRule ^/myCustom-sso-web/(.*)$ http://appserver.example.com:14100/myCustom-sso-sso-web/$1

<VirtualHost *:7778>
ServerName https://mySite.com:443

The ADf application and the reports servers mapping is done using custom configuration files included in http.conf files
<Location /myApplication>
SetHandler weblogic-handler
WebLogicCluster appserver.example.com:9001,appserver1.example.com:9003
WLProxySSLPassThrough ON

# Force caching for image files
<FilesMatch "\.(jpg|jpeg|png|gif|swf)$">
Header unset Surrogate-Control
Header unset Pragma
Header unset Cache-Control
Header unset Last-Modified
Header unset Expires
Header set Cache-Control "max-age=86400, public"
Header set Surrogate-Control "max-age=86400"

<Location /reports>
SetHandler weblogic-handler
WebLogicCluster appserver.example.com:9004,appserver1.example.com:9004
DynamicServerList OFF
WLProxySSLPassThrough ON

After configuring a ADF application and the Reports Server to be protected through the WebGate, the users can connect and work without any issue during the first 30 minutes.
Then they loose their sessions. We thought first it was related to the session timeouts or inactivity timeout.
We increased the values of those timeouts without success.
We checked the logs and found out that the issue was related to the OAM and WebGate cookies.

The OAM Server gets and sets a cookie named OAM_ID.
Each WebGate gets and sets a cookie named OAMAuthnCookie_ + the host name and port.

The contents of the cookies are:

Authenticated User Identity (User DN)
Authentication Level
IP Address
SessionID (Reference to Server side session – OAM11g Only)
Session Validity (Start Time, Refresh Time)
Session InActivity Timeouts (Global Inactivity, Max Inactivity)
Validation Hash

The validity of a WebGate handled user session is 30 minutes by default and then the WebGate checks the OAM cookies.
Those cookies are secured and were lost because they were not forwarded by the WAF or the reverse proxy due to ending of the https.

We needed to changes the SSL reverse proxy configuration to send the correct information to the WebLogic Server and HTTP Server about ending SSL at reverse proxy level.
This has been done adding two HTTP Headers to the request before sending them to the Oracle Access Manager or Fusion Middleware HTTP Server.

# For the WebLogic Server to be informed about SSL ending at reverse proxy level
RequestHeader set WL-Proxy-SSL true
# For the Oracle HTTP Server to take the secure cookies in account
RequestHeader set X-Forwarded-Proto “https”

The WAF needed to be configured to do the same HTTP Headers adds in the production environment.

After those changes, the issue was solved.


Cet article User Session lost using ADF Application est apparu en premier sur Blog dbi services.


Subscribe to Oracle FAQ aggregator