Feed aggregator

LISTAGG 4000 CHAR restriction

Tom Kyte - Fri, 2017-12-15 16:46
I am using LISTAGG(card_name, ',') WITHIN GROUP(ORDER BY CardId) CARD_IDS to get the comma separate string. Since there is more data and concatenate data legth exceeds 4000 CHAR due to which LISGADD is failing. My need is to concate strings upto...
Categories: DBA Blogs

acknowledge over PGA limit at the top event in 12c

Tom Kyte - Fri, 2017-12-15 16:46
Hi, We are noticing this wait event (acknowledge over PGA limit) at the top after upgrade from 11g to 12c. We have already tried the workaround to set PGA_TARGET_AGGREGATE to 0 and this wait event still comes up at the top. Is this a problem to ha...
Categories: DBA Blogs

Pass Bind Variable Into Partition Keyword

Tom Kyte - Fri, 2017-12-15 16:46
Hi, I've created a simple example of what I'm trying to do (below). Basically, I'm wondering if I can tell Oracle to treat &var1 as a bind variable so that a profile can be attached to this SQL statement. Is that possible? If so, can you guide ...
Categories: DBA Blogs

How to create a trigger for a table and multiply the values inserted into the table by a function.

Tom Kyte - Fri, 2017-12-15 16:46
Dear Tom My requirement is.. I need to create a trigger for a empty table, where the data will be inserted into the columns. i need to multiply the inserting values by a function which is already created and the result should be stored i...
Categories: DBA Blogs

Difference between Lag and First_value

Tom Kyte - Fri, 2017-12-15 16:46
Hi Tom, I just want to know the difference between the below two queries. Lets say i have a table called member : SQL> select member_id,member_first_name from member; MEMBER_ID MEMBER_FIR ---------- ---------- 1 A 2 B 3 C ...
Categories: DBA Blogs

PLW-07206 compiler warning when assign parameter value to local date value

Tom Kyte - Fri, 2017-12-15 16:46
Please look at this small function: <code>create or replace function next_day_start ( p_date in date ) return date authid definer is l_date date not null:=p_date; begin return 1 + trunc(l_date); end;</code> The idea to assign th...
Categories: DBA Blogs

New packages added to Oracle Linux (OCI SDK/CLI, more EPEL packages, GlusterFS server, Terraform,...

Wim Coekaerts - Fri, 2017-12-15 11:41

For the folks that don't check our awesomely cool what's new page :-) on yum.oracle.com : whats new here's a bit of a summary of some of the cool packages we just added in the last week or 2:

- latest version of terraform (0.11.1-1) and soon a new terraform-provider-oci

- VirtualBox-5.2-5.2.2 updates in the developer repo so you can just yum install it instead of downloading it manually

- a TON, and I mean a TON more packages in our EPEL clone (again, no forking or modifying we just want to make sure it comes from the same place and is signed by us and built by us and we also clone our yum repo inside Oracle Cloud so customers don't get charged for network bandwidth when they download packages for the OS. By having our EPEL clone it counts for all those packages as well of course). Last time I checked we had about 7500 RPMs in the EPEL repo.

- the latest tagged version of the OCI python SDK and CLI (1.3.11 and 2.4.13) - we had a bit of a delay in the past but that's resolved and we're caught up

- GlusterFS server is now in the developer repository for both OL6 and OL78

- we now have an em agent 13cr2 preinstall rpm for OL7 (in add ons) to make it easy to install em agent

- UEK4 update 6 was released yesterday.

More stuff coming soon...


How to create dashboard for MySQL database

Nilesh Jethwa - Fri, 2017-12-15 10:12

MySQL is the most popular Open Source SQL database management system. Due to its reliability and easy-to-use structure, MySQL is widely used within almost any industry. It is used by both small and big businesses. Among MySQL users you can find such huge companies like Facebook, Youtube, Twitter,etc.

Using MySQL with InfoCaptor does not require any JDBC driver as it uses native PHP drivers. In case you need to use JDBC drivers, please check this resource. MySQL Connector/J is the official JDBC driver for MySQL.

Are you using MySQL for your data marts or data-warehouse? If so, build your Free MySQL dashboard software.

Read more at http://www.infocaptor.com/ice-database-connect-dashboard-to-mysql-sql

Riga Dev Days : 2018

Tim Hall - Fri, 2017-12-15 10:05

Just a quick note to say I’ll be speaking at the 2018 Riga Dev Days conference in May next year. They’ve just released the first batch of speakers here. My flights and hotel are already booked!

It’s a multidisciplinary conference, rather than just a straight Oracle conference, which means there is something for everyone there. I was last there in 2015 and it was a really cool experience. I think I’m going to get even more from it this year as my interests have broadened substantially since then!

See you there!



Riga Dev Days : 2018 was first posted on December 15, 2017 at 5:05 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

The technology industry is under broad political attack

DBMS2 - Fri, 2017-12-15 03:25

I apologize for posting a December downer, but this needs to be said.

The technology industry is under attack:

  • From politicians and political pundits …
  • … especially from “populists” and/or the political right …
  • … in the United States and other countries.

These attacks:

  • Are in some cases specific to internet companies such as Google and Facebook.
  • In some cases threaten the tech industry more broadly.
  • Are in some cases part of general attacks on the educated/ professional/“globalist”/”coastal” “elites”.

You’ve surely noticed some of these attacks. But you may not have noticed just how many different attacks and criticisms there are, on multiple levels.

1. Concerns about jobs, disruption, gentrification and so on are a Really Big Deal, causing large swaths of the population to regard technology as bad for their pocketbooks. In particular:

  • There’s tremendous concern about job loss to automation and/or globalization. Technology helps cause the first and enable the second.
  • Generally, when an industry destroys jobs, one hopes that it will create new ones to take their place. But while US technology companies have created many jobs, a lot of those are overseas.
  • Flaps about overseas finances, taxes, and so on aren’t helping. Apple, for example, has major issues in Europe and the US alike.
  • Working-class jobs that tech companies do create are often attacked for their pay and conditions, e.g. for Amazon warehouse workers or Uber drivers.
  • Even when the technology industry unquestionably creates good, domestic jobs, the industry may be attacked for them. Consider for example the concerns about cost of living/gentrification in Northern California.
  • “Sharing economy” companies such as Uber and Airbnb and others are involved in local political fights all around the world, as they undercut traditional service providers.

People who believe that technologists harm them are a major political force.

2. The technology industry is under considerable legislative, regulatory, and judicial pressure. For starters:

  • Tech companies are attacked for doing too little to aid law enforcement and government surveillance.
  • Tech companies are attacked for doing too much to aid law enforcement and government surveillance.
  • Tech companies are attacked for doing too little censorship.
  • Tech companies are attacked for doing too much censorship.
  • Privacy regulations are ever-changing.

Complicating things further, these challenges take different forms in different countries around the world.


  • China pressures foreign vendors to transfer technology into China.
  • Recent network neutrality developments in the US favor older telecom providers, at the expense of newer internet companies.
  • Anti-immigrant policies in the US threaten tech vendors.

I could keep going much longer than that. Government relations are a major, major issue for tech.

3. It is traditional to claim that advances in communication/media technologies will wreck society.

  • Television was going to make us mass-conformist couch potatoes.
  • Video games were going to make us violent couch potatoes.

This era brings similar concerns.

  • Social media makes us couch potatoes sitting in niche-conformist echo chambers.
  • Modern media over-stimulate us and wreck our attention spans.

I.e., the apocalypse is imminent, and tech is what will bring it on.

The most compelling version of that argument I’ve seen is Jean Twenge’s claims that there’s a teen mental health crisis perfectly matched in time to the rise of the smartphone. And to make any such claim seem particularly damning, please recall: Social media and gaming companies are clearly trying to foster a form of addiction in — well, in their users.

Current concern may ebb just like previous generations’ did. But for now, they’re yet another aspect of a threat-filled environment.

4. What worries me most is this: The United States and other countries face relentless attacks on education, educators, science, scientists, and rationality itself. And there are no obvious limits to how bad these can get. China’s Cultural Revolution and the Cambodian genocide happened during my lifetime. Stalin and Hitler ruled during my parents’. All four took particular aim at people like us.

Bottom line: EVERYBODY in the technology industry should be or quickly become politically aware. We have an awful lot of politics to deal with.

Categories: Other

Oracle docker image from docker store

Yann Neuhaus - Fri, 2017-12-15 00:54

Did you notice that each time you want to download the Oracle binaries from the OTN website (for non-production usage) you have to click on the “Accept License Agreement”? This is because you have to agree with the OTN license agreement, and that makes it not easy to distribute an automated way to build an environment.
The only exception I have seen was the sealed envelopes provided for the RACattack:

Software is provided for @ludodba #racattack thanks to @OracleRACpm pic.twitter.com/1GQTVVn2BS

— Franck Pachot (@FranckPachot) September 17, 2015

In both cases, there must be a physical action involved to agree legally with the license terms.


There is now a new possibility where you click on ‘Agree’ only once, in the Docker Store, and then can download (aka ‘pull’) a container containing the binary distribution. You just go to: https://store.docker.com/images/oracle-database-enterprise-edition, login (you can create one in two minutes with a username, e-mail address, and password) and accept the license agreement:
CaptureOracle Docker

Once this is done, you will be able to pull the Oracle containers from the command line, after a ‘docker login’.

It may not be easy to use Docker on your laptop, especially in you are on Windows and don’t want to enable Hyper-V. Here is how I run it on a VirtualBox VM running Oracle Enterprise Linux. You may wonder what’s the point to run containers within a VM. But I think that you don’t have the choice here. The docker processes will run within the host. This means that you need an OS that is supported (and Oracle Enterprise Linux is the best fitted to run Oracle Database). This also means that you also need to adapt the kernel parameters for it, shm, limits, have the oracle user, etc. Better to do that in a VM dedicated for Oracle Database.

Then you wonder what’s the point of running in a container, given that you have to do all those installation prerequisites anyway, and installing Oracle is just two more commands (runInstaller and dbca). Well, it seems that the main reason is that it’s cool. In my opinion, any user of database (from developer to administrator) should have installed an Oracle Database at least with the DBA GUI, because it is a good way to understand what is a database, a listener, a datafile, the characterset,… But let’s be cool and pull it instead of install it.

Docker evolves quickly, I remove old releases just in case:

[root@localhost oracle]# yum -y remove docker-ce docker docker-common docker-selinux docker-engine
Loaded plugins: ulninfo
No Match for argument: docker-ce
No Match for argument: docker
No Match for argument: docker-common
No Match for argument: docker-selinux
No Match for argument: docker-engine
No Packages marked for removal

I’m on the latest OEL7:

[oracle@localhost ~]$ cat /etc/oracle-release
Oracle Linux Server release 7.4
[root@localhost oracle]# yum upgrade
Loaded plugins: ulninfo
No packages marked for update
[oracle@localhost ~]$ uname -a
Linux localhost.localdomain 4.1.12-103.10.1.el7uek.x86_64 #2 SMP Tue Dec 5 15:42:37 PST 2017 x86_64 x86_64 x86_64 GNU/Linux

I don’t want docker to fill my / filesystem, and those images with an Oracle Database are big, so I’m creating a link from /var/lib/docker to /u01

[root@localhost oracle]# mkdir /u01/docker
[root@localhost oracle]# ln -s /u01/docker /var/lib/docker
[root@localhost oracle]# ls -ld /var/lib/docker
lrwxrwxrwx. 1 root root 11 Dec 10 15:48 /var/lib/docker -> /u01/docker

Installing Docker (Community Edition):

[root@localhost oracle]# yum -y install docker-ce
Loaded plugins: ulninfo
docker-ce-stable | 2.9 kB 00:00:00
ol7_UEKR4 | 1.2 kB 00:00:00
ol7_addons | 1.2 kB 00:00:00
ol7_latest | 1.4 kB 00:00:00
docker-ce-stable/x86_64/primary_db | 10 kB 00:00:00
(1/7): ol7_UEKR4/x86_64/updateinfo | 135 kB 00:00:00
(2/7): ol7_addons/x86_64/updateinfo | 40 kB 00:00:00
(3/7): ol7_addons/x86_64/primary | 78 kB 00:00:00
(4/7): ol7_latest/x86_64/group | 681 kB 00:00:00
(5/7): ol7_latest/x86_64/updateinfo | 1.6 MB 00:00:02
(6/7): ol7_UEKR4/x86_64/primary | 25 MB 00:00:25
(7/7): ol7_latest/x86_64/primary | 31 MB 00:00:26
ol7_UEKR4 506/506
ol7_addons 251/251
ol7_latest 23517/23517
Resolving Dependencies
--> Running transaction check
---> Package docker-ce.x86_64 0:17.09.1.ce-1.el7.centos will be installed
--> Processing Dependency: container-selinux >= 2.9 for package: docker-ce-17.09.1.ce-1.el7.centos.x86_64
--> Running transaction check
---> Package container-selinux.noarch 2:2.21-1.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
Package Arch Version Repository Size
docker-ce x86_64 17.09.1.ce-1.el7.centos docker-ce-stable 21 M
Installing for dependencies:
container-selinux noarch 2:2.21-1.el7 ol7_addons 28 k
Transaction Summary
Install 1 Package (+1 Dependent package)
Total download size: 21 M
Installed size: 76 M
Is this ok [y/d/N]: y
Downloading packages:
(1/2): container-selinux-2.21-1.el7.noarch.rpm | 28 kB 00:00:01
(2/2): docker-ce-17.09.1.ce-1.el7.centos.x86_64.rpm | 21 MB 00:00:07
Total 2.7 MB/s | 21 MB 00:00:07
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : 2:container-selinux-2.21-1.el7.noarch 1/2
Installing : docker-ce-17.09.1.ce-1.el7.centos.x86_64 2/2
Verifying : docker-ce-17.09.1.ce-1.el7.centos.x86_64 1/2
Verifying : 2:container-selinux-2.21-1.el7.noarch 2/2
docker-ce.x86_64 0:17.09.1.ce-1.el7.centos
Dependency Installed:
container-selinux.noarch 2:2.21-1.el7

Starting Docker:

[root@localhost oracle]# systemctl start docker

I have to login with my credentials. This is the way to connect with the agreement I accepted online:

[root@localhost oracle]# docker login
Login with your Docker ID to push and pull images from Docker Hub. If you don't have a Docker ID, head over to https://hub.docker.com to create one.
Username: franck.pachot
Login Succeeded

Then I pull the docker container provided by Oracle. Oracle software is quit large when including all features, so I choose the ‘slim’ one:

[root@localhost oracle]# docker pull store/oracle/database-enterprise: Pulling from store/oracle/database-enterprise
4ce27fe12c04: Pull complete
9d3556e8e792: Pull complete
fc60a1a28025: Pull complete
0c32e4ed872e: Pull complete
be0a1f1e8dfd: Pull complete
Digest: sha256:dbd87ae4cc3425dea7ba3d3f34e062cbd0afa89aed2c3f3d47ceb5213cc0359a
Status: Downloaded newer image for store/oracle/database-enterprise:
[root@localhost oracle]#

Here is the image:

[root@localhost oracle]# docker images
store/oracle/database-enterprise 27c9559d36ec 3 months ago 2.08GB

To run a database, you just have to run the container. In order to connect to it, you need to forward the 1521 port:

[root@localhost oracle]# docker run -p store/oracle/database-enterprise:
Setup Oracle Database
Oracle Database Setup
Sun Dec 10 19:09:14 UTC 2017
Check parameters ......
log file is : /home/oracle/setup/log/paramChk.log
paramChk.sh is done at 0 sec
untar DB bits ......
log file is : /home/oracle/setup/log/untarDB.log

Ok. This takes some time. The ORACLE_HOME is unzipped, then the database created…

I’ll not describe further. Just go to the Setup Instructions in https://store.docker.com/images/oracle-database-enterprise-edition where everything is clearly explained.

In my opinion, it is good to try and think about it. Docker was created to containerize an application with process(es) and memory. A database is a different beast. The database is persistent, so you should store it in an external volume, because you don’t want to create a new empty database each time you start it. There are also the configuration files which should be persistent: should they belong to the container or be external? And the logs under ORACLE_BASE_DIAG? Do you want to keep them? purge them? Or just let the image grow, which can be very quick if you fill the Recovery Area. Finally, do you want to run a container into a Virtual Machine, this container running Oracle Database 12c, which is a Container Database (CDB), itself containing containers (PDBs)? Personally, I’m very skeptical about the usage of docker for an Oracle Database. But I also gave it an early try some years ago (read here). And you may see things differently in your context. The very good point is that Oracle now provides an easy way to test whether it helps you to run a database quickly or not, with a way to get the binaries without an ‘accept’ click for each download.


Cet article Oracle docker image from docker store est apparu en premier sur Blog dbi services.

Handle HTTP PATCH request with Java Servlet

Amis Blog - Thu, 2017-12-14 23:04

The Java Servlet specification does not include handling a PATCH request. That means that class  javax.servlet.http.HttpServlet does not have a doPatch() method, unlike doGet, doPost, doPut etc.

That does not mean that a Java Servlet can not handle PATCH requests. It is quite simple to make it do that.

The trick is overriding the service(request,response) method – and have it respond to PATCH requests (in a special way) and to all other requests in the normal way. Or to do it one step more elegantly:

  1. create an abstract class – MyServlet for example – that extends from HttpServlet, override servce() and add an abstract doPatch() method – that is not supposed to be ever invoked but only be overridden
    package nl.amis.patch.view;
    import java.io.IOException;
    import javax.servlet.ServletException;
    import javax.servlet.http.HttpServlet;
    import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;
    public abstract class MyServlet extends HttpServlet {
        public void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
            if (request.getMethod().equalsIgnoreCase("PATCH")){
               doPatch(request, response);
            } else {
                super.service(request, response);
        public abstract void doPatch(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException;
  2. any servlet (class) that should handle PATCH requests should extend from this class [MyServlet] and implement the doPatch() method


package nl.amis.patch.view;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.*;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.*;

@WebServlet(name = "TheServlet", urlPatterns = { "/theservlet" })
public class TheServlet extends MyServlet {
    private static final String CONTENT_TYPE = "text/html; charset=windows-1252";

    public void init(ServletConfig config) throws ServletException {

    public void doPatch(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        PrintWriter out = response.getWriter();
        out.println("<p>The Servlet has received a PATCH request and will do something meaningful with it! This is the reply.</p>");


Here is the result of sending a PATCH request from Postman to the Servlet:



The post Handle HTTP PATCH request with Java Servlet appeared first on AMIS Oracle and Java Blog.

List of “Dashboard” Startups and Products

Nilesh Jethwa - Thu, 2017-12-14 14:14

The idea of building a dashboard application has become synonymous to the idea of a developer thinking let us build a "To-do" application.

This is evident by the sheer amount of dashboard related applications that developers/founders have submitted to Hacker News over the past several years.

The dashboards range from wide spectrum, on one side to personal dashboards, project management dashboards, network dashboards to full blown social media dashboards.

If you are looking to build the next dashboard application or just shopping, it is very interesting to look at all the "Show HN" Dashboard submissions

Read more at http://www.infocaptor.com/dashboard/list-of-dashboard-startups

Q2 FY18 GAAP EPS UP 8% TO $0.52 and NON-GAAP EPS UP 14% TO $0.70

Oracle Press Releases - Thu, 2017-12-14 14:04
Press Release
Q2 FY18 GAAP EPS UP 8% TO $0.52 and NON-GAAP EPS UP 14% TO $0.70 Q2 FY18 Cloud Revenues Up 44% to $1.5 Billion and Total Revenues Up 6% to $9.6 Billion

Redwood Shores, Calif.—Dec 14, 2017

Oracle Corporation (NYSE: ORCL) today announced fiscal 2018 Q2 results. Total Revenues were up 6% to $9.6 billion, compared to Q2 last year. Cloud plus On-Premise Software Revenues were up 9% to $7.8 billion. Cloud Software as a Service (SaaS) revenues were up 55% to $1.1 billion. Cloud Platform as a Service (PaaS) plus Infrastructure as a Service (IaaS) revenues were up 21% to $396 million. Total Cloud Revenues were up 44% to $1.5 billion.

GAAP Operating Income was up 1% to $3.1 billion and GAAP Operating Margin was 32%. Non-GAAP Operating Income was up 10% to $4.2 billion and non-GAAP Operating Margin was 44%. GAAP Net Income was up 10% to $2.2 billion, while non-GAAP Net Income was up 16% to $3.0 billion. GAAP Earnings Per Share was up 8% to $0.52, while non-GAAP Earnings Per Share was up 14% to $0.70.

Short-term deferred revenues were up 9% to $8.1 billion. Operating cash flow on a trailing twelve-month basis was up 2% to $14.6 billion.

“Overall cloud revenue growth of 44% drove our quarterly revenue and earnings higher,” said Oracle CEO, Safra Catz. “With non-GAAP Cloud SaaS Applications growth of 49% leading the way, Oracle delivered 14% non-GAAP earnings per share growth and 6% overall revenue growth. Our success in the quarter was based on the increasing scale and the gathering momentum in our cloud business. I expect the business to continue to grow and strengthen over the coming quarters.”

“Our Fusion ERP and Fusion HCM SaaS applications suite revenues grew 65% in the quarter,” said Oracle CEO, Mark Hurd. “We are now the clear market leader in enterprise back-office SaaS applications with over 5,000 Fusion customers. And we expect to extend our lead by selling around $2 billion in new enterprise SaaS application cloud subscriptions over the coming four quarters. That’s more new SaaS sales than any of our competitors.”

“Oracle will soon deliver the world’s first autonomous “self-driving” database,” said Oracle CTO, Larry Ellison. “The new artificially intelligent Oracle database is fully automated and requires no human labor for administration. If a security vulnerability is detected, the database immediately patches itself while running. No other system can do anything like this. Best of all, we guarantee the price of running the Oracle Autonomous Database in the Oracle Cloud is less than half the cost of running a database in the Amazon Cloud.”

The Board of Directors increased the authorization for share repurchases by $12 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 January 10, 2018, with a payment date of January 24, 2018.

Q2 Fiscal 2018 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 Q2 results and Fiscal 2018 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: 9396959.

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/investor 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 cloud business, extension of our market position and sales in enterprise SaaS applications, and delivery of our new autonomous database, 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 computing strategy, including our Oracle Cloud SaaS, PaaS, IaaS and data as a service offerings, may not be successful. (2) If we are unable to develop new or sufficiently differentiated products and services, or to enhance and improve our products and support services in a timely manner or to position and/or price our products and services to meet market demand, customers may not buy new software licenses, cloud software subscriptions or hardware systems products or purchase or renew support contracts. (3) If the security measures for our products and services are compromised or if our products and services contain significant coding, manufacturing or configuration errors, we may experience reputational harm, legal claims and reduced sales. (4) We may fail to achieve our financial forecasts due to such factors as delays or size reductions in transactions, fewer large transactions in a particular quarter, fluctuations in currency exchange rates, delays in delivery of new products or releases or a decline in our renewal rates for support contracts. (5) Our international sales and operations subject us to additional risks that can adversely affect our operating results, including risks relating to foreign currency gains and losses. (6) Economic, geopolitical 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) We have an 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 December 14, 2017. 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

OpenSSL and mod_ssl Replacing Oracle Wallet and mod_ossl for EBS 12.1

Steven Chan - Thu, 2017-12-14 12:14

The use of mod_ssl is being phased in along with OpenSSL for the E-Business Suite 12.1 product line. Oracle E-Business Suite Release 12.1 is migrating to OpenSSL and mod_ssl technology in order to future proof the TLS implementation.  OpenSSL and mod_ssl are required for TLS 1.1 or TLS 1.2 and to support new cipher suites.

We provided support for mod_ssl and OpenSSL in a phased approach, so that deployment can be planned methodically.  Given the rate of SSL and TLS vulnerabilities that have been found recently and the limited number of strong cipher suites supported with Oracle Wallet, we highly recommend that our customers make the transition to TLS 1.1 or 1.2 sooner rather than later. This way, migrating does not have to be done as a fire drill.

You should follow the instructions in Enabling TLS in Oracle E-Business Suite Release 12.1 (Note 376700.1) to implement or migrate to OpenSSL and mod_ssl. 

For reference, the older mod_ossl (SSL v3 and TLS 1.0) which uses the Oracle wallet for the certificates is documented in Enabling SSL or TLS in Oracle E-Business Suite Release 12 (2143099.1).  

Related Articles


Categories: APPS Blogs

Set autotrace on

Tom Kyte - Thu, 2017-12-14 04:06
Hi Tom When I enter the statement set autotrace on i get the following error. SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled SP2-0611: Error enabling STATISTICS report How can solve it?
Categories: DBA Blogs

hash join

Tom Kyte - Thu, 2017-12-14 04:06
Hi Tom , I have your book and am still not able to understand the mechanism of hash join . it just says similar to this ( I do not have book at work so can not exactly reproduce it ) one table would be hashed into memory and then the other table...
Categories: DBA Blogs

SQL Loader - Load CSV file, double quoted record, dual double quoted field

Tom Kyte - Thu, 2017-12-14 04:06
Hello, Please tell me how to write the control file to load following data (without quotes) using sqlldr in three separate data fields. We get such a csv file from out client and they can't change the way it generates. This file opens fine in M...
Categories: DBA Blogs

ORA-29471: DBMS_SQL access denied

Tom Kyte - Thu, 2017-12-14 04:06
I have a problem in procedure: procedure .. begin v_c := dbms_sql.open_cursor; v_c2 := dbms_sql.open_cursor; dbms_sql.parse(v_c, v_sql, dbms_sql.native); dbms_sql.parse(v_c2, v_query, dbms_sql.native); v_stmt := dbms_sql.execute(...
Categories: DBA Blogs

Error in Opening KeyStore in Oracle 12c R2

Tom Kyte - Thu, 2017-12-14 04:06
I am trying to create TDE example . I was able to create a keystore ; but when I open the key store , I am getting ORA-28367. What am I missing here ? Thanks very much in advance. <code> SQL> select * from v$version ; BANNER ...
Categories: DBA Blogs


Subscribe to Oracle FAQ aggregator