Feed aggregator

Run class Java in Oracle from other databases

Tom Kyte - Tue, 2018-09-25 18:26
Hello Is it possible to create a Java class using JDBC and run a job, I have seen that it has how to execute Java classes in SQL Developer, I would like it to work in Oracle itself, not in SQL Developer
Categories: DBA Blogs

Overlapping of dates

Tom Kyte - Tue, 2018-09-25 18:26
I have two scenarios explained below: 1. Suppose say, I have an organization with start date as 01/JAN/2017 and end date as 31/DEC/2017. The speciality of my organization has the start date as 01/OCT/2017 and end date as 10/OCT/2018. So when the qu...
Categories: DBA Blogs

Oracle Boosts Software Development Productivity with New Java Release

Oracle Press Releases - Tue, 2018-09-25 12:00
Press Release
Oracle Boosts Software Development Productivity with New Java Release JDK 11 first Long Term Support release under new six-month cadence

Redwood Shores, Calif.—Sep 25, 2018

Continuing its commitment to deliver a regular cadence of Java innovations and updates to the community, Oracle today announced the general availability of Java SE 11 (JDK11). JDK 11 brings a number of new developer productivity enhancements as well as support for modern cryptographic and Internet standards, including TLS 1.3 and HTTP/2.

The first Long Term Support (LTS) update under Oracle’s six-month release schedule announced last year, JDK 11 is the result of extensive collaboration between Oracle engineers and members of the worldwide Java developer community via the OpenJDK Community and the JCP. Since the release of Java SE 8, the community has collaborated on more than 100 new enhancements that were added through JDK 9, 10, and 11.

“TLS 1.3 was recently approved and it's fantastic news that Java SE 11 will support it right away,” said Jim Manico, co-author of Iron Clad Java and founder of Manicode Security. “The new Java release cycle for Java SE means that important security protocols and other standards such as TLS 1.3 can be released and adopted rapidly, giving application developers more tools to write secure software with the world’s most popular language - Java!”

Customers can now migrate from Java SE 8 to Java SE 11 at the pace that best meets their unique business needs, backed by Oracle’s Long Term Support. Oracle will offer its customers security and bug-fixing updates for JDK 11 through 2026, with the next LTS release scheduled for September 2021.

“Thanks to continuous improvements by Oracle and the Java Community, the JVM remains the best platform for building applications,” said Rafael Winterhalter, from Scienta Norway and creator of the popular Byte Buddy code generation and manipulation library for Java. “The Java SE 11 release gives me confidence as we see the benefits of the module system taking hold, making Java applications more encapsulated and transparent. This is crucial in times where applications become increasingly complex and rely on growing numbers of dependencies. Newer features being explored like 'nestmates' provide great promise of improved startup and compilation performance going forward”.

Key features in Java 11 include:

  • Nest-based access controls: eliminates the need for compilers to insert accessibility-broadening bridge methods.

  • Dynamic class-file constants: reduces the cost and disruption of creating new forms of materializable class-file constants and offers broader options for expressivity and performance.

  • ZGC: a completely passive GC implementation with a bounded allocation limit and the lowest latency overhead possible.

  • Flight Recorder: low overhead data collection framework for troubleshooting Java applications and the HotSpot JVM.

“The LTS model releases enable our customers to migrate from one well-supported Java SE LTS release to the next at their own pace, while at the same time allowing the Java developer ecosystem to get access to improvements faster than before,” said Georges Saab, Vice President, Software Development, Java Platform Group at Oracle. “Together with the introduction of Oracle Java SE Subscription, customers now have an easy way to benefit from access to regular releases of tested and certified performance, stability, and security updates, directly from Oracle.”

Java SE Subscription is Oracle’s low-cost and predictable offering to manage Oracle Java SE installations across enterprises. To learn more about JDK 11, visit the Java PM blog and see the full list of features here. 

To see these innovations in action, join Oracle Code One, Oracle’s inaugural full-stack developer conference, October 22-25, 2018 in San Francisco. Register at: https://www.oracle.com/code-one

Java is the world’s most popular programming language, with over 12 million developers running Java. Java is also the #1 developer choice for cloud, with over 21 billion cloud-connected Java virtual machines.

Contact Info
Alex Shapiro
Oracle
+1.415.608.5044
alex.shapiro@oracle.com
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.

Trademarks

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

Alex Shapiro

  • +1.415.608.5044

Oracle 18c : Active Data Guard and AWR Reports

Yann Neuhaus - Tue, 2018-09-25 09:43

Since Oracle Database 12c Release 2 (12.2), Automatic Workload Repository (AWR) data can be captured for Active Data Guard (ADG) standby databases. This feature enables analyzing any performance-related issues for ADG standby databases
AWR snapshots for ADG standby databases are called remote snapshots. A database node, called destination, is responsible for storing snapshots that are collected from remote ADG standby database nodes, called sources.
The AWR data captures for Active Data Guard require certain steps that I am trying to describe here. I am using Oracle 18c with following configuration

DGMGRL> show configuration

Configuration - NONC18C_DR

  Protection Mode: MaxPerformance
  Members:
  NONC18C_SITE1 - Primary database
    NONC18C_SITE2 - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS   (status updated 30 seconds ago)

DGMGRL>

The primary is opened in Read Write mode and the standby in Read Only Mode With Apply

SQL> select db_unique_name,open_mode, database_role from v$database;

DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE
------------------------------ -------------------- ----------------
NONC18C_SITE2                  READ ONLY WITH APPLY PHYSICAL STANDBY

SQL> select db_unique_name,open_mode, database_role from v$database;

DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE
------------------------------ -------------------- ----------------
NONC18C_SITE1                  READ WRITE           PRIMARY

SQL>

The feature uses the Remote Management Framework which comes with a New Oracle built-in user called SYS$UMF. This user is locked by default and should be unlocked before configuring the RMF.

SQL> select username,common,account_status from dba_users where username like 'SYS%';

USERNAME                       COM ACCOUNT_STATUS
------------------------------ --- --------------------------------
SYS                            YES OPEN
SYSTEM                         YES OPEN
SYSBACKUP                      YES EXPIRED & LOCKED
SYSRAC                         YES EXPIRED & LOCKED
SYSKM                          YES EXPIRED & LOCKED
SYS$UMF                        YES EXPIRED & LOCKED
SYSDG                          YES EXPIRED & LOCKED

7 rows selected.

SQL> alter user sys$umf identified by root account unlock;

User altered.

For the configuration we need in our case 2 database links. Indeed each source must have two database links, a destination-to-source database link and a source-to-destination database link. So connecting on the primary, let’s create 2 database links
=>prima_to_stand: from the primary to the standby
=>stand_to_prima: from standby to the primary

SQL> create database link prima_to_stand CONNECT TO sys$umf IDENTIFIED BY root using 'STBY_NONC';

Database link created.

SQL> create database link stand_to_prima CONNECT TO sys$umf IDENTIFIED BY root using 'PRIMA_NONC';

Database link created.

SQL>
SQL> select * from dual@prima_to_stand;

D
-
X

SQL> select * from dual@stand_to_prima;

D
-
X

SQL>

The RMF topology is a centralized architecture that consists of all the participating database nodes along with their metadata and connection information. So let’s configure the nodes. We will call them “site_prim” for primary and “site_stby” for standby
While connecting on the primary we execute

SQL> exec dbms_umf.configure_node ('site_prim');

PL/SQL procedure successfully completed.

SQL>

On the standby side we do the same but here we give the database link. Be sure that the database links were created in the right direction, otherwise you will get errors later.

SQL> exec dbms_umf.configure_node('site_stby','stand_to_prima');

PL/SQL procedure successfully completed.

SQL>

And now from the primary, we can then create the RMF topology.

SQL> exec DBMS_UMF.create_topology ('Topology_1');

PL/SQL procedure successfully completed.

SQL>

To verify the status of the configuration we can use following UMF views on the primary

SQL> select * from dba_umf_topology;

TOPOLOGY_NAME    TARGET_ID TOPOLOGY_VERSION TOPOLOGY
--------------- ---------- ---------------- --------
Topology_1      1530523744                1 ACTIVE

SQL> select * from dba_umf_registration;

TOPOLOGY_NAME   NODE_NAME          NODE_ID  NODE_TYPE AS_SO AS_CA STATE
--------------- --------------- ---------- ---------- ----- ----- --------------------
Topology_1      site_prim       1530523744          0 FALSE FALSE OK

SQL>

Everything seems fine, so we can register the standby in the topology. On the primary let’s excute the register_node procedure.

SQL> exec DBMS_UMF.register_node ('Topology_1', 'site_stby', 'prima_to_stand', 'stand_to_prima', 'FALSE', 'FALSE');

PL/SQL procedure successfully completed.

SQL>

If we do not have errors then we can enable the AWR service.

SQL> exec DBMS_WORKLOAD_REPOSITORY.register_remote_database(node_name=>'site_stby');

PL/SQL procedure successfully completed.

SQL>

Using UMF views, we can again verify our configuration.

SQL> select * from dba_umf_topology;

TOPOLOGY_NAME    TARGET_ID TOPOLOGY_VERSION TOPOLOGY
--------------- ---------- ---------------- --------
Topology_1      1530523744                4 ACTIVE

SQL> select * from dba_umf_registration;

TOPOLOGY_NAME   NODE_NAME          NODE_ID  NODE_TYPE AS_SO AS_CA STATE
--------------- --------------- ---------- ---------- ----- ----- --------------------
Topology_1      site_prim       1530523744          0 FALSE FALSE OK
Topology_1      site_stby       3265600723          0 FALSE FALSE OK

SQL> select * from dba_umf_service;

TOPOLOGY_NAME      NODE_ID SERVICE
--------------- ---------- -------
Topology_1      3265600723 AWR

SQL>

SQL> select * from dba_umf_link;

TOPOLOGY_NAME   FROM_NODE_ID TO_NODE_ID LINK_NAME
--------------- ------------ ---------- --------------------
Topology_1        1530523744 3265600723 PRIMA_TO_STAND
Topology_1        3265600723 1530523744 STAND_TO_PRIMA

SQL>

It’s now time to generate remote snapshots for the standby. While connecting to the primary. Two snapshots are at least required to be able to generate an AWR report.

SQL> set time on
16:01:22 SQL> exec dbms_workload_repository.create_remote_snapshot('site_stby');

PL/SQL procedure successfully completed.

16:21:41 SQL> exec dbms_workload_repository.create_remote_snapshot('site_stby');

PL/SQL procedure successfully completed.

16:21:50 SQL>

And we can generate the report as we usually do

SQL> @?/rdbms/admin/awrrpti.sql

Specify the Report Type
~~~~~~~~~~~~~~~~~~~~~~~
AWR reports can be generated in the following formats.  Please enter the
name of the format at the prompt. Default value is 'html'.

   'html'          HTML format (default)
   'text'          Text format
   'active-html'   Includes Performance Hub active report

Enter value for report_type: text



Type Specified: text


Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  DB Id      Inst Num   DB Name      Instance     Host
------------ ---------- ---------    ----------   ------
  2315634502     1      NONC18C      NONC18C      standserver1
  3265600723     1      NONC18C      NONC18C      standserver1
* 2315634502     1      NONC18C      NONC18C      primaserver.

Enter value for dbid: 3265600723
Using 3265600723 for database Id
Enter value for inst_num: 1
Using 1 for instance number


Specify the number of days of snapshots to choose from
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Entering the number of days (n) will result in the most recent
(n) days of snapshots being listed.  Pressing  without
specifying a number lists all completed snapshots.


Enter value for num_days:

Listing all Completed Snapshots
Instance     DB Name      Snap Id       Snap Started    Snap Level
------------ ------------ ---------- ------------------ ----------

NONC18C      NONC18C              1  24 Sep 2018 16:01    1
                                  2  24 Sep 2018 16:21    1


Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 1
Begin Snapshot Id specified: 1

Enter value for end_snap: 2
End   Snapshot Id specified: 2



Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_1_2.txt.  To use this name,
press  to continue, otherwise enter an alternative.

Enter value for report_name:

And viewing the generated report, we can see that the database role is PHYSICAL STANDBY

WORKLOAD REPOSITORY report for

DB Name         DB Id    Unique Name DB Role          Edition Release    RAC CDB
------------ ----------- ----------- ---------------- ------- ---------- --- ---
NONC18C       3265600723 NONC18C_SIT PHYSICAL STANDBY   EE      18.0.0.0.0 NO  NO

Instance     Inst Num Startup Time
------------ -------- ---------------
NONC18C             1 24-Sep-18 15:49

Host Name        Platform                         CPUs Cores Sockets Memory(GB)
---------------- -------------------------------- ---- ----- ------- ----------
standserver1.loc Linux x86 64-bit                    1                     2.96

Conclusion
In this blog we have shown how we can use UMF to generate AWR reports in Active Data Guard Instance. The framework UMF use the package DBMS_UMF which has many subprograms. The following note How to Generate AWRs in Active Data Guard Standby Databases (Doc ID 2409808.1) and Oracle documentation will help.

 

Cet article Oracle 18c : Active Data Guard and AWR Reports est apparu en premier sur Blog dbi services.

Oracle Lauded for Predictive Analytics, Machine Learning Solution

Oracle Press Releases - Tue, 2018-09-25 08:00
Press Release
Oracle Lauded for Predictive Analytics, Machine Learning Solution Oracle Autonomous Data Science Cloud Service recognized as a leader in notebook-based predictive analytics and machine learning by independent report

Redwood Shores, Calif.—Sep 25, 2018

Oracle has been named a leader in notebook-based Predictive Analytics and Machine Learning (PAML) solutions by Forrester Research, earning the highest average current offering score as well as the highest possible score for its solution roadmap. The Forrester Wave™: Notebook-Based Predictive Analytics and Machine Learning Solutions, Q3 2018 report recognizes that Oracle Autonomous Data Science Cloud Service “provides the standardization and controls that enterprises need” and “makes it easy to put models into production by offering visual tools to create APIs with automatic load balancing.”

According to Forrester, PAML solutions are defined as “Software that provides enterprise data scientist teams and stakeholders with 1) tools to analyze data; 2) workbench tools to build predictive models using statistical and machine learning algorithms; 3) a platform to train, deploy, and manage analytical results and models; and 4) collaboration tools for extended enterprise teams including businesspeople, data engineers, application developers, DevOps, and AI engineers.” Forrester evaluated the strengths and weaknesses of the top notebook-based PAML vendors across 24 evaluation criteria, which were grouped into three categories: current offering, strategy and market presence. Of the nine vendors Forrester evaluated, Oracle was one of the two companies recognized as a leader.

“With Oracle Autonomous Data Science Cloud Service, Oracle has a winning solution for our customers to build and deploy artificial intelligence and machine learning models on the Oracle Cloud," said Greg Pavlik, Senior Vice President and Chief Technology Officer, Oracle Cloud Platform. “I believe that being recognized by Forrester as a leader in this space is not only a recognition of our offering, but of our vision for a comprehensive and integrated suite of products and services for developing AI-driven applications. It takes a team to develop AI efficiently, and Oracle offers industry leading solutions for every stage in the AI development lifecycle, whether it be data management, data science, or application development.”

According to the report, “With its recent acquisition of DataScience.com, Oracle has added a critical missing component to its portfolio of machine learning solutions in the cloud.” Adding that, “By combining one of the most promising startups in the notebook-based PAML space with its own related offerings for infrastructure, data management, third-party data sources, BI, and a suite of business applications, Oracle is instantly a force to be reckoned with in the PAML market.”

Oracle Autonomous Data Science Cloud Service enables data science and application development teams to easily build, train, deploy, and manage models on the Oracle Cloud. The platform makes data science and application development teams more productive and enables them to deploy more work faster to power their organizations with machine learning.

To learn more about Oracle Autonomous Data Science Cloud Service, please visit https://cloud.oracle.com/ai-platform.

Contact Info
Alex Shapiro
Oracle
415-608-5044
alex.shapiro@oracle.com
Quentin Nolibois
Burson Cohn & Wolfe
+1.415.591.4097
quentin.nolibois@bm.com
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.

Trademarks

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

Alex Shapiro

  • 415-608-5044

Quentin Nolibois

  • +1.415.591.4097

Oracle Eloqua Innovations Accelerate Lead Generation and Increase Conversion Rates

Oracle Press Releases - Tue, 2018-09-25 07:00
Press Release
Oracle Eloqua Innovations Accelerate Lead Generation and Increase Conversion Rates New content creation, sales tools and auditing capabilities help marketers increase efficiency and creativity

Redwood Shores, Calif. —Sep 25, 2018

To help marketers accelerate lead generation and increase conversion rates, Oracle today announced a series of updates to Oracle Eloqua. The latest innovations within Oracle Eloqua help marketers communicate with their prospects and customers as efficiently and easily as possible by introducing new content creation, sales tools and auditing capabilities.

“In order to drive sales and strengthen brand and customer loyalty, B2B marketers increasingly have to deliver irresistible, consistent and connected experiences to customers wherever they are and however they choose to engage,” said Pierre Custeau, VP, product management, Oracle Eloqua. “To help our customers meet these increasing expectations, we are focused on delivering innovations within Eloqua that bring efficiency and creativity to the way marketers work. With the addition of powerful new content creation, sales tools and auditing capabilities, we are continuing to set the industry standard for marketing automation.”

Part of Oracle Marketing Cloud, Eloqua is a B2B marketing automation platform that helps marketing teams nurture prospects through email marketing and cross-channel marketing. 

The new enhancements to Oracle Eloqua enable customers to:

  • Quickly and efficiently create compelling and creative landing pages: A new Eloqua Landing Page Editor enables marketers to build out-of-the box landing pages without touching code and provides an enhanced guided experience with more interactive elements to further increase efficiency and spark creativity. With the new landing page editor, marketers can natively build responsive landing pages featuring image carousels with rotating images and add video backgrounds to create more engaging content without needing technical expertise or outside agency support.

  • Streamline and optimize the sales process: New Eloqua Sales Tools for Microsoft Outlook enable sales teams to access rich buyer insights, relevant content and track emails sent to prospects without having to leave their email platform of choice. The new integration with Microsoft Outlook also provides a seamless and consistent experience for sales teams that work across a range of platforms and devices by enabling users to easily access Eloqua Engage and Eloqua Profiler.  

  • Enhance security, tracking and auditing: A new comprehensive logging and auditing procedure for all major accounts and objects, further enhances the security and tracking capabilities within Eloqua. The new auditing capabilities ensure any sensitive data within Eloqua is protected against unauthorized usage or retrieval and enable users to obtain insights about login history, detailed audit insights and enhanced audit reporting that includes the ability to export audit logs for up to 25 months in CSV and XLS format.   

Oracle Marketing Cloud is part of Oracle Customer Experience (CX) Cloud Suite, an integrated suite of applications that empower organizations to take a smarter approach to customer experience management and business transformation initiatives. By providing a trusted business platform that connects data, experiences and outcomes, Oracle CX Cloud Suite helps customers reduce IT complexity, deliver innovative customer experiences, and achieve predictable and tangible business results.

For additional information about Oracle Marketing Cloud, follow @OracleMktgCloud on Twitter, LinkedIn and Facebook or visit the Modern Marketing Blog.

Contact Info
Simon Jones
Oracle
415.202.4574
s.jones@oracle.com
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.

Trademarks

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

Simon Jones

  • 415.202.4574

Oracle Study Reveals Increased Network Complexity is Driving Security, Visibility, and Control Challenges for IT Leaders

Oracle Press Releases - Tue, 2018-09-25 07:00
Press Release
Oracle Study Reveals Increased Network Complexity is Driving Security, Visibility, and Control Challenges for IT Leaders Ninety-One Percent of IT Leaders Rank Security as Top Challenge with Expanding Enterprise Networks

Redwood Shores, Calif.—Sep 25, 2018

As enterprise networks grow, so does the challenge of effectively managing them a new Oracle Communications survey found. In the "Enterprise Networks in Transition: Taming the Chaos" report, IT and telecom leaders noted that security, fraud, and increased complexity resulting from channel proliferation are amongst their top concerns. Companies are increasingly looking to emerging technologies, such as biometrics, artificial-intelligence, and blockchain as opportunities to improve security and control.

In June 2018, Oracle surveyed 277 IT, telecom and network decision makers globally regarding their perspectives on key business and network trends and the solutions that will help them compete and thrive in a digital world. Sixty-six percent of respondents represented companies with at least 11 locations and 62 percent managed operations in multiple countries.

Separately, software-defined wide area networking (SD-WAN) was also listed as a critical technology underpinning the evolution of enterprise networks. Yet, North America lags other regions in software-defined networking (SDN) deployment (50 percent versus 65-78 percent).

“In today’s digital economy, enterprises face increasing operational complexities, heightened customer expectations and an unprecedented amount of chaos in the form of security breaches and communications overload that require a higher level of network sophistication than ever before,” said Doug Suriano, senior vice president and general manager, Oracle Communications.

Bigger Enterprise Networks, Bigger Problems
  • Security poses an ongoing challenge: 91 percent of respondents ranked security as a top three challenge, particularly in Asia and Latin America, where mobile usage is most popular. Additionally, more than one-third of respondents ranked security as their top challenge in relation to planning, deploying and managing their enterprise networks. As mobile devices continue to expand and redefine the network edge, security continues to be a top-of-mind issue.
  • Emerging tech seen as possible solution: Seventy-six percent of respondents agreed that they require new solutions to improve visibility and control over their entire network. Sixty-nine percent of respondents noted they will use biometrics in network security use cases and 57 percent artificial intelligence (AI). In tandem, AI and machine learning were also identified as key technologies in supporting quality of service and cost efficiencies (30 percent each), while blockchain was identified as a top technology to improve network control by 27 percent of respondents.
  • Channel proliferation drives greater complexity: 76 percent of survey respondents stated that the breadth and reach of their enterprise network is expanding. Network users increasingly have more channels available to them, which means that managing time and productivity is becoming increasingly difficult. While voice and e-mail are the predominant communications channels, video, chat, and other in-app communications are growing increasingly popular. This impacts how the network is deployed and managed and what defines the edge of the network.
  • Leaders are focused on fraud: At least 83 percent of respondents identified virtually all types of network and telecoms fraud as a serious issue, with more than half citing identity fraud as a primary concern in relation to real-time communications. Solutions must adapt and evolve in anticipation of current and constantly evolving threats, particularly as network complexity increases.
     
  • SD-WAN is critical for evolving enterprise networks: The majority (71 percent) of respondents agreed that SD-WAN is critical for their enterprise networks to evolve, and a greater share (88 percent) of respondents from global companies with 101 or more locations said the same. Amongst large, global companies considering SD-WAN, convenience and ease of deployment was the top driver for 48 percent, followed by reliability (36 percent) and traffic-related flexibility (34 percent).
Contact Info
Katie Barron
Oracle
+1.202.904.1138
katie.barron@oracle.com
Raleigh Miller
Burson Cohn & Wolfe
+1.202.530.4554
raleigh.miller@bm.com
About Oracle Communications

Oracle Communications provides integrated communications and cloud solutions for Service Providers and Enterprises to accelerate their digital transformation journey in a communications-driven world from network evolution to digital business to customer experience. www.oracle.com/communications

To learn more about Oracle Communications industry solutions, visit: Oracle Communications

LinkedIn, or join the conversation at Twitter @OracleComms.

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.

Trademarks

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

Safe Harbor

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Katie Barron

  • +1.202.904.1138

Raleigh Miller

  • +1.202.530.4554

New Oracle and MIT Technology Review Insights Report Examines State of Open Banking

Oracle Press Releases - Tue, 2018-09-25 07:00
Press Release
New Oracle and MIT Technology Review Insights Report Examines State of Open Banking Financial Services executives agree on need to react fast to market changes and customer expectations

Redwood Shores, Calif.—Sep 25, 2018

Open banking is one of the most critical trends driving change in the U.S. and international banking community. It represents the move from closed to open financial systems where data is shared with third parties through the use of Application Programming Interfaces (APIs). Oracle Financial Services commissioned an industry outlook report from MIT Technology Review Insights that examines how banks are responding to regulatory changes, market shifts and business model changes as a result of open banking.

The new report, Open Banking: The Race to Deliver Banking-as-a-Service, finds that most banks are still in the early stages of open banking adoption. Many are developing strategies, launching APIs, and keeping an eye on the competitive landscape. But the overarching sentiment among the banking community executives interviewed for this report indicates the banks that are able to balance speed, innovation and strategic long-term decisions will win market share.

“Not reacting rapidly enough to open banking could result in another party, either a competitor bank or fintech, innovating more quickly and eroding trust or relationships,” said Frank Tong, Head of Innovation and Strategic Investment at HSBC, in the report.

The report also asserts regulation is brokering open banking innovation through collaboration with banks to develop the frameworks needed to move forward – not only in progressive markets like the U.K. and Singapore but around the world.

“While regulation usually plays a ‘catch-up’ role when it comes to technology, our interviews revealed a fascinating trend of regulators setting the pace for banking innovation,” said Claire Beatty, Editor for MIT Technology Review Insights and one of the authors of the report. “We’re seeing a strong collaboration between governments, regulators, incumbent players and fintechs to ensure the right framework is developed to give customers greater control over their data and provide a more seamless financial services user experience.”

The report reiterates competition and consumer demand continue to be key drivers to accelerate banking digitization. Fintechs can quickly deploy consumer services while consumers seek the ease and convenience they offer. In order for traditional financial institutions to remain competitive they have to embrace open banking and a collaborative strategy that allows them to build smarter, deeper, and more relevant digital experiences across the customer lifecycle. Banks must also overcome challenges such as coordinating open banking strategies locally and globally, managing the ongoing digital transformation of the front and back office, prioritizing API development and uniting and educating teams.

“Open banking is no longer an option, but an inevitable reality,” said Sonny Singh, senior vice president and general manager of Oracle Financial Services Global Business Unit. “Banks that tap into an expanding ecosystem of potential digital partners, embrace APIs and leverage cloud-ready solutions, will get ahead in the race to efficiently deliver a broad range of financial products and services to their customers.”

For example, the process of designing customized APIs and exposing them for consumption can take between 12 to 24 months, depending on the complexity of the banks’ IT landscape. With a cloud-ready platform like Oracle Banking APIs, banks can tap into a prebuilt repository of more than 1,500 Representational State Transfer (REST) APIs.

For the report, MIT Technology Review interviewed the following senior executives from around the world who are directly involved with open banking: Abhishek Seth, Head of Open Banking and API, APAC and EMEA, Global Consumer Technology, Citi; Frank Tong, Global Head of Innovation and Strategic Investment, HSBC; Gerard Florian, Chief Information Officer, ANZ; Deniz Güven, Global Head of Customer Experience, Standard Chartered Bank; Jason Bates, Co-Founder, 11:FS; Alex Weber, Head of International Markets, N26 Group; Derek White, Global Head of Customer Service, BBVA; and Tomofumi Watanabe, Joint General Manager, Sumitomo Mitsui Financial Group.

The full report is available at http://ora.cl/G3Qd6

Contact Info
Judi Palmer
Oracle
+1 650 784 7901
judi.palmer@oracle.com
Brian Pitts
Hill+Knowlton Strategies
+1 312 475 5921
brian.pitts@hkstrategies.com
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 MIT Technology Review

Founded at the Massachusetts Institute of Technology in 1899, MIT Technology Review is a world-renowned, independent media company whose insight, analysis, reviews, interviews and live events explain the commercial, social and political impact of new technologies. MIT Technology Review derives its authority from the world’s foremost technology institution and from its editors’ deep technical knowledge, capacity to see technologies in their broadest context, and unequaled access to leading innovators and researchers. For 117 years, MIT Technology Review’s mission has been to equip readers with the intelligence to understand a world shaped by technology and the impact upon their careers and lives. Subscribe.

Trademarks

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

Judi Palmer

  • +1 650 784 7901

Brian Pitts

  • +1 312 475 5921

Simulation of long time for query parsing

Tom Kyte - Tue, 2018-09-25 00:06
Hi Tom, How can I force a long query parsing time for Oracle or how to prepare such a complicated query? I want to simulate a situation where Oracle parses a query for 30 seconds before execution. Within 30 seconds I want to modify the synonym ...
Categories: DBA Blogs

Unified Audit on 12.2 - partitioning

Tom Kyte - Tue, 2018-09-25 00:06
Hi there We have a customer on 12.2 and is about use Unified Audit, since we have alot of FGA audit due to GDPR (450 G in 3? mth) - we chose UA because of its partitioning capabilites, thus beeing able to delete offload. Questions: 1 I know...
Categories: DBA Blogs

Convert clob to char to get distinct

Tom Kyte - Tue, 2018-09-25 00:06
Hii ASKTOM, select distinct clob_column_name from table_name; I get following error:- ora-00932: inconsistent datatypes;expected-got CLOB While i use to_char function select distinct to_char(clob_column_name) from table_name; then i get follo...
Categories: DBA Blogs

Cube Explorer - A new way of viewing your data

Anthony Shorten - Mon, 2018-09-24 18:28

One of the most common uses for spreadsheets these days is to Pivot information. It is a way of displaying information using multiple dimensions in a way that make it easier to analyze. In Oracle Utilities Application Framework V4.3.0.6.0, introduces a new zone paradigm called the Cube Viewer which allows for pivot style analysis to be configured and made available to authorized users.

The Cube Viewer is a new way of displaying and analyzing information with the following capabilities:

  • Dynamic Configuration. End users can dynamically change the look and subset of data available to the Cube within the user interface.
  • Save and Load Views. As with other zones, it is possible to save all the dynamic configuration for reuse across sessions. This allows optimizations at the user level.
  • Configurable Selection Criteria. Allows for users to supply criteria for sub-setting the data to be displayed. For example:

Example Selection Criteria

  • Comparison Support. Allowing two sets of criteria data to be available for comparison purposes. For example:

Example Comparison Criteria

  • Different Views. It is possible to view the data in a variety of formats including data views or graphically. This helps users to understand data in the style they prefer. It is possible to even see the raw data that the analysis was based upon. For example:

Example different views

  • Multiple Dimensions Supported. The dimensions for the Cube are available including any dimensions not shown but available. For example:

Example dimensions

  • Configurable View Columns. List of columns to display for selection. For example:

Example value columns

  • Flexible Formatting.  The Cube Viewer allows for custom formula to be dynamically added for on the fly analysis.

Example formatting

  • Dynamic Filtering. The Cube Viewers allows for filters to be dynamically imposed at both the global and hierarchical levels to allow for focused analysis.

Example Filtering

To use Cube Viewer the following can be configured:

  • Query Portal - A query portal is built containing the SQL and any derived columns for use in the analysis. Filters (User and Hidden) are specified for use in the Cube Viewer. Column displayed are used as the basis for the Cube Viewer display.
  • Business Service - The query portal is defined as a Business Service using the standard FWLZDEXP application service.
  • Cube Type (New Object) - Define the Service and capabilities of the cube in a new object.
  • Cube View (New Object) - Define the Portal to display the Cube Viewer/Cube Type

This process is shown as follows:

Configuration Overview

The Cube Viewer is an exciting new way of allowing users to interact with data and provide value added analysis.

Note: This capability can be used independently of the use of the Oracle Database In-Memory capability. Use with the Oracle Database In-Memory can allow for more advanced analytics to be implemented with increased performance.

For more information about the Cube Viewer, refer to the online documentation supplied with the product.

Survey: Lack of Confidence in Clinical Trial Data Delaying Drug Development

Oracle Press Releases - Mon, 2018-09-24 07:00
Press Release
Survey: Lack of Confidence in Clinical Trial Data Delaying Drug Development Costly data preparation, slow data reconciliation and poor data quality hindering drug development efforts for life-saving therapies

Redwood Shores, Calif.—Sep 24, 2018

Pharmaceutical companies share significant concerns over their ability to bring more drugs to market faster due to clinical data challenges. A new global study, commissioned by Oracle Health Sciences and conducted by Pharma Intelligence, revealed that 57 percent of the clinical researchers surveyed believe that their clinical data issues result in trial delays.

In addition to trial delays, 81 percent of respondents cited data governance issues as the biggest challenge in meeting regulatory compliance. The top three data issues according to survey respondents were duplicate data/inconsistent data, data quality and data integrity/traceability.

“Data governance is our top concern because clinical data quality issues can hinder a trial’s completion,” said Melonie Longan, Director, Data Operations, Functional Services, Premier Research.  Premier Research is a CRO serving biotechnology customers who are researching therapies related to analgesia, dermatology, hematology, oncology, neuroscience, pediatrics, and rare disease.

When asked what the top three operational challenges were with their clinical trial data, 51 percent cited data completeness, 45 percent said data quality and 43 percent, data cleaning.

“The kind of clinical data quality issues such as those highlighted in this report can have significant negative impacts,” said Julie Barenholtz, Principal Clinical Data Manager, Cytel Inc. “As a data company, we are always looking for ways to improve the quality of the data and process it efficiently so that patients have access to treatments as quickly as possible.” Founded in 1987, Cytel is a multinational contract research organization (CRO) known for its pioneering work in statistical science and the design and implementation of adaptive clinical trials.

Not surprisingly, over three-fourths of respondents cited inconsistent data and missing patient data as the most critical clinical data problems to catch in clinical trials.

“Clinical teams are forced to spend time cleaning data instead of analyzing it, and they can’t always see the entire picture of what is available to them; this delays the ability to make critical decisions about the trial and holds up regulatory submission,” said Steve Rosenberg, General Manager, Oracle Health Sciences. “Clinical researchers shouldn’t have to spend time and resources on fixing data issues that technology was built to handle. Technology can, and should, be used to eliminate unnecessary manual intervention and mitigate risk so we can get therapies in the hands of patients who are waiting.”

The top three risks highlighted by the research include the need for additional data reconciliation; incomplete data to determine efficacy and patient replacements.

“Wasting precious time reconciling clinical data issues can be detrimental and costly to our customers,” said Vicki Gashwiler, Associate Director, Strategic Development & Market Access, MedTech Division for Novella Clinical. “Our top concern is proactive data management and data monitoring to reduce the risk of clinical data quality issues slowing down a trial. These delays can have significant financial implications for our customers.”

About the Survey

The survey was conducted by Pharma Intelligence and sponsored by Oracle Health Sciences and ran from the beginning of August 2018 into September 2018. The largest percentage of responses came from clinical researchers, data scientists and clinical programmers from biopharma organizations and a small percentage of medical device companies and Contract Research Organizations. Respondents were from around the globe with 61 percent from North America, 20 percent from Asia Pacific and 17 percent from Europe.

Contact Info
Valerie Beaudett
Oracle
+1 650.400.7833
valerie.beaudett@oracle.com
Meghan Roman
Blanc and Otus
+1 202.347.7113‬
meghan.roman@blancandotus.com
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 Health Sciences

Oracle Health Sciences breaks down barriers and opens new pathways to unify people and processes to bring new drugs to market faster. As the number one vendor in Life Sciences (IDC, 2017), the number one provider of eClinical solutions (Everest Group, 2017) and powered by the number one data management technology in the world (Gartner, 2018), Oracle Health Sciences technology is trusted by 29 of the top 30 pharma, 10 of the top 10 biotech and 10 of the top 10 CROs for clinical trial and safety management around the globe.

Trademarks

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

Valerie Beaudett

  • +1 650.400.7833

Meghan Roman

  • +1 202.347.7113‬

Export table with exclude columns

Tom Kyte - Mon, 2018-09-24 05:46
Hi, I have large partitioned table now i want to export and give dump to someone but not all columns some specific columns needs to trim.. My approach i am importing table on dev setup then make specific columns unused and then try to drop then...
Categories: DBA Blogs

SQL Plan stability in 11G using stored outlines

Yann Neuhaus - Mon, 2018-09-24 05:01

A stored outline is a collection of hints associated with a specific SQL statement that allows a standard execution plan to be maintained, regardless of changes in the system environment or associated statistics. Plan stability is based on the preservation of execution plans at a point in time where the performance of a statement is considered acceptable. The outlines are stored in the OL$, OL$HINTS, and OL$NODES tables, but the [USER|ALL|DBA]_OUTLINES and [USER|ALL|DBA]_OUTLINE_HINTS views should be used to display information about existing outlines.

All of the caveats associated with optimizer hints apply equally to stored outlines. Under normal running the optimizer chooses the most suitable execution plan for the current circumstances. By using a stored outline you may be forcing the optimizer to choose a substandard execution plan, so you should monitor the affects of your stored outlines over time to make sure this isn’t happening. Remember, what works well today may not tomorrow.

Many times we are into the situation when the performance of a query regressing, or the optimizer is not able to choose the better execution plan.

In the next lines I will try to describe a scenario that needs the usage of a stored outline:

–we will identify the different plans that exists for our sql_id

SQL> select hash_value,child_number,sql_id,executions from v$sql where sql_id='574gkc8gn7u0h';

HASH_VALUE CHILD_NUMBER SQL_ID        EXECUTIONS 
---------- ------------ ------------- ---------- 
 524544016            0 574gkc8gn7u0h          4 
 576321033            1 574gkc8gn7u0h          5

 

Between the two different plans, we know that the best one is that with the cost 15 and the hash_value : 4013416232, but which is not all the time choosed by the optimizer, causing peak of performance

SQL> select * from table(dbms_xplan.display_cursor(‘574gkc8gn7u0h’,0));

PLAN_TABLE_OUTPUT
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------

SQL_ID  574gkc8gn7u0h, child number 0
-------------------------------------
Select   m.msg_message_id,   m.VersionId,   m.Knoten_id,
m.Poly_User_Id,   m.State,   'U' as MutationsCode from
........................................................

Plan hash value: 4013416232

-------------------------------------------------------------------------------------------------------------
| Id  | Operation                      | Name                       | Rows  | Bytes | Cost (%CPU)| Time     |
-------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT               |                            |       |       |    15 (100)|       |
|   1 |  UNION-ALL                     |                            |       |       |            |       |
|*  2 |   FILTER                       |                            |       |       |            |       |
|   3 |    NESTED LOOPS                |                            |       |       |            |       |
|   4 |     NESTED LOOPS               |                            |     1 |    76 |     7  (15)| 00:00:01 |
|   5 |      MERGE JOIN CARTESIAN      |                            |     1 |    52 |     5  (20)| 00:00:01 |
|   6 |       SORT UNIQUE              |                            |     1 |    26 |     2   (0)| 00:00:01 |
|*  7 |        TABLE ACCESS FULL       | TMPINTLIST                 |     1 |    26 |     2   (0)| 00:00:01 |
|   8 |       BUFFER SORT              |                            |     1 |    26 |     3  (34)| 00:00:01 |
|   9 |        SORT UNIQUE             |                            |     1 |    26 |     2   (0)| 00:00:01 |
|* 10 |         TABLE ACCESS FULL      | TMPINTLIST                 |     1 |    26 |     2   (0)| 00:00:01 |
|* 11 |      INDEX RANGE SCAN          | XAK2_MSG_MESSAGE_ENTRY     |     1 |       |     1   (0)| 00:00:01 |
|* 12 |     TABLE ACCESS BY INDEX ROWID| MSG_MESSAGE_ENTRY          |     1 |    24 |     2   (0)| 00:00:01 |
|* 13 |   FILTER                       |                            |       |       |            |       |
|  14 |    NESTED LOOPS                |                            |       |       |            |       |
|  15 |     NESTED LOOPS               |                            |     1 |    76 |     8  (13)| 00:00:01 |
|  16 |      MERGE JOIN CARTESIAN      |                            |     1 |    52 |     5  (20)| 00:00:01 |
|  17 |       SORT UNIQUE              |                            |     1 |    26 |     2   (0)| 00:00:01 |
|* 18 |        TABLE ACCESS FULL       | TMPINTLIST                 |     1 |    26 |     2   (0)| 00:00:01 |
|  19 |       BUFFER SORT              |                            |     1 |    26 |     3  (34)| 00:00:01 |
|  20 |        SORT UNIQUE             |                            |     1 |    26 |     2   (0)| 00:00:01 |
|* 21 |         TABLE ACCESS FULL      | TMPINTLIST                 |     1 |    26 |     2   (0)| 00:00:01 |
|* 22 |      INDEX RANGE SCAN          | XAK3_MSG_MESSAGE_ENTRY_DEL |     1 |       |     2   (0)| 00:00:01 |
|  23 |     TABLE ACCESS BY INDEX ROWID| MSG_MESSAGE_ENTRY_DEL      |     1 |    24 |     3   (0)| 00:00:01 |
-------------------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   2 - filter(:LASTTREATEDVERSIONID<=:MAXVERSIONID)
   7 - filter("SERIAL#"=1999999999)
  10 - filter("SERIAL#"=1999999998)
----------------------------------------------

 

In order to fix this , we will create and enable an outline, that should help the optimizer to choose always the best plan:

 BEGIN
      DBMS_OUTLN.create_outline(hash_value    =>524544016,child_number  => 0);
    END;
  /

PL/SQL procedure successfully completed.

SQL>
SQL> alter system set use_stored_outlines=TRUE;

System altered.

SQL> create or replace trigger trig_start_out after startup on database
  2  begin
  3  execute immediate 'alter system set use_stored_outlines=TRUE';
  4  end;
  5  /

Trigger created.

As the parameter “use_stored_outlines” is a ‘pseudo’ parameter, is not persistent over the reboot of the system, for that reason we had to create this trigger on startup database.

Now we can check , if the outline is used:

NAME                           OWNER                          CATEGORY                       USED
------------------------------ ------------------------------ ------------------------------ ------
SYS_OUTLINE_18092409295665701  TEST                         DEFAULT                        USED

And also, to check that the execution is taking in account

SQL> select * from table(dbms_xplan.display_cursor('574gkc8gn7u0h',0));

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------------------------------------------------------------------

SQL_ID  574gkc8gn7u0h, child number 0
-------------------------------------
Select   m.msg_message_id,   m.VersionId,   m.Knoten_id,
m.Poly_User_Id,   m.State,   'U' as MutationsCode from
msg_message_entry m where   m.VersionId between :LastTreatedVersionId
...................

Plan hash value: 4013416232

-------------------------------------------------------------------------------------------------------------
| Id  | Operation                      | Name                       | Rows  | Bytes | Cost (%CPU)| Time     |
-------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT               |                            |       |       |    15 (100)|       |
|   1 |  UNION-ALL                     |                            |       |       |            |       |
|*  2 |   FILTER                       |                            |       |       |            |       |
|   3 |    NESTED LOOPS                |                            |       |       |            |       |
|   4 |     NESTED LOOPS               |                            |     1 |    76 |     7  (15)| 00:00:01 |
|   5 |      MERGE JOIN CARTESIAN      |                            |     1 |    52 |     5  (20)| 00:00:01 |
|   6 |       SORT UNIQUE              |                            |     1 |    26 |     2   (0)| 00:00:01 |
|*  7 |        TABLE ACCESS FULL       | TMPINTLIST                 |     1 |    26 |     2   (0)| 00:00:01 |
|   8 |       BUFFER SORT              |                            |     1 |    26 |     3  (34)| 00:00:01 |
|   9 |        SORT UNIQUE             |                            |     1 |    26 |     2   (0)| 00:00:01 |
|* 10 |         TABLE ACCESS FULL      | TMPINTLIST                 |     1 |    26 |     2   (0)| 00:00:01 |
|* 11 |      INDEX RANGE SCAN          | XAK2_MSG_MESSAGE_ENTRY     |     1 |       |     1   (0)| 00:00:01 |
|* 12 |     TABLE ACCESS BY INDEX ROWID| MSG_MESSAGE_ENTRY          |     1 |    24 |     2   (0)| 00:00:01 |
|* 13 |   FILTER                       |                            |       |       |            |       |
|  14 |    NESTED LOOPS                |                            |       |       |            |       |
|  15 |     NESTED LOOPS               |                            |     1 |    76 |     8  (13)| 00:00:01 |
|  16 |      MERGE JOIN CARTESIAN      |                            |     1 |    52 |     5  (20)| 00:00:01 |
|  17 |       SORT UNIQUE              |                            |     1 |    26 |     2   (0)| 00:00:01 |
|* 18 |        TABLE ACCESS FULL       | TMPINTLIST                 |     1 |    26 |     2   (0)| 00:00:01 |
|  19 |       BUFFER SORT              |                            |     1 |    26 |     3  (34)| 00:00:01 |
|  20 |        SORT UNIQUE             |                            |     1 |    26 |     2   (0)| 00:00:01 |
|* 21 |         TABLE ACCESS FULL      | TMPINTLIST                 |     1 |    26 |     2   (0)| 00:00:01 |
|* 22 |      INDEX RANGE SCAN          | XAK3_MSG_MESSAGE_ENTRY_DEL |     1 |       |     2   (0)| 00:00:01 |
|  23 |     TABLE ACCESS BY INDEX ROWID| MSG_MESSAGE_ENTRY_DEL      |     1 |    24 |     3   (0)| 00:00:01 |
-------------------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   2 - filter(:LASTTREATEDVERSIONID<=:MAXVERSIONID)
   7 - filter("SERIAL#"=1999999999)
  10 - filter("SERIAL#"=1999999998)
  
Note
-----
   - outline "SYS_OUTLINE_18092409295665701" used for this statement

To use stored outlines when Oracle compiles a SQL statement we need to enable them by setting the system parameter USE_STORED_OUTLINES to TRUE or to a category name. This parameter can be also be set at the session level.
By setting this parameter to TRUE, the category by default on which the outlines are created is DEFAULT.
If you prefer to add a category on the procedure of outline creation, Oracle will used this outline category until you provide another category value or you disable the usage of the outlines by putting the parameter USE_STORED_OUTLINE to FALSE.

 

Cet article SQL Plan stability in 11G using stored outlines est apparu en premier sur Blog dbi services.

Connection from Data Center to Cisco Switch issue on Exadata X7

Alejandro Vargas - Mon, 2018-09-24 04:25

It may happen that when trying to reach the Exadata machine using the management network, the data center switch that connects to the Exadata Cisco switch get a 'connection rejected' error.

On X7-2 port 48 of the Cisco switch is setup by default as ‘spanning tree network’ that set the BPDU* filter to disable, and communications between customer switch and the Cisco are rejected.

To solve run this command on the Cisco:

  • spanning tree BPDU filter en

Enabling BPDU filtering in the interface level stops sending or receiving BPDU on this interface; this is the same as disabling spanning tree on the interface.

See on My Oracle SupportCisco 93108 switch is getting Error Disabled on the Uplink Switch (Doc ID 2360702.1)

* BPUD stands for: Bridge Protocol Data Unit. BPDUs are data messages that are exchanged across the switches within an extended LAN that uses a spanning tree protocol topology

 

Categories: DBA Blogs

Safari 12 Implications for E-Business Suite Users

Steven Chan - Sun, 2018-09-23 22:21

Customers have been asking about the compatibility of new versions of the following Apple products with Oracle E-Business Suite 12.1 and 12.2:

  •          Safari 12 (works with macOS 10.13.6 and 10.12.6)
  •          macOS Mojave (macOS 10.14)

Neither of these two products have been certified with either EBS 12.1 or EBS 12.2 as of September 18, 2018).  

Safari 12 is unable to launch Java in the way that prior Safari versions could. This will prevent E-Business Suite 12.1 and 12.2 customers from running Forms-based products. Therefore, customers should *NOT* upgrade to Safari 12 on macOS desktop platforms.

macOS Mojave (macOS 10.14) will include Safari 12. Customers should *NOT* upgrade to macOS Mojave.

We are aware of the potential impact to E-Business Suite users and are actively pursuing solutions.    

What has changed?

Safari 12 introduces an important change: it removes support for “legacy NPAPI plug-ins”. This affects all EBS releases. macOS Mojave includes Safari 12.

Some products within Oracle EBS 12.1 and 12.2 run via HTML in browsers. These are sometimes called “self-service web applications.” These EBS products are expected to run without issue in Safari 12, but our certification testing is still underway.

Some products within Oracle EBS 12.1 and EBS 12.2 use Oracle Forms. Oracle Forms requires Java for desktop clients. On the macOS desktop platform, the only certified option today for launching Java is via the JRE plugin via the NPAPI approach.

This means that Safari 12 and macOS Mojave (macOS 10.4) will be unable to use the current JRE plugin-based launching technology for Java and Forms for EBS desktop users.

Recommendations for EBS customers

As of today, the latest certified versions of these products are:

  • Safari 11 (works with macOS 10.13)
  • macOS High Sierra (macOS 10.13)

EBS customers should use only certified configurations. EBS customers who use Forms-based products should avoid upgrading to Safari 12 or macOS Mojave today.

What’s next for EBS clients on macOS?

We have certified Java Web Start (JWS) for Windows clients accessing EBS 12.1 and 12.2 environments. Java Web Start is an alternative to the JRE plugin approach. Java Web Start works with browsers that lack NPAPI support. For more details about Java Web Start and EBS on Windows, see:

We are working on certifying Java Web Start technology with macOS. Our goal is to provide a solution that allows E-Business Suite users on macOS to continue without any reduction in functionality. Given changes to Safari and Apple’s security model, we are examining options for browsers such as Firefox.

Once again, we are acutely aware of the potential impact to E-Business Suite users and have been working on solutions for macOS for some time.

Oracle’s Revenue Recognition rules prohibit us from discussing certification and release dates, but you’re welcome to monitor or subscribe to this blog. I’ll post updates here as soon as soon as they’re available.   

Related Articles

Categories: APPS Blogs

Verifying White Listing for Oracle Integration Platform

Antony Reynolds - Sun, 2018-09-23 18:33
Verifying Your White List is Working

A lot of customers require all outbound connections from systems to be validated against a whitelist.  This article explains the different types of whitelist that might be applied and why they are important to Oracle Integration Cloud (OIC).  Whitelisting means that if a system is not specifically enabled then its internet access is blocked.

The Need

If your company requires systems to be whitelisted then you need to consider the following use cases:

  • Agent Requires Access to Integration Cloud
  • On-Premise Systems Initiating Integration Flows
  • On-Premise Systems Raising Events

In all the above cases we need to be able to make a call to Integration Cloud through the firewall which may require whitelisting.

Types of Whitelisting

Typically there are two components involved in whitelisting: the source system and the target system.  In our case the target system will be Oracle Integration Cloud, and if using OAuth then the Identity Cloud Service (IDCS) as well.  The source system will be either the OIC connectivity agent, or a source system initiating integration flows, possibly via an event mechanism.

Whitelisting Patterns   Source Whitelisted Target Whitelisted Target Only No Yes Source & Target Yes Yes Source Only No No

Only the first two are usually seen, the third is included for completeness but I have not seen it in the wild.

Information Required

When providing information to the network group to enable the whitelisting you may be asked to provide IP addresses of the systems being used.  You can obtain these by using the nslookup command.

> nslookup myenv-mytenancy.integration.ocp.oraclecloud.com Server: 123.45.12.34 Address: 123.45.12.34#53 Non-authoritative answer: myenv-mytenancy.integration.ocp.oraclecloud.com canonical name = 123456789ABCDEF.integration.ocp.oraclecloud.com. Name: 123456789ABCDEF.integration.ocp.oraclecloud.com Address: 123.123.123.123

You will certainly need to lookup your OIC instance hostname.  You may also need your IDCS instance which is the URL you get when logging on.

Testing Access

Once the whitelist is enabled we can test it by using the curl command from the machine from which we require whitelist access.

> curl -i -u 'my_user@mycompany.com:MyP@ssw0rd' https://myenv-mytenancy.integration.ocp.oraclecloud.com/icsapis/v2/integrations HTTP/1.1 200 OK Date: Sun, 23 Sep 2018 23:19:44 GMT Content-Type: application/json;charset=utf-8 Transfer-Encoding: chunked Connection: keep-alive X-ORACLE-DMS-ECID: 1234567890abcdef X-ORACLE-DMS-RID: 0 Set-Cookie: iscs_auth=0123456789abcdef; path=/; HttpOnly ...

The -i flag is used to show the header of the response, if there is an error this flag will enable you to see the HTTP error code.

The -u glag is used to provide credentials.

In the example above we have listed all the integrations that are in the instance.  If you don't see the list of integrations then something is wrong.  Common problems are:

  • Wrong URL
  • Wrong username/password - pass them using single quotes to prevent interpretation of special characters by the shell.
  • Access denied due to whitelist not enabled - depending on the environment this may show as a timeout or an error from a proxy server.
Summary

As you can see gathering the information for whitelisting and then testing that it is correctly enabled are straightforward and don't require advanced networking skills.

New Batch Level Of Service Algorithms

Anthony Shorten - Sun, 2018-09-23 18:25

Batch Level Of Service allows implementations to register a service target on individual batch controls and have the Oracle Utilities Application Framework assess the current performance against that target.

In past releases of the Oracle Utilities Application Framework the concept of Batch Level Of Service was introduced. This is an algorithm point that assess the value of a performance metric against a target and returns the appropriate response to that target. By default, if configured, the return value is returned on the Batch Control maintenance screen or whenever called. For example:

Example Batch Control

It was possible to build an algorithm to set and check the target and return the appropriate level. This can be called manually, be available via the Health Service API or used in custom Query Portals. For example:

Example Portal

In this release a number of enhancements have been introduced:

  • Possible to specify multiple algorithms. If you want to model multiple targets it is now possible to link more than one algorithm to a batch control. The appropriate level will be returned (the worst case) for the multiple algorithms.
  • More Out Of The Box algorithms. In past releases a basic generic algorithm was supplied but additional algorithms are now provided to include additional metrics:
Batch Control Description F1-BAT-LVSVC Original Generic Algorithm to evaluate Error Count and Time Since Completion F1-BAT-ERLOS Compare Count Of Records in Error to Threshold F1-BAT-RTLOS Compare Total Batch Run Time to Threshold F1-BAT-TPLOS Compare Throughput to Threshold

For more information about these algorithms refer to the algorithm entries themselves and the online documentation.

Sea of Fertility

Greg Pavlik - Sun, 2018-09-23 18:24
In a discussion on some of my reservations on Murakami's take on 20th century Japanese literature, a friend commented on Mishima's Sea of Fertility tetrology with some real insights I thought worth preserving and sharing, albeit anonymously (if you're not into Japanese literature, now's a good time to stop reading):

"My perspective is different: it was a perfect echo of the end of “Spring Snow” and a final liberation of the main character from his self-constructed prison of beliefs. Honda’s life across the novels represents the false path: of consciousness the inglorious decay and death of the soul trapped in a repetition of situations that it cannot fathom being forced into waking. He is forced into being an observer of his own life eventually debasing himself into a “peeping Tom” even as he works as a judge. The irony is rich. Honda decays through the four novels since he clings to the memory of his friend (Kiyoaki) and does not understand the constructed nature his experience and desires. He is asleep. He wants Matsugae’s final dream to be the truth (that they will “...meet again under the Falls.”) His desires have been leading him in a circle and the final scene in the garden is his recognition of what the Abbess (Satoko from Spring Snow) was trying to convey to him. When she tells him, “There was no such person as Kiyoaki Matsugae”, it is her attempt to cure him of his delusion (and spiritual illness that has rendered him desperate and weak - chasing the ego illusions of his youth and seeking the reincarnation of his friend everywhere.) Honda lives in the dream of his ego and desire. In the final scene, he wakes up for the first time. I loved the image of the shadows falling on the garden. He is finally dying, stripped of illusion. I found it to be Mishima at his most powerful. I agree about “Sailor”, that is a great novel and much more Japanese in its economy of expression. Now, Haruki Murakami is a world apart from Kawabata and Mishima. I love his use of the unconscious/Id as a place to inform and enthrall: the labyrinth of dreams. Most of his characters are trapped (at least part of the time) in this “place”: eg Kafka on the Shore, Windup Bird Chronicle, Hard-boiled Wonderland and End of the World, etc. Literature has to have room for all of them. I like the other Murakami, Ryu Murkami, whose “Audition” and “Famous Hits of the Shōwa Era” are dark, psychotic tales of unrestrained, escalating violence but redeemed by deep probing of unconscious, hidden motives (the inhuman work of the unconscious that guides the characters like the Greek sense of fate (Moira)) and occasional black humor."
 

Pages

Subscribe to Oracle FAQ aggregator