Feed aggregator

How Oracle Won Over Blockchain Bellwether Everledger

Oracle Press Releases - Tue, 2019-05-14 09:00
Blog
How Oracle Won Over Blockchain Bellwether Everledger

By Michael Hickins—May 14, 2019

It’s no small thing that Everledger, the pioneer in so-called digital provenance tracking, has embraced Oracle’s blockchain technology as its own.

Everledger’s blockchain-based platform is trusted by many industries including diamonds, colored gemstones, fine wine, and art. The ability to transparently track the provenance and lifetime journey of assets as they move across global supply chains is especially critical for high value goods. These industries are more susceptible than most to theft, fraud and counterfeit – in the diamond industry alone, fraud events cost the insurance industry millions of dollars a year.

Leanne Kemp, Founder and CEO of Everledger says, “With an increasing consumer consciousness and a vocal demand for transparency, our work is focused on engaging entire business ecosystems to provide consumers the ability to make fully informed purchasing decisions. It is thus key for us to enable the ease of systems interaction and provide value add to our customers.”

According to Kemp, by including Oracle Blockchain Platform in its offering, Everledger can offer its customers more innovative products and solutions, in particular with improved time to market for business intelligence reporting solutions.

“Oracle’s comprehensive enterprise-grade offering will open our customers to realizing more from our blockchain-based platform and crystalize value from the data in their own systems,” she says.

Some of the new capabilities of Oracle Blockchain Platform are deemed critical by Everledger in the integration of its blockchain-based platform with customers’ existing business and IT systems. As blockchain becomes an important data store in the enterprise, the Oracle Blockchain Platform enables users to capture blockchain transaction history and current state data for analytics as well as integrate it with other data sources.

“Our longstanding goal has been to help customers to manage, protect, analyze and use the world’s data for the benefit of all. Being able to work with innovative companies like Everledger is an amazing opportunity. We look forward to helping both the company itself further its innovations in tracking and tracing the authenticity of some of the world’s most precious items, but also helping those in the ecosystem link key data sources for wider benefit,” said Frank Xiong, group vice president, Blockchain Product Development, Oracle.

The key elements of note include:

  • Database access - Data is an integral part of blockchain. With much of the world’s data resident in Oracle systems, the use of Oracle Blockchain Platform to seamlessly link to those repositories will enable these same customers to leverage both their existing data stores and data on the Everledger blockchain.
  • Analytics - Oracle Blockchain Platform’s ability to connect to the rich histories stored in an organisation’s existing database means that Everledger can seamlessly enable analytics integration for highly visual interactive dashboards and reports.
  • Monitoring of network health, transaction rates, and other statistics, and other elements of blockchain administration/configuration, are made easier by enhanced REST APIs, which also simplify integration with existing enterprise IT tools.
  • Out of the box plug and play capabilities from the Oracle Blockchain Platform makes it not only easy for Everledger to get off the ground, but will also easier for deployment.
  • Developer tools - Additionally, the query tools for Oracle Blockchain Platform link into things like smart contract support standard SQL-based ledger queries, enabling organisations to leverage the skill sets their developers already have, thereby reducing the complexity of developing chaincode and boosting performance.
 

University of Pittsburgh Selects Oracle ERP Cloud to Help Build Better Lives

Oracle Press Releases - Tue, 2019-05-14 08:00
Press Release
University of Pittsburgh Selects Oracle ERP Cloud to Help Build Better Lives Two hundred thirty two-year-old university modernizes business and finance systems to increase productivity, lower costs and enhance the student experience

Redwood Shores, Calif.—May 14, 2019

 

The University of Pittsburgh, a leading higher-education institution, has selected Oracle Enterprise Resource Planning (ERP) Cloud to support its mission to advance teaching, research and public service. With Oracle ERP Cloud, the University of Pittsburgh will be able to improve operational efficiency, modernize its business and finance operations and gain deeper organization insight.

Founded in 1787, the University of Pittsburgh is one of the oldest higher education institutions in the United States and attracts more than 34,000 students each year. To improve the productivity of its finance and operations team, the university needed to replace its legacy financial management system with a modern cloud solution that would improve agility and future-proof the organization. The school selected Oracle ERP Cloud for its ability to manage finance, human resource and student data on a single, highly secure and scalable cloud solution.

“Technology plays a strategic role in the university’s success and the achievement of our mission. To maximize value and impact, our technology must be a coordinated effort across business functions,” said Monte Ciotto, Associate Vice Chancellor, Financial Information Systems. “With Oracle ERP Cloud we’ll be able to manage finance, HR and student data on the same platform, creating a single source of truth that improves efficiency and organizational insights.”

Oracle ERP Cloud helps organizations of all sizes, across multiple industries, increase productivity, lower costs and improve controls. With Oracle ERP Cloud, the University of Pittsburgh will not only be able to embrace current best practices, but it will also enable the University to integrate emerging technology to support changing organizational demands. The University of Pittsburgh also has plans to implement Oracle Human Capital Management (HCM) Cloud for core HR processes, including payroll, time and attendance, and talent acquisition. The University’s unified ERP and HCM solution will enhance organizational alignment and business insight.

“Technology is an incredible enabler that can help organizations like the University of Pittsburgh not just streamline processes, but also improve engagement and transform existing business processes and models,” said Rondy Ng, senior vice president of applications development at Oracle. “We look forward to partnering with the University of Pittsburgh as it embraces new innovations and works to deliver the best possible higher education experience.”

Additional Information

For additional information on Oracle ERP Cloud applications, visit Oracle Enterprise Resource Planning (ERP) Cloud’s Facebook and Twitter or the Modern Finance Leader blog.

Contact Info
Bill Rundle
Oracle
+1.650.506.1891
bill.rundle@oracle.com
About Oracle

The Oracle Cloud offers a complete suite of integrated applications for Sales, Service, Marketing, Human Resources, Finance, Supply Chain and Manufacturing, plus Highly Automated and Secure Generation 2 Infrastructure featuring the Oracle Autonomous Database. For more information about Oracle (NYSE: ORCL), please visit us at www.oracle.com.

Trademarks

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

Talk to a Press Contact

Bill Rundle

  • +1.650.506.1891

My Favorite Enterprise Blockchain Articles

David Haimes - Tue, 2019-05-14 07:47

For the past few years I have been working on Blockchain for Enterprises, and I get a lot of questions about where to get started.  There are a lot of complicated explanations about the technology of blockchain, but I try to talk about how Blockchain (or Distributed Ledger Technology) is different to traditional databases; where it can be useful and how it will be adopted.  If these things interest you too, then you will find the articles below a good starting point.  I’m thrilled that I have had articles published in some prestigious publications, I hope you enjoy them.  As always, I love feedback and discussions so please share your thoughts in the comments section below.

Forbes: 4 Real World Blockchain Use Cases

These four design patterns are a good way to categorize use cases and also stimulate ideas for use cases in your industry.

Channel Futures: Making Sense of Where Blockchain Can Impact Your Business

This is a more comprehensive (but very readable) explanation of the four patterns of use cases in a guest blog post I authored back in 2017.

Wall Street Journal: Why Blockchain Will Fundamentally Change Corporate Finance

This article captures a lot of important points in how back office functions will be impacted by Blockchain technology.

Database Trends and Applications: Why Permissioned Blockchain Technology Is Important to Enterprises

My article explains how blockchains are different to a database and why for some applications they are a better option.  It was exciting to have this highlighted on the cover of the print edition last year.

Forbes: What Will Spark The Blockchain Explosion?

Some thoughts on where we will see the enterprise uptakes and what factors are needed for the “Killer App” to evolve.

Bloomberg Accounting Blog: Lack of Consensus Reigns with Blockchain

I was interviewed for this article after presenting at a conference, I like that they opened with:

“one of the common bifurcations of blockchain types is between private and public blockchains, such as explained here in a blog on the AICPA website. David Haimes, believes this to be a “false dichotomy.”

The article is a good read and I get to explain the differences between Permissioned versus Permissionless Blockchain networks.

 

 

Categories: APPS Blogs

PVH Asia Limited Selects Oracle to Modernize the Customer Experience

Oracle Press Releases - Tue, 2019-05-14 07:30
Press Release
PVH Asia Limited Selects Oracle to Modernize the Customer Experience One of the world’s largest apparel companies, boasting TOMMY HILFIGER and CALVIN KLEIN, invests in retail technology to support growth

Redwood Shores, Calif.—May 14, 2019

PVH Asia Limited, a wholly owned subsidiary of PVH Corp. [NYSE: PVH], one of the world’s largest apparel companies, has selected Oracle Retail to modernize its customer experience and store technology. Its iconic brands include CALVIN KLEIN, TOMMY HILFIGER, Van Heusen and IZOD. PVH Asia will implement Oracle Retail Xstore Point-of-Service and Oracle Retail Customer Engagement to connect with the next generation of consumers. The solution will be rolled out in stores across China, Hong Kong, Macau, Taiwan, Singapore, Malaysia, South Korea, and Japan.

“PVH continues to experience extraordinary growth. As we compete and grow across Asia, we wanted to ensure our technology partner understands and supports local business requirements of a modern customer experience,” said Eileen Mahoney, executive vice president, chief information officer, PVH Corp. “After a competitive evaluation, Oracle emerged as the best choice to support our business.”

“We are honored to partner with PVH Asia. We recognize that retailers need to deliver added value to win favor with the next generation shoppers,” said Mike Webster, senior vice president, and general manager, Oracle Retail. “With a 360 view of the consumer, we can help PVH empower associates and allow them to deliver relevant and local offers.”

Contact Info
Kris Reeves
Oracle PR
+1.925.787.6744
kris.reeves@oracle.com
About Oracle Retail

Oracle is the modern platform for retail. Oracle provides retailers with a complete, open, and integrated platform for best-of-breed business applications, cloud services, and hardware that are engineered to work together. Leading fashion, grocery, and specialty retailers use Oracle solutions to accelerate from best practice to next practice, drive operational agility and refine the customer experience. For more information, visit our website at www.oracle.com/retail.

About Oracle

The Oracle Cloud offers a complete suite of integrated applications for Sales, Service, Marketing, Human Resources, Finance, Supply Chain and Manufacturing, plus Highly Automated and Secure Generation 2 Infrastructure featuring the Oracle Autonomous Database. For more information about Oracle (NYSE: ORCL), please visit us at www.oracle.com.

About PVH Corp.

PVH is one of the most admired fashion and lifestyle companies in the world. We power brands that drive fashion forward – for good. Our brand portfolio includes the iconic CALVIN KLEIN, TOMMY HILFIGER, Van Heusen, IZOD, ARROW, Speedo*, Warner’s, Olga and Geoffrey Beene brands, as well as the digital-centric True & Co. intimates brand. We market a variety of goods under these and other nationally and internationally known owned and licensed brands. PVH has over 38,000 associates operating in over 40 countries and $9.7 billion in annual revenues. That’s the Power of Us. That’s the Power of PVH.

*The Speedo brand is licensed for North America and the Caribbean in perpetuity from Speedo International Limited.

Trademarks

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

Talk to a Press Contact

Kris Reeves

  • +1.925.787.6744

Oracle Helps Organizations Improve Productivity Across Global Supply Chains

Oracle Press Releases - Tue, 2019-05-14 07:05
Press Release
Oracle Helps Organizations Improve Productivity Across Global Supply Chains New Oracle Supply Chain Management (SCM) Cloud logistics updates help improve responsiveness, optimize shipments and asset utilization, and improve productivity

Redwood Shores, Calif.—May 14, 2019

To help organizations design and operate efficient and agile supply chains, Oracle today announced a series of logistics management updates to Oracle Supply Chain Management (SCM) Cloud. The updates include a new logistics network modeling product and enhanced transportation management and global trade management capabilities. The latest innovations can help customers drive better business outcomes by enhancing supply chain responsiveness, optimizing shipments and asset utilization, and improving productivity across global supply chains.  

“Expectations are not only increasing, they also are constantly evolving. To meet these demands, organizations need customer-driven supply chains that deliver the agility required to rapidly respond,” said Derek Gittoes, vice president, SCM Product Strategy, Oracle. “Disruptions due to customer demand volatility, new product introductions, government regulation changes, and a host of other factors, leave supply chain professionals struggling to adapt. To eliminate this guessing game of how best to respond, we are giving our customers the insights they need to improve decision making and increase efficiency of logistics operations.”

To help organizations quickly and easily analyze and respond to logistics network changes, Oracle has added a new Logistics Network Modeling product to Oracle Logistics Cloud. The new product enables customers to analyze logistics networks using real-time, operational data—all within the context of their own cloud environment. Unlike point solutions that often inaccurately model real-world conditions, Logistics Network Modeling analyzes real production data in the context of a customer’s unique rules, policies, and planning algorithms to show the true impact of change on logistics operations. This enables Oracle customers to enhance decision making and quickly improve agility and profitability.

“With global trade policies in flux, organizations of all sizes are struggling to make sense of changing regulations and unstable global duty rates,” said Gittoes. “To help our customers combat global trade instability and improve efficiency, while lowering costs and minimizing risk, we have introduced a series of updates to Oracle Transportation Management Cloud Service and Oracle Global Trade Management Cloud Service. The latest updates can help our customers reduce risk and take advantage of preferential trade contracts and agreements.”

To help customers lower supply chain costs, reduce supply chain risk, and adapt to evolving trade regulations, Oracle has updated Oracle Transportation Management Cloud and Oracle Global Trade Management Cloud. The latest updates enable customers to better support trade compliance and customs processes, such as country of origin management, or certificate management associated with trade agreements. The net result is more effective use of preferential trade agreements, which can lead to lower supply chain costs and reduced risk.

"Goods are traveling further and faster than ever before, and as supply chains flatten the globe, understanding the complexities and interferences that may arise in real-time can be a game changer for those orchestrating the operations,” said Victoria Brown, research director of Global Supply Chain at IDC. “Furthermore, being able to not only manage those interruptions, but also the cross-border considerations at hand, expedites and simplifies global operations management for shippers helping them take back control of their cargo and freight."

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

Contact Info
Bill Rundle
Oracle
+1.650.506.1891
bill.rundle@oracle.com
About Oracle

The Oracle Cloud offers a complete suite of integrated applications for Sales, Service, Marketing, Human Resources, Finance, Supply Chain and Manufacturing, plus Highly Automated and Secure Generation 2 Infrastructure featuring the Oracle Autonomous Database. For more information about Oracle (NYSE: ORCL), please visit us at www.oracle.com.

Trademarks

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

Talk to a Press Contact

Bill Rundle

  • +1.650.506.1891

Oracle Helps Comms Providers Intelligently Launch New Services

Oracle Press Releases - Tue, 2019-05-14 07:00
Press Release
Oracle Helps Comms Providers Intelligently Launch New Services New AI-based tech fuels the creation of more relevant, impactful digital offers for customers

Redwood Shores, Calif.—May 14, 2019

Customers today simply expect more from their communications service providers (CSPs). Instead of buying expensive broad scale offerings, customers want CSPs to propose services, devices, plans and pricing that best meet their unique lifestyle or business needs.

To meet this demand, Oracle has developed the Oracle Enterprise Catalog for Communications, as part of the Oracle Digital Experience for Communications solution. Oracle Enterprise Catalog for Communications empowers CSPs to easily launch new service offers and tailor them to specific customer micro-segments to improve engagement. By providing a common and consistent definition of product information, Oracle Enterprise Catalog for Communications helps CSPs simplify and streamline offer introduction across sales, ecommerce, ordering, fulfillment and billing.

For example, a CSP can quickly launch a compelling new digital content offer – one that might include music, video, 5G and an IoT-based digital assistant – by easily configuring its pricing, discounts and promotions for  various channels and fulfillment paths– all from one central platform. 

“At Oracle, data is simply part of our DNA,” said Rob Tarkoff, executive vice president and general manager, Oracle CX Cloud. “We use the industry’s richest dataset available to accurately anticipate customer needs, then leverage this in our innovative CX cloud applications like Oracle Enterprise Catalog for Communications. This enables CSPs to rapidly design and launch compelling AI-recommended offers that target the right customers, in just the right way, and at just the right time to maximize uptake, revenue, customer satisfaction and loyalty.”

A New Era of Tailored Communications Services

Expected to be generally available in Oracle’s fiscal year 2020, Oracle Enterprise Catalog for Communications enables CSPs to rapidly create offer bundles of existing products, commercial terms and conditions, as well as the creation of completely new product offerings.

As part of the Oracle Digital Experience for Communications solution, Oracle Enterprise Catalog for Communications gives service providers in communications and media the means to accelerate their digital business. Oracle Enterprise Catalog for Communications is a key component within Oracle’s intelligent, holistic offer introduction framework that enables higher commercial success with fewer offer launches. It starts with offer ideation, leveraging social, marketing and intelligent customer insights to generate relevant, personalized and timely offers for specific customer audiences. Once the offers are designed by Oracle Enterprise Catalog for Communications, the framework then enables the launch and presentation of offers through customers’ channels of choice, using AI to increase offer uptake and providing CSPs with real time offer analytics.

“As CSPs look to launch and expand new 5G and IoT-based digital services increasingly with ecosystem partners, it is essential they be able to accurately determine which offers are most likely to drive adoption with specific audiences,” said John Abraham, principal analyst, research, Analysys Mason. “But to drive profitable revenue growth, CSPs also need the operational agility to define and synchronize their product and offer details – what they sell, what gets ordered and delivered and what gets billed – across all participating systems.”

Embracing the Larger Comms Ecosystem through Open Standards

Oracle Enterprise Catalog for Communications is based on the TM Forum canonical communications model and supports full offer lifecycle management. As an enterprise catalog, Oracle Enterprise Catalog for Communications is pre-integrated with Oracle’s sales, commerce, fulfillment and billing capabilities and Oracle Siebel CRM for ease of importing catalog information. Oracle Enterprise Catalog for Communications also integrates with external participating systems using the standards-based TM Forum Open API as part of a broader concept to cash to care solution.

“With this announcement and as a signatory to the TM Forum Open API manifesto, Oracle is further demonstrating the industry value of adopting extensible open APIs to expose and consume a catalog of capabilities to drive innovation and monetization of new products and services,” said George Glass, vice president architecture & APIs, TM Forum. “The adoption of these APIs enables companies like Oracle to execute at digital speeds and capitalize on the opportunities presented by an increasingly connected world.”

Contact Info
Katie Barron
Oracle
+1.202.904.1138
katie.barron@oracle.com
Amy Dalkoff
Hill+Knowlton Strategies
+1.312.255.3078
amy.dalkoff@hkstrategies.com
About Oracle Communications

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

To learn more about Oracle Communications industry solutions, visit: Oracle Communications LinkedIn, or join the conversation at Twitter @OracleComms.

About Oracle

The Oracle Cloud offers a complete suite of integrated applications for Sales, Service, Marketing, Human Resources, Finance, Supply Chain and Manufacturing, plus Highly Automated and Secure Generation 2 Infrastructure featuring the Oracle Autonomous Database. For more information about Oracle (NYSE: ORCL), please visit us at www.oracle.com.

Trademarks

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

Safe Harbor

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

Talk to a Press Contact

Katie Barron

  • +1.202.904.1138

Amy Dalkoff

  • +1.312.255.3078

Rising Star in Digital Telco Market Calls on Oracle

Oracle Press Releases - Tue, 2019-05-14 07:00
Press Release
Rising Star in Digital Telco Market Calls on Oracle Circles.Life deploys Oracle to monetize digital telco and lifestyle services

Redwood Shores, Calif.—May 14, 2019

Asia’s first fully digital telco, Circles.Life is working with Oracle to give power back to the customers and lead innovation in the digital industry. Oracle’s monetization engine empowers Circles.Life’s customers with the freedom to control their telco needs and customize their plans directly on the Circles.Life app.

As the company plans to expand internationally and create more digital lifestyle products, Circles.Life sought a solution to support convergent charging and policy. The company selected Oracle for its ability to scale with even the most complex digital offerings and high-performance infrastructure. Gold level member of Oracle PartnerNetwork (OPN), Covalense Technologies led the implementation based on its proven deployment experience and track record success.

“Our vision is to revolutionize the telco industry by giving our customers unprecedented control of their telco and digital experience,” said Changez Khan, Circles.Life’s head of telco systems engineering. “Oracle helps us to automate our telco systems and gives a differentiated platform so we can create various digital services beyond telco across geographies.”

The monetization capabilities of Oracle’s Digital Experience for Communications solution, powered by Oracle Communications’ Billing and Revenue Management Elastic Charging Engine and Oracle Communications Policy Management, provides a scalable and future-proof solution that enables Circles.Life to monetize voice, messaging and data services.

“In today’s digital age, consumers have come to expect simplicity, personalization and complete control over their services,” said Doug Suriano, senior vice president and general manager of Oracle Communications. “Together with our partner Covalense, we are proud to have enabled Circles.Life to deliver exactly that, by leading the way in taking digital experience to the next level with their innovative digital telco products.”

Contact Info
Katie Barron
Oracle
+1.202.904.1138
katie.barron@oracle.com
Amy Dalkoff
Hill+Knowlton Strategies
+1.312.255.3078
amy.dalkoff@hkstrategies.com
About Oracle Communications

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

To learn more about Oracle Communications industry solutions, visit: Oracle Communications LinkedIn, or join the conversation at Twitter @OracleComms.

About Oracle

The Oracle Cloud offers a complete suite of integrated applications for Sales, Service, Marketing, Human Resources, Finance, Supply Chain and Manufacturing, plus Highly Automated and Secure Generation 2 Infrastructure featuring the Oracle Autonomous Database. For more information about Oracle (NYSE: ORCL), please visit us at www.oracle.com.

About Circles.Life

Circles.Life was born with a vision to revolutionize the telco industry by giving power back to customers. Circles.Life applies a cloud-based business model to automate telco systems and delivers a highly customizable mobile service that users can manage through the Circles.Life app. Since its launch in 2016, Circles.Life has become the fastest-growing telco in Singapore. The company’s ambition is to expand to more countries and create a highly personalized digital service that goes beyond telco.

Trademarks

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

Talk to a Press Contact

Katie Barron

  • +1.202.904.1138

Amy Dalkoff

  • +1.312.255.3078

Austrian Service Provider Evolves Digital Offerings with Oracle

Oracle Press Releases - Tue, 2019-05-14 07:00
Press Release
Austrian Service Provider Evolves Digital Offerings with Oracle ORS Group taps Oracle Communications to modernize, monetize and manage content delivery

Redwood Shores, Calif.—May 14, 2019

Service providers in the media industry must boost revenue while also developing new digital offerings to meet changing customer demands. As ORS Group evolved from a network operator to a digital content gateway, it needed to enable the delivery of modern TV and radio solutions via terrestrial, satellite, cable and IP networks. Leveraging the Oracle Digital Experience for Communications platform, ORS Group will be able to get products to market faster, increase operational agility, and lower the cost of customer service for providers delivering digital content.

“As we support the continued market and technology innovations in the distribution of digital content, ORS needs both flexible technology and trusted partners who can help us navigate the waves of change,” said Michael Wagenhofer, chief executive officer, ORS. “The Oracle Digital Experience for Communications platform provides us a complete, agile solution to support our core business, enabling flexibility, rapid product introduction and fast solution configuration as we continue our digital transformation.”

The Oracle Digital Experience for Communications platform, featuring Oracle Communications Billing and Revenue Management, provides an enterprise-grade subscription management engine for digital, media and 5G services. The platform has been proven to scale in real-time across even the most challenging industries and business models, spanning both B2B and B2C. Coupled with Oracle Service Cloud, another key element of the platform, ORS will be able to help its users better serve and understand their customers and quickly deliver the right answers to their questions through their preferred service channels.

As the Oracle solution is delivered via the Oracle Cloud and managed by Oracle Communications Consulting, ORS will be able to free up valuable IT resources and benefit from comprehensive ongoing updates that are provided standard in this cloud solution.

“As enterprises and service providers shift to match market demands and reinvent themselves as digital service providers, they’re seeking deeper insight about their customers and means to engage them via new digital channels,” said Doug Suriano, senior vice president and general manager of Oracle Communications. “To achieve this, focused media service providers, such as ORS and the biggest providers alike need to engage the market in a truly ‘digital’ manner through simplification of process, organization and systems that then enable automation for scale and efficiency.”

Contact Info
Katie Barron
Oracle
+1.202.904.1138
katie.barron@oracle.com
Amy Dalkoff
Hill+Knowlton Strategies
+1.312.255.3078
amy.dalkoff@hkstrategies.com
About Oracle Communications

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

To learn more about Oracle Communications industry solutions, visit: Oracle Communications LinkedIn, or join the conversation at Twitter @OracleComms.

About Oracle

The Oracle Cloud offers a complete suite of integrated applications for Sales, Service, Marketing, Human Resources, Finance, Supply Chain and Manufacturing, plus Highly Automated and Secure Generation 2 Infrastructure featuring the Oracle Autonomous Database. For more information about Oracle (NYSE: ORCL), please visit us at www.oracle.com.

Trademarks

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

About the ORS Group

The ORS Group was formed in 2005 from ORF’s broadcast engineering services and consists of ORS (Österreichische Rundfunksender GmbH & Co KG) and its subsidiary ORS comm (ORS comm GmbH & Co KG).

The Group has taken advantage of the digital transformation and evolved from a transmitter network operator to a “digital content gateway”. With its digital infrastructures, it guarantees content providers the realisation of modern TV and radio solutions via terrestrial, satellite, cable and IP.

For further information www.ors.at

Talk to a Press Contact

Katie Barron

  • +1.202.904.1138

Amy Dalkoff

  • +1.312.255.3078

ACEs at Riga DevDays - May 29-31

OTN TechBlog - Tue, 2019-05-14 05:00

If you find yourself wandering the Baltic states late in May, why not make your way to Riga, Latvia and drop in on the Riga Dev Days? Held May 29-31 at the Cinema Kino Citadele in Riga, the 3-day DevDays event features 40 speakers, including these members of the Oracle ACE Program.

Oracle ACE Director Christian AntogniniChristian Antognini
Senior Principal Consultant and Partner, Trivadis AG
Monte Carasso, Switzerland

 

Oracle ACE Director Martin BachMartin Bach
Principal Consultant, Accenture Enkitec Group
Germany

 

Oracle ACE Director Heli HelskyahoHeli Helskyaho
CEO, Miracle Finland Oy
Finland

 

Oracle ACE Director Oren NakdimonOren Nakdimon
Database Expert, Moovit
Acre, Israel

 

Oracle ACE Direcctor Franck PachotFranck Pachot
Data Engineer, CERN
Lausanne, Switzerland

 

Oracle ACE Øyvind IseneØyvind Isene
Consultant, Sysco AS
Oslo, Norway

 

Oracle ACE Piet De VisserPiet De Visser
Independent Oracle Database Consultant
The Hague, Netherlands

 
Related Resouorces

Hash Keys and Security

Anthony Shorten - Mon, 2019-05-13 20:11

One of the features that has been changed over the last few releases of the Oracle Utilities Application Framework has been security. To keep up with security requirements across the industry, the Oracle Utilities Application Framework utilizes the security features of the infrastructure (Operating System, Oracle WebLogic and Oracle Database) as well as provide inbuilt security capabilities. One of the major capabilities is the support for Hash Keys on the user identity.

On the user object, there is a hash key that is managed by the Oracle Utilities Application Framework. The goal of this hash key is to detect any unauthorized changes to the user identity and prevent users from being used after an unauthorized change has been done. From an Oracle Utilities Application Framework point of view, an unauthorized change is a change that is done without going through the user object itself. For example, if you issued an UPDATE statement against the user tables directly, that did not go through the user object. That is an example of an unauthorized change.

When a user record is accessed, for example at login time, the Oracle Utilities Application Framework recalculates the hash key and compares that against the stored hash key. If they match, then the user is authorized, using the authorization model, to access the product. If the hash key does not match, then the user record has been compromised and the user action is rejected. In the case of a login, the user is refused access to the product.

The log will contain the message:

User security hash doesn't match for userid

From time to time we get customers reporting issues with these same characteristics. In most cases, this is caused by a number of practices:

  • User Object Updated Directly. Some implementations update the user object via direct SQL for a particular reason. This technique is discouraged bypasses the business rules configured for the user object within the product. We recommend that customers update the user object via the provided methods to prevent the user becoming recognized as compromised. The user object is protected by the authentication and authorization model used.
  • Encryption Key has been changed. At some sites, the encryption key is rotated on a regular basis. When this happens, the hash key becomes stale and needs to be rebuilt to reflect the new key.  

These are the only two use cases where the hash key becomes invalid. So what can be done about it? Well there are two techniques that are suggested to resolve this issue:

Note: The utility will set all the hash's not just the invalid ones.

It is recommended not to alter the User Object directly without going through the user object to avoid security hash issues.

Top time-consuming predicates from ASH

XTended Oracle SQL - Mon, 2019-05-13 15:42

Sometimes it might be useful to analyze top time-consuming filter and access predicates from ASH, especially in cases when db load is spread evenly enough by different queries and top segments doesn’t show anything special, except usual things like “some tables are requested more often than others”.
Of course, we can start from analysis of SYS.COL_USAGE$: col_usage.sql

col_usage.sql

col owner format a30
col oname format a30 heading "Object name"
col cname format a30 heading "Column name"
accept owner_mask prompt "Enter owner mask: ";
accept tab_name prompt "Enter tab_name mask: ";
accept col_name prompt "Enter col_name mask: ";

SELECT a.username              as owner
      ,o.name                  as oname
      ,c.name                  as cname
      ,u.equality_preds        as equality_preds
      ,u.equijoin_preds        as equijoin_preds
      ,u.nonequijoin_preds     as nonequijoin_preds
      ,u.range_preds           as range_preds
      ,u.like_preds            as like_preds
      ,u.null_preds            as null_preds
      ,to_char(u.timestamp, 'yyyy-mm-dd hh24:mi:ss') when
FROM   
       sys.col_usage$ u
     , sys.obj$       o
     , sys.col$       c
     , all_users      a
WHERE  a.user_id = o.owner#
AND    u.obj#    = o.obj#
AND    u.obj#    = c.obj#
AND    u.intcol# = c.col#
AND    a.username like upper('&owner_mask')
AND    o.name     like upper('&tab_name')
AND    c.name     like upper('&col_name')
ORDER  BY a.username, o.name, c.name
;
col owner clear;
col oname clear;
col cname clear;
undef tab_name col_name owner_mask;

[collapse]

But it’s not enough, for example it doesn’t show predicates combinations. In this case we can use v$active_session_history and v$sql_plan:

Top 50 predicates

with 
 ash as (
   select 
      sql_id
     ,plan_hash_value
     ,table_name
     ,alias
     ,ACCESS_PREDICATES
     ,FILTER_PREDICATES
     ,count(*) cnt
   from (
      select 
         h.sql_id
        ,h.SQL_PLAN_HASH_VALUE plan_hash_value
        ,decode(p.OPERATION
                 ,'TABLE ACCESS',p.OBJECT_OWNER||'.'||p.OBJECT_NAME
                 ,(select i.TABLE_OWNER||'.'||i.TABLE_NAME from dba_indexes i where i.OWNER=p.OBJECT_OWNER and i.index_name=p.OBJECT_NAME)
               ) table_name
        ,OBJECT_ALIAS ALIAS
        ,p.ACCESS_PREDICATES
        ,p.FILTER_PREDICATES
      -- поля, которые могут быть полезны для анализа в других разрезах:
      --  ,h.sql_plan_operation
      --  ,h.sql_plan_options
      --  ,decode(h.session_state,'ON CPU','ON CPU',h.event) event
      --  ,h.current_obj#
      from v$active_session_history h
          ,v$sql_plan p
      where h.sql_opname='SELECT'
        and h.IN_SQL_EXECUTION='Y'
        and h.sql_plan_operation in ('INDEX','TABLE ACCESS')
        and p.SQL_ID = h.sql_id
        and p.CHILD_NUMBER = h.SQL_CHILD_NUMBER
        and p.ID = h.SQL_PLAN_LINE_ID
        -- если захотим за последние 3 часа:
        -- and h.sample_time >= systimestamp - interval '3' hour
   )
   -- если захотим анализируем предикаты только одной таблицы:
   -- where table_name='&OWNER.&TABNAME'
   group by 
      sql_id
     ,plan_hash_value
     ,table_name
     ,alias
     ,ACCESS_PREDICATES
     ,FILTER_PREDICATES
)
,agg_by_alias as (
   select
      table_name
     ,regexp_substr(ALIAS,'^[^@]+') ALIAS
     ,listagg(ACCESS_PREDICATES,' ') within group(order by ACCESS_PREDICATES) ACCESS_PREDICATES
     ,listagg(FILTER_PREDICATES,' ') within group(order by FILTER_PREDICATES) FILTER_PREDICATES
     ,sum(cnt) cnt
   from ash
   group by 
      sql_id
     ,plan_hash_value
     ,table_name
     ,alias
)
,agg as (
   select 
       table_name
      ,'ALIAS' alias
      ,replace(access_predicates,'"'||alias||'".','"ALIAS".') access_predicates
      ,replace(filter_predicates,'"'||alias||'".','"ALIAS".') filter_predicates
      ,sum(cnt) cnt
   from agg_by_alias 
   group by 
       table_name
      ,replace(access_predicates,'"'||alias||'".','"ALIAS".') 
      ,replace(filter_predicates,'"'||alias||'".','"ALIAS".') 
)
,cols as (
   select 
       table_name
      ,cols
      ,access_predicates
      ,filter_predicates
      ,sum(cnt)over(partition by table_name,cols) total_by_cols
      ,cnt
   from agg
       ,xmltable(
          'string-join(for $c in /ROWSET/ROW/COL order by $c return $c,",")'
          passing 
             xmltype(
                cursor(
                   (select distinct
                       nvl(
                       regexp_substr(
                          access_predicates||' '||filter_predicates
                         ,'("'||alias||'"\.|[^.]|^)"([A-Z0-9#_$]+)"([^.]|$)'
                         ,1
                         ,level
                         ,'i',2
                       ),' ')
                       col
                    from dual
                    connect by 
                       level<=regexp_count(
                                 access_predicates||' '||filter_predicates
                                ,'("'||alias||'"\.|[^.]|^)"([A-Z0-9#_$]+)"([^.]|$)'
                              )
                   )
               ))
          columns cols varchar2(400) path '.'
       )(+)
   order by total_by_cols desc, table_name, cnt desc
)
select 
   table_name
  ,cols
  ,sum(cnt)over(partition by table_name,cols) total_by_cols
  ,access_predicates
  ,filter_predicates
  ,cnt
from cols
where rownum<=50
order by total_by_cols desc, table_name, cnt desc;

[collapse]

As you can see it shows top 50 predicates and their columns for last 3 hours. Despite the fact that ASH stores just sampled data, its results are representative enough for high-load databases.
Just few details:

  • Column “COLS” shows “search columns”, and total_by_cols – their number of occurrences
  • I think it’s obvious, that this info is not unambiguous marker of the problem, because for example few full table scans can misrepresent the statistics, so sometimes you will need to analyze such queries deeper (v$sqlstats,dba_hist_sqlstat)
  • We need to group data by OBJECT_ALIAS within SQL_ID and plan_hash_value, because in case of index access with lookup to table(“table access by rowid”) some predicates are in the row with index access and others are in the row with table access.

Depending on the needs, we can modify this query to analyze ASH data by different dimensions, for example with additional analysis of partitioning or wait events.

Categories: Development

OIM/OIG – IDCS Connector Integration : [Troubleshooting] InvalidCredentialException: HTTP 401 Error : User not authorized to execute service

Online Apps DBA - Mon, 2019-05-13 10:16

[Solved] OIM/OIG-IDCS Integration Issue because of wrong IDCS Service End Point Error: IAM-1020021 Unable to execute job : IDCS Group Lookup Reconciliation org.identityconnectors.framework.common.exceptions.InvalidCredentialException: HTTP 401 Error : User not authorized to execute service. If you are integrating OIM/OIG to IDCS using IDCS connector then make sure you read this post as there is documentation gap/ Error on […]

The post OIM/OIG – IDCS Connector Integration : [Troubleshooting] InvalidCredentialException: HTTP 401 Error : User not authorized to execute service appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Oracle Again a Leader in Gartner Magic Quadrant for Enterprise Integration Platform as a Service

Oracle Press Releases - Mon, 2019-05-13 07:00
Press Release
Oracle Again a Leader in Gartner Magic Quadrant for Enterprise Integration Platform as a Service Report solidifies Oracle’s leadership in execution and vision for enterprise customers

Redwood Shores, Calif.—May 13, 2019

For the third straight year, Oracle was named a Leader in Gartner’s 2019 “Magic Quadrant for Enterprise Integration Platform as a Service (iPaaS)” report.

iPaaS offerings are crucial for the modern enterprise to adopt hybrid digital transformation strategies, making this recognition a testament to Oracle’s continued success in delivering value to its large enterprise customers.

“Successfully transforming into a digital business requires putting into place the foundation of agile connectivity spanning any combination of cloud-native and on-premises,” said Bruce Tierney, director of product marketing for Integration, Oracle. “Being recognized as a Leader for the third year in a row demonstrates our ability to help customers innovate now and in the future.”

According to the report, Oracle’s strong global presence is a major benefit for end users. Oracle’s broad network enables them to use Oracle Integration Cloud locally, whether directly or through Oracle’s SaaS and PaaS channels, almost anywhere in the world. Its offerings in PaaS, IaaS, and SaaS technology sectors make Oracle one of the most cohesive and versatile enterprise iPaaS suites on the market.

Oracle’s iPaaS services include Oracle Integration Cloud and Oracle SOA Cloud Service and eliminate barriers between business applications through a combination of machine learning, embedded best-practice guidance, pre-built integration, and process automation. Oracle Integration Cloud is an easy to use and powerful integration platform targeting ad hoc integrators with tools such as process automation, while Oracle SOA Cloud delivers a high-control platform for specialist integrators. With more than 100 adapters, customers can quickly integrate and scale Oracle, third-party, and on-premises applications, APIs, people and devices. Additionally, Oracle has many other cross-PaaS offerings that can be combined with Oracle’s iPaaS services to deliver greater productivity. Those services include data integration to support real-time data streaming, batch data processing, and enterprise data quality and governance; Oracle API Platform Cloud Service for API first design and management; and Oracle Internet of Things (IoT) Cloud Service for IoT integration. Oracle API Platform Cloud, leveraging the unique API-first design tool from Apiary that is used by over 300,000 developers and 400,000 APIs, is designed to eliminate the complexities associated with transforming on-premises API solutions into the cloud so companies can thrive in the digital economy.

Download a complimentary copy of Gartner’s 2019 "Magic Quadrant for Enterprise Integration Platform as a Service" here.

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.

Contact Info
Nicole Maloney
Oracle
+1.650.506.0806
nicole.maloney@oracle.com
About Oracle

The Oracle Cloud offers a complete suite of integrated applications for Sales, Service, Marketing, Human Resources, Finance, Supply Chain and Manufacturing, plus Highly Automated and Secure Generation 2 Infrastructure featuring the Oracle Autonomous Database. For more information about Oracle (NYSE: ORCL), please visit us at www.oracle.com.

Trademarks

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

Talk to a Press Contact

Nicole Maloney

  • +1.650.506.0806

Partner Webcast – Oracle Visual Builder Cloud Service: Web and Mobile App Development for all

Oracle Visual Builder focuses on simplifying development by providing a visual approach to application development and publishing. As a visual and declarative cloud environment it allows developing...

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

EM13.3 Directory Structures

Michael Dinh - Sun, 2019-05-12 09:41

Currently, I am preparing POC to migrate OMS 13.3 from OEL6 to OEL7 and wanted a high level overview of the installation.

[oracle@MGOEM ~]$ cat .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

export PATH=$PATH:$HOME/bin
export DISPLAY=127.0.0.1:10.0

export ORACLE_BASE=/u01/app/oracle
export AGENT_BASE=$ORACLE_BASE/agent

export AGENT_HOME=$AGENT_BASE/agent_13.3.0.0.0
export EM_INSTANCE_BASE=$ORACLE_BASE/gc_inst
export OMS_INSTANCE_BASE=$EM_INSTANCE_BASE
export OHS=$EM_INSTANCE_BASE/user_projects/domains/GCDomain/servers/ohs1

### Starting from 13cR1, Oracle home (or OMS home) refers to the Middleware home.
export ORACLE_HOME=$ORACLE_BASE/middleware
export MW_HOME=$ORACLE_HOME
export OMS_HOME=$ORACLE_HOME
[oracle@MGOEM ~]$

Overview of the Directories Created for OMS Installation.
The OMS instance base directory (typically, gc_inst) is maintained outside the middleware home

[oracle@MGOEM ~]$ cd $MW_HOME; pwd; ls
/u01/app/oracle/middleware
allroot.sh   common               embip          ldap           OMSPatcher     plsql                root.sh     ucp
asr          create_header.log    gccompliance   lib            OPatch         plugins              slax        user_projects
bi           crs                  has            logs           oracle_common  plugins_common       soa         webgate
bin          css                  install        network        oracore        postjava_header.log  sqlplus     wlserver
bmp          disc                 instantclient  nls            oraInst.loc    precomp              srvm        xdk
cfgtoollogs  doc                  inventory      ocm            ord            rdbms                stage
clone        domain-registry.xml  jdbc           ohs            oui            relnotes             sysman
coherence    em                   jlib           omscarespfile  perl           response             thirdparty
[oracle@MGOEM middleware]$

Overview of the Directories Created for Management Agent Installation (Central Agent).
Agent base directory for the central agent (Management Agent installed with the OMS).

[oracle@MGOEM middleware]$ cd $AGENT_BASE; pwd; ls
/u01/app/oracle/agent
agent_13.3.0.0.0  agent_inst  agentInstall.rsp
[oracle@MGOEM agent]$

Agent home that is within the agent base directory.

[oracle@MGOEM agent]$ cd $AGENT_HOME; pwd; ls
/u01/app/oracle/agent/agent_13.3.0.0.0
agent.rsp    EMStage        jdbc  jythonLib  OPatch         perl     replacebins.sh           sbin    xsds
bin          install        jdk   ldap       oracle_common  plugins  replacebins.sh.template  stage
cfgtoollogs  instantclient  jlib  lib        oraInst.loc    prereqs  root.sh                  sysman
config       inventory      js    ocm        oui            rda      root.sh.template         ucp
[oracle@MGOEM agent_13.3.0.0.0]$

The OMS instance base directory (typically, gc_inst) is maintained outside the middleware home.

[oracle@MGOEM agent_13.3.0.0.0]$ cd $OMS_INSTANCE_BASE; pwd; ls
/u01/app/oracle/gc_inst
em  user_projects
[oracle@MGOEM gc_inst]$

ORACLE_BASE

[oracle@MGOEM gc_inst]$  cd $ORACLE_BASE; pwd; ls
/u01/app/oracle
agent  bip  gc_inst  middleware  swlib
[oracle@MGOEM oracle]$

Inventory and Patches:

[oracle@MGOEM ~]$ cat /u01/app/oraInventory/ContentsXML/inventory.xml
<?xml version="1.0" standalone="yes" ?>
<!-- Copyright (c) 1999, 2015, Oracle. All rights reserved. -->
<!-- Do not modify the contents of this file by hand. -->
<INVENTORY>
<VERSION_INFO>
   <SAVED_WITH>13.8.0.0.0</SAVED_WITH>
   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME="oms13c1" LOC="/u01/app/oracle/middleware" TYPE="O" IDX="1"/>
<HOME NAME="agent13c1" LOC="/u01/app/oracle/agent/agent_13.3.0.0.0" TYPE="O" IDX="2"/>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>
[oracle@MGOEM ~]$

[oracle@MGOEM ~]$ $AGENT_HOME/OPatch/opatch lspatches
27839641;One-off
27369653;One-off
27244723;One-off
27074880;OPSS Bundle Patch 12.1.3.0.171124
26933408;One-off
25832897;One-off
25412962;
23519804;One-off
20882747;One-off
20442348;One-off
19982906;One-off
19345252;One-off
18814458;One-off
28042003;One-off
27419391;WLS PATCH SET UPDATE 12.1.3.0.180417
23527146;One-off
20741228;JDBC 12.1.3.1 BP1

OPatch succeeded.
[oracle@MGOEM ~]$

[oracle@MGOEM ~]$ $ORACLE_HOME/OPatch/opatch lspatches
27839641;One-off
27369653;One-off
27244723;One-off
27074880;OPSS Bundle Patch 12.1.3.0.171124
26933408;One-off
25832897;One-off
25412962;
23519804;One-off
20882747;One-off
20442348;One-off
19982906;One-off
19345252;One-off
18814458;One-off
28042003;One-off
27419391;WLS PATCH SET UPDATE 12.1.3.0.180417
23527146;One-off
20741228;JDBC 12.1.3.1 BP1

OPatch succeeded.
[oracle@MGOEM ~]$

[oracle@MGOEM ~]$ $ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 13.8.0.0.0
Copyright (c) 2019, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/middleware
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/middleware/oraInst.loc
OPatch version    : 13.8.0.0.0
OUI version       : 13.8.0.0.0
Log file location : /u01/app/oracle/middleware/cfgtoollogs/opatch/opatch2019-05-12_16-34-38PM_1.log


OPatch detects the Middleware Home as "/u01/app/oracle/middleware"

Lsinventory Output file location : /u01/app/oracle/middleware/cfgtoollogs/opatch/lsinv/lsinventory2019-05-12_16-34-38PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: MGOEM
ARU platform id: 226
ARU platform description:: Linux_AMD64

[oracle@MGOEM ~]$ cat /etc/oraInst.loc
inventory_loc=/u01/app/oraInventory
inst_group=oinstall
[oracle@MGOEM ~]$

[oracle@MGOEM ~]$ cat /u01/app/oracle/middleware/oraInst.loc
#Oracle Installer Location File Location
#Fri May 10 16:53:18 CEST 2019
inst_group=oinstall
inventory_loc=/u01/app/oraInventory
[oracle@MGOEM ~]$

Reference:
DIRECTORY STRUCTURE AND LOCATIONS OF IMPORTANT TRACE AND LOG FILES OF ENTERPRISE MANAGER CLOUD CONTROL 13C

Overview of the Directories Created for an Enterprise Manager System

Create Mount Filesystem for Vagrant VirtualBox

Michael Dinh - Sat, 2019-05-11 09:41

Once again, I am using oravirt boxes.

If you just want to create the machine, and not run the provisioning step run this:

vagrant up

Since I don’t know ansible, it was much simpler to do the work manually.

Oracle Linux Server release 7.3

Review disks:

[root@MGOEM ~]# fdisk -l /dev/sd*

Disk /dev/sda: 52.4 GB, 52428800000 bytes, 102400000 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x000979b6

   Device Boot      Start         End      Blocks   Id  System
/dev/sda1   *        2048     2099199     1048576   83  Linux
/dev/sda2         2099200   102399999    50150400   8e  Linux LVM

Disk /dev/sda1: 1073 MB, 1073741824 bytes, 2097152 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes


Disk /dev/sda2: 51.4 GB, 51354009600 bytes, 100300800 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes

### Disk is not partitioned since there are no # for device /dev/sdb and no Filesystem
Disk /dev/sdb: 187.9 GB, 187904819200 bytes, 367001600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
[root@MGOEM ~]#

Create partition:

[root@MGOEM ~]# fdisk /dev/sdb
Welcome to fdisk (util-linux 2.23.2).

Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.

Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0x37a8a8de.

Command (m for help): n
Partition type:
   p   primary (0 primary, 0 extended, 4 free)
   e   extended
Select (default p):
Using default response p
Partition number (1-4, default 1):
First sector (2048-367001599, default 2048):
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-367001599, default 367001599):
Using default value 367001599
Partition 1 of type Linux and of size 175 GiB is set

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.
[root@MGOEM ~]#

Review disk: Linux System

[root@MGOEM ~]# fdisk -l /dev/sdb

Disk /dev/sdb: 187.9 GB, 187904819200 bytes, 367001600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x37a8a8de

   Device Boot      Start         End      Blocks   Id  System
/dev/sdb1            2048   367001599   183499776   83  Linux
[root@MGOEM ~]#

Create Filesystem:

[root@MGOEM ~]# mkfs.ext4 /dev/sdb1
mke2fs 1.42.9 (28-Dec-2013)
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
Stride=0 blocks, Stripe width=0 blocks
11468800 inodes, 45874944 blocks
2293747 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=2193620992
1400 block groups
32768 blocks per group, 32768 fragments per group
8192 inodes per group
Superblock backups stored on blocks:
        32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208,
        4096000, 7962624, 11239424, 20480000, 23887872

Allocating group tables: done
Writing inode tables: done
Creating journal (32768 blocks): done
Writing superblocks and filesystem accounting information: done

[root@MGOEM ~]#

Create and mount /u01:

[root@MGOEM ~]# mkdir -p /u01
[root@MGOEM ~]# mount /dev/sdb1 /u01
[root@MGOEM ~]#
[root@MGOEM ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
devtmpfs              2.8G     0  2.8G   0% /dev
tmpfs                 2.8G     0  2.8G   0% /dev/shm
tmpfs                 2.8G  8.4M  2.8G   1% /run
tmpfs                 2.8G     0  2.8G   0% /sys/fs/cgroup
/dev/mapper/ol-root    46G  2.1G   44G   5% /
/dev/sda1            1014M  167M  848M  17% /boot
vagrant               932G  283G  650G  31% /vagrant
sf_working            420G  139G  281G  33% /sf_working
media_patch           3.7T  513G  3.2T  14% /media/patch
media_swrepo          3.7T  513G  3.2T  14% /media/swrepo
sf_OracleSoftware     3.7T  513G  3.2T  14% /sf_OracleSoftware
media_shared_storage  932G  283G  650G  31% /media/shared_storage
tmpfs                 571M     0  571M   0% /run/user/1000
/dev/sdb1             173G   61M  164G   1% /u01
[root@MGOEM ~]#

Update /etc/fstab:

[root@MGOEM ~]# tail /etc/fstab
# Created by anaconda on Tue Apr 18 08:50:14 2017
#
# Accessible filesystems, by reference, are maintained under '/dev/disk'
# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info
#
/dev/mapper/ol-root     /                       xfs     defaults        0 0
UUID=ed2996e5-e077-4e23-83a5-10418226a725 /boot                   xfs     defaults        0 0
/dev/mapper/ol-swap     swap                    swap    defaults        0 0
/swapfile1              swap                    swap    defaults        0 0
/dev/sdb1               /u01                    ext4    defaults        1 1
[root@MGOEM ~]#

Oracle E-Business Suite (EBS) R12.2 Supported O.S. & Version : Certification Matrix

Online Apps DBA - Sat, 2019-05-11 06:42

Oracle E-Business Suite (EBS R12) can be installed on multiple Operating Systems (OS). Do you know what all OS are supported by the Oracle E-Business Suite (EBS) R12.2?* If Not, Then This Blog at https://k21academy.com/appsdba53 will help you in updating your skills by knowing: ✔ Operating System Certified With Oracle E-Business Suite (EBS) R12.2 ✔ […]

The post Oracle E-Business Suite (EBS) R12.2 Supported O.S. & Version : Certification Matrix appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Get Started with Autonomous Database and SQLcl in No Time Using Cloud Developer Image

OTN TechBlog - Fri, 2019-05-10 22:46

In this blog post, I describe how to use a free trial for Oracle Cloud and the recently released, Oracle Linux-based Cloud Developer Image to provision an Autonomous Transaction Processing Database and connect to it via SQLcl, all in a matter of minutes.

Think of the Cloud Developer Image as a Swiss army knife for Cloud developers. It has a ton of tools pre-installed, including:

Languages and Oracle Database Connectors
  • Java Platform Standard Edition (Java SE) 8
  • Python 3.6 and cx_Oracle 7
  • Node.js 10 and node-oracledb
  • Go 1.12
  • Oracle Instant Client 18.5
Oracle Cloud Infrastructure Client Tools
  • Oracle Cloud Infrastructure CLI
  • Python, Java, Go and Ruby Oracle Cloud Infrastructure SDKs
  • Terraform and Oracle Cloud Infrastructure Terraform Provider
  • Oracle Cloud Infrastructure Utilities
Other
  • Oracle Container Runtime for Docker
  • Extra Packages for Enterprise Linux (EPEL) via Yum
  • GUI Desktop with access via VNC Server

Here are the steps to provision a fresh Autonomous Transaction Processing Database ad connect to it via SQLcl.

Steps
  1. Launch the Cloud Developer Image from the Console
  2. Log to the instance running the Cloud Developer Image via ssh
  3. Set up OCI cli
  4. Create Autonomous Transaction Processing Database using CLI
  5. Download Wallet using CLI
  6. Install and configure SQLcl
  7. Connect to the database
1. Launch Cloud Developer Image

Log in to the Console. If you don't already have an ssh key pair, make sure you generate those firstby following the documentation. Launch the image by choosing Marketplace under Solutions, Platforms and Edge via the hamburger menu and clicking on Oracle Cloud Developer Image.

Click Launch Instance. Review the terms and conditions, click Launch Instance again. Paste in your ssh public key and click Create. Once the image is running, make a note of the IP address.

2. Set up the OCI client tools

Connect to your newly launched image from your local computer via ssh:

ssh -i <path to your ssh keys> opc@<IP address>

Once logged in, run oci setup config and follow the directions, providing the necessary OCIDs as described in the documentation on Required Keys and OCIDs.

$ oci setup config

Remember to upload your API key by following the instructions in the same documentation. If you accepted all the defaults during the oci client setup, the public key to upload is the output of this:

$ cat /home/opc/.oci/oci_api_key_public.pem 3. Create Autonomous Transaction Processing Database using the OCI CLI

A few of the next commands require the compartment-id as input so it's helpful to have a shorthand ready. Get its value and store it in an environment variable by calling the metadata service via oci-metadata

$ export C=`oci-metadata -g compartmentid --value-only`

Next, create the Autonomous Database. Be sure to provide your own admin password.

$ oci db autonomous-database create --compartment-id $C --db-name myadb --cpu-core-count 1 --data-storage-size-in-tbs 1 --admin-password "<YOUR PASSWORD>"

You should see output similar to:

{ "data": { "compartment-id": "ocid1.tenancy.oc1..aaaaaalskdjflsdkjflsdjflsdkflsjdflksjjfqntfkzizeeikohha4oa", "connection-strings": null, "cpu-core-count": 1, "data-storage-size-in-tbs": 1, "db-name": "myadb", "db-version": null, "db-workload": "OLTP", "defined-tags": {}, "display-name": "autonomousdatabase20190511024732", "freeform-tags": {}, "id": "ocid1.autonomousdatabase.oc1.iad.abuwcljrgx2kosiudoisdufoidsufoidsufodsfkdkdd3zprxjzsouzq", "license-model": "BRING_YOUR_OWN_LICENSE", "lifecycle-details": null, "lifecycle-state": "PROVISIONING", "service-console-url": null, "time-created": "2019-05-11T02:47:32.745000+00:00", "used-data-storage-size-in-tbs": null }, "etag": "a133c7fa" }

Export the Database ID in an environment variable as that will come in handy later.

export DB_ID=`oci db autonomous-database list --compartment-id $C | jq -r '.data[] | select( ."db-name" == "myadb" ).id'`

Wait for the Database to be in AVAILABLE state. You can check the database state with the following command. Initially, this command will return PROVISIONING

oci db autonomous-database get --autonomous-database-id $DB_ID | jq -r '.data["lifecycle-state"]' AVAILABLE

For me, it took about 6 minutes from for the database to be available after executing the create command.

Download Wallet using CLI $ oci db autonomous-database generate-wallet --autonomous-database-id $DB_ID --password <YOUR PASSWORD> --file wallet.zip

Set TNS_ADMIN and extract wallet.zip

$ export TNS_ADMIN="`cat /etc/ld.so.conf.d/oracle-instantclient.conf`/network/admin" $ sudo -E unzip ~/wallet.zip -d $TNS_ADMIN Install and configure SQLcl

Install SQLcl by temporarily enabling the ol7_ociyum_config repo. Then, run the sqlcl.sh that was installed in /etc/profile.d to add the sql command to your PATH.

$ sudo yum install -y --enablerepo=ol7_ociyum_config sqlcl $ source /etc/profile.d/sqlcl.sh

Start SQLcl in /nolog mode and point it to the wallet.zip you downloaded earlier using the set cloudconfig command.

$ sql /nolog SQLcl: Release 19.1 Production on Fri May 10 00:24:29 2019 Copyright (c) 1982, 2019, Oracle. All rights reserved. SQL> set cloudconfig /home/opc/wallet.zip Operation is successfully completed. Operation is successfully completed. Using temp directory:/tmp/oracle_cloud_config2842421108875448254 Connect to the database

Connect to your Autonomous database with the admin. For the service name, use one of the entries in $TNS_ADMIN/tnsnames.ora. Each ADB is created with a high, medium and low service.

SQL> connect admin/<YOUR PASSWORD>@myadb_high Connected. SQL> select sysdate from dual; SYSDATE --------- 11-MAY-19 SQL> Conclusion

The Oracle Linux-based Cloud Developer Image comes with wealth of developer tools pre-installed, reducing the time it takes to get started with Oracle Cloud and Autonomoud Database. In this blog post, I showed how you can provision an Autonomous Database and get connected to it in a matter of minutes. The fact that the Cloud Developer Image already has the important bits pre-installed, including OCI client tools an Oracle Instant Client, makes completing this task a breeze.

PLS-00436: implementation restriction error when using forall in update

Tom Kyte - Fri, 2019-05-10 19:26
I have a object as follows: create or replace type claims_only as object (fordnr varchar2(15),glaeubigernr number,fordergnr number); and I have a a collection as: create or replace type claims_only_collection as table of claims_only; I have a...
Categories: DBA Blogs

Wireguard: Status information / using the wg command

Dietrich Schroff - Fri, 2019-05-10 14:10

After the installation of wireguard on two servers i shut down the secondary server and after 4h i did the wg command:
root@zerberus:~# wg
interface: wg0
  public key: XXX=
  private key: (hidden)
  listening port: 46932

peer: YYY=
  endpoint: 192.168.178.54:35891
  allowed ips: 10.0.0.2/32
  latest handshake: 4 hours, 19 minutes, 2 seconds ago
  transfer: 348 B received, 436 B sent
With the "ip addr" command there is nothing really interesting:
root@zerberus:~# ip addr show wg0
5: wg0: mtu 1420 qdisc noqueue state UNKNOWN group default qlen 1000
    link/none
    inet 10.0.0.1/24 scope global wg0
       valid_lft forever preferred_lft forever
Just to get some information about the "wg" command:
root@zerberus:~# wg help
Usage: wg []

Available subcommands:
  show: Shows the current configuration and device information
  showconf: Shows the current configuration of a given WireGuard interface, for use with `setconf'
  set: Change the current configuration, add peers, remove peers, or change peers
  setconf: Applies a configuration file to a WireGuard interface
  addconf: Appends a configuration file to a WireGuard interface
  genkey: Generates a new private key and writes it to stdout
  genpsk: Generates a new preshared key and writes it to stdout
  pubkey: Reads a private key from stdin and writes a public key to stdout
You may pass `--help' to any of these subcommands to view usage.
and one more example:
root@zerberus:~# wg showconf wg0

[Interface]
ListenPort = 46932
PrivateKey = TTT=

[Peer]
PublicKey = XXX=
AllowedIPs = 10.0.0.2/32
Endpoint = 192.168.178.54:35891


Pages

Subscribe to Oracle FAQ aggregator