Feed aggregator

Twitter Chat Reveals – Is headless CMS signaling the end of WCM?

WebCenter Team - Tue, 2017-04-25 14:18

Last week, on April 20, @oraclewebcenter hosted a live Twitter Chat at #contentdgtl. The topic – Is headless CMS signaling the end of WCM?

Decoupled CMS architecture (aka “headless”) is rising in popularity in the development world. This model allows breakthrough user experiences, gives developers great flexibility to innovate, and helps site owners future-proof their builds by allowing them to refresh the design without re-implementing the whole CMS. With all this upside, it’s no wonder this type of build has gained serious traction.

With that in mind, the live Twitter discussion focused on the topic of headless CMS and whether companies need to be thinking about it. The Twitter Chat explored headless CMS vs. WCM and use cases of when it makes sense to use one or the other. Industry thought leaders including Melissa Webster from IDC, Dave Gray from Xplaner.com, numerous partners and more participated in this very engaging discussion. The interaction ranged from the benefits of headless CMS to both the developer and business, to things to watch for with headless CMS and ended with best practice recommendations for content production, management & delivery in a cloud world.

From serious musings to light hearted commentary (including this pic that Tanu Sood shared), the Twitter Chat proved to be a great meeting of minds.

Even if you participated, you may have missed portions of the live discussion so we have curated the chat here; it might be worth going back and following the discussion.

One of my personal favorites was a tweet from Carlos Picazo (@carlines) that said "in a few years, we will have even more connected than today and content is key, Internet of People!"

Catch the recap of the Twitter Chat and while you still can, feel free to search for the complete thread by searching on “#contentdgtl” on Twitter.

Archive: Is headless CMS signaling the end of WCM?

Picture Courtesy: https://t.co/jb7JDERk9i

Oracle Helps Transform Lead Generation with LinkedIn Matched Audiences

Oracle Press Releases - Tue, 2017-04-25 12:30
Press Release
Oracle Helps Transform Lead Generation with LinkedIn Matched Audiences Product integration between Oracle Marketing Cloud and LinkedIn Campaign Manager enables marketers to generate high-quality leads at scale, increase conversion rates and accelerate sales.

Modern Customer Experience 2017, Las Vegas —Apr 25, 2017

To help marketers generate high-quality leads at scale and maximize the ROI of lead generation campaigns, Oracle today announced a new product integration between Oracle Marketing Cloud and LinkedIn Campaign Manager - a new targeting capability within LinkedIn’s recently announced product, Matched Audiences. This new product integration enables Oracle Marketing Cloud customers to seamlessly integrate data from more than 467 million LinkedIn users into existing marketing campaigns to reach and engage their ideal buyers on the world’s largest professional social network.

Marketers need to be able to deliver personalized experiences at scale in order to increase conversion rates and accelerate sales. With the new product integration between Oracle Eloqua, part of the Oracle Marketing Cloud, and LinkedIn Campaign Manager, marketers now have the power to seamlessly nurture leads using LinkedIn Matched Audiences. The product integration enables marketers to personalize and orchestrate campaigns across multiple channels including email, websites and digital ads in order to engage the right audience at the right time in the buyer’s journey.

“At LinkedIn, we strive to equip B2B marketers with the tools and insights that they need to reach the audiences that matter most to their business,” said Russ Glass, vice president of product, LinkedIn Marketing Solutions. “Matched Audiences gets us closer to that goal by enabling us to give marketers custom ways to combine LinkedIn’s powerful professional data with their own first-party data. Our product integration with Oracle was key to helping make that happen for Oracle Eloqua customers.”

This integration also empowers marketers to enhance their Account Based Marketing (ABM) strategies. Marketers can leverage the powerful insights delivered by the new integration to help convert unknown prospects into known buyers, retarget buyers with relevant digital ads, and enrich buyer profiles and optimize digital ad spend on LinkedIn. This enables marketers to increase conversion rates and accelerate sales.

“We are focused on empowering marketers with the data they need to inform, measure and maximize the impact of marketing campaigns,” said Laura Ipsen, general manager and senior vice president, Oracle Marketing Cloud. “LinkedIn is the world’s largest professional network and by enabling marketers to seamlessly integrate data from more than 467 million LinkedIn users we are able to provide powerful customer insights that can transform lead generation campaigns. The new product integration between Oracle Eloqua and LinkedIn Campaign Manager can ultimately help marketers enhance the customer experience and increase revenues.” 

Oracle Marketing Cloud is part of Oracle CX Cloud Suite. 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 Commerce Cloud, Oracle Marketing Cloud, Oracle Sales Cloud and Oracle Service 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

Blue Microphones Turns Up the Volume with NetSuite

Oracle Press Releases - Tue, 2017-04-25 12:30
Press Release
Blue Microphones Turns Up the Volume with NetSuite Microphone Maker Gains Vital Business Agility for Innovation and Growth

SUITEWORLD 2017, LAS VEGAS, Nev.—Apr 25, 2017

Oracle NetSuite Global Business Unit (GBU), the industry’s leading provider of cloud financials / ERP, HR and omnichannel commerce software suites, today announced that Blue Microphones (www.bluemic.com), a leading designer and producer of premium microphones and sound recording equipment for audio professionals, musicians and consumers, has gained vital business agility with NetSuite’s unified cloud business management system. NetSuite allows Blue Microphones to focus on product innovation, scale into new markets, and challenge larger rivals in the competitive recording industry. To ensure agility for innovation and growth, the company replaced QuickBooks Enterprise with NetSuite to manage its end-to-end business operations including financials, fixed assets, demand planning, inventory management, bill of materials, work orders and assemblies, warehouse management, CRM, HR, and multi-currency transactions in the Canadian dollar and Euro. After a rapid three-month implementation, the company went live on NetSuite in July 2014.

Headquartered in Westlake, Calif., Blue Microphones was founded in 1995 by an American jazz musician and a recording engineer who designed high-quality studio microphones and pioneered the digital USB microphone – microphones that plug directly into a computer. Beginning in 2004, the company saw significant growth thanks to its Snowball, a USB mic built for use with Apple’s GarageBand recording software, and continued to develop a range of USB mics made vastly successful by the explosion of user generated content. Since then, Blue Microphones has continued to design and manufacture a full range of studio microphones, the world’s #1 USB mic line, and recently launched a lineup of premium headphones.

With 30 to 35 percent annual growth, the company was quickly realizing it needed new functionality its existing system couldn’t provide, including: multicurrency transactions; anywhere, anytime access to business data across the globe; integration with marketing and engineering systems for better collaboration; and integration to its shipping software.

“Replacing our entry-level accounting system with a unified cloud-based business management suite has made a huge difference in our business and has us well positioned for our next stage of growth,” said Bart Thielen, CFO and COO of Blue Microphones. “With NetSuite, we’re able to scale the business very quickly and our visibility is tremendously improved. We now have strong financial controls and a solid infrastructure with great agility to respond rapidly to changing market conditions.”

Leveraging the NetSuite SuiteCloud Development Platform, Blue Microphones was able to customize the NetSuite system to meet its business needs and industry specific requirements. The company was also able to integrate the Pacejet Enterprise Shipping Software with NetSuite seamlessly, allowing it to better manage millions of freight quotes and shipments with reduced costs and improved efficiency. Bidirectional EDI interface powered by the NetSuite SuiteCloud Development Platform enables Electronic Data Interchange to 15 different partners including large retailers like Best Buy, Apple and Amazon; which saves Blue Microphones up to 30 to 40 hours a week of manual order entry and invoicing and enables near 100 percent accuracy.

Blue Microphones’ IT modernization efforts have also attracted the notice of others. Most recently, the company was awarded the prestigious 2016 Manufacturing Leadership (ML) Award in the “Enterprise Leadership" category from Frost and Sullivan’s ML Council. The awards are given to companies and individuals that have undertaken breakthrough projects in manufacturing as determined by an expert panel of judges. Blue Microphones was recognized for its "IT Modernization Project,” which allowed the company to rapidly scale, while giving it the agility to adapt to changing market conditions.

