viernes, 26 de agosto de 2016

How to get ORE to work with APEX by Brendan Tierney

This blog post will bring you through the steps of how to get Oracle R Enterprise (ORE) to work with APEX.

The reason for this blog posts is that since ORE 1.4+ the security model has changed for how you access and run in-database user defined R scripts using the ORE SQL API functions.

I have a series of blog posts going out on using Oracle Text, Oracle R Enterprise and Oracle Data Mining. It was during one of these posts I wanted to show how easy it was to display an R chart using ORE in APEX. Up to now my APEX environment consisted of APEX 4 and ORE 1.3. Everything worked, nice and easy. But in my new APEX environment (APEX 5 and ORE 1.5), it didn't work. This is the calling of an in-database user defined R script using the SQL API functions didn't work. Here is the error message that is displayed.


So something extra was needed with using ORE 1.5. The security model around the use of in-database user defined R scripts has changed. Extra functions are now available to allow you who can run these scripts. For example we have an ore.grant function where you can grant another user the privilege to run the script.

But the problem was, when I was in APEX, the application was defined on the same schema that the r script was created in (this was the RQUSER schema). When I connect to the RQUSER schema using ORE and SQL, I was able to see and run this R script (see my previous blog post for these details). But when I was in APEX I wasn't able to see the R script. For example, when using the SQL Workshop in APEX, I just couldn't see the R script.

Something strange is going on. It turns out that the view definitions for the in-database ORE scripts are defined with
(Thanks to the Oracle ORE team and the Oracle APEX team for their help in working out what needed to be done)

This means when I'm connected to APEX, using my schema (RQUSER), I'm not able to see any of my ORE objects.

How do you overcome this problem ?
To fix this problem, I needed to grant the APEX_PUBLIC_USER access to my ORE script.
ore.grant(name = "prepare_tm_data_2", type = "rqscript", user = "APEX_PUBLIC_USER")
Now when I query the ALL_RQ_SCRIPTS view again, using the APEX SQL Workshop, I now get the following.


Great. Now I can see the ORE script in my schema.

Now when I run my APEX application I now get graphic produced by R, running on my DB server, and delivered to my APEX application using SQL (via a BLOB object), displayed on my screen.


FBI: Oregon man charged with cyberstalking, making interstate threats

Department of Justice
U.S. Attorney’s Office
Northern District of Ohio

Wednesday, August 24, 2016

An Oregon man was charged with cyberstalking and other offenses for making numerous threats to his former co-workers and law enforcement officials.

Michael A. Hagar, 46, was charged with one count of cyberstalking and two counts of interstate threatening communication.

Hagar was employed at a Goodyear store in Salem, Oregon, from 2011 through 2013. He was employed by Eaton in Portland, Oregon, from 2014 through 2015. He was involuntarily terminated from both positions, according to the indictment.

Hager sent numerous threatening e-mails to at least seven former co-workers at Eaton and Goodyear in 2015 and 2016, as well as threatening emails to law enforcement officials in Oregon. The e-mails he sent traveled through Eaton and Goodyear data centers in Northeast Ohio, according to the indictment.

In 2016, Hagar was personally served with a temporary stalking protective order ordering him to stop any contact with an Eaton employee identified as R.G. He was also arrested for trespassing on Goodyear property in Oregon, according to the indictment.

On May 30, 2016, he sent an email to R.G. and Oregon law enforcement officials with the subject line: “I AM GOING TO RUIN EVERYONE OF YOU(R) LIVES,” according to the indictment.

This case is being prosecuted by Assistant U.S. Attorneys Daniel J. Riedl and Om Kakani following an investigation by the FBI.

If convicted, the defendant’s sentence will be determined by the court after a review of the federal sentencing guidelines and factors unique to the case, including the defendant’s prior criminal record (if any), the defendant’s role in the offense, and the characteristics of the violation.

An indictment is only a charge and is not evidence of guilt. A defendant is entitled to a fair trial in which it will be the government’s burden to prove guilt beyond a reasonable doubt.
Cyber Crime
Updated August 24, 2016

FBI: Jacob “Kobi” Alexander Pleads Guilty To Securities Fraud

Department of Justice
U.S. Attorney’s Office
Eastern District of New York

Wednesday, August 24, 2016

Founder and Former CEO of Comverse Technology Was Extradited from Namibia to Face Charges Related to an Options Backdating Scheme

BROOKLYN, N.Y. – Jacob Alexander, also known as “Kobi Alexander,” an Israeli national, pleaded guilty today to one count of securities fraud for his role in a stock options backdating scheme involving Comverse Technologies Inc. (Comverse).  Following a bail hearing, the court entered a permanent order of detention. 
Alexander was a founder, former Chief Executive Officer, and member of the Board of Directors of Comverse, which was traded on the NASDAQ stock market.  Comverse was a component stock of the S&P 500 and the NASDAQ 100 at the time of the offense.  Alexander was ordered extradited from Namibia on Monday, August 22, 2016, after having been indicted in the Eastern District of New York more than ten years ago.  Alexander arrived at John F. Kennedy International Airport in Queens, New York, this morning in the custody of special agents of the Federal Bureau of Investigation.  When sentenced, Alexander faces up to 10 years in prison.  Sentencing is set for 12:00PM on December 16, 2016.
The extradition and guilty plea were announced by U.S. Attorney Robert L. Capers of the Eastern District of New York, and Diego Rodriguez, Assistant Director-in-Charge, Federal Bureau of Investigation, New York Field Office (FBI).
“By fraudulently backdating Comverse stock options, the defendant personally gained millions of dollars in paper profits.  He then compounded his crime by attempting to bribe a witness to make false statements to government investigators.  For more than ten years, law enforcement pursued Kobi Alexander, and now he will be held to account for his role in a securities fraud scheme,” stated United States Attorney Capers.  “The guilty plea announced today demonstrates our steadfast commitment to enforce the law against corporate executives who defraud the investing public.”  
“The wheels of justice turn slowly but they keep moving; this is especially true in the case against Jacob “Kobi” Alexander.  Today, Alexander pled guilty to a charge that was brought forth by the FBI more than 10 years ago for his role in a securities fraud scheme.  Alexander and his coconspirators backdated the issuance of Comverse stock options, awarded them to themselves, and then lied to investors in public filings.  The scheme profited Alexander millions of dollars.  Ensuring that all investors have factual information and our markets are fair is exactly why the FBI continues to investigate and bring those to justice who perpetrate securities fraud schemes,” stated FBI Assistant Director-in-Charge Rodriguez.
U.S. Attorney Capers and FBI Assistant Director-in-Charge Rodriguez thanked the Department of Justice’s Office of International Affairs (OIA), the National Police for the Republic of Namibia, Interpol, and FBI Legat Pretoria for their invaluable assistance during the extradition proceedings.  They also thanked the Securities and Exchange Commission (SEC) for their cooperation and assistance in the investigation and prosecution.
According to charging documents, the guilty plea proceeding, and other documents filed by the government in this case, Comverse was a communications software company with offices in Woodbury, New York.  Between 1998 and 2006, the defendant and his coconspirators engaged in a fraudulent backdating scheme using hindsight to select the issuance date of Comverse stock options, which they awarded to themselves and Comverse employees, and then lied about this practice to investors in public filings and elsewhere.  In doing so, the defendant and his coconspirators were able to select issuance dates when Comverse stock was trading lower, thereby awarding themselves and Comverse employees “in-the-money” options without properly accounting for these options in Comverse’s financial disclosures to investors.  By backdating options, the defendant and his coconspirators violated accounting rules and caused Comverse to overstate its profits.  Additionally, the backdated options also violated the terms of Comverse’s stock option plans that were approved by its shareholders.  As the top recipient of stock options in every company-wide grant, the defendant gained millions of dollars in paper profits from the scheme.  Ultimately, the defendant forfeited $60 million, which was applied as restitution to compensate Comverse shareholders. 
When the defendant’s conduct came to light, he attempted to obstruct justice by offering to bribe a witness to make false statements to federal investigators.  Shortly before being charged in connection with his scheme, and after he was aware of the government’s investigation, the defendant moved to Namibia, where he relocated with his family.  The government promptly sought the defendant’s extradition.
Today’s guilty plea took place before United States District Judge Nicholas G. Garaufis.           
*          *          *
The government’s case is being prosecuted by the Office’s Business and Securities Fraud Section.  Assistant United States Attorney James P. Loonam is in charge of the prosecution and led the Office’s efforts to secure Alexander’s extradition from Namibia, with assistance from the Department of Justice’s Office of International Affairs.
*          *          *
The charges in this case were brought in connection with the President’s Financial Fraud Enforcement Task Force.  The task force was established to wage an aggressive, coordinated, and proactive effort to investigate and prosecute financial crimes.  With more than 20 federal agencies, 94 U.S. attorneys’ offices, and state and local partners, it is the broadest coalition of law enforcement, investigatory, and regulatory agencies ever assembled to combat fraud.  Since its formation, the task force has made great strides in facilitating increased investigation and prosecution of financial crimes; enhancing coordination and cooperation among federal, state, and local authorities; addressing discrimination in the lending and financial markets; and conducting outreach to the public, victims, financial institutions, and other organizations.  Since fiscal year 2009, the Justice Department has filed over 18,000 financial fraud cases against more than 25,000 defendants.  For more information on the task force, please
The Defendant:
JACOB ALEXANDER, also known as “Kobi Alexander”
Age:  64
E.D.N.Y. Docket No. 06-CR-628 (NGG)

Oracle Database Appliance X6-2S / X6-2M Support Oracle Database Standard Edition and Oracle Database Standard Edition One

By Tammybednar-Oracle on Aug 25, 2016

The next Oracle Database Appliance software update ( will add support for Oracle Database 11g Standard Edition and Standard Edition One (release running on Oracle Database Appliance X6-2S /X6-2M. You will be able to deploy and run Oracle Database Standard Edition (release on ODA X6-2S/X6-2M and utilize Oracle Database Standard Edition, Oracle Database Standard Edition One, or Oracle Database Standard Edition 2 licenses. Refer to the table below for specific details.

Database Version
License Required
Standard Edition/Standard Edition One (

  • 1 x DB SE, or
  • 1 x DB SE1, or
  • 1 x DB SE2
Standard Edition/Standard Edition One (
  • 2 x DB SE, or
  • 2 x DB SE1, or
  • 2 x DB SE2
Enterprise Edition ( or
  • ODA X6-2S, or
  • ODA X6-2M, or
  • ODA X5-2-HA
 (number of cores enabled/2) x DB EE (plus options)
Standard Edition 2 (
1 x DB SE2
Standard Edition 2 (
2 x DB SE2

Frequently Asked Questions:
Q: If I have an SE or SE1 license, can I run Oracle Database 12c Standard Edition?  You must migrate your license to SE2, and then you can run Oracle Database 12c Standard Edition 2.

Q: Can I run Oracle Database 11g Standard Edition on an ODA X6-2 S/X6-2M using an SE One license?  Yes.   SE is valid on servers with up to a four sockets, and SE1 is valid servers with up to two sockets.  ODA X6-2S/X6-2M thus meets the criteria for either SE or SE1 licenses.

Q: Can I purchase a new license to run Oracle Database 11g Standard Edition?  Yes, but you must purchase an Oracle Database Standard Edition 2 license, which will entitle you to run Oracle Database 11g Standard Edition as well as Oracle Database 12g Standard Edition 2.

Q: Can I run Oracle Database Standard Edition on ODA X5-2?  No, only ODA X6-2S/X6-2M are eligible to run Standard Edition.

Q: When will 11g Standard Edition be supported on ODA? Effective with the update, currently targeted for release on August 29.

Q: Can I use Capacity on Demand licensing with Standard Edition (SE/SE1/SE2)? No, you cannot disable an entire socket in any X86 server. 

Q: Can I run Oracle Standard Edition Real Application Clusters (SE RAC) on ODA? No, SE RAC requires an HA configuration like the ODA X5-2, and that platform is not eligible to run Standard Edition.

Oracle Information InDepth Database Insider Edition

Oracle Information InDepth
Oracle Database 12c
Oracle Database 12c Plug into the Cloud
Aug 2016


Stay Connected
Oracle Blog
Oracle on Twitter
Oracle on Facebook
Oracle on Youtube
Oracle on LinkedIn

Contact Oracle
Global Contacts
Sales Chat

Organizers of Oracle OpenWorld 2016 have announced key events and speakers for the conference, taking place September 18-22, 2016 in San Francisco’s Moscone Center. Get information about the don’t-miss sessions recommended by the Oracle Database team.
Read More

At Oracle OpenWorld, you’ll discover ways to optimize your database systems and solutions to help you take your business to the cloud. In the Hands-on-Lab sessions you’ll hear from Oracle experts and thought leaders sharing best practices aimed to make you successful at your job!
Read More


Juan Loazia
Oracle senior vice president, Juan Loazia, discusses big changes sweeping through the database industry. Database architectures are fundamentally changing due to new technologies and new requirements. Organizations need to understand and embrace these transformations to thrive in the future economy.


Oracle Database In-Memory Toolkit for SAP BW
Performance Gurus! Don't delay! Download the NEW Oracle Database In-Memory toolkit for SAP BW & watch your analytics fly!



Read blogs from Oracle and the extended community of Oracle Database evangelists.


Oracle Cloud Marketplace
Oracle Specialized Partner
Oracle Exastack Partner
Oracle Validated Integrations


Subscribe to the digital edition of Oracle Magazine now, and get issues delivered straight to your device. Enjoy all the benefits of a free subscription: get the latest issue early, share your favorite content, bookmark your favorite articles, and get exclusive content and videos. Sign up for the digital edition of Oracle Magazine today!
Oracle Magazine


Oracle Database 12c Courses Available in Training On Demand Learning Format
Training On Demand is expert training from Oracle’s top instructors in a sophisticated streaming video recording available for 90 days, 24 hours a day, 7 days a week. There are multiple Oracle Database 12c courses available in this format. The Training On Demand learning format will provide you with these benefits:
  • You can focus on specific topics or take the full course in one go
  • You can start. stop, pause, jump or rewind sections of the course as needed
  • There is a full-text search that leads to the relevant video fragment in a matter of seconds
  • You learn from the comfort of the (home) office. No travel is required
Featured Oracle Database 12c Courses:
Also available is the Oracle Cloud Platform as a Service (PaaS) Learning Subscription. Learn how to migrate your skills to the Cloud.
Visit to view Oracle Database 12c courses and related certification details.


September 18–22, 2016 | San Francisco, California | #oow16

December 5–7, 2016 | Birmingham, UK

January 31 – February 2, 2017 | Redwood Shores, CA | #BIWA2017

Please send questions or comments to
This document is provided for information purposes only, and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor is it subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document, and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission.
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

Integrated Cloud Applications and Platform Services

Oracle Corporation