Feed aggregator

Announcing Oracle Content and Experience Cloud

WebCenter Team - Wed, 2017-04-26 07:34

In a press release today, Oracle announced Oracle Content and Experience Cloud -- a digital experience platform that enables organizations to manage and deliver content to any digital channel to drive effective engagement with customers, partners, and employees. The cloud-based content hub allows organizations to easily create and distribute content in a meaningful way to improve brand engagement and customer growth and retention.

What’s new in Oracle Content and Experience Cloud?

Oracle Content and Experience Cloud delivers a single cloud-native platform for content production, management, and delivery across all lines of business. It provides unique capabilities to support a variety of business needs, from employee and customer engagement, to sales enablement and business development.

What are the key capabilities in Oracle Content and Experience Cloud?

  • Content Collaboration: Easily collaborate on content internally and with external teams. Discuss, share, and annotate content with mobile access, anywhere, anytime.
  • Centralized Content Hub: Utilize a single content hub to create, share, manage, and publish content to any channel, including business documents, digital assets, user-generated content, and web content.
  • Consistent Omni-Channel Experience: Leverage rich APIs to deliver engaging experiences across any channels and put your business in charge with business-friendly tools.
  • Enhanced Enterprise Applications with Content: Manage content from within your enterprise applications and enhance your application experience.

Where can you get more information on Oracle Content and Experience Cloud?

We encourage you to read the press release to learn more. We also invite you to join David Le Strat, senior director, product management, Oracle, in a webcast on May 2 at 10:00am PDT as he goes into depth about the key capabilities listed above and demonstrates Oracle Content and Experience Cloud in action!

Oracle Introduces a Smarter Approach to Customer Experience Management

Oracle Press Releases - Wed, 2017-04-26 07:30
Press Release
Oracle Introduces a Smarter Approach to Customer Experience Management Chatbots, artificial intelligence and enhanced mobile, video and messaging capabilities empower customer experience professionals to transform existing business processes

Modern Customer Experience 2017, Las Vegas, Nev.—Apr 26, 2017

Oracle today announced a series of new innovations within the Oracle Customer Experience (CX) Cloud Suite. By combining innovative new technologies such as chatbots and artificial intelligence with enhanced mobile, video and messaging capabilities, the latest updates to Oracle CX Cloud Suite enable commerce, marketing, sales and service professionals to reduce IT complexity, provide innovative customer experiences and deliver tangible business results.

Digital technologies have fundamentally changed how customers interact with brands and now a new generation of innovations, such as artificial intelligence and the Internet of Things (IoT), are reaching the mainstream. With the latest enhancements to the Oracle CX Cloud Suite, Oracle empowers customer experience professionals to take a smarter approach to managing digital business transformation. The latest enhancements include updates to commerce, marketing, sales and service applications within the Oracle CX Cloud Suite.

Chatbot Innovations

Innovative chatbot capabilities enable new customer experiences by asking and intelligently answering customer questions on both text and voice-driven platforms such as Facebook Messenger and Amazon Alexa. Marketing professionals can take advantage of chatbot capabilities for their cross-channel marketing in order to enhance larger, marketer-orchestrated customer journeys. Service professionals can benefit from the conversational style of a new Virtual Assistant to provide differentiated customer self-service experiences, as well as to improve response and resolution times across chat and messaging channels. Sales professionals can leverage a new Virtual Assistant that improves sales productivity by acting as a mobile, voice-driven assistant that automates common sales tasks such as account search, transaction creation and updates.  

Artificial Intelligence Innovations

New artificial intelligence based customer experience apps empower commerce, marketing, sales and service professionals to deliver smarter experiences across the customer lifecycle. The new Adaptive Intelligent Apps for CX uniquely blend first-party and third-party customer data with sophisticated decision science and machine learning, to help organizations optimize customer experiences and business outcomes.

Adaptive Intelligent Apps for CX embed within existing Oracle CX Cloud Suite commerce, marketing, sales and service applications. This ensures that business professionals are able to achieve immediate impact and value. For further details, see Adaptive Intelligent Apps for CX announcement.

Mobile, Video and Social Messaging Innovations

Enhanced mobile, video and social messaging capabilities help customer experience professionals transform existing business processes to meet the increasing expectations of empowered customers. New video and social messaging capabilities for service professionals power next-generation customer service strategies by enabling customer service agents to interact with customers across WeChat, Facebook Messenger and video channels. New mobile capabilities for sales professionals maximize productivity for sales reps, managers and partners with a voice-activated, task-based and role-based user experience. In addition, sales professionals now have the flexibility to use Windows Surface tablets, as well as iOS and Android devices, and take advantage of full offline capabilities to create and edit sales data without a cellular or Wi-Fi connection.

“These enhancements to the Oracle CX Cloud Suite underscore our commitment to an innovation-driven approach to software development and delivery across our entire platform,” said Rondy Ng, senior vice president, Application Development, Oracle. “By combining new mobile, video and messaging capabilities with the latest innovations in chatbots, artificial intelligence and IoT, we are uniquely able to help organizations of all sizes drive innovation and business transformation. We are committed to helping organizations meet the demands of empowered customers for seamless, personalized and immediate experiences today and in the future.”

Part of Oracle Applications Cloud, Oracle CX Cloud Suite empowers 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. The Oracle CX Cloud Suite includes Oracle Marketing Cloud, Oracle Sales Cloud, Oracle CPQ Cloud, Oracle Commerce Cloud, Oracle Service Cloud and Oracle Social Cloud.

Contact Info
Simon Jones
Public Relations for Oracle
+1.415.856.5155
sjones@blancandotus.com
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.

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 preceding 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

Simon Jones

  • +1.415.856.5155

Oracle Empowers Customer Experience Professionals with New Artificial Intelligence Apps

Oracle Press Releases - Wed, 2017-04-26 07:05
Press Release
Oracle Empowers Customer Experience Professionals with New Artificial Intelligence Apps Innovative commerce, marketing, sales and service apps enable smarter customer experiences that drive tangible and predictable business results

Modern Customer Experience 2017, Las Vegas, Nev.—Apr 26, 2017

Oracle today announced new artificial intelligence based customer experience apps that empower commerce, marketing, sales and service professionals to deliver smarter experiences across the customer lifecycle in real time. The new Adaptive Intelligent Apps for CX uniquely blend first-party and third-party data with sophisticated decision science and machine learning to deliver the industry’s most powerful AI-based customer experience solutions. Adaptive Intelligent Apps for CX are designed to help enhance existing commerce, marketing, sales and customer service applications within the Oracle CX Cloud Suite.

Adaptive Intelligent Apps are powered by insights from the Oracle Data Cloud, which is the largest data marketplace in the world with a collection of more than 5 billion global consumer and business IDs and more than 7.5 trillion data points collected monthly.

By applying advanced data science and machine learning to Oracle’s web-scale data and an organization’s own data, the new Adaptive Intelligent Apps for CX can have an unprecedented ability to react, learn and adapt in real time based on historical and dynamic customer data such as click-stream and social activity as well as inputs such as weather, lookalike audiences and Internet of Things (IoT) data. The new Adaptive Intelligence Apps for CX helps deliver customized insights that improve with every customer interaction and include innovative apps designed for consumer and B2B professionals.

Adaptive Intelligent Apps for CX deliver immediate impact by embedding within Oracle CX Cloud Suite applications to support customer experience workflows across commerce, marketing, sales and service.

  • Commerce Professionals: New AI-powered capabilities help turn static journeys into smart ones by delivering targeted product and content that is most relevant to the shopper’s immediate context. Recommendations utilize account data, shopper third-party data and real-time inputs to optimize outcomes and create superior consumer experiences for both first time and known shoppers. This drives repeat visits, loyalty and ultimately revenue.
  • Marketing Professionals: New AI-powered capabilities help enable smarter cross-channel experiences by delivering the most relevant, personalized content for each individual customer, at scale. By personalizing engagements in real time across all channels, the new AI capabilities help empower marketers to capture attention, drive engagement and improve conversion.
  • Customer Service Professionals: New AI-powered capabilities help enable smarter and faster resolution of customer issues by providing the best information in the right channel at the right time. By delivering predictive product failure, predictive account health and predictive recommendation capabilities to customer service professionals, customers can receive connected service experiences that ultimately improve customer loyalty and advocacy.
  • Sales Professionals: New AI-powered capabilities help enable smarter sales experiences by optimizing the selling process for sales teams and customers. For customers, the buying process is made more effortless and seamless as the right offer, optimized for the individual customer, is presented digitally or through a sales professional. Sales professionals can improve productivity by following guidance derived from opportunity analysis as well as using account engagement and next-best-action capabilities to accelerate and close more deals.

“Oracle is uniquely placed to deliver on the promise of artificial intelligence based enterprise applications and is delivering on the future of AI driven business applications today,” said Clive Swan, SVP Applications Development, Oracle Adaptive Intelligence. “By combining first and third party data with advanced machine learning and the industry’s most comprehensive cloud applications suite, Oracle provides a complete package that helps eliminate the need for more integrations or other costly and time-consuming processes. This enables our customers to achieve immediate value and take a smarter approach to business transformation.”

Part of Oracle Applications Cloud, Oracle CX Cloud Suite empowers 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. The Oracle CX Cloud Suite includes Oracle Marketing Cloud, Oracle Sales Cloud, Oracle CPQ Cloud, Oracle Commerce Cloud, Oracle Service Cloud and Oracle Social Cloud.

Contact Info
Simon Jones
Public Relations for Oracle
+1.415.856.5155
sjones@blancandotus.com
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.

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 preceding 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

Simon Jones

  • +1.415.856.5155

Oracle Content and Experience Cloud Empowers Organizations to Deliver Modern, Engaging Digital Experiences

Oracle Press Releases - Wed, 2017-04-26 07:02
Press Release
Oracle Content and Experience Cloud Empowers Organizations to Deliver Modern, Engaging Digital Experiences New cloud-based content hub drives omni-channel marketing asset management

Modern Marketing Experience, Las Vegas, Nev.—Apr 26, 2017

Oracle today announced Oracle Content and Experience Cloud, a digital experience platform that enables organizations to manage and deliver content to any digital channel to drive effective engagement with customers, partners, and employees. The cloud-based content hub allows organizations to easily create and distribute content in a meaningful way to improve brand engagement and customer growth and retention.

“Organizations are faced with a deluge of content,” said David Le Strat, senior director, product management, Oracle. “Oracle Content and Experience Cloud helps organizations develop, use, and distribute content in a meaningful way to deliver contextualized experiences, improve customer loyalty, and create brand advocates.”

“Renault Italy implemented CRUEL’s WONDER Marketing solution powered by Oracle Content and Experience Cloud in 2015 and 2016 and is now able to distribute marketing materials 90 percent faster and respond to its auto dealers 40 percent faster,” said Antonio Orefice, Business Account Manager, Renault Italia SPA.

Part of the Oracle Cloud Platform, Oracle Content and Experience Cloud delivers a single cloud-native platform for content production, management, and delivery across all lines of business. It provides unique capabilities to support a variety of business needs, from employee and customer engagement, to sales enablement and business development. Key capabilities include:

  • Content Collaboration: Easily collaborate on content internally and with external teams. Discuss, share, and annotate content with mobile access, anywhere, anytime.
  • Centralized Content Hub: Utilize a single content hub to create, share, manage, and publish content to any channel, including business documents, digital assets, user-generated content, and web content.
  • Consistent Omni-Channel Experience: Leverage rich APIs to deliver engaging experiences across any channels and put your business in charge with business-friendly tools.
  • Enhanced Enterprise Applications with Content: Manage content from within your enterprise applications and enhance your application experience.

 “In today’s digital economy, everyone expects to have a seamless experience across channels,” said Melissa Webster, program vice president, content and digital media technologies, IDC. “Enterprises need the ability to unlock content from existing systems, and drive native cloud content production to publish across any channels. This helps organizations deliver consistent omni-channel experiences for their customers and build brand advocates.”

Oracle Content and Experience Cloud is uniquely capable of addressing the needs of both the business user and IT, enabling them to work together to deliver modern, engaging digital experiences (DX). The platform integrates with the Oracle Customer Experience Cloud Suite, an integrated suite of cloud applications that empower organizations to take a smarter approach to customer experience management and business transformation initiatives. The Content and Experience Cloud also integrates with a number of leading Oracle Cloud Platform services, including Oracle Process Cloud, Oracle Mobile Cloud and Oracle Integration Cloud. This forms the most comprehensive and powerful DX platform for managing content operations, data integration, complex workflow management, and mobile and marketing automation capabilities.

Oracle Cloud

Oracle Cloud is the industry’s broadest and most integrated public cloud, offering a complete range of services across SaaS, PaaS, and IaaS. It supports new cloud environments, existing ones, and hybrid, and all workloads, developers, and data. The Oracle Cloud delivers nearly 1,000 SaaS applications and 50 enterprise-class PaaS and IaaS services to customers in more than 195 countries around the world and supports 55 billion transactions each day.

For more information, please visit us at http://cloud.oracle.com.

Contact Info
Nicole Maloney
Oracle
+1.415.235.4033
nicole.maloney@oracle.com
Simon Jones
Public Relations for Oracle
+1.415.856.5145
simon.jones@blancandotus.com
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.

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 preceding 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

Nicole Maloney

  • +1.415.235.4033

Simon Jones

  • +1.415.856.5145

Oracle Honors Excellence in Modern Marketing at the 2017 Markie Awards

Oracle Press Releases - Wed, 2017-04-26 07:00
Press Release
Oracle Honors Excellence in Modern Marketing at the 2017 Markie Awards Awards recognize creativity, innovation and success in modern marketing

Modern Customer Experience 2017, Las Vegas, Nev.—Apr 26, 2017

To promote best practices and celebrate the accomplishments of modern marketers around the world, Oracle has announced the winners of the 2017 Markie Awards. Now in its 11th year, the Markie Awards recognize the top companies and leaders for creative, innovative, and effective modern marketing campaigns that delivered increased engagement, conversion and ROI. Past winners include notable companies such as Lenovo, Royal Philips, Cisco Systems, Dell, Inc. and Mobovida, LLC.

The 2017 Markie Awards featured 17 categories that reflect the evolving marketing landscape, including: Account-Based Marketing Team of the Year, Best Digital Marketing Ecosystem, Best Integrated Mobile Experience, Best Use of Data, Most Creative Marketing Campaign, and Modern Marketing Leader of the Year.

“The annual Markie Awards are our way to recognize and celebrate heroic marketing and the most prominent modern marketing success stories over the past year,” said Laura Ipsen, senior vice president and general manager, Oracle Marketing Cloud. “This year’s winners have gone above and beyond, fully leveraging the most innovative marketing technologies to create customer-centric campaigns that delivered outstanding results.”

Winners of the 2017 Markie Awards are:

  • Account-Based Marketing Team of the Year: Covance Inc.
  • Best Cross-Channel Marketing Program: Cisco Inc.
  • Best Digital Marketing Ecosystem: Juniper Networks
  • Best Email Marketing Campaign: Jetstar Airways
  • Best Emerging Company Marketing Campaign: National MI
  • Best Integrated Mobile Experience: Mountain America Credit Union
  • Best International Campaign: Tableau Software
  • Best Lead Management Program: Morningstar, Inc.
  • Best Overall Customer Experience: Avon
  • Best Social Campaign: TD Ameritrade Institutional
  • Best Testing and Optimization: Hilton Worldwide
  • Best Use of Data: Calçados Bibi
  • Best Use of Insights & ROI: Deltek
  • Modern Marketing Leader of the Year: Kenya Airways
  • Most Creative Marketing Campaign: Eaton
  • Rapid Transformation: FIS
  • People’s Choice Award – Best Video Submission: Juniper Networks

The 2017 Markie Awards were presented on Tuesday, April 25th, during Modern Customer Experience 2017 Las Vegas, Nevada.

Contact Info
Simon Jones
Public Relations for Oracle
+1.415.856.5155
sjones@blancandotus.com
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.

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 preceding 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

Simon Jones

  • +1.415.856.5155

Save the date: Swiss PGDay 2017

Yann Neuhaus - Wed, 2017-04-26 05:52

The 30th of June is not too far away and if you want to learn more about the “World’s most advanced open source database” you should register soon. The sessions are not yet officially announced but you can expect that to happen next week. What we can say already is that we will be there and that you can expect these sessions from dbi:

  • How to migrate data from MongoDB to Postgres with ToroDB
  • Elking your PostgreSQL database infrastructure
  • PostgreSQL upgrade best practices

Hope to see you in June.
PGDay2017CH

 

Cet article Save the date: Swiss PGDay 2017 est apparu en premier sur Blog dbi services.

Oracle 12.2 tables, indexes new features

Yann Neuhaus - Wed, 2017-04-26 04:26

The Oracle 12.2.0.1 version has some interesting new features  concerning tables or indexes.

The first new feature is about the online table move.

In 12.2 version Oracle offers now the possibility to move non-partitioned tables without blocking any DML operations.

To realise this operation, we must use the ONLINE keyword and/or the UPDATE_INDEXES clause. If you remember, in the previous Oracle version, we encountered the classical ORA-01502 error.

If you remember in version 12.1, we have the following behaviour, we create a table with a constraint and we insert some values:

SQL> create table emp (name varchar2(10), salary number );
Table created.
SQL> alter table emp add constraint emp_pk primary key (name);
Table altered.
SQL> insert into emp values ('Bill', 100000);
1 row created.
SQL> insert into emp values ('Larry', 10000000);
1 row created.
SQL> commit;
Commit complete.

SQL> select * from emp;
NAME           SALARY
 ---------- ----------
 Bill           100000
 Larry         10000000

Then if  we move the table to another tablespace, the index become unusable, and if we try to insert some data we receive the ORA-1502 error:

SQL> alter table emp move tablespace PSI;
Table altered.
 
SQL> select index_name, status from user_indexes;
 
INDEX_NAME        STATUS
EMP_PK           UNUSABLE
 
SQL> insert into emp values ('Pierre', 99999);
insert into emp values ('Pierre', 99999)
*
ERROR at line 1:
ORA-01502: index 'PSI.EMP_PK' or partition of such index is in unusable state

Now in 12.2 version, we do not have this problem anymore:

SQL> create table emp (name varchar2(10), salary number);
Table created.
 
SQL> alter table emp add constraint emp_pk primary key (name);
Table altered.
 
SQL> insert into emp values ('Bill', 100000);
1 row created.
 
SQL> insert into emp values ('Larry', 999999); 
1 row created.
 
SQL> commit;
Commit complete.
 
SQL> select * from emp;
 
NAME       SALARY
---------- ----------
Bill         100000
Larry        999999
 
 
SQL> select index_name, status from user_indexes;
 
INDEX_NAME        STATUS
EMP_PK            VALID
 
SQL> alter table emp move tablespace PSI2 update indexes;
Table altered.
 
SQL> select index_name, status from user_indexes;
INDEX_NAME        STATUS
EMP_PK            VALID
 
SQL> insert into emp values ('Pierre', 99999);
1 row created.

Using this way, we also can move indexes in different tablespaces:
SQL> alter table emp move online tablespace PSI
  2  update indexes
  3  (emp_pk tablespace psi_ix1,
  4  emp_ix2 tablespace psi_ix1);
 
Table altered.
 
SQL> select index_name, status, tablespace_name from user_indexes;
 
INDEX_NAME.   STATUS TABLESPACE_NAME
EMP_PK        VALID  PSI_IX1
EMP_IX2       VALID  PSI_IX1

Another interesting new feature is about the conversion to a partitioned table. Before the Oracle 12.2 version, the methods used to convert a non-partitioned table to a partitioned table were not online or were using dbms_redefinition. Now in 12.2 we have the possibility to realize the operation in online mode:

SQL> create table emp (name varchar2(10), emp_id number, salary number);

Table created.

SQL> insert into emp values(‘Larry’, 1, 1000000);

1 row created.

SQL> insert into emp values (‘Bill’, 100, 999999);

1 row created.

SQL> insert into emp values (‘Steve’, 1000, 1000000);

1 row created.

SQL> alter table emp modify

partition by range (emp_id) interval (100)

(partition p1 values less than (50),

partition p2 values less than (500),

partition p3 values less than (5000)

) online;

Table altered.

SQL> select table_name , partition_name, high_value from user_tab_partitions;

TABLE_NAME.     PARTITION_NAME      HIGH_VALUE

EMP                                  P1                                      50

EMP                                  P2                                     500

EMP                                  P3.                                    5000

As you can see, this is really an easy way to move a non partitioned table to a partitioned table.

The next new feature I will talk about is concerning the advanced compression. For example, we have the possibility to create a tablespace with such an argument:

SQL> create tablespace psi_ix_compress
  2  default index compress advanced high
  3  datafile '/u01/oradata/db1/db1pdb1/psi_ix_comp01.dbf' size 10M;
 
Tablespace created.

Every new index created in this tablespace will use high advanced compression. But at first approach it does not seem to work very well:

SQL> create index psi_ix2 on emp(salary) tablespace psi_ix_compress;
 
Index created.
 
SQL> select index_name, compression from user_indexes;
 
INDEX_NAME             COMPRESSION
EMP_PK                  DISABLED
EMP_IX2                 DISABLED
PSI_IX2                 DISABLED

But if you have a more precise look, there is a parameter you have also to modify:

SQL> show parameter db_index_compression_inheritance
 
NAME                                  TYPE VALUE
db_index_compression_inheritance     string NONE

SQL> alter system set db_index_compression_inheritance = 'TABLESPACE';
 
System altered.

And finally, it works fine:

SQL> create index psi_ix1_comp on emp (name, emp_id,salary) tablespace psi_ix_compress;
Index created.
 
SQL> select index_name, compression from user_indexes where index_name like '%COMP';
INDEX_NAME.      COMPRESSION
PSI_IX1_COMP     ADVANCED HIGH

We have the possibility to specify the ADVANCED COMPRESS HIGH or LOW argument in the create or rebuild statement:

 

SQL> create index psi_ix1 on emp (salary) compress advanced low;
 
Index created.
 
SQL> select index_name, compression from user_indexes;
 
INDEX_NAME         COMPRESSION
EMP_PK              DISABLED
PSI_IX1             ADVANCED LOW
PSI_NEW             DISABLED

And we can use alter index rebuild to modify to high advanced compression:

SQL> alter index psi_ix1 rebuild compress advanced high;
Index altered.
 
SQL> select index_name, compression from user_indexes;
 
INDEX_NAME.        COMPRESSION
EMP_PK              DISABLED
PSI_IX1.            ADVANCED HIGH
PSI_NEW             DISABLED

Enjoy using those Oracle 12.2.0.1 new features !

 

Cet article Oracle 12.2 tables, indexes new features est apparu en premier sur Blog dbi services.

JRE 1.7.0_141 Certified with Oracle E-Business Suite 12.1 and 12.2

Steven Chan - Wed, 2017-04-26 02:00

Java logo

Java Runtime Environment 1.7.0_141 (a.k.a. JRE 7u141-b11) and later updates on the JRE 7 codeline are now certified with Oracle E-Business Suite Release 12.1 and 12.2 for Windows-based desktop clients.

All JRE 6, 7, and 8 releases are certified with EBS upon release

Our standard policy is that all E-Business Suite customers can apply all JRE updates to end-user desktops:

  • From JRE 1.6.0_03 and later updates on the JRE 6 codeline
  • From JRE 1.7.0_10 and later updates on the JRE 7 codeline 
  • From JRE 1.8.0_25 and later updates on the JRE 8 codeline
We test all new JRE releases in parallel with the JRE development process, so all new JRE releases are considered certified with the E-Business Suite on the same day that they're released by our Java team. 

You do not need to wait for a certification announcement before applying new JRE 6, 7, or 8 releases to your EBS users' desktops.

Effects of new support dates on Java upgrades for EBS environments

Support dates for the E-Business Suite and Java have changed.  Please review the sections below for more details:

  • What does this mean for Oracle E-Business Suite users?
  • Will EBS users be forced to upgrade to JRE 7 for Windows desktop clients?
  • Will EBS users be forced to upgrade to JDK 7 for EBS application tier servers?

32-bit and 64-bit versions certified

This certification includes both the 32-bit and 64-bit JRE versions for various Windows operating systems. See the respective Recommended Browser documentation for your EBS release for details.

Where are the official patch requirements documented?

EBS + Discoverer 11g Users

This JRE release is certified for Discoverer 11g in E-Business Suite environments with the following minimum requirements:

JRE 7 End of Public Updates

The JRE 7u79 release was the last JRE 7 update available to the general public. Java is an integral part of the Oracle E-Business Suite technology stack, so EBS users will continue to receive Java SE 7 updates to the end of Java SE 7 Premier Support to the end of July 2016.

How can EBS customers obtain Java 7 updates after the public end-of-life?

EBS customers can download Java 7 patches from My Oracle Support.  For a complete list of all Java SE patch numbers, see:

Both JDK and JRE packages are now contained in a single combined download.  Download the "JDK" package for both the desktop client JRE and the server-side JDK package. 

Coexistence of multiple JRE releases Windows desktops

The upgrade to JRE 8 is recommended for EBS users, but some users may need to run older versions of JRE 6 or 7 on their Windows desktops for reasons unrelated to the E-Business Suite.

Most EBS configurations with IE and Firefox use non-static versioning by default. JRE 8 will be invoked instead of earlier JRE releases if both are installed on a Windows desktop. For more details, see "Appendix B: Static vs. Non-static Versioning and Set Up Options" in Notes 290807.1 and 393931.1.

Java Auto-Update Mechanism

With the release of the January 2015 Critical patch Updates, the Java Auto-Update Mechanism will automatically update JRE 7 plug-ins to JRE 8.

Coexistence of multiple JRE releases Windows desktops

The upgrade to JRE 8 is recommended for EBS users, but some users may need to run older versions of JRE 6 or 7 on their Windows desktops for reasons unrelated to the E-Business Suite.

Most EBS configurations with IE and Firefox use non-static versioning by default. JRE 8 will be invoked instead of earlier JRE releases if both are installed on a Windows desktop. For more details, see "Appendix B: Static vs. Non-static Versioning and Set Up Options" in Notes 290807.1 and 393931.1.

What do Mac users need?

Mac users running Mac OS X 10.7 (Lion), 10.8 (Mountain Lion), 10.9 (Mavericks), and 10.10 (Yosemite) can run JRE 7 or 8 plug-ins.  See:

Will EBS users be forced to upgrade to JDK 7 for EBS application tier servers?

JRE is used for desktop clients.  JDK is used for application tier servers.

JDK upgrades for E-Business Suite application tier servers are highly recommended but currently remain optional while Java 6 is covered by Extended Support. Updates will be delivered via My Oracle Support, where you can continue to receive critical bug fixes and security fixes as well as general maintenance for JDK 6 for application tier servers. 

Java SE 6 is covered by Extended Support until June 2017.  All EBS customers with application tier servers on Windows, Solaris, and Linux must upgrade to JDK 7 by June 2017. EBS customers running their application tier servers on other operating systems should check with their respective vendors for the support dates for those platforms.

JDK 7 is certified with E-Business Suite 12.  See:

Known Issues

When using Internet Explorer, JRE 1.7.0_01 had a delay of around 20 seconds before the applet started to load. This issue is fixed in JRE 1.7.0_95.

References

Related Articles
Categories: APPS Blogs

Cross-origin resource sharing (CORS) from Spring Boot Rest Controllers

Pas Apicella - Tue, 2017-04-25 18:45
Was involved in a hackathon recently and after creating a few Spring boot API's for the UI team to consume and they run into errors around (Cross-origin resource sharing ). For security reasons, browsers prohibit AJAX calls to resources residing outside the current origin.

I have seen this before and Spring Boot has support to ensure you can control which resources can be accessed outside of the current origin. It's as simple as an annotation "@CrossOrigin", as shown below. In this example every request from this Rest Controller supports resource calls residing outside the current origin.
  
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.HttpStatus;
import org.springframework.http.MediaType;
import org.springframework.web.bind.annotation.*;

import java.util.List;

@CrossOrigin
@RestController
@RequestMapping(value = "/beacon")
public class BeaconRest
{
private static Log logger = LogFactory.getLog(BeaconRest.class);

@Autowired
private BeaconRepository beaconRepository;

@RequestMapping(value = "/all",
method = RequestMethod.GET,
produces = MediaType.APPLICATION_JSON_VALUE)
public List<Beacon> allBeacons()
{
logger.info("Invoking /beacon/all RESTful method");
return beaconRepository.findAll();
}

Of course it's much more flexible then that adding the ability to add options, and you can read more about it here.

https://docs.spring.io/spring/docs/4.2.x/spring-framework-reference/html/cors.html
Categories: Fusion Middleware

Find duplicates in String.

Tom Kyte - Tue, 2017-04-25 17:06
Hello- I have bunch of numbers returned via a report, as shown. What would be the best way to return numbers that occur more than once? For ex: In the first data set, I should return 11; in the second data set I should return 9 and 12 and so on...
Categories: DBA Blogs

Dynamic sql with case statement.

Tom Kyte - Tue, 2017-04-25 17:06
hello, i have wrote normally a long query and i use many case statements and i want to reuse this query. therefore i want to create a procedure with parameter to do that. At the end i want to create a view or a table with this query. therefore i hav...
Categories: DBA Blogs

REGEXP_REPLACE Match Parameters m and n.

Tom Kyte - Tue, 2017-04-25 17:06
I've been trying to write a query that will remove the comments from another query. Here's the small sample query-with-comments, from which I want to remove the comments: <code>WITH sample_SQL ( line#, txt ) AS ( SELECT line#, txt FROM dual ...
Categories: DBA Blogs

Index coalesce clean waits on enq: TX - row lock contention

Tom Kyte - Tue, 2017-04-25 17:06
Hi TOMs! I've noticed that periodically our 12.1.0.2 Asynchronous Global Index Maintenance job (PMO_DEFERRED_GIDX_MAINT_JOB) gets hung up from time to time and I've tracked it down to a long running insert causing the job to wait on enq: TX - row lo...
Categories: DBA Blogs

Reporting with SQL, How we can merge multiple execution of SQL

Tom Kyte - Tue, 2017-04-25 17:06
Hello TOM, we are generating report with SQL Query and output save to text file. I want to know if we can avoid multiple execution of SQL queries by using any other better way to achieve this and also not want to impact performance. we execute ...
Categories: DBA Blogs

using LIKE operator with IN Clause

Tom Kyte - Tue, 2017-04-25 17:06
Hi, Currently we have a query as given below, select count (distinct chk_ppl_val.serialnum) serialnum__ndv, count (distinct chk_ppl_val.individual_id) individual_id__ndv from chk_ppl_val where (substring(industry_code,1,4) in (SELECT distinct st...
Categories: DBA Blogs

P1TEXT, P1, P2TEXT, P2

Tom Kyte - Tue, 2017-04-25 17:06
Hi Tom, Want to understand what exactly P1TEXT, P1, P3TEXT, P2 denote in various v$ views like v$session, v$session_wait. Documentation says P1TEXT : Description of the first wait event parameter P1 : First wait event parameter (in decimal) ...
Categories: DBA Blogs

scheduler job not raise error

Tom Kyte - Tue, 2017-04-25 17:06
Hi askTome team. I have two database one name is prod and another is test. Their version are 12.2.0.1 I create a scheduler job on db:prod like this <code> begin dbms_scheduler.create_job( job_name=>'J_TEST_02', job_typ...
Categories: DBA Blogs

Trigger to capture before and after insert value of particular column

Tom Kyte - Tue, 2017-04-25 17:06
Hi Team, I have to create a trigger which will record the old value as well as new value in case of insert. Situation is that I have one application and on frontend part whenever some changes happened then the xyz_id got changed. At the backend, ...
Categories: DBA Blogs

What are the benefits of Manufacturing Dashboards?

Nilesh Jethwa - Tue, 2017-04-25 16:15

Today in the US economy, the major players in the manufacturing industry are electronics, automobile, steel, consumer goods, and telecommunications. And as they offer more advanced products, including tablets and smartphones. These technological advancements significantly influence consumer lifestyles.

Along with these changes, the global manufacturing industry is currently embracing a new key player called metrics based manufacturing. This is actually the latest trend that industries need to consider in their sales funnel. So, what does this mean?

Read more at http://www.infocaptor.com/dashboard/manufacturing-dashboards-what-are-their-benefits

Listener and Virtual IP

Yann Neuhaus - Tue, 2017-04-25 15:24

When you configure a standby database, you want the application to transparently connect to the primary database, wherever it is. That’s the role of Transparent Application Failover, but this requires configuration on the client side. If you can’t configure TAF, you can use a virtual IP address. But then the question is how to configure the listener.ora to handle connections to this VIP.

Don’t worry, if you configured everything as recommended, with the hostname declared in /etc/hosts, and listener.ora referencing this host name, then you can simply ignore the VIP for your configuration. The reason is that when the host specified in the listener.ora resolves to the same IP address as the hostname of the server, then Oracle listener binds the port on all interfaces, and this includes the VIP.

However, if you mentioned an IP address in the listener.ora, or if you mentioned a host that resolves to a different IP than the hostname, then it listens only tho this interface.

Why not just listen to the VIP? There are two reasons for that. First, you will need to listen to the host IP anyway for the dynamic registration of instances. You don’t want the standby database to contact the listener on the primary server. The second reason is that you cannot start the listener if the IP is not up. Then, if you want to explicitly listen to the VIP you will need two listeners, some security rules to allow only local registration and to manage the start of the listener, monitoring, etc.

The simplest configuration is to have one listener configured on the server hostname, then it listens on all interfaces and clients can connect with the VIP (for the application) or with the server IP (for Data Guard broker, backups, monitoring, administration).

The behaviour is described in How The Listener Binds On TCP Protocol Addresses (Doc ID 421305.1)

Examples

I have two network interfaces on my system, the loopback (lo) and Ethernet (enp0s3). This interface has the IP 192.168.78.104 and I have added a virtual IP 192.168.66.102 with:

ip a add 192.168.66.102/24 dev enp0s3

Here is the list of interfaces:

[oracle@VM104 tmp]$ ip a
1: lo: mtu 65536 qdisc noqueue state UNKNOWN
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: enp0s3: mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether 08:00:cc:00:4e:68 brd ff:ff:ff:ff:ff:ff
inet 192.168.78.104/24 brd 192.168.78.255 scope global enp0s3
inet 192.168.66.102/24 scope global enp0s3
inet6 fe80::a00:ccff:fe00:4e68/64 scope link
valid_lft forever preferred_lft forever

Here is the content of my /etc/hosts where I have two names that resolve to my server IP address 192.168.78.104

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.78.104 VM104 myhost

One of these names is my server hostname:


[oracle@VM104 tmp]$ hostname
VM104

I’ll try different configuration of my listener.ora

(HOST=127.0.0.1)

I mentioned the IP address of the loopback interface

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=6666)))

The listener listens to this address only:

[oracle@VM104 tmp]$ ss -elpunt | grep -E "^Net|tnslsnr"
Netid State Recv-Q Send-Q Local Address:Port Peer Address:Port
tcp LISTEN 0 128 127.0.0.1:6666 *:* users:(("tnslsnr",4685,8))

With this configuration, I’m able to connect only through the mentioned address, 127.0.0.1

Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.78.104)(PORT=6666)))
TNS-12541: TNS:no listener
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.66.102)(PORT=6666)))
TNS-12541: TNS:no listener
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=6666)))
OK (10 msec)

(HOST=localhost)

I mentioned the loopback interface by a host name

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=6666)))

This is actually the same as above: the host mentioned has been resolved at listener startup.

(HOST=1192.168.78.104)

I mentioned the IP address of the host interface

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.78.104)(PORT=6666)))

The listener listens to this address only:

[oracle@VM104 tmp]$ ss -elpunt | grep -E "^Net|tnslsnr"
Netid State Recv-Q Send-Q Local Address:Port Peer Address:Port
tcp LISTEN 0 128 192.168.78.104:6666 *:* users:(("tnslsnr",4735,8))

With this configuration, I’m able to connect only through the mentioned address, not the virtual IP, not other interfaces:

Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.78.104)(PORT=6666)))
OK (0 msec)
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.66.102)(PORT=6666)))
TNS-12541: TNS:no listener
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=6666)))
TNS-12541: TNS:no listener

(HOST=localhost)

I mentioned the loopback interface by a host name

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=6666)))

This is actually the same as above: the host mentioned has been resolved at listener startup.

(HOST=VM104)

I mentioned the host name which resolves to the IP address of the host interface – this is the default when creating with DBCA, and the recommended configuration.

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=VM104)(PORT=6666)))

The listener socket do not mention the IP address:

[oracle@VM104 tmp]$ ss -elpunt | grep -E "^Net|tnslsnr"
Netid State Recv-Q Send-Q Local Address:Port Peer Address:Port
tcp LISTEN 0 128 :::6666 :::* users:(("tnslsnr",4760,8))

We see something different here as there’s no mention of a local address in :::6666

With this configuration, I’m able to connect through any IP address, including the virtual IP

Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.78.104)(PORT=6666)))
OK (0 msec)
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.66.102)(PORT=6666)))
OK (10 msec)
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=6666)))
OK (10 msec)

(HOST=myhost)

I mentioned another host name which resolves to the IP address of the host interface (see the /etc/hosts above). It is not the hostname returned by $(hostname) but it resolve to same IP.

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=VM104)(PORT=6666)))

The listener has resolved the address through /etc/hosts and then, because the IP matches the resolution of $(hostname), has used the $(hostname). We are then in the same situation as above where we can connect through any interface:

[oracle@VM104 tmp]$ ss -elpunt | grep -E "^Net|tnslsnr"
Netid State Recv-Q Send-Q Local Address:Port Peer Address:Port
tcp LISTEN 0 128 :::6666 :::* users:(("tnslsnr",4760,8))

(HOST=0.0.0.0)

Finally, when you want to listen on all interfaces, why not configure the host to 0.0.0.0

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=VM104)(PORT=6666)))

We are again in the same situation here and the listener has replaced it with the hostname. This may be convenient when you want to use the same listener.ora for different hosts. However, as it finally show the hostname, better to avoid confusion and have it in the listener.ora

(HOST=VM104)(IP=FIRST)

This is the way to bypass the ‘listen on all interfaces’ rule, even when you resolve to the hostname.

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.78.104)(PORT=6666)))

Because of (IP=FIRST) the listener listens to the first IP address returned by gethostbyname()

Conclusion

It is easy to know if the listener listens on one specific IP address, or on all interfaces. You get the hostname and the listener endpoints

hostname
lsnrctl status

If the ‘HOST=’ matches the hostname, then it listens to all interfaces. If the ‘HOST=’ mentions an IP address, then it listens on this IP only. If it mentions a name which is not the hostname, then maybe someone has changed the hostname after the listener was started?

The other way is to look at the socket information with:

netstat -elpunt
ss -elpunt

If you think that it is a security problem to listen to all interfaces, then you should understand that the listener is not a firewall. It is just a convenient way to route connections by service name to the right instance. But remember that you can even connect to the database without the listener (read https://amitzil.wordpress.com/2015/10/19/bypassing-the-listener/), just connecting to the dispatcher:

Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SID=CDB1))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=30229)))
OK (0 msec)

And this one listens to all interfaces:


[oracle@VM104 tmp]$ ss -elpunt | grep -E "(^Net|ora_d)"
Netid State Recv-Q Send-Q Local Address:Port Peer Address:Port
tcp LISTEN 0 128 :::30229 :::* users:(("ora_d000_cdb1",1362,8)) uid:54321 ino:20635 sk:ffff880117900800
tcp LISTEN 0 128 :::32316 :::* users:(("ora_d000_cdb2",1729,8)) uid:54321 ino:20958 sk:ffff880117900040

Security is done by firewall rules. Listener is there only to help, so keep it simple.

 

Cet article Listener and Virtual IP est apparu en premier sur Blog dbi services.

Pages

Subscribe to Oracle FAQ aggregator