As a result of its implementation of NetSuite, Blue Microphones has realized multiple benefits, including:

  • Improved IT and operational efficiency. As a pure cloud system, NetSuite spares Blue Microphones from the hassles of managing on-premise software and the hardware required to support it, including patches, upgrades and security. As a result of efficiencies gained, Blue Microphones can attribute avoiding the costs of hiring two full-time employees by converting to NetSuite, an annual savings of $80,000.
  • Improved inventory management. Third-party logistics partners in Amsterdam and Hong Kong are now able to access NetSuite through a portal to fulfill orders, improving accuracy and efficiency. Previously, Blue Microphones would scan documents and email them over as PDFs, a labor intensive, error-prone process. Additionally, the company has been able to setup a virtual warehouse for its marketing group, which sequesters key products for product reviews and key influencers like artists and producers.
  • Product improvements. Blue Microphones is now capturing customer feedback in the system, which can be shared directly with engineering and overseas manufacturers to improve the products.
  • Reduced manual entry. Workflow and scripting has saved up to 15 hours a month of manual entry for the sales department.
  • A flexible and powerful development platform. NetSuite’s SuiteCloud Development Platform provides flexibility for Blue Microphones to tailor the system and integrate with other third-party solutions to meet its unique business needs and industry-specific requirements.
  • Improved asset tracking. A new fixed assets interface saves significant time at both monthly and year-end audits. During the course of a year, the company estimates it is saving about 50 hours total.
About Oracle NetSuite Global Business Unit

Oracle NetSuite Global Business Unit pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, Oracle NetSuite Global Business Unit provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit www.netsuite.com.

Follow Oracle NetSuite Global Business Unit’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

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. 

Pods Turns to NetSuite SuiteSuccess to Fuel Its Global Operation

Oracle Press Releases - Tue, 2017-04-25 12:15
Press Release
Pods Turns to NetSuite SuiteSuccess to Fuel Its Global Operation SuiteSuccess Engineers Customer Success – Readies PODS for Rapid Global Expansion

LAS VEGAS, Nev. —Apr 25, 2017

Oracle NetSuite Global Business Unit (GBU), the industry's leading provider of cloud financials / ERP, HR and omnichannel commerce software suites, today announced that PODS Enterprises, LLC, the leading provider of portable container-based moving and storage solutions, chose NetSuite SuiteSuccess to support its business expansion. PODS will be using NetSuite to manage mission-critical business processes including financials, inventory management, multi-subsidiary management for 16 subsidiaries and multi-currency management for the U.S., Canadian and Australian dollars. SuiteSuccess is the culmination of a multi-year transformation effort to combine the NetSuite unified suite, 20 years of industry leading practices, a new customer engagement model, and business optimization methods into a unified, industry cloud solution. SuiteSuccess is NetSuite’s new purpose-built, unified cloud solution tailored for each industry. 

“I was amazed how closely NetSuite worked with us to ensure we had good process alignment with the fewest possible gaps,” said Bill Tingle, CIO of PODS. “We need to get a system up and running quickly to meet our strategic objectives and SuiteSuccess seems to fit the bill perfectly.”

PODS transformed the moving business when it invented the concept of portable storage in 1998 and now counts a network of more than 170,000 PODS storage containers and 230 PODS Storage Centers in North America alone. In 2016, leadership reevaluated the business and IT strategy and determined the need to move onto a new software platform to support the company’s growth and development plans moving forward. After a rigorous evaluation process, PODS selected NetSuite OneWorld for its flexible platform, strong partner ecosystem and its commitment to customer success.

“Before we had even made the decision to purchase NetSuite, they had a detailed engagement plan with very specific steps on how we would implement the solution,” said Tingle. “We felt comfortable knowing we wouldn’t be starting from scratch and would have a robust solution with NetSuite’s years of experience baked into the product.”

PODS is using SuiteSuccess to ensure a successful deployment of NetSuite OneWorld across its 16 subsidiaries and a complex franchise model with 230 PODS Storage Centers. NetSuite OneWorld will give PODS a flexible, scalable system for growth. With support for 190 currencies, 20 languages, automated tax compliance in more than 100 countries, and transactions in more than 200 countries.

SuiteSuccess was engineered to solve unique industry challenges that historically have limited a company’s ability to grow, scale and adapt to change. Most ERP vendors have tried to solve the industry solution problem with templates, rapid implementation methodologies, and custom code. NetSuite took a holistic approach to the problem and productized domain knowledge, leading practices, KPI’s, and an agile approach to product adoption. The benefits of this are faster time to value, increased business efficiency, flexibility, and greater customer success.

For more information about SuiteSuccess, please visit:  http://www.netsuite.com/portal/services/suitesuccess.shtml

Other expected features and benefits include:

  • Rapid deployment. Backed by SuiteSuccess, PODS expects to launch NetSuite OneWorld in less than three months, a huge difference from its experience with the previous system that took nearly four years.
  • A powerful development platform. The SuiteCloud development platform provides unprecedented flexibility that enables businesses to tailor the system to meet their unique requirements and industry-specific needs.
  • A robust partner ecosystem. NetSuite’s wide array of partner solutions will allow PODS to extend NetSuite to meet its current and future business needs. PODS plans to leverage NetSuite’s comprehensive partner ecosystem for solutions in warehouse management, Electronic Data Interchange (EDI) integration and financial planning.
  • Centralized order and inventory management. NetSuite OneWorld can provide real-time inventory visibility across the business for better forecasting and optimization of more than 170,000 PODS containers moving throughout North America.
  • Built-in business intelligence. With NetSuite OneWorld, PODS will have real-time insights into key business performance indicators for a unified view of the organization and a single version of truth.
  • A highly scalable system for growth. NetSuite’s scalable infrastructure will enable PODS to easily expand to support growing business volumes.

Bill Tingle is sharing PODS’ story at SuiteWorld 2017, the number one cloud ERP event of the year, this year being held in Las Vegas from April 24-27. Watch all keynotes live here.

About PODS Enterprises, LLC
PODS® is a leader in the moving and storage industry providing both residential and commercial services in 46 U.S. states, Canada, Australia and the UK. Founded in 1998, PODS pioneered the portable moving and storage industry now preferred by many customers’ increasingly active and mobile lifestyles. To date, the PODS network has completed more than 700,000 long-distance moves, exceeded 3 million deliveries and has more than 170,000 PODS containers in service.

About Oracle NetSuite Global Business Unit  
Oracle NetSuite Global Business Unit pioneered the Cloud Computing revolution in 1998, establishing the world's first company dedicated to delivering business applications over the internet. Today, Oracle NetSuite Global Business Unit provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit www.netsuite.com.
 

Follow Oracle NetSuite Global Business Unit's Cloud blogFacebook page and @NetSuite Twitter handle for real-time updates.

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.

Smartsheet Realizes the Power of Unified Billing and Revenue Recognition with NetSuite

Oracle Press Releases - Tue, 2017-04-25 12:00
Press Release
Smartsheet Realizes the Power of Unified Billing and Revenue Recognition with NetSuite Enterprise Collaboration Software Leader Can Easily Adapt to Market Changes, New Business Models and New Revenue Recognition Standards

SUITEWORLD 2017, LAS VEGAS, Nev.—Apr 25, 2017

Oracle NetSuite Global Business Unit (GBU), the industry's leading provider of cloud financials / ERP, HR and omnichannel commerce software suites, today announced that Smartsheet, a leading provider of SaaS-based solutions for managing and automating collaborative work, has implemented NetSuite OneWorld to manage rapid growth. Smartsheet is leveraging NetSuite OneWorld to manage mission critical business processes including financials, billing, revenue recognition, analytics and multi-currency transactions in the Euro, yen, Pound and US, Australian and Canadian dollars. With NetSuite OneWorld, Smartsheet has a platform that is ready for next and provides the foundation to scale the business. As Smartsheet has evolved its business model, NetSuite’s SuiteBilling software is helping the company to manage recurring revenue processes from order to billing and revenue recognition with complete control and auditability for its software subscription business.

“Using a hairball of multiple point products, whether on-premise or in the cloud, is always a bad idea. But doing it in your financial system is downright reckless,” said Jason Maynard, SVP of Strategy and Marketing, NetSuite. “Smartsheet is an innovator in collaboration software and knew how to leverage NetSuite innovation to fuel their growth.”

Founded 11 years ago in Bellevue, Wash., Smartsheet began selling collaboration software for individuals and small teams but has grown rapidly as it began selling its product into large enterprises, including 50 percent of the Fortune 500, to help solve large, complex work management and project automation challenges. It has achieved more than 70 percent year-over-year revenue growth for the fifth consecutive year and currently serves more than 68,000 companies and 10 million users across 190 countries. Smartsheet’s prior accounting system couldn’t handle that growth, requiring extensive manual workarounds that were cumbersome and inefficient, including the physical entry of every invoice. Smartsheet knew that it needed a new platform that could manage all its critical business processes in one system while also providing the flexibility to scale rapidly with the company’s growth. After a rigorous evaluation of several applications, Smartsheet chose NetSuite OneWorld for its scalability, revenue recognition and international capabilities.

A key factor in Smartsheet’s decision was SuiteBilling, the industry’s first unified cloud-based order-to-billing-to revenue recognition solution. SuiteBilling enables businesses to adopt any business model from product-based, time- and services-based, through to usage- and subscription-based, or any combination of these without limit. In the future, Smartsheet plans to manage subscriptions for its enterprise customers while providing a self-service model for its smaller customers allowing them to sign up for a trial, pay with a credit card and establish a recurring billing account all from a single system.

“We needed a solution that could support significant growth in our primary segments—enterprise customers as well as SMBs where we leverage a self-service model—each of which has its own unique set of complexities,” said Mark Mader, Smartsheet CEO. “NetSuite was the only solution that offered us the ability to automate both the back office and customer-facing aspects across both these important segments of our business.”

After a four-month implementation, Smartsheet deployed NetSuite OneWorld, which supports 190 currencies, 20 languages, automated tax calculation and reporting in more than 100 countries, and support for customer transactions in more than 190 countries. NetSuite OneWorld supports Smartsheet’s growth by providing:

  • Scalability for growth. NetSuite OneWorld’s single cloud solution allows Smartsheet to quickly and easily; add functionality as the business evolves; quickly add offices as it expands with anywhere, anytime access.
  • Single source of truth. NetSuite’s unified billing and advanced revenue management system, synchronizes complex processes from order to billing to revenue recognition.
  • Real-time visibility. NetSuite OneWorld’s unified platform gives Smartsheet visibility across its operations with one single unified financial system of record, providing users with real-time information right at their fingertips.
  • Improved efficiency. NetSuite has automated numerous processes previously done manually, including processing of thousands of renewals at a time, saving significant time in order entry.
  • Robust customization and integration. NetSuite's SuiteCloud Developer Network (SDN) provides a platform for Smartsheet to customize the system to its specific needs and adapt as its business evolves. Customized business rule logic improves data quality while a planned integration with Salesforce.com will fully automate the quote-to-cash process for sales floor led deals.


Mark Mader will be sharing Smartsheet’s story at SuiteWorld 2017, the number one cloud ERP event of the year, this year being held in Las Vegas from April 24-27. Watch him and all other SuiteWorld 2017 keynotes live here.

About Oracle NetSuite Global Business Unit

Oracle NetSuite Global Business Unit pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, Oracle NetSuite Global Business Unit provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit www.netsuite.com.

Follow Oracle NetSuite Global Business Unit’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

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. 

Ring Dials NetSuite to Fuel Growth

Oracle Press Releases - Tue, 2017-04-25 11:45
Press Release
Ring Dials NetSuite to Fuel Growth Outdoor Home Security Innovator Leverages NetSuite to Scale Global Business Operations

SUITEWORLD 2017, LAS VEGAS, Nev.—Apr 25, 2017

Oracle NetSuite Global Business Unit (GBU), the industry's leading provider of cloud financials / ERP, HR and omnichannel commerce software suites, today announced that Ring, a leader in outdoor home security, has implemented NetSuite to fuel its rapid growth, which took it from startup to 1,000 team members in less than three years. Ring is using NetSuite for financial management and reporting with plans to significantly extend the NetSuite platform to other areas of the business as it continues to extend its business model beyond doorbells, to services and subscriptions. With NetSuite, Ring has gained efficiencies and real-time visibility with a unified platform that is next ready. NetSuite enables Ring to grow, scale and adapt its business model as Ring’s business expands and evolves.

With a mission to reduce crime in neighborhoods, Ring has revolutionized outdoor home security by building smart doorbells and outdoor cameras designed to proactively monitor your home. Initially founded as DoorBot, Ring got a significant boost when CEO and Chief Inventor Jamie Siminoff appeared on ABC’s “Shark Tank” with the smart doorbell in September 2013. It has since expanded its product line and is building a “Ring of Security” around your home with data services and digital neighborhood watches. Additionally, Ring has received $209 million in investment, reached over 1,000,000 users and has expanded its footprint in retail and is now available in over 15,000 stores globally. Initially, Ring relied on an outsourced accounting firm for basic general ledger and journal entries, to manage its financial processes with reporting done in Excel and online spreadsheets. Understanding that the company’s growth trajectory demanded more comprehensive solution, Ring evaluated several software packages on the market including Microsoft Dynamics, before selecting NetSuite.

“When you grow as fast as we’ve grown, one of the biggest challenges is breaking older systems and having to move to new things,” said Siminoff. “NetSuite gives us a platform that allows us to grow from zero to infinity. It takes away those concerns and means resources can be directed to sales and business development.”

“We are honored to partner with a mission-driven business like Ring as they transform communities and help make neighborhoods safer,” said Jason Maynard, SVP of Strategy and Marketing, Oracle NetSuite GBU. “Empowering entrepreneurial companies to scale and achieve their vision is NetSuite’s purpose.”

While still a young and fast-growing business, Ring has complex needs including a B2C website and B2B relationships with retailers like Costco, Best Buy and Home Depot. Ring is confident that the advanced revenue recognition features in NetSuite can allow it to sell, bill and recognize its revenue as it continues to transform its business and meet the needs of the modern customer. With NetSuite, Ring has streamlined financial processes and gained operational efficiency with a roadmap for future growth.

Since implementing NetSuite, Ring has gained the following benefits:

  • A flexible and agile platform. The NetSuite SuiteCloud Platform easily enables the company to customize NetSuite to meets its current and future business requirements and to integrate with other third-party solutions.
  • Real-time visibility. One single, unified financial system of record and financial reporting across the entire organization has created efficiencies by automating cumbersome manual processes.
  • Significant savings in IT costs and complexity. NetSuite's proven, securely featured cloud solution eliminates the hassles of managing, maintaining and upgrading business applications and offers significant time and cost savings.
  • Anytime, anywhere access. For a company built around accessing a video doorbell from a smartphone, NetSuite’s mobile capabilities enable staff to access the system anywhere there is an internet connection.
  • Scalability for growth. With plans to extend the NetSuite platform to adopt advanced revenue recognition, CRM and ecommerce, plus inventory management for its warehouse and fulfillment for its retail partners, Ring can continue to grow and adapt its business on a single platform.

Jamie Siminoff will be sharing Ring’s story at SuiteWorld 2017, the number one cloud ERP event of the year, this year being held in Las Vegas from April 24-27. Watch him and all SuiteWorld 2017 keynotes live here.

About Ring

Ring's mission is to reduce crime in neighborhoods and empower consumers by creating a Ring of Security around homes and communities with its suite of smart home security products: Ring Video Doorbell, Ring Video Doorbell Pro (HomeKit-enabled), Ring Stick Up Cam and the new Ring Floodlight Cam. With these security devices, Ring has created the neighborhood watch for the digital age and continues to keep homes around the world safe. For more information, visit www.ring.com. With Ring, you’re always home. To learn more, please visit https://ring.com.

About Oracle NetSuite Global Business Unit

Oracle NetSuite Global Business Unit pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, Oracle NetSuite Global Business Unit provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit www.netsuite.com.

Follow Oracle NetSuite Global Business Unit’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

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. 

NetSuite Announces SuiteSuccess: The First Unified Industry Cloud Solution

Oracle Press Releases - Tue, 2017-04-25 11:30
Press Release
NetSuite Announces SuiteSuccess: The First Unified Industry Cloud Solution SuiteSuccess Transforms the Way NetSuite Builds, Sells, Delivers and Supports Industry Solutions
SuiteSuccess Empowers Customers to Be Ready for What’s Next

SUITEWORLD 2017, LAS VEGAS, Nev.—Apr 25, 2017

Oracle NetSuite Global Business Unit, the world’s leading provider of cloud-based financials / ERP, HR and omnichannel commerce software suites, today announced SuiteSuccess, the first unified industry cloud solution. NetSuite has delivered 12 SuiteSuccess editions for the following eight industries:

  • Advertising, media, publishing
  • Financial technology
  • Manufacturing
  • Nonprofit
  • Retail
  • Service-based businesses
  • Software/internet
  • Wholesale distribution

SuiteSuccess is the culmination of a multi-year transformation effort to combine the NetSuite unified suite, 20 years of industry leading practices, a new customer engagement model, and business optimization methods into a unified, industry cloud solution. SuiteSuccess was engineered to solve unique industry challenges that historically have limited a company’s ability to grow, scale and adapt to change. Most ERP vendors have tried to solve the industry solution problem with templates, rapid implementation methodologies, and custom code. NetSuite took a holistic approach to the problem and productized domain knowledge, leading practices, KPI’s, and an agile approach to product adoption. The benefits of this are faster time to value, increased business efficiency, flexibility, and greater customer success.

Within each industry offering, NetSuite has built unique micro-vertical solutions to address specific market needs. SuiteSuccess has over 300 customers and is available now, expanding globally into more industries and to current NetSuite customers over the course of this year.

“SuiteSuccess is what is next for NetSuite and our customers,” said Jim McGeever, Executive Vice President, Oracle NetSuite Global Business Unit. “When we started SuiteSuccess, we had high expectations, but the results our customers have achieved have gone way beyond our wildest dreams.”

“I was amazed, not only with how fast the project went, but how closely NetSuite worked with us,” said Bill Tingle, CIO of PODS. “We needed to get a system up and running quickly to keep up with our growth and SuiteSuccess fit the bill perfectly.”

The four key pillars of SuiteSuccess are:

  • BUILD. A complete suite to support the modern business including ERP, CRM, PSA, omnichannel commerce, HR, and Business Intelligence (BI) built on the NetSuite cloud platform, continually updated with leading edge capabilities and technologies to support all eight industries.
  • ENGAGE. Leading practices for each industry and role including workflows, KPI’s, reports, dashboards and metrics, with the flexibility to personalize on the NetSuite platform from the initial sales contact to ongoing support. With these leading practices, value is added at each stage of the engagement.
  • CONSUME. Intelligent staged approach via NetSuite’s industry ‘stairway’ allows companies to consume capabilities based on their business needs. Re-imagined consumption model drives faster time to value, better ROI and greater user adoption. Companies can now go from zero to cloud in 100 days.
  • OPTIMIZE. Customers benefit from continuous engagement, updated leading practices, new feature releases, value added SuiteCloud partners, and movement up the stairway. Customers also are always on the latest release.

DirectScale, a software solution designed to seamlessly meet the needs of the direct and social sales industry, implemented NetSuite OneWorld in November of 2016 with SuiteSuccess.

“NetSuite had customers in our industry that were dealing with the same issues as us. Setting up contracts, revenue recognition rules, revenue schedules. Choosing NetSuite, it was a match made in heaven,” said Ansen Hatch, Corporate Controller, DirectScale. “We know that NetSuite can grow with us as quickly as we can grow.”

Sourcingpartner, a leading provider of complete end-to-end sourcing solutions from product concept to after care support, implemented NetSuite in July 2016 with SuiteSuccess.

“Everything went much smoother than our Microsoft implementation. I’ve had nothing but good comments from everyone involved and I’m so glad we switched,” said Richard Gardner, Director for Customer Service, Sourcingpartner.

Precision Disposables, a wholesale distributor of high quality, cost efficient, medical products, implemented NetSuite in January 2017 with SuiteSuccess.

“I have 15 plus years of experience in all the major ERP platforms, including SAP, and I’ve been through six major implementations. This was by far the best,” said Bruce Capagli, COO, Precision Disposables.

To learn more about SuiteSuccess, please visit www.netsuite.com/suitesuccess.

About Oracle NetSuite Global Business Unit

Oracle NetSuite Global Business Unit pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, Oracle NetSuite Global Business Unit provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit www.netsuite.com.

Follow Oracle NetSuite Global Business Unit’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

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. 

NetSuite Unveils SuitePeople, the Most Unified and Flexible Cloud Core HR Offering

Oracle Press Releases - Tue, 2017-04-25 11:15
Press Release
NetSuite Unveils SuitePeople, the Most Unified and Flexible Cloud Core HR Offering Addition of Core HR Unifies Financial, Customer, Product, Services and People Data in NetSuite

SUITEWORLD 2017, LAS VEGAS, Nev.—Apr 25, 2017

Oracle NetSuite Global Business Unit (GBU), the industry’s leading provider of cloud financials / ERP, HR and omnichannel commerce software suites, today announced SuitePeople, a new core human resources (HR) offering natively built on NetSuite’s unified cloud suite. NetSuite is the first and only cloud ERP suite to give businesses a single platform to manage mission critical business processes across ERP, Customer Relationship Management (CRM), Professional Services Automation (PSA), omnichannel commerce and now HR.

Traditionally, businesses have had to manage core HR processes in separate modules, disparate systems, or worse, in spreadsheets. Growing businesses can’t afford the cost, time and risk associated with manual workarounds, complex integrations or siloed data. Unlike legacy HRIS solutions, SuitePeople helps people information actionable throughout the organization from a single suite.

“Since its inception, NetSuite has believed that the best way to run a business is with a unified suite. Today, we are incredibly excited to complete that vision with the launch of SuitePeople,” said Jim McGeever, Executive Vice President of the Oracle NetSuite Global Business Unit. “NetSuite has always delivered applications designed to run a complete business not just a department. And that same philosophy was built into the core of SuitePeople, the most unified flexible core HR offering ever available.”

“Having HR data available in NetSuite has transformed how we manage, train and retain our most valuable asset—our people,” said Noah Finn, Managing Partner at Finn Partners, a SuitePeople customer. “We’ve already seen significant business benefits and have only just scratched the surface of what we can do with all of our information in one central repository.”

“Successful organizations seek employee engagement solutions to ensure that their people are empowered and motivated. These solutions must enable everyone from the shop floor to the top floor,” said R “Ray” Wang, Principal Analyst and CEO of Constellation Research, Inc.

SuitePeople weaves people data throughout the suite, giving businesses complete control over their core HR processes. SuitePeople help enable employees to request time off, access employee directories and organizational charts, monitor upcoming vacation schedules and new hires or publicly recognize good work. SuitePeople help empower managers and HR professionals to streamline employee information, new hires, employee onboarding, promotions and compensation changes, all from a single suite.

SuitePeople plans to provide:

  • Core HR Capabilities. Native organization design, job and position management, workflows and  compliance management, all powered by effective-dated employee master data, providing HR with the systems they need to run a best-in-class operation.
  • HR Analytics. With pre-built reports and dashboards focused on key people metrics and compliance, including a new Chief People Officer dashboard, SuitePeople gives employees the data they need, right at their fingertips.
  • Employee Engagement. Kudos help allow all employees to recognize those co-workers who have helped drive the business forward, vital in today’s world of distributed workforces.
  • HR compliance. Built in human resources reports, searches and notifications are paired with tailored compliance features to ensure regulatory requirements are easily met and filing deadlines aren’t missed.
  • Unified access. With NetSuite’s unified data model, people information can be seamlessly analyzed from a single application suite. From HR to finance, services to the shop floor and the warehouse, the suite wins.
  • Global reach. With the NetSuite OneWorld supporting 190 currencies, 20 languages, automated tax calculation and reporting in more than 100 countries, and customer transactions in more than 200 countries, fast growing businesses know they can expand abroad and manage a global workforce.
  • Flexibility. Built on the flexible SuiteCloud platform, SuitePeople help allow customers and partners to configure workflows and forms to meet their unique needs without worrying about upgrades.
  • People security. Sophisticated role-based security features help allow executives, managers, supervisors and employees to simultaneously view information based on their operational and management role. Supporting both each other and their teams while safeguarding sensitive data.
  • Unmatched ease of use. Built within NetSuite’s intuitive user interface, SuitePeople can give employees a familiar experience that speeds adoption and training.

“Systems are the backbone of your business, but the heartbeat is your people,” said Joseph Fung, VP of Product Development at NetSuite. “With SuitePeople, businesses can achieve a more engaged workforce, improved operational efficiency, and timely strategic decision making. And best of all, because it is part of the unified suite, you can now manage and engage a global workforce better than ever.”

About Oracle NetSuite Global Business Unit

Oracle NetSuite Global Business Unit pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, Oracle NetSuite Global Business Unit provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit www.netsuite.com.

Follow Oracle NetSuite Global Business Unit’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

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. 

NetSuite Announces Massive Global Expansion Initiatives

Oracle Press Releases - Tue, 2017-04-25 11:00
Press Release
NetSuite Announces Massive Global Expansion Initiatives Launching More Data Centers, More Field Offices, More Development Centers, More International Product Functionality and a Broader Partner Network

SUITEWORLD 2017, LAS VEGAS, Nev.—Apr 25, 2017

Oracle NetSuite Global Business Unit, the industry's leading provider of cloud financials / ERP, HR and omnichannel commerce software suites, today announced a massive expansion plan to accelerate its international growth. NetSuite customers will benefit from Oracle’s vast global scale and resources. The expansion initiatives will enable Oracle NetSuite Global Business Unit to launch more data centers, more field offices and more development centers globally, which will help to bring the leading cloud ERP suite to more organizations around the world.

“Leveraging Oracle’s global scale, we are able to massively accelerate NetSuite’s vision of bringing a single unified suite to companies all over the world,” said Jim McGeever, Executive Vice President of Oracle NetSuite Global Business Unit. “Oracle’s technology infrastructure and global reach enables us to help ensure customer success no matter where they are located in the world.”

“Oracle’s increased investment in all areas of the NetSuite product and operations offers more opportunities to customers, particularly growing international businesses like PageGroup,” said Mark Hearn, Finance Director of recruitment company PageGroup. “As we continue our global roll-out of NetSuite OneWorld, I am reassured by the even greater capabilities and resources behind the product. A commitment to strong and sustained investment in OneWorld functionality will enable international companies like us to continue to grow with NetSuite in the future.”

Adding Oracle’s global resources to NetSuite’s existing global footprint provides rapid entry and expansion into new markets across three key areas:

  • Data Centers. Oracle NetSuite Global Business Unit plans to more than double its data center footprint from five data centers globally to 11. NetSuite currently operates five data centers, three in North America, one in Amsterdam, Netherlands and one in Dublin, Ireland. NetSuite expects to add a fourth North American data center in Chicago. As part of the global expansion plans, NetSuite will leverage existing Oracle data centers in Europe and Asia. In Europe, NetSuite is scheduled to open a data center in Frankfurt, Germany to remedy the lack of modern cloud computing offerings in the country. In Asia Pacific, NetSuite plans to initially launch facilities in Australia and Singapore, followed by Japan and China. The addition of Oracle data centers to NetSuite’s operations will provide even greater security, redundancy, performance and scalability for new and existing customers across the globe.
  • Field offices. NetSuite expects to double its global presence, expanding from offices in 10 countries to 23 spread across the globe. The addition of Oracle’s field offices significantly increases NetSuite’s ability to meet the rising demand for cloud ERP around the world. NetSuite is establishing a new presence in Argentina, Brazil, Colombia, Chile, Mexico, France, Germany, Sweden, Dubai, China, India, Malaysia and New Zealand. In addition, NetSuite is expanding headcount in existing field offices by over 50 percent to provide better resources for customer demand.
  • Development centers. Oracle NetSuite Global Business Unit is leveraging existing Oracle development centers across India, China and Japan. The development centers will be able to accelerate the development of international, regional and local features and functionality within NetSuite OneWorld.
About Oracle NetSuite Global Business Unit

Oracle NetSuite Global Business Unit pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, Oracle NetSuite Global Business Unit provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit www.netsuite.com.

Follow Oracle NetSuite Global Business Unit’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

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. 

Oracle Unified Auditing Performance Issues and 12.2 Improvements

For those of you using and/or considering Unified Auditing, in case you might have missed, Oracle has made significant changes to Unified Auditing in 12.2. Unified Auditing, new in Oracle 12c, represents a complete rewrite of how native database auditing works - see the links below for Integrigy research on Unified Auditing.

With Oracle 12.1, when using Unified Auditing, reads of the UNIFIED_AUDIT_TRAIL view were not performant. With Oracle 12.2, a new relational partitioned table (AUDSYS.AUD$UNIFIED) is created to solve the performance issue, and a patch (22782757) has been issued to backport the fix to 12.1.

For 12.1 clients using Unified Auditing, the patch and/or the workaround should be a high priority consideration.

Thank you to Mark Dietrich for pointing out the 12.1 patch.

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

-Michael Miller, CISSP-ISSMP, CCSP, CCSK

References
 
 
 
 
 
 
Auditing, Oracle Database
Categories: APPS Blogs, Security Blogs

Does the wal segment size matter in PostgreSQL?

Yann Neuhaus - Tue, 2017-04-25 02:39

In PostgreSQL you configure the size of the wal (write ahead log) segments when you compile from source. If you use an installer or if you use the packages provided by your OS distribution the size of the wal segments is usually 16MB. Although 16MB seems very low you don’t need to worry about that in most of the cases, it just works fine. However there are cases where you might want to adjust this, e.g. when you have an application that generates thousands of transactions in a very short time and therefore forces PostgreSQL to generate huge amounts of wal segments. In this post we’ll look at a specific case: Usually you want to archive the wal segments for being able to do point in time recovery in case your severs crashes for some reason. Does the size of the wal segments matter for archiving?

Archiving of wal segments in PostgreSQL is done by specifying an archive_command. Whatever you put there will be executed by PostgreSQL once a new wal segment is created. Usually you’ll find something like this in archive_command (from the documentation):

archive_command = 'test ! -f /mnt/server/archivedir/%f && cp %p /mnt/server/archivedir/%f'  # Unix
archive_command = 'copy "%p" "C:\\server\\archivedir\\%f"'  # Windows

Or something like this:

archive_command = 'rsync -a %p postgres@[SOME_OTHER_HOST]:/path/to/wal_archive/%f'

Or:

archive_command ='scp %p postgres@[SOME_OTHER_HOST]:/path/to/wal_archive/%f'

Lets test how the size of wal segments impact the three ways of archiving outlined above. To begin with lets create 100 files each 16MB (the same as the default wal segment size in PostgreSQL) and 25 files 64MB each:

rm -rf /var/tmp/test16mb
mkdir /var/tmp/test16mb
for i in {1..100}; do
   dd if=/dev/zero of=/var/tmp/test16mb/${i} bs=1M count=16
done
ls -la /var/tmp/test16mb
rm -rf /var/tmp/test64mb
mkdir /var/tmp/test64mb
for i in {1..25}; do
   dd if=/dev/zero of=/var/tmp/test64mb/${i} bs=1M count=64
done
ls -la /var/tmp/test64mb
du -sh /var/tmp/test16mb
du -sh /var/tmp/test64mb

This will give us a total size of 1.6GB for each of the wal sizes (16MB and 64MB). Lets start by testing the “cp” way:

echo 3 > /proc/sys/vm/drop_caches
mkdir -p /var/tmp/target
rm -rf /var/tmp/target/*
time for i in `ls /var/tmp/test16mb`; do
    cp /var/tmp/test16mb/${i} /var/tmp/target/
done

My result (on a VM local on my notebook):

real	0m17.444s
user	0m0.275s
sys	0m8.569s

The same test for the 64MB files:

echo 3 > /proc/sys/vm/drop_caches
mkdir -p /var/tmp/target
rm -rf /var/tmp/target/*
time for i in `ls /var/tmp/test64mb`; do
    cp /var/tmp/test16mb/${i} /var/tmp/target/
done

It is almost 3 times as fast to copy the large files than to copy the smaller files:

real	0m5.365s
user	0m0.065s
sys	0m1.835s

Of course, for production systems, you would copy the files not locally but rather to e.g. NFS mount and then the numbers will change.

What are the numbers for scp? For the smaller files:

echo 3 > /proc/sys/vm/drop_caches
mkdir -p /var/tmp/target
rm -rf /var/tmp/target/*
time for i in `ls /var/tmp/test16mb`; do
    scp /var/tmp/test16mb/${i} root@localhost:/var/tmp/target/
done

The result:

real	2m51.708s
user	0m14.136s
sys	0m35.292s

Quite a huge overhead. What is the result with the 64MB files?:

echo 3 > /proc/sys/vm/drop_caches
mkdir -p /var/tmp/target
rm -rf /var/tmp/target/*
time for i in `ls /var/tmp/test64mb`; do
    scp /var/tmp/test64mb/${i} root@localhost:/var/tmp/target/
done

Approximately double as fast:

real	1m23.326s
user	0m10.353s
sys	0m30.814s

And finally rsync, for the smaller files:

echo 3 > /proc/sys/vm/drop_caches
mkdir -p /var/tmp/target
rm -rf /var/tmp/target/*
time for i in `ls /var/tmp/test16mb`; do
    rsync -a /var/tmp/test16mb/${i} root@localhost:/var/tmp/target/${i}
done

The result:

real	0m51.624s
user	0m4.488s
sys	0m10.247s

For the larger ones:

echo 3 > /proc/sys/vm/drop_caches
mkdir -p /var/tmp/target
rm -rf /var/tmp/target/*
time for i in `ls /var/tmp/test64mb`; do
    rsync -a /var/tmp/test64mb/${i} root@localhost:/var/tmp/target/${i}
done

The result:

real	0m34.342s
user	0m3.623s
sys	0m9.685s

Conclusion: When you have applications with high transaction rates it can make sense to increase the default wal segment size as archiving will usually be much faster when you use bigger segments. Of course you’ll need to test this on your specific hardware and for your specific workload. In a next post we’ll look at how bigger segments affect performance of PostgreSQL.

 

Cet article Does the wal segment size matter in PostgreSQL? est apparu en premier sur Blog dbi services.

Accepting SQL profiles

Tom Kyte - Mon, 2017-04-24 22:46
Hi - we are doing some data conversion of our database associated with a vendor product. This means migrating from one version of the vendor schema to another. so remapping the data. During a performance run, one of the SQLs was taking longer to run....
Categories: DBA Blogs

Correctly identifying Dynamic Sampling queries run by Optimizer

Tom Kyte - Mon, 2017-04-24 22:46
It is clear that dynamic sampling queries run by the optimizer contains <b>/* DS_SVC */ </b>clause in them (when traced). e.g. SELECT /* DS_SVC */ /*+ dynamic_sampling(0) no_sql_tune no_monitoring optimizer_features_enable(default) no_parallel...
Categories: DBA Blogs

Pivot and null values

Tom Kyte - Mon, 2017-04-24 22:46
Hi team, I have a table test having column as name,id,language.... <code>name id language a 1 eng b 2 eng c 3 fer d 4 (null) select * from TEST pivot (min(id) for language in('eng' as "english",'fer' as "french",)) </code> ...
Categories: DBA Blogs

RANGE Partition in DATE column DD/MM/YYYY HH24:MM:SS

Tom Kyte - Mon, 2017-04-24 22:46
Hi team, I need to partition TEST_PARTITIONS table on the basis of end_date using RAGE INTERVAL partition. <code>create table TEST_PARTITIONS partition by range(end_date) ( partition p2010 values less than (to_date('01-Jan-2011','dd-mon-yyy...
Categories: DBA Blogs

Custom UI Components in Oracle ABCS for Dynamic Image Display

Shay Shmeltzer - Mon, 2017-04-24 17:29

This quick one is based on a customer question about Oracle Application Builder Cloud Service. The scenario is that we have a business object that has a field that contains the URL to an image. We want to be able to show that image on a page in Oracle Application Builder Cloud Service.

animated GIF

To do that I add a custom UI component object to the details (or edit) page of a record - then I switched the HTML of that object to be: <img id="logoimg"/>

custom code

I then added a button to the page and added a bit of custom JavaScript code in its action as follow:

var img = document.getElementById('logoimg');

img.src=$Company.getValue('Logo');

resolve();

This code simply locates the custom object on the page using the object id and then sets the src property of the img html tag to match the value of the field in the business object.

Code in Button

Categories: Development

Benefits of Analytics for Non-Profit Organizations

Nilesh Jethwa - Mon, 2017-04-24 14:49

Analytics is a process that uses tools to collect those ever-increasing volumes of diverse types of data from multiple sources, sort them out at record speeds, analyze them, and use them to gain new insights. This concept has existed for decades, and it has been recreated with modern and more powerful tools to consolidate today's data upsurge.

Non-profits run the extent in terms of using analytics. Some are only getting started, utilizing business intelligence and dashboard software for their budgeting and forecasting procedures, while others have gone far along the continuum and are considering effective ways to get more unstructured data to further enhance their existing analytics models. 
 

Read more at http://www.infocaptor.com/dashboard/non-profit-dashboards-benefits-of-analytics-for-non-profit

ADF BC Groovy Expression Security Policy Configuration

Andrejus Baranovski - Mon, 2017-04-24 13:23
Today I'm going to explain how to configure Groovy expression security policy. This could be helpful, if you dont want to change trustMode property to trusted everywhere across the app, but looking for single configuration point.

My sample app - GroovyPermissionApp.zip, contains bind variable with expression reference pointing towards custom method located in AM implementation class:


JDEV 12.2.1.2 returns compilation error for Groovy expression, can't resolve applicationModule property:


Such kind of checks can be disabled in Model project configuration. Uncheck option for Groovy Expression Type Validation:


JDEV 12.2.1.2 by default creates Groovy expressions in untrusted mode. If you change it to trusted, expression would work OK. However, if your app contains many expressions like this, you may want to ignore trustMode property:


If you run ADF BC tester in JDEV 12.2.1.2, it will show error text in the log for untrusted expression. ADF BC tester will fail to start, if there is any error - we logged this issue with Oracle Support. Property applicationModule can't be resolved, when trustMode is set to untrusted:


To disable this check, we can create new class extending ExprSecurityPolicy class. Override checkProperty method to allow calls to applicationModule property:


This class should be registered in adf-config.xml:


Try to run ADF BC tester again. Error about applicationModule will be gone. This time it will complain about permission error to call getCurrentRegion method:


Method access can be granted by annotation in AM implementation class:


ADF BC tester runs, and returns VO row data:

Java Web Start Now Available for EBS 12.1 and 12.2

Steven Chan - Mon, 2017-04-24 12:20

Java Web Start (JWS) is now available for Oracle E-Business Suite 12.1 and 12.2:

What is Java Web Start?

Java Web Start launches E-Business Suite Java-based functionality as Java Web Start applications instead of as applets.  Java Web Start is part of the Java Runtime Environment (JRE).

Does EBS use Java on desktop clients?

Yes.  The E-Business Suite requires Oracle Forms.  Oracle Forms requires Java. 

Other EBS products also have functionality that require Java.

What is the new approach with Java Web Start?

It's not technically "new" (it is a mature Java technology originally released in 2004), but we're using it for the first time with the E-Business Suite.  This approach launches EBS Forms-based screens and other functionality as Java Web Start applications instead of as applets.

What prerequisites are needed for Java Web Start?

 Oracle E-Business Suite Release  Minimum JRE Release  12.2  JRE 8 Update 121 b33  12.1.3  JRE 8 Update 121 b33

A small number of server-side patches for Forms and EBS are needed. See:

Why is this important?

Until now, E-Business Suite's Java-based content required a browser that supports Netscape Plug-in Application Programming Interface (NPAPI) plug-ins.

Some browsers are phasing out NPAPI plug-in support.  Some browsers were released without NPAPI plug-in support.  This prevents the Java plug-in from working.

With the release of Java Web Start, E-Business Suite 12.1 and 12.2 users can launch Java-based content (e.g. Oracle Forms) from browsers that do not support Java plug-ins via NPAPI.  Java Web Start in EBS works with:

  • Microsoft Internet Explorer
  • Microsoft Edge
  • Firefox Rapid Release (32-bit and 64-bit)
  • Firefox Extended Support Release (32-bit and 64-bit)
  • Google Chrome

How does the technology architecture change?

Java Web Start changes the way that Java runs on end-users' computers but this technical change is generally invisible to end-users.

Java Web Start applications are launched from browsers using the Java Network Launching Protocol (JNLP).

E-Business Suite Java Web Start architecture diagram

Will the end-user's experience change?

Generally not. We have worked hard to ensure that your end-users' experience with Java Web Start applications is as similar as possible to applets via the Java browser plugin.  The differences between the Java Plug-in and Java Web Start are expected to be almost-invisible to end-users.

Will E-Business Suite still require Java in the future?

Yes.  It is expected that our ongoing use of Oracle Forms for high-volume professional users of the E-Business Suite means that EBS will continue to require Java.  We replicate, simplify, or migrate selected Forms-based flows to OA Framework-based (i.e. web-based HTML) equivalents with every EBS update, but Oracle Forms is expected to continue to be part of the E-Business Suite technology stack for the foreseeable future. 

Does the E-Business Suite have other Java applet dependencies?

Yes.  In addition to Oracle Forms, various E-Business Suite products have functionality that runs as Java applets.  These Java applets require browsers that offer plugin support.  These products include applets:

  • Oracle General Ledger (GL): Account Hierarchy Manager
  • Oracle Customers Online (IMC): Party Relationships
  • Oracle Call Center Technology (CCT)
  • Oracle Sourcing (PON): Auction Monitor
  • Oracle Installed Base (CSI): Visualizer
  • Oracle Process Manufacturing (OPM): Recipe Designer
  • Oracle Advanced Supply Chain Planning (MSC): Plan Editor (PS/SNO)
  • Workflow (WF): Status Diagram, Notification Signing with Digital Signatures
  • Scripting (IES): Script Author

What is the roadmap for browser support for plug-ins?

Plug-in support has various names, including:

This article will simply use the term "plug-in support," which refers to all of the different types listed above.

Some browsers are phasing out plug-in support. Some browsers were never released with plug-in support.

Some organizations may wish to use browsers that do not offer plugin support.  The Java Web Start approach works with all browsers, regardless of whether they have plugin support. 

What is the roadmap for Java's support for plug-ins?

The Java team recently published their plans
for removing the Java browser plugin in a future version of Java. The announcement states (highlighted for emphasis):

Oracle plans to deprecate the Java browser plugin in JDK 9. This technology will be removed from the Oracle JDK and JRE in a future Java SE release.

What does "deprecate" mean?

In this context, "deprecate" means there will still be a Java Plug-in in JRE 9.

In other words, JRE 9 will include the Java Browser Plug-in and Java Web Start.  Users will still be able to run Java-based applications using the Java Plug-in and Java Web Start in JRE 9.

What does this mean for E-Business Suite users running the Java Plug-in with JRE 9?

The release of Java 9 is not expected to affect E-Business Suite users.

JRE 9 is expected to continue to work with the E-Business Suite in browsers that support the Java Browser Plug-in via the NPAPI protocol.

JRE 9 is expected to work with the E-Business Suite in browsers that support Java Web Start.

What browsers are expected to support the JRE 9 plug-in?

Internet Explorer, Firefox ESR 32-bit, and Safari are expected continue to support NPAPI -- and, therefore, Java and Forms. 

Firefox Rapid Release, Firefox ESR 64-bit, Google Chrome, and Microsoft Edge do not support NPAPI, so Java-based apps cannot run in those browsers using the Java Plug-in.  EBS users can run Java-based content using Java Web Start with JRE 9.

What are the timelines for browsers' plugin support?

Individual browser vendors have been updating their plans regularly.  Here's a snapshot of what some browser vendors have stated as of today:

Microsoft Internet Explorer (IE)

Microsoft has indicated that they intend to continue to offer plug-in support in IE.

Microsoft Edge

Microsoft Edge was released in Windows 10 without Browser Helper Object (BHO, aka. plugin) support.  Microsoft has no plans to add plugin support to Edge.

Mozilla Firefox Extended Support Release (ESR)

Mozilla indicated in early 2016 that Firefox ESR 52 32-bit will be the last version to offer NPAPI (and JRE) support.  Firefox ESR 52 32-bit was released in March 2017 and will be supported until May 2018. 

Mozilla removed NPAPI support from Firefox ESR 52 64-bit in March 2017.  

Mozilla Firefox Rapid Release

Mozilla removed NPAPI support from the Firefox 52 Rapid Release version in March 2017. 

Apple Safari for macOS

Safari offers Internet plug-in support for macOS users.  Apple has not made any statements about deprecating plugin support for macOS users.

Google Chrome for Windows

Chrome offered support for plugins until version 45, released in September 2015.  They removed NPAPI support in later Chrome releases.

Will I need to change browsers for EBS 12.1 or 12.2?

Not generally, but it depends on your choice of browsers and whether you wish to use Java Plug-in or Java Web Start.

Here's the compatibility matrix for EBS 12.1 and 12.2 certified combinations:

   Java Plug-In  Java Web Start  Microsoft Internet Explorer  Yes  Yes  Microsoft Edge    Yes  Firefox Rapid Release 32-bit    See Note 1  Firefox Rapid Release 64-bit    See Note 1  Firefox Extended Support Release 32-bit  Yes  Yes  Firefox Extended Support Release 64-bit    Yes  Google Chrome    Yes  Safari on macOS  Yes  See Note 2

Note 1: Expected to work but not tested.

New personal versions of Firefox on the Rapid Release channel are released roughly every six weeks.  It is impractical for us to certify these new personal Rapid Release versions of Firefox with the Oracle E-Business Suite because a given Firefox release is generally obsolete by the time we complete the certification.

From Firefox 10 and onwards, Oracle E-Business Suite is certified only with selected Firefox Extended Support Release versions. Oracle has no current plans to certify new Firefox personal releases on the Rapid Release channel with the E-Business Suite.

Note 2: Not certified.

Apple changed the Gatekeeper permissions in macOS Sierra 10.12.  These changes prevent JNLP execution, making the Java Web Start user experience very challenging.  We are investigating options right now. 

Will Oracle release its own browser for the E-Business Suite?

No.  Long-time Oracle users may remember the Oracle PowerBrowser. The industry has since moved away from software that requires proprietary browsers.  We have no plans to release a browser specifically for E-Business Suite users. 

Will this work on Android or iOS?

No. Neither of these operating systems are compatible with Java. 

E-Business Suite users who need to run Oracle Forms-based content or other Java-based functionality should use Windows or macOS.

Will Java Web Start be mandatory?

Not immediately. It is expected that the use of Java Web Start will be optional at least up to, and including, Java 9, which may be the last Java release to include the JRE browser plugin. 

Will Java Web Start coexist with JRE?

Yes.  You can have a mixed environment where some end-users launch Java Web Start applications, while others use applets via the Java plug-in.  This mixed group of end-users can connect to the same E-Business Suite environment.

EBS system administrators have full server-side control over these choices.

Will this affect EBS customizations?

Maybe. It depends upon which of the following apply to your environment:

  • Scenario 1You have modified standard EBS screens running in Forms: 
    No actions needed. These customizations are expected to work with Java Web Start without any additional changes.
  • Scenario 2You have built custom Java applets of your own to extend the E-Business Suite:  These will continue to run with the Java plug-in, but you may wish to update those applets to use Java Web Start.
  • Scenario 3You have third-party extensions or products that depend upon the Java plug-in:
    These will continue to run with the Java plug-in but you may wish to contact your third-party vendor for details about their plans for Java Web Start.

Are there any additional licensing costs?

No. Java Web Start is included with EBS licenses and does not introduce any new licensing costs.

Related Articles

Disclaimer

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 decision.  The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

 

Categories: APPS Blogs

Simple Steps to Perform oPatch Maintenance with Ansible

Pythian Group - Mon, 2017-04-24 10:44

Like the Universe, IT growth seems to be infinite, we always have more environments, more servers, more users, more disk usage, more databases to manage and it won’t stop. In fact, we are pretty sure that this expansion is going to be faster and faster.

We then have to adapt to this new, mutating IT environment being more productive in order to manage more and more targets in less time.

How to achieve this goal? Like human beings have always done from the early days – by using tools and by making better tools with the tools we have.

1/ The Ansible Tool

 

1.1/ A Word on Ansible

Ansible is an open source IT automation tool that was launched in early 2013 and bought by Red Hat in 2015. The most recent 2.3 version was released few days ago.

1.2/ Why Ansible?

Other the automation tools are professed to be easy, fast, able to manage thousands of thousands of targets, etc… so why Ansible instead of Puppet or Chef? For me, it’d because Ansible is agentless and does everything through standard SSH (or Paramiko which is a Python SSH implementation).

Indeed, ‘no agent’ really means easy to deploy, no agent to maintain (!), and it is very secure since it uses SSH. I am accustomed to working with companies that have tough security processes and challenging processes for any kind of installations. Be sure that it is easier to quickly deploy everything with these features:

  • Is it secure? Yes, it goes through SSH.
  • Anything to install on the targets? No.
  • Do you need root access? No, as long as what I need to do is doable with no root privilege.
  • Can it go through sudo? Yes, no worries.
  • What do you need then? An SSH key deployed on the targets (which also means that it is very easy to unsetup, you just have to remove that SSH key from the target)

For more information on the differences between Ansible, Puppet and Chef, just perform an online search.  You will find many in-depth comparatives.

2/ Manage oPatch with Ansible

To illustrate how quick and easy it is to use Ansible, I will demonstrate how to update oPatch with Ansible. oPatch is a very good candidate for Ansible as it needs to be frequently updated, exists in every Oracle home and also needs to be current every time you apply a patch (and for those who read my previous blogs, you know that I like to update opatch :))

2.1/ Install Ansible

The best way to install Ansible is to first refer to the official installation documentation .  There you will find the specific commands for your favorite platform (note that Ansible is not designed for Windows).

2.2/ Configure Ansible

To start, Ansible has to know the hosts you want to manage in a “host” file like:

oracle@control:~/work$ cat hosts_dev
[loadbalancer]
lb01

[database]
db01
db02 ansible_host=192.168.135.101
oracle@control:~/work$

We can split the hosts by group like [loadbalancer], [database] to have various hosts group. It is also possible that the host you are running Ansible on cannot resolve a host. We can then use the ansible_host parameter to specify the IP for it like I did for the db02 server. In fact, ansible_host defines the host Ansible will connect to and the name at the start of the line is an alias used if ansible_host is not defined

Note that I named the hosts file “hosts_dev” in my example. This was done so I would not use the default ansible hosts file which make it more modular. We then have to tell Ansible that we want to use this file instead of the default file in the ansible.cfg configuration file.

oracle@control:~/work$ cat ansible.cfg
[defaults]
inventory=./hosts_dev
oracle@control:~/work$

Please remember that Ansible uses SSH connectivity so you’ll need to exchange the SSH key of your “control” server to your targets. More extensive documentation on the subject can be found online. Here is an example with ssh-copy-id (if you don’t know the target user password, conduct a Google search for authorized_keys and you will find how to exchange an SSH key when you don’t know the target user password):

  oracle@control:~$ ssh-keygen                          # This will generate your SSH keys

  ... press ENTER at all prompts) ...

  oracle@control:~$ ssh-copy-id oracle@db01
  ...
  Are you sure you want to continue connecting (yes/no)? yes
  ...
  oracle@db01's password:                             # You will be prompted for the target password once
  ...
  Now try logging into the machine, with:   "ssh 'oracle@db01'"
  and check to make sure that only the key(s) you wanted were added.

  oracle@control:~$ ssh ansible@db01                   # Try to connect now
  Welcome to Ubuntu 14.04.5 LTS (GNU/Linux 3.13.0-112-generic x86_64)
  Last login: Thu Apr 20 02:17:24 2017 from control
  oracle@db01:~$                                       # We are now connected with no password

 

2.3/ A First Playbook

A playbook is a collection of Ansible commands that are used to orchestrate what you want to do. Ansible uses the YAML language (please have a look at the official YAML website) for this purpose.

Let’s start with a first easy playbook that checks if the /etc/oratab file exists on my [database] hosts:

oracle@control:~/work$ cat upgrade_opatch.yml
---
- hosts: database                              # Specify only the hosts contained in the [database] group
  tasks:
  - name: Check if /etc/oratab exists          # A name for the task
    stat:                                      # I will use the stat module to check if /etc/oratab exists
      path: /etc/oratab                        # The file or directory I want to check the presence
    register: oratab                           # Put the return code in a variable named "oratab"

  - debug:                                     # A debug task to show an error message if oratab does not exist
      msg: "/etc/oratab does not exists"       # The debug message
    when: oratab.stat.exists == false          # The message is printed only when the /etc/oratab file does not exist

oracle@control:~/work$

Let’s run it now (we use ansible-playbook to run a playbook):

oracle@control:~/work$ ansible-playbook upgrade_opatch.yml

PLAY [database] ***************************************************************************************************************************************************************************************************

TASK [Gathering Facts] ********************************************************************************************************************************************************************************************
ok: [db02]
ok: [db01]

TASK [Check if /etc/oratab exists] ********************************************************************************************************************************************************************************
ok: [db02]
ok: [db01]

TASK [debug] ******************************************************************************************************************************************************************************************************
skipping: [db01]
ok: [db02] => {
    "changed": false,
    "msg": "/etc/oratab does not exists"
}

PLAY RECAP ********************************************************************************************************************************************************************************************************
db01                       : ok=2    changed=0    unreachable=0    failed=0
db02                       : ok=3    changed=0    unreachable=0    failed=0

oracle@control:~/work$

Since I removed /etc/oratab from db02 on purpose, I received the “/etc/oratab does not exists” error message (as expected).

Before going further, let’s add a test to see if unzip exists (we’ll need unzip to unzip the opatch zipfile). Put the db02’s oratab file back where it should be and run the playbook again:

  oracle@control:~/work$ cat upgrade_opatch.yml
  ---
  - hosts: database
    tasks:
    - name: Check if /etc/oratab exists
      stat:
        path: /etc/oratab
      register: oratab

    - debug:
        msg: "/etc/oratab does not exists"
      when: oratab.stat.exists == false

    - name: Check if unzip exists (if not we wont be able to unzip the opatch zipfile)
      shell: "command -v unzip"
      register: unzip_exists

    - debug:
        msg: "unzip cannot be found"
      when: unzip_exists == false
  oracle@control:~/work$ ansible-playbook upgrade_opatch.yml

  PLAY [database] ***************************************************************************************************************************************************************************************************

  TASK [Gathering Facts] ********************************************************************************************************************************************************************************************
  ok: [db02]
  ok: [db01]

  TASK [Check if /etc/oratab exists] ********************************************************************************************************************************************************************************
  ok: [db01]
  ok: [db02]

  TASK [debug] ******************************************************************************************************************************************************************************************************
  skipping: [db01]
  skipping: [db02]

  TASK [Check if unzip exists (if not we wont be able to unzip the opatch zipfile)] *********************************************************************************************************************************
  changed: [db02]
  changed: [db01]

  TASK [debug] ******************************************************************************************************************************************************************************************************
  skipping: [db01]
  skipping: [db02]

  PLAY RECAP ********************************************************************************************************************************************************************************************************
  db01                       : ok=3    changed=1    unreachable=0    failed=0
  db02                       : ok=3    changed=1    unreachable=0    failed=0

  oracle@control:~/work$

Please note that I used the shell built-in module to test if unzip is present or not.

2.4/ Upgrade oPatch

To upgrade oPatch, we need to copy the zipfile to the target Oracle home and then unzip it — easy and straightforward. Let’s ask Ansible to do it for us.

First, let’s use the copy module to copy the oPatch zipfile to the target Oracle home:

- name: Copy the opatch zipfile to the target oracle home
   copy:
     src: p6880880_112000_Linux-x86-64.zip
     dest: /u01/oracle/11204

Unzip the zipfile in the target Oracle home (I use the shell module to unzip instead of the unarchive module on purpose. This will trigger a warning during the playbook execution, but I am not a big fan of the unarchive module… we could discuss that later on):

  - name: Upgrade opatch
    shell: unzip -o /u01/oracle/11204/p6880880_112000_Linux-x86-64.zip -d /u01/oracle/11204
    register: unzip
    failed_when: unzip.rc != 0

Let’s cleanup the zipfile we copied earlier using the file module (note that this is the keyword state: absent which will remove the file), we do not want to leave any leftovers:

  - name: Cleanup the zipfile from the target home
    file:
      name: /u01/oracle/11204/p6880880_112000_Linux-x86-64.zip
      state: absent

Now review the whole playbook:

  oracle@control:~/work$ cat upgrade_opatch.yml
---
- hosts: database
  tasks:
  - name: Check if /etc/oratab exists
    stat:
      path: /etc/oratab
    register: oratab

  - debug:
      msg: "/etc/oratab does not exists"
    when: oratab.stat.exists == false

  - name: Check if unzip exists (if not we wont be able to unzip the opatch zipfile)
    shell: "command -v unzip"
    register: unzip_exists

  - debug:
      msg: "unzip cannot be found"
    when: unzip_exists == false

  - name: Copy the opatch zipfile to the target oracle home
    copy:
      src: p6880880_112000_Linux-x86-64.zip
      dest: /u01/oracle/11204

  - name: Upgrade opatch
    shell: unzip -o /u01/oracle/11204/p6880880_112000_Linux-x86-64.zip -d /u01/oracle/11204
    register: unzip
    failed_when: unzip.rc != 0

  - name: Cleanup the zipfile from the target home
    file:
      name: /u01/oracle/11204/p6880880_112000_Linux-x86-64.zip
      state: absent

oracle@control:~/work$

and execute it:

oracle@control:~/work$ ansible-playbook upgrade_opatch.yml

PLAY [database] ***************************************************************************************************************************************************************************************************

TASK [Gathering Facts] ********************************************************************************************************************************************************************************************
ok: [db02]
ok: [db01]

TASK [Check if /etc/oratab exists] ********************************************************************************************************************************************************************************
ok: [db01]
ok: [db02]

TASK [debug] ******************************************************************************************************************************************************************************************************
skipping: [db01]
skipping: [db02]

TASK [Check if unzip exists (if not we wont be able to unzip the opatch zipfile)] *********************************************************************************************************************************
changed: [db02]
changed: [db01]

TASK [debug] ******************************************************************************************************************************************************************************************************
skipping: [db01]
skipping: [db02]

TASK [Copy the opatch zipfile to the target oracle home] **********************************************************************************************************************************************************
changed: [db01]
changed: [db02]

TASK [Upgrade opatch] *********************************************************************************************************************************************************************************************
 [WARNING]: Consider using unarchive module rather than running unzip

changed: [db01]
changed: [db02]

TASK [Cleanup the zipfile from the target home] *******************************************************************************************************************************************************************
changed: [db02]
changed: [db01]

PLAY RECAP ********************************************************************************************************************************************************************************************************
db01                       : ok=6    changed=4    unreachable=0    failed=0
db02                       : ok=6    changed=4    unreachable=0    failed=0

oracle@control:~/work$

We now have a playbook that can update all your oPatches in a blink!

Please note that this example is a very basic one since this is to give an overview on how to manage oPatch with Ansible.
Many features could be implemented here (and are implemented in the code we use here at Pythian) like:

  • Check the list of Oracle homes on each server — there are often many.
  • Check the version of each Oracle home’s oPatch.
  • Manager different oPatch versions : 11, 12 and 13.
  • Use the Ansible roles to make the code more modular and reusable.
  • Upgrade opatch only if it needs to and more…

I hope you enjoyed this Ansible overview!

Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator