Feed aggregator

Live Twitter Chat on Headless CMS – Tomorrow!

WebCenter Team - Wed, 2017-04-19 09:14

You are invited! Have you heard the term "headless CMS" going around? Decoupled/headless CMS architecture is rising in popularity in the development world and we want to hear from you! If you have something to say about headless CMS or WCM, if you have questions on this topics, if you have experience working with coupled or decoupled CMS or WCM, if you've been following the discussions on this topic or if you are just interested in trying a Twitter Chat out for the first time, we invite you to participate in the live Twitter conversation on "Is headless CMS signaling the end of WCM?" @oraclewebcenter will be kicking off the live Twitter Chat on Thursday, April 20 at 10:00am PT / 1:00pm ET, and we hope to hear from you!

The live Twitter Chat would run about an hour long, and we look to have a meaningful conversation on the topic. So, if you have a Twitter handle, we encourage you to participate in the live discussion. Join or simply follow along using hashtag: #contentdgtl

And, if you have questions in mind, simply send those to us @oraclewebcenter and we will do our best to include or have those addressed by the Digital Experience community.

So, mark your calendar and please join us!

Live Twitter Chat
  • Topic: Is headless CMS signaling the end of WCM? 
  • Date: Thursday, April 20 (tomorrow!)
  • Time: 10:00am PT / 1:00pm ET
  • Hashtag: #contentdgtl
  • Host: @oraclewebcenter
We will archive and post the discussion shortly after the live event. Talk to you soon!

Oracle Brings Oracle’s Flagship Databases and Developer Tools to the Docker Store

Oracle Press Releases - Wed, 2017-04-19 09:00
Press Release
Oracle Brings Oracle’s Flagship Databases and Developer Tools to the Docker Store Developers can easily access leading databases and developer tools as Docker containers to develop and deploy cloud-scale applications.

DockerCon, AUSTIN, TX.—Apr 19, 2017

Oracle announced today that it is collaborating with Docker to release  its flagship databases, middleware and developer tools into the Docker Store marketplace via the Docker Certification Program. Together, Oracle and Docker enable developers to quickly build cloud-native applications using Docker Enterprise Edition as their container platform and Oracle’s databases and developer tools immediately available as Docker containers through the Docker Store.. The Docker Certification Program is a framework for partners to integrate and certify their technology to the Docker EE commercial platform.

Effective immediately, developers can now pull images of Oracle products in Docker and quickly start developing, testing and deploying modern enterprise applications. Solutions offered include Oracle Database, Oracle MySQL, Oracle Java 8 SE Runtime Environment, Oracle WebLogic Server, Oracle Coherence and Oracle Instant Client, which are now all available in the Docker Store as enterprise-ready containers. 

As cloud computing continues to transform every business and industry, developers at global enterprises and emerging startups alike are increasingly leveraging container technologies to accelerate how they build modern Web, mobile and IoT applications. Because the need for new applications in the enterprise consistently outpaces development capabilities, modern developers need to be able to quickly develop, test and deploy their applications without worrying about their deployment environment. With the availability of Oracle in the Docker Store, developers are now free for the first time to deliver best in class secure, high-performance, and resilient applications in containers with confidence. Oracle is a long-time supporter of the Docker ecosystem with more than 100 images of Oracle products already available in the Docker Hub, including OpenJDK and Oracle Linux.

Developers can try these images immediately by downloading them on any public cloud or on-premises servers. With Oracle Cloud, developers can deploy these images on the cloud infrastructure of their choice: virtual, bare metal or managed containers. Developers can try the service and experience Oracle Cloud with $300 in free credits by visiting https://cloud.oracle.com/tryit.

“Docker is revolutionizing the way developers build and deploy modern applications, but mission-critical systems in the enterprise have been a holdout until now,” said Mark Cavage, Vice President of Software Development at Oracle. “Together with Docker, Oracle is bringing bedrock software to millions of developers enabling them to create enterprise-grade solutions that meet stringent security, performance and resiliency SLAs with the high level of productivity and low friction that they have come to expect from Dockerizing their application development stack."

“Enterprises have relied on Oracle’s technology to power their businesses for decades and their databases and middleware tools are used by millions of developers around the world,” said Marianna Tessel, EVP Strategic Development at Docker. “With this new partnership, developers looking to use containers for their businesses can now access the world’s most popular databases and developer tools and leverage the performance and robustness of Oracle in their applications, all in just a few clicks.”

For more information, please visit https://developer.oracle.com/docker

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 about Oracle Cloud, please visit http://cloud.oracle.com

Contact Info
Alex Shapiro
Oracle PR
+1.415.608.5044
alex.shapiro@oracle.com
Kristin Reeves
Blanc & Otus
+1.415.856.5145
kristin.reeves@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

Alex Shapiro

  • +1.415.608.5044

Kristin Reeves

  • +1.415.856.5145

Come to the UKOUG PeopleSoft Roadshow

Duncan Davies - Wed, 2017-04-19 08:16

The UK Oracle User Group PeopleSoft Roadshow is nearly upon us. It’s my favourite PeopleSoft event in the UK’s calendar as you know that everyone there has a focus on PeopleSoft and the agenda is always really strong.

It’s 26th April (yes, a week today!) in the Crowne Plaza, London – the same as last time, which was a great venue.

Oracle US Speakers

In terms of Oracle speakers, we’re spoiled this year with both Marc Weintraub and Julie Alonso presenting.

Marc Weintraub

Pretty much everyone should know Marc by now, and he’s always good value. He’s giving multiple sessions including a PeopleSoft Update, Modernising with Fluid, Fully Executing on Selective Adoption and PeopleSoft in the Cloud.

Julie Alonso

A new speaker to those who’ve only attended UK PeopleSoft events is Julie Alonso. She is Product Management Director within PeopleSoft HCM Strategy and the brains behind the monthly PeopleSoft HR Newsletter (if you don’t know what this is, either see Julie on the day or drop me a mail and I’ll link you up). Julie is presenting on The Power of PeopleSoft HCM.

It’s great that Oracle are supporting the event with two such speakers, and it’s wonderful to see a new face on the circuit.

Cedar Speakers

We’ve also got a couple of speakers from Cedar on the agenda.

Graham Smith

As with Marc, everyone should know Graham by now. He’s a rare blend of techie that’s been around PeopleSoft for long enough to know the history behind just about everything, but has such fantastic enthusiasm that he’s always trying the latest tools and techniques. Graham is talking about Selective Adoption and the Oracle Cloud.

Sarah Hurley

For those with excellent memories, Sarah has spoken at a PeopleSoft conference before (on a custom recruitment front-end that Cedar built for a client) however that was a few years back. Sarah has been busy managing some of Cedar’s PeopleSoft projects in the interim and is giving learnings from a Fluid implementation for a client – Fluid Development – Getting to Grips with a Different Skill Set.

Other Speakers

Check out the agenda for the full listings, but in addition to the above we’ve got Paul Smit from Oracle Netherlands, Malcolm Hewlett from Excel4Apps and Ken de Landro talking about Hays’ automated PeopleSoft testing investigations.

If the above sounds like the sort of content that would interest you – and there’s something there for pretty much everyone – it’d be great to see you there. Book here.


Al Nahdi Drives Growth and Insight with Oracle Retail Cloud Services

Oracle Press Releases - Wed, 2017-04-19 06:00
Press Release
Al Nahdi Drives Growth and Insight with Oracle Retail Cloud Services From Spreadsheets to Packaged Applications, Saudi Arabian Retailer Drives Increased Productivity

Redwood Shores, Calif.—Apr 19, 2017

Today Oracle announced Saudi Arabian pharmacies’ retailer Nahdi Medical Company deployed Oracle Retail Advanced Science Engine Cloud Service, Oracle Retail Merchandising Solutions, and Oracle Retail Category Management. Nahdi is considered the largest pharmacies’ chain in Middle East and North Africa. Its mission is to exceed the expectations of 85 million guests across 125 cities by providing personalized high-quality health, wellness and beauty products and services through its expertise and extended reach.

Nahdi manages a huge and growing assortment of SKUs across 170 categories throughout its stores. The volume of data forced Nahdi to adopt a scalable and smart planning solution. With the deployment of Oracle Retail, Nahdi gains the ability to segment customers, cluster stores and understand the effects of demand transference without having to recruit a full team of scientists with transaction-level data experience. Powerful scientific insights are delivered in a digestible format for the business user through personal-based dashboards. Prior to selecting Oracle, Nahdi planners spent time navigating a manual process using Excel spreadsheets and in-house databases. Today Nahdi is able to optimize the planning team’s productivity with standardized and automated planning processes. 

“The implementation of Oracle Retail increased the accuracy of planning and forecasting the merchandising figures. We are able to plan and execute better assortment of products across our stores to improve our guests’ satisfaction,” said Dr. Khalid Tadlaoui, Vice President of Information Technology, Nahdi Medical Company.

“The proliferation of data can be overwhelming, and it becomes increasingly important for retailers like Nahdi Medical Company to leverage and invest in solutions that understand how to drive insight through embedded science, business intelligence and analytics into solutions and processes,” said Ray Carlin, Senior Vice President and General Manager, Oracle Retail. “Oracle Retail is incredibly proud to provide this competitive advantage as cloud services, accelerating speed to market and driving productivity.”

Oracle PartnerNetwork Gold Level Partner Logic Information Systems accelerated a smooth cloud implementation and guided the customer through business process change. Logic developed a Retail Data Extractor to extract data correctly and cleanly from the installation of Oracle Retail Merchandising Systems for the cloud implementation. Logic delivered training programs to empower the business and technical teams. 

"It is a privilege to work with a retailer like Nahdi who is using science to leverage the performance and availability of each individual product to satisfy their guests and who also places an importance that their employees have access to critical planning information without wasted time sifting through Excel and manual processes,” said Amber Naqvi, President, Logic Information Systems.

Contact Info
Judi Palmer
Oracle (US)
650-784-7901
judi.palmer@oracle.com
Gaurav Bhatnagar
Oracle (Middle East)
+97143909094
gaurav.b.bhatnagar@oracle.com
About Oracle Retail

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

About Logic Information Systems

Since 1997, Logic has been the trusted systems integration partner to leading retailers around the world. With an exclusive focus on Oracle Retail, and a team of more than 750 expert consultants who bring a unique balance of real-world retail and IT experience, Logic is equipped to understand and deliver on a retailer’s business and technology goals. Working with Logic, retailers benefit from people, process, and technology solutions that increase efficiency, profitability and deliver a world-class experience for shoppers.

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

Judi Palmer

  • 650-784-7901

Gaurav Bhatnagar

  • +97143909094

Compress Basic Table

Tom Kyte - Tue, 2017-04-18 20:06
Tom, I need help. -If I create a table with COMPRESS BASIC on the partitions and then I insert data from another table does not decrease the size. -Now if I create a table from another with a: CREATE TABLE AS SELECT * FROM TABLE_2 And COMPRESS ...
Categories: DBA Blogs

Swap memory

Tom Kyte - Tue, 2017-04-18 20:06
Hi Team, In which case Oracle uses Swap memory. If we set Memory_target=10G parameter Oracle allocates SGA + PGA which that 10G only. Thanks & Regards Krishna.
Categories: DBA Blogs

Can I optimize the auto extend operation by changing the resizing value?

Tom Kyte - Tue, 2017-04-18 20:06
Hi, I'm using Oracle database 12.1.0.2.0 on Windows 64-bit The alert log is showing many "Resize operation completed for file#..." messages and the "Resource monitor" is showing I/O intensive usage. select * from DBA_DATA_FILES shows that the IN...
Categories: DBA Blogs

How to remove the duplicates records which are in two different columns of a single table.

Tom Kyte - Tue, 2017-04-18 20:06
I have table called "DUPLICTAE" which contains the below records. I need the below desired ouput... <code>COL1 | COL2 :----- | -----: banglore | chennai kolkata | pune chennai | mysore pune | banglore mysore | kolkata mumba...
Categories: DBA Blogs

Loading a file in External Table with a fields more than 4000 characters

Tom Kyte - Tue, 2017-04-18 20:06
Hi Tom, I have a file with the following structure: <code>+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+= 2017-03-01 16:17:08 : INFO : (65193 | WRIT...
Categories: DBA Blogs

Oracle Buys Moat

Oracle Press Releases - Tue, 2017-04-18 16:09
Press Release
Oracle Buys Moat Creates the World’s Most Comprehensive Cloud Platform for Marketing Data and Analytics

Redwood Shores, Calif.—Apr 18, 2017

Oracle today announced that it has signed an agreement to acquire Moat, the fastest-growing digital measurement cloud company. Moat will join Oracle Data Cloud, which uses data and analytics to enhance media for leading marketers and publishers. The combination of Oracle and Moat will connect data to consumer attention for better media experiences and business outcomes.

Moat will remain an independent platform within Oracle Data Cloud, providing trusted measurement, analytics, and intelligence to the world’s largest brands including Nestle, Procter & Gamble, and Unilever, and leading publishers such as ESPN, Facebook, NBCUniversal, Snapchat, and YouTube. Moat’s enterprise client base and industry-leading attention analytics and intelligence suite provide a strong complement to Oracle Data Cloud’s audience targeting and measurement solutions.

“I am thrilled to welcome CEO Jonah Goodhart and the entire Moat team to Oracle Data Cloud,” said Eric Roza, SVP and GM of Oracle Data Cloud. “Moat has grown its attention analytics business by over 100% in the past year, providing actionable insights around viewability, brand safety, non-human traffic, and ad creative to over 600 publisher, brand and agency clients. With the Moat acquisition, Oracle Data Cloud now offers brands and publishers a full suite of targeting and measurement solutions to improve the outcome of virtually every type of digital advertising campaign.”

“It is with great enthusiasm that we join forces with Oracle Data Cloud,” said Jonah Goodhart, CEO and Co-Founder of Moat. “When Oracle approached us about working together, we began to see the huge potential to jointly drive innovation. At our core, we believe there is an opportunity to fundamentally improve marketing and storytelling by brands and publishers through better data and analytics.”

More information about this announcement is available at www.oracle.com/moat.

Oracle is currently reviewing the existing Moat product roadmap and will be providing guidance to customers in accordance with Oracle’s standard product communication policies. Any resulting features and timing of release of such features as determined by Oracle’s review of Moat’s product roadmap are at the sole discretion of Oracle. All product roadmap information, whether communicated by Moat or by Oracle, does not represent a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. It is intended for information purposes only, and may not be incorporated into any contract.

Cautionary Statement Regarding Forward-Looking Statements
This document contains certain forward-looking statements about Oracle and Moat, including statements that involve risks and uncertainties concerning Oracle’s proposed acquisition of Moat, anticipated customer benefits and general business outlook. When used in this document, the words “anticipates”, “can”, “will”, “look forward to”, “expected” and similar expressions and any other statements that are not historical facts are intended to identify those assertions as forward-looking statements. Any such statement may be influenced by a variety of factors, many of which are beyond the control of Oracle or Moat, that could cause actual outcomes and results to be materially different from those projected, described, expressed or implied in this document due to a number of risks and uncertainties. Potential risks and uncertainties include, among others, the possibility that the transaction will not close or that the closing may be delayed, the anticipated synergies of the combined companies may not be achieved after closing, the combined operations may not be successfully integrated in a timely manner, if at all, general economic conditions in regions in which either company does business may deteriorate and/or Oracle or Moat may be adversely affected by other economic, business, and/or competitive factors. Accordingly, no assurances can be given that any of the events anticipated by the forward-looking statements will transpire or occur, or if any of them do so, what impact they will have on the results of operations or financial condition of Oracle or Moat. You are cautioned to not place undue reliance on forward-looking statements, which speak only as of the date of this document. Neither Oracle nor Moat is under any duty to update any of the information in this document.

Contact Info
Deborah Hellinger
Oracle Corporate Communications
+1.212.508.7935
deborah.hellinger@oracle.com
Ken Bond
Oracle Investor Relations
+1.650.607.0349
ken.bond@oracle.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

Deborah Hellinger

  • +1.212.508.7935

Ken Bond

  • +1.650.607.0349

April 2017 Critical Patch Update Released

Oracle Security Team - Tue, 2017-04-18 15:00

Oracle today released the April 2017 Critical Patch Update.

This Critical Patch Update provides fixes for a wide range of product families including: Oracle Database Server, Oracle Enterprise Manager Grid Control, Oracle E-Business Suite, Oracle Industry Applications, Oracle Fusion Middleware, Oracle Sun Products, Oracle Java SE, and Oracle MySQL.

Oracle recommends this Critical Patch Update be applied as soon as possible. A summary and analysis of this Critical Patch Update has been published on My Oracle Support (Doc ID 2252203.1)

For More Information:

The Critical Patch Update Advisory is located at http://www.oracle.com/technetwork/security-advisory/cpuapr2017-3236618.html

My Oracle Support Note 2220314.1 is located at https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2252203.1 (MOS account required).

How to make dashboard for Informix database

Nilesh Jethwa - Tue, 2017-04-18 14:25

Informix is a secure database, optimized for or OLTP, IoT and is forging new frontiers with its unique ability to seamlessly integrate SQL, NoSQL/JSON, time series and spatial data. Reliability, flexibility, ease of use, and low total cost of ownership makes Informix the best in class enterprise database available in the market.

Instant Visibility. A Informix dashboard visually summarizes all the important metrics you have selected to track, to give you a quick-and- easy overview of where everything stands. With real-time Informix SQL reporting reporting, it's a live view of exactly how your marketing campaign is performing.

  • Better Decision Making
  • Gain Competitive Advantage
  • Enhance Collaboration
  • Spotting potential problems
  • Merge with data from Excel Dashboards
  • Live SQL against database
  • No need for Data-warehouse or ETL
  • Leverage the speed and stability of your powerful database.

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

Getting Started with Oracle Developer Samples

Are you just joining Oracle's transformation journey to Cloud? Are you just getting used to working with the technology leader ? Having trouble getting started?  Oracle is developing,...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Oracle Warehouse Management Cloud Update Helps Businesses Scale Logistics to Meet Multi-Channel Demand

Oracle Press Releases - Tue, 2017-04-18 07:00
Press Release
Oracle Warehouse Management Cloud Update Helps Businesses Scale Logistics to Meet Multi-Channel Demand Momentum of Cloud WMS Solution Touted in Top Industry Analyst Reports

Redwood Shores, Calif.—Apr 18, 2017

Oracle today announced a new supply chain cloud functionality that helps businesses master challenging warehouse fulfillment issues in order to help outpace their competition. Version 8 of Oracle Warehouse Management Cloud (the former LogFire Warehouse Management System) has the latest functional user experience and integration enhancements that provide a comprehensive view of inventory from supplier to the distribution center (DC) to store shelves.

With Forrester research reporting that the total cloud market value is expected to top $236 billion dollars by 2020, and Transparency Market Research reporting the cloud WMS market is expected to expand from $1.2 billion in 2015 to $4.1 billion by 2024, Oracle is well-positioned to help companies on their journey to adopt SCM cloud solutions.

With Version 8, Oracle continues to lead the industry in modernizing application release cycles by leveraging 100 percent cloud architecture to offer access to frequent solution improvements similar to the easy updates with leading consumer applications.

“LogFire has conclusively proven the viability and compelling value proposition of their cloud-based WMS. The Oracle WMS Cloud is a no-compromise solution built from day one for the cloud. It enables companies to thrive in today’s dynamic, interconnected, omni-channel fulfillment economy,” said Jon Chorley, CSO & group vice president, SCM product strategy at Oracle. “Version 8 continues our dedication to providing customers with the very latest logistics execution capabilities, which now also gives them the ability to leverage other compelling cloud solutions from Oracle.”

Oracle Warehouse Management Cloud recently garnered attention for their offering in two different industry analyst reports. Both reports lauded Oracle’s position and commented on increased cloud WMS adoption across industries. The first is the IDC research on WMS in the Cloud and second is the 2017 Gartner Magic Quadrant for Warehouse Management Systems, which placed Oracle in the Leaders Quadrant.

Chorley continued, “We believe that 2017 is the year cloud computing in Warehouse Management Systems will go mainstream. Our positioning in the Gartner and IDC reports affirms that businesses are comfortable transitioning their fulfillment operations to the cloud. We’re taking every opportunity to introduce the value of the cloud to our customers to help them grow their businesses.”

At Oracle’s recent major supply chain conference—the Modern Supply Chain Experience in San Jose, California – Oracle users saw this technology first hand. Customers packed into sessions in order to learn more about the future of their industry and how the cloud will be transforming everything from sourcing and manufacturing to transportation, warehousing, and even store shelves.

For more information, please see the Gartner Magic Quadrant1 and IDC’s WMS in the Cloud report2.

For additional information on Oracle Supply Chain Management (SCM) Cloud, visit Facebook, Twitter or the Oracle SCM blog.

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

1. Gartner, “2017 Magic Quadrant for Warehouse Management Systems,” by C. Dwight Klappich, Simon Tunstall, February 13, 2017. Oracle has acquired distribution rights for this report, expiration March 2018.
2. IDC, “WMS in the Cloud,” by John Santagate, January 2017. Oracle has acquired distribution rights for this report, expiration March 2018.

Contact Info
Joann Wardrip
Oracle
+1.650.607.1343
joann.wardrip@oracle.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

Joann Wardrip

  • +1.650.607.1343

Getting Started with Oracle Developer Samples

Are you just joining Oracle's transformation journey to Cloud? Are you just getting used to working with the technology leader ? Having trouble getting started?  Oracle is developing,...

We share our skills to maximize your revenue!
Categories: DBA Blogs

3 Ways to Make Paperwork Less Difficult

WebCenter Team - Tue, 2017-04-18 06:54

Authored by: Sarah Gabot, Partner Marketing Manager, HelloSign

Let’s face it--paperwork, regardless of whether it’s on paper or in the cloud, is no fun. It still takes time and effort to prepare, and if you’re getting it signed, you’re often sitting waiting for the document to return. 

Believe it or not, you can make the paperwork even simpler with the help of an eSignature tool. 

We’ve listed out three ways you can make paperwork less painful. You can immediately begin applying these to the HelloSign for Oracle Content and Experience Cloud integration today. 

Avoid manually reviewing documents with data validation 
Human error happens. People accidentally input the wrong information or have typos when filling out forms. That’s why HelloSign created data validation

Data validation is a feature that prevents users from entering incorrect information. For example, if you require the user to type in his or her social security number, you know that only nine numbers are acceptable. No letters. Exactly nine numbers. 

Using this feature, when the documents return, there will be fewer errors to comb through and less back and forth between you and the signer. 

Increase signer completion rates with mobile-friendly signing
Nearly everybody has a smartphone these days. Being able to handle tasks on-the-go on a smartphone has become a requirement for most people. Signing documents is no exception. 

HelloSign’s signing experience is mobile-friendly. Instead of having to pinch on a small screen, the signer experience is intuitive with responsive pages. There’s also progress tracking that shows how many total (and remaining) required fields are left. 

A more mobile-friendly experience means that your signers are more inclined to complete the document faster. 

Save time by auto-filling documents. 
For certain documents, there are fields that you, the document preparer, can pre-fill. For example, if you have a templated document like an offer letter, you can pre-fill fields in the document (eg. job title, salary number) in HelloSign for Oracle CEC. 

It’s a quick way for you to prepare standardized documents without having to recreate it every time. 

Try it out yourself! 
See for yourself how you can simplify paperwork flows using Oracle Content and Experience Cloud and HelloSign. To learn how to get started, email our sales team at oracle-sales@hellosign.com or speak to your Oracle Account rep.

3 Ways to Make Paperwork Less Difficult

WebCenter Team - Tue, 2017-04-18 06:54

Authored by: Sarah Gabot, Partner Marketing Manager, HelloSign

Let’s face it--paperwork, regardless of whether it’s on paper or in the cloud, is no fun. It still takes time and effort to prepare, and if you’re getting it signed, you’re often sitting waiting for the document to return. 

Believe it or not, you can make the paperwork even simpler with the help of an eSignature tool. 

We’ve listed out three ways you can make paperwork less painful. You can immediately begin applying these to the HelloSign for Oracle Content and Experience Cloud integration today. 

Avoid manually reviewing documents with data validation 
Human error happens. People accidentally input the wrong information or have typos when filling out forms. That’s why HelloSign created data validation

Data validation is a feature that prevents users from entering incorrect information. For example, if you require the user to type in his or her social security number, you know that only nine numbers are acceptable. No letters. Exactly nine numbers. 

Using this feature, when the documents return, there will be fewer errors to comb through and less back and forth between you and the signer. 

Increase signer completion rates with mobile-friendly signing
Nearly everybody has a smartphone these days. Being able to handle tasks on-the-go on a smartphone has become a requirement for most people. Signing documents is no exception. 

HelloSign’s signing experience is mobile-friendly. Instead of having to pinch on a small screen, the signer experience is intuitive with responsive pages. There’s also progress tracking that shows how many total (and remaining) required fields are left. 

A more mobile-friendly experience means that your signers are more inclined to complete the document faster. 

Save time by auto-filling documents. 
For certain documents, there are fields that you, the document preparer, can pre-fill. For example, if you have a templated document like an offer letter, you can pre-fill fields in the document (eg. job title, salary number) in HelloSign for Oracle CEC. 

It’s a quick way for you to prepare standardized documents without having to recreate it every time. 

Try it out yourself! 
See for yourself how you can simplify paperwork flows using Oracle Content and Experience Cloud and HelloSign. To learn how to get started, email our sales team at oracle-sales@hellosign.com or speak to your Oracle Account rep.

OGG: Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2

Yann Neuhaus - Tue, 2017-04-18 06:20

Another GoldenGate 12.2 one: Some days ago I had this in the GoldenGate error log:

2017-04-12 14:56:08  WARNING OGG-02901  Oracle GoldenGate Capture for Oracle, extimch.prm:  Replication of UDT and ANYDATA from redo logs is not supported with the Oracle compatible parameter setting. Using fetch instead.
2017-04-12 14:56:08  ERROR   OGG-02912  Oracle GoldenGate Capture for Oracle, extimch.prm:  Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later.

Seemed pretty obvious that I was missing a patch.

Headed over to mos and searched for the patch mentioned:

ogg_17030189

Hm, only two hits and I was neither on Exadata nor on the 12.1.0.1 database release. After digging around a bit more in various mos notes there was one (Doc ID 2091679.1) which finally mentioned a workaround. When you install GoldenGate 12.2 you get a script by default in the GoldenGate Home which is called “prvtlmpg.plb”. Looking at the script:

oracle@xxxxx:/u01/app/ogg/ch_src/product/12.2.0.1.160823/ [xxxxx] ls prvtlmpg.plb
prvtlmpg.plb
oracle@xxxxx:/u01/app/ogg/ch_src/product/12.2.0.1.160823/ [xxxxx] strings prvtlmpg.plb
WHENEVER SQLERROR EXIT
set verify off 
set feedback off
set echo off
set serveroutput on
column quotedMiningUser new_value quotedMiningUser noprint
column quotedCurrentSchema new_value quotedCurrentSchema noprint
variable status number
prompt
prompt Oracle GoldenGate Workaround prvtlmpg
prompt
prompt This script provides a temporary workaround for bug 17030189.
prompt It is strongly recommended that you apply the official Oracle 
prompt Patch for bug 17030189 from My Oracle Support instead of using
prompt this workaround.
prompt
prompt This script must be executed in the mining database of Integrated
prompt Capture. You will be prompted for the username of the mining user.
prompt Use a double quoted identifier if the username is case sensitive
prompt or contains special characters. In a CDB environment, this script
prompt must be executed from the CDB$ROOT container and the mining user
prompt must be a common user.
prompt
prompt ===========================  WARNING  ==========================
prompt You MUST stop all Integrated Captures that belong to this mining
prompt user before proceeding!
prompt ================================================================

Really? You get a script to workaround a known issue by default? Lets try:

SQL> @prvtlmpg.plb

Oracle GoldenGate Workaround prvtlmpg

This script provides a temporary workaround for bug 17030189.
It is strongly recommended that you apply the official Oracle
Patch for bug 17030189 from My Oracle Support instead of using
this workaround.

This script must be executed in the mining database of Integrated
Capture. You will be prompted for the username of the mining user.
Use a double quoted identifier if the username is case sensitive
or contains special characters. In a CDB environment, this script
must be executed from the CDB$ROOT container and the mining user
must be a common user.

===========================  WARNING  ==========================
You MUST stop all Integrated Captures that belong to this mining
user before proceeding!
================================================================

Enter Integrated Capture mining user: GGADMIN

Installing workaround...                                                                                         
No errors.                                                                                                       
No errors.
No errors.                                                                                                       
Installation completed.                                                                                          
SQL>                                                                                                             

And finally the extract started fine. Interesting … There seems to be a patch for 11.2.0.4.7DBPSU in development but nothing else for the moment. Even the latest PSU for 11.2.0.4 seems not to include the patch.

 

Cet article OGG: Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 est apparu en premier sur Blog dbi services.

Oracle Audit Trail Add Program Name

The program name attribute (V$SESSION.PROGRAM) is not by default passed to Oracle’s audit logs. It can be optionally included. To do so, apply Patch 7023214 on the source database. After the patch is applied, the following event needs to be set:

ALTER SYSTEM SET
           EVENT='28058 trace name context forever'
           COMMENT='enable program logging in audit trail' SCOPE=SPFILE;

The table below summarizes key session attributres (V$SESSION) the are passed/not passed to Oracle auditing

Oracle Audit Trails

Session Attribute

(V$SESSION)

Description

Traditional Auditing (SYS.AUD$)

Fine Grained Auditing (SYS.FGA_LOG$)

CLIENT_IDENTIFIER

End user username

CLIENTID

CLIENTID

CLIENT_INFO

Concatenated application log string

Not passed

Not passed

MODULE

ABAP program, module, application component or service

Not passed

Not passed

ACTION

Business action being executed, page, code event, location within program

Not passed

Not passed

 

If you have questions, please contact us at info@integrigy.com

-Michael Miller, CISSP-ISSMP

Reference
 
 
 
Auditing, Oracle Database, Oracle Audit Vault
Categories: APPS Blogs, Security Blogs

Down the performance of single table using Various DML Operation.

Tom Kyte - Tue, 2017-04-18 01:46
Suppose I have a table that's called account_detail of customer account detail. And This table contain 100,000,000 Rows. suppose we fire select query on this table and at a same time may or may not be insert or update or delete record fire by staff...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator