Feed aggregator

Standby Database for Reporting Purpose

Tom Kyte - Mon, 2018-10-15 14:46
Hi We are using 10.2.0.1.0 database and we intend to configure a standby database for reporting purpose. Could you guide us as to how can we achieve the above. Regards Abdul Wahid
Categories: DBA Blogs

Enabling TKPROF/TRACE on certain queries

Tom Kyte - Mon, 2018-10-15 14:46
Hey, Is there a way to enable TKPROF / TRACE on certain queries only. I have application with hundreds of queries. When we do load test using appdynamics(profiling tool) it shows certain simple queries like insert/update too slow (43 seconds,53 seco...
Categories: DBA Blogs

How can I get characters before and after '-OO' character in a sentence?

Tom Kyte - Mon, 2018-10-15 14:46
Hi Tom, I have a string like '000-O 1000 DENIS GRATTON TRANSPORT LTD-OO Profile Class-PHONE-25183', can I use oracle regular expression to get all characters before '-OO'? I am using Oracle 12c release 1 Kind Regards, Derek
Categories: DBA Blogs

Tutorial: Configuring Integrated SOA Gateway in Oracle E-Business Suite R12.1.3

Steven Chan - Mon, 2018-10-15 11:19

I have being receiving queries about configuring Oracle E-Business Suite Integrated SOA Gateway (ISG). ISG provides REST and SOAP based web service interfaces for public integration APIs registered in Oracle Integration Repository. Here's a quick video that walks through the configuration process:

What is in this tutorial?

In this tutorial, I follow the steps documented in Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.1.3 (MOS ID 556540.1). This is the main document which lists the required patches and steps to configure EBS R12.1.3 instance for Integrated SOA Gateway.

This tutorial has following major sections:

  • Applying Patches
  • Executing TXK script
  • Enabling ASADMIN user
  • Verifying ISG Setup

This tutorial talks about configuring ISG in single node of EBS R12.1.3. If your EBS R12.1.3 instance is configured with a load balancer, you will be required to perform additional steps mentioned in My Oracle Support Document 1081100.1.

References

Related Articles

 

Categories: APPS Blogs

3 Ways to Meet Oracle Advanced Customer Services at OpenWorld 2018

Chris Warticki - Mon, 2018-10-15 10:35

If you are attending Oracle OpenWorld 2018 in San Francisco this month, we invite you to connect with us and learn more about how Oracle Advanced Customer Services can help you and your business.

Here is where you can find us:

1. Learning Sessions

We will lead over a dozen sessions, discussing some of the top challenges businesses like yours face every day. Topics include:

  • Oracle Cloud Infrastructure: A Proven End-to-End Approach to IaaS
  • Break Down Barriers with DevOps to Accelerate Innovation
  • Protect Your Business and Your Data with Oracle Managed Security Services

2. Support Stars Bar

Come meet our experts and learn how we can help you both maximize and modernize your existing infrastructure. Share your business challenges with us and learn how we are helping customers solve these same issues every day.

3. Customer Welcome Center Demos

Join the experts demonstrating key services and capabilities of Oracle Advanced Customer Services. Learn firsthand how our flexible solutions support your innovation and business growth.

Join Us

Oracle OpenWorld 2018 is today's premier business and technology event that you won't want to miss. Oracle Advanced Customer Services will be there, ready to help you and your business achieve tomorrow’s business goals, today!

To learn more about Oracle Support and Services at Oracle OpenWorld visit: oracle.com/goto/openworldservices

To learn more about Oracle Advanced Customer Services, visit: oracle.com/acs

We look forward to seeing you there!

Faking Histograms

Jonathan Lewis - Mon, 2018-10-15 07:37

This is a short index of articles I’ve written on how to create the different types of histogram that the optimizer uses:

  • Faking a frequency histogram    How to create frequency histograms (using a numeric column for the example)
  • Histogram Tip  An example of creating a simple character-based frequency histogram (published in the IOUG Tips booklet 2014).
  • Faking a height-balanced histogram  How to create a height-balanced histogram (using a numeric column for the example).
  • Hybrid Fake: How to create a hybrid histogram (using a character column for the example).
  • Extended Histogram:  faking values into a histogram for a column group – only special because we need to derive the value stored.
  • Top frequency:  I haven’t yet worked out how to fake a Top Frequency histogram. Since it’s little more than a frequency histogram where the optimizer knows there’s a further small percentage (less than one bucketful) of other data, this doesn’t worry me; if necessary I’ll just create a “good enough” frequency histogram and set a suitable density for the remainder.

And a couple of miscellaneous things about histograms

  • Big number problem – older versions of Oracle (pre 12c) can go wrong with data values more than 15 digits long
  • Long strings problem – until 12c Oracle stored at most 32 bytes of a string in the endpoint_actual_value column.
  • Hybrid/Top-N problem – a bug, fixed in 12.2 with a patch for 12.1.
  • Upgrade threat – a step you need to take to upgrade from 11.2.0.3 if you have histograms on char() columns
  • Upgrade threat 2 (Oracle-L) – if you’ve got a big history of histograms then the upgrade from 11.2.0.3 (or earlier) could take a long time

 

[Q/A BLOG] Oracle GoldenGate 12c Q/A: Part III

Online Apps DBA - Mon, 2018-10-15 07:04

Are you learning GoldenGate and have some questions unanswered? Visit: https://k21academy.com/goldengate28 to go through some of the most commonly asked questions in our training and their answers. In this Blog we cover: ✔ The difference between CSN, SCN ✔How to get log from source & target ✔What are the areas monitoring required in Goldengate and […]

The post [Q/A BLOG] Oracle GoldenGate 12c Q/A: Part III appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Alshaya Partners with Oracle Cloud to Accelerate Growth and Expansion

Oracle Press Releases - Mon, 2018-10-15 07:00
Press Release
Alshaya Partners with Oracle Cloud to Accelerate Growth and Expansion Multinational Franchise Operator Selects Cloud Suite to Arm Associates with New Tools to Personalize Customer Experience

Redwood Shores, Calif.—Oct 15, 2018

A leading Middle East retail franchise operator, M.H. Alshaya Co., has teamed up with Oracle as part of an enterprise transformation to improve operational efficiency and build a foundation for future growth and innovation. Alshaya’s digital transformation will empower its associates by introducing retail best practices to create a more responsive and personalized customer service experience across its portfolio of recognized global brands.

For over 30 years Alshaya has been a pioneering force in retail as franchise operator of nearly 90 of the world’s best-known brands including H&M, Mothercare, Debenhams, American Eagle Outfitters, Victoria’s Secret, Starbucks, The Cheesecake Factory, Boots and Pottery Barn. This diverse brand portfolio has provided Alshaya with a footprint including more than 4,000 physical stores and 53,000 associates across the Middle East, North Africa and Europe.

To streamline omnichannel operations and support brand loyalty objectives, Alshaya will implement a suite of Oracle Retail, Oracle Customer Experience, and Oracle Cloud Applications. These solutions will be provisioned on Oracle Cloud Infrastructure solutions.

“Oracle is a proven, world-class retail solution provider with unmatched expertise and they will be a key partner in our transformation,” said Steve Marston, Chief Information Officer at M.H. Alshaya Co. “Alshaya has worked with Oracle for many years and we are delighted to extend our collaboration with them to modernize our operations, invest in our teams and foster future growth as we expand our omnichannel reach.”

Alshaya will work with Oracle Consulting Services to implement applications and cloud services across the portfolio. Alshaya associates will be empowered to segment and personalize the consumer experience and encourage loyalty with new customer relationship management capabilities. Updated operational and financial systems will accelerate growth as Alshaya continues to expand.

“Alshaya operates a complex global business model with an impressive brand portfolio. Our collaboration creates a unique opportunity to deliver long-term value for their customers,” said Mike Webster, Senior Vice President and General Manager, Oracle Retail. “Oracle is focused on innovation while uniquely helping our customers maintain a single view of customer, inventory, order and channel.”

Alshaya has selected a powerful, end-to-end modern retail solution from Oracle including:

  • Enabling a Modern Customer Experience with a Single View of Customer: Oracle Retail Xstore Point of Service, Oracle Retail Customer Engagement Cloud Service, Oracle Marketing Cloud and Oracle Service Cloud

  • Driving Operational Excellence with a Single View of Inventory: Oracle Retail Merchandise Operations Management suite with Oracle Retail Store Inventory Management

  • Modernizing Legacy Systems: Oracle Fusion Procurement Cloud, Oracle Talent Management Cloud and Oracle EPM Cloud

  • Delivering Innovation and Scale: Oracle Infrastructure as a Service, Oracle Platform as a Service, Oracle Integration Cloud Service, Oracle Mobile Cloud Service, Oracle API Platform Cloud Service

Contact Info
Matt Torres
Oracle
4155951584
matt.torres@oracle.com
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

About Oracle Retail

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

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

Matt Torres

  • 4155951584

Chegg Creates New Monetization Opportunities with Oracle Cloud

Oracle Press Releases - Mon, 2018-10-15 07:00
Press Release
Chegg Creates New Monetization Opportunities with Oracle Cloud Provider of digital services for students deploys Oracle Monetization Cloud to support flexible billing and revenue management, improve customer retention, and accelerate time to market

Redwood Shores Calif—Oct 15, 2018

Chegg, Inc., the Smarter Way to Student™, has deployed Oracle Monetization Cloud to enable innovative digital subscription services.

Chegg’s student-first, interconnected learning platform is transforming the way millions of students learn by reconnecting the link between learning and earning through tools and services that support students throughout their educational journey. Their mission is to help students save time, save money, and get smarter in order to improve the overall return on educational investment.

With Oracle Monetization Cloud, Chegg is able to offer students cross-product discounts, bundled services, free trials, and other pricing incentives to increase value to their student subscribers. The solution allows Chegg to reduce time to market for the introduction of new subscription products such as Chegg Math Solver, which went through configuration, testing and launch in just two weeks.

Chegg is also using Oracle Monetization Cloud to consolidate multiple products into a single bundle. Formerly, Chegg customers needed to buy separate subscriptions for each service –each with a separate bill. By supporting the new Chegg “Study Pack” Oracle Monetization Cloud empowers Chegg to simplify their operations, take advantage of cross-selling opportunities, and improve their subscribers’ experience of initiating and paying for their services.

“We were able to replace our homegrown billing system with Oracle Monetization Cloud in a matter of months, working closely with the Oracle Communications Consulting team to meet our projected launch date, to quickly offer students more value and a better experience” said Pritie Sharda, director of e-Commerce, at Chegg.

Oracle Monetization Cloud is integrated with Oracle NetSuite ERP to provide Chegg with a streamlined financial management solution.

“As businesses innovate to offer greater digital services, they require increasingly flexible monetization capabilities,” said Doug Suriano, senior vice president and general manager of Oracle Communications. “Chegg is leveraging Oracle Monetization Cloud to bring these services to market faster and provide a more appealing customer experience.”

Contact Info
Katie Barron
Oracle
+1.202.904.1138
katie.barron@oracle.com
Jamie Dowling
Burson Marsteller
+1.212.614.4214
jamie.dowling@bm.com
About Oracle Communications

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

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

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

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

Talk to a Press Contact

Katie Barron

  • +1.202.904.1138

Jamie Dowling

  • +1.212.614.4214

Consumer Energy Savings Hit Unprecedented 20TWh with Oracle Utilities Opower

Oracle Press Releases - Mon, 2018-10-15 07:00
Press Release
Consumer Energy Savings Hit Unprecedented 20TWh with Oracle Utilities Opower Efficiency programs save enough energy to power San Francisco households for a decade or three million Tesla Model 3s traversing the length of the equator

Redwood Shores, Calif.—Oct 15, 2018

Consumer households supported by Oracle Utilities Opower Energy Efficiency programs have reached more than 20-terawatt hours (TWh) in cumulative energy savings. This equates to enough energy to power San Francisco homes for 10 years, Spain for a month or three million Tesla Model 3s traversing the length of the equator. 

Learn what else 20 TWh in energy savings can power here.

The digital revolution has enabled consumers to better control everything from how they shop to how they ride to work. Until relatively recently, however, they lacked the ability to effectively manage their energy usage to lessen both their environmental footprint and monthly costs. Opower first introduced its consumer Energy Efficiency programs to the market in 2008. Just ten years later, the 20 TWh milestone is a testament to how utilities and their customers have embraced these programs and transformed their behaviors to significantly reduce energy emissions.

“Opower revolutionized residential energy efficiency by empowering consumers at every economic level to manage their energy usage with no additional cost,” said Rodger Smith, Senior Vice President and General Manager for Oracle Utilities. “Together, with our utility customers, we have given 15 million consumers access to actionable data that is enabling them to take charge of their energy consumption. With 20 TWh of savings, we have only scratched the surface of what’s possible. It is inspiring to imagine the impact these programs will continue to have in creating a more sustainable energy future for everyone.”

The Opower energy efficiency programs, including Home Energy Reports, are part of a larger Oracle Utilities demand-side management product suite that includes Peak Management, Proactive Alerts, and energy management web tools. Working in tandem, these solutions are designed to inform and motivate consumers to better control their home energy consumption and cost, while allowing utilities to proactively meet regulatory requirements, decrease the cost to serve, reduce call center volume, and improve customer satisfaction.

Exelon’s Utilities – Driving Energy Awareness and Efficiency for Millions of Customers

Exelon’s utility companies (Atlantic City Electric, BGE, ComEd, Delmarva Power, PECO and Pepco) are committed to helping their customers save energy and have been key innovators and collaborators in reaching the 20 TWh efficiency milestone. As part of their comprehensive Business Intelligence and Data Analytics strategy, the company is driving consumer engagement and conservation efforts with a multi-pronged approach that includes Opower Home Energy Report programs and the first application of behavioral science in demand response through Opower Peak Management.

Today, Exelon’s Home Energy Report programs reach more than 3.6 million customers and have generated 2.85 TWh in total savings. Their Peak Management programs, which began at Baltimore Gas and Electric (BGE) in 2011, now touch 1.1 million BGE and 270,000 ComEd customers. The combined Peak Management programs have generated more than 1.9 GW in total demand reduction during critical peak periods, resulting in lower costs for consumers and increasing the overall reliability of the grid.

Collectively this impact is powering a cleaner and brighter future for Exelon’s utility customers and communities. Learn more about Exelon’s journey here.

The Future of Energy Efficiency

This 20 TWh milestone represents a solid step forward to a larger, more sustainable future for participating utility companies and their customers. Currently, Oracle Utilities Opower programs are on track to deliver 4 TWh of savings annually, which is equivalent to the power generated yearly by the Hoover Dam.

By comparison, Opower’s 20 TWh achievement is seven times greater than the next closest ranking energy efficiency provider in Navigant Research’s 2018 Home Energy Management Leaderboard Report.

“In just two years, Oracle Utilities Opower has gone from 11 TWh energy savings to 20 TWh – a milestone no other software provider has come remotely close to,” added Smith. “Working closely with our utility partners, we will continue to redefine how consumers reach their full energy saving potential, with innovative, scalable solutions that drive behavior change at the time and location that have the most impact.”

Contact Info
Kristin Reeves
Oracle
+1.925.787.6744
kris.reeves@oracle.com
Molly Hardy-Knowles
Hill+Knowlton Strategies
+1.713.752.1931
molly.hardy-knowles@hkstrategies.com
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at 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

Kristin Reeves

  • +1.925.787.6744

Molly Hardy-Knowles

  • +1.713.752.1931

Oracle Recognized as a Leader in Two Recent Gartner Reports: Magic Quadrant for Data Integration Tools and Magic Quadrant for Metadata Management Solutions

Oracle Press Releases - Mon, 2018-10-15 07:00
Press Release
Oracle Recognized as a Leader in Two Recent Gartner Reports: Magic Quadrant for Data Integration Tools and Magic Quadrant for Metadata Management Solutions Oracle positioned in both reports as a Leader based on completeness of vision and ability to execute

Redwood Shores, Calif.—Oct 15, 2018

Oracle today announced that it has been named a Leader in two recent reports, Gartner’s 2018 “Magic Quadrant for Data Integration Tools” report1 and Gartner’s 2018 “ Magic Quadrant for Metadata Management Solutions” report 2.  This recognition is further validation of Oracle’s continued leadership in delivering a comprehensive portfolio of integration solutions.

“Our leadership illustrates the importance of data integration in the digital age and the value that Oracle’s data integration solutions deliver to customers every day,” said Jeff Pollock, vice president, product management, Oracle. “Oracle delivers a modern data integration solution bringing together data integration, data governance, and streaming data along with comprehensive cloud-based data warehousing, big data and analytics solutions.”

According to Gartner, “The data integration tools market is composed of tools for rationalizing, reconciling, semantically interpreting and restructuring data between diverse architectural approaches, specifically to support data and analytics leaders in transforming data access and delivery in the enterprise.” The report continued, “The discipline of data integration comprises the practices, architectural techniques and tools that ingest, transform, combine and provision data across the spectrum of information types. This integration takes place in the enterprise and beyond the enterprise—across partners and third-party data sources and use cases—to meet the data consumption requirements of all applications and business processes.”

The Magic Quadrant for Metadata Management Solutions report identified Leaders as “front-runners with an offering that supports the full range of metadata management capabilities. They exhibit a clear understanding of, and vision for, where the market is headed and are strong in matching customers’ requirements in a variety of use cases. They support both business and technical metadata scenarios, leveraging strategic partnerships to optimize the delivery of their solutions. These vendors establish market trends by providing new functional capabilities in their products, and by identifying new types of business problem to which they can bring significant value. Leaders have an established and/or fast-growing market presence, and a multinational presence,” according to Gartner.

Oracle’s integration solutions provide application and data integration capabilities to seamlessly connect applications, share data across hybrid environments to enable trusted global analytics, and modernize to the cloud. Oracle’s integration offerings include Oracle Data Integration Platform Cloud, Oracle GoldenGate Cloud Service, and Oracle Integration Cloud. Oracle Data Integration Platform Cloud is a powerful and unified cloud based solution that helps companies migrate their data to cloud as well as modernize their data management platforms and data integration requirements through real-time data streaming, batch data processing, data enrichment and data governance. Oracle Data Integration Platform Cloud is also uniquely positioned to enable autonomous data warehousing along with Oracle Autonomous Data Warehouse Cloud Service. Oracle GoldenGate Cloud Service is a focused data integration solution that provides real-time replication from database-to-database or database-to-big data. Oracle Integration Cloud is a powerful application integration platform with a large library of pre-built integration adapters to enable customers quickly integrate Oracle and third-party SaaS and on-premises applications, APIs, people and devices.

Download a complimentary copy of Gartner’s 2018 Magic Quadrant for Data Integration Tools here.

Download a complimentary copy of Gartner’s 2018 Magic Quadrant for Metadata Management Solutions here.

[1] Source: Gartner, Magic Quadrant for Data Integration Tools, Mark Beyer, Eric Thoo, Ehtisham Zaidi, 19 July 2018
[2] Source: Gartner, Magic Quadrant for Metadata Management Solutions, Guido De Simoni, Alan Dayley, Roxane Edjlali, 9 August 2018

Gartner Disclaimer
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
Quentin Nolibois
Burson-Marsteller
1.415.591.4097
quentin.nolibois@bm.com
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

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

Talk to a Press Contact

Nicole Maloney

  • 1.650.506.0806

Quentin Nolibois

  • 1.415.591.4097

Oracle Recognized as a Leader in the 2018 Magic Quadrant for Supply Chain Planning System of Record

Oracle Press Releases - Mon, 2018-10-15 06:30
Press Release
Oracle Recognized as a Leader in the 2018 Magic Quadrant for Supply Chain Planning System of Record Oracle included in Leaders quadrant of the 2018 Gartner Magic Quadrant for Supply Chain Planning System of Record

Redwood Shores, Calif.—Oct 15, 2018

Oracle announced today that Oracle Supply Chain Planning (SCP) Cloud has been positioned as a Leader in the 2018 Gartner Magic Quadrant for Supply Chain Planning System of Record.

Oracle has traditionally had strong offerings in on-premises SCP applications, and the company believes the Magic Quadrant placement validates Oracle’s success in yet again creating best-of-breed business applications, this time, natively, on the cloud.

A complimentary copy of the report is available here.

Over the last 20 years, Supply Chain Planning has matured from a niche process for early adopters to an integral and indispensable strategic tool for competing in the global marketplace. Supply Chain Planning practices are now critical for ensuring high customer service levels at the lowest possible cost, in a business climate characterized by increased demand volatility and supply chain complexity. According to the Gartner Magic Quadrant, SCP SOR has seven key functional areas which are Stage 3 sales and operations planning (S&OP), demand planning including collaborative demand planning, inventory planning including collaborative inventory planning, replenishment planning including collaborative replenishment planning, order planning/promising, production planning, and manufacturing scheduling.

According to Gartner, choosing a SCP SOR is a key decision. “Not only must it provide planning integration and visibility across a supply chain, it also must provide a critical steppingstone in an SCP technology roadmap that will help enable the business’s future SCP aspirations. To be fully effective, an SCP SOR is deployed, at a minimum, at the supply chain planning organizational level, as opposed to SCP key functional capability or geographically.”

Oracle is committed to investing in an integrated supply chain planning service that works seamlessly with innovative new technology such as artificial intelligence, the Internet of Things (IoT), and blockchain. Oracle SCP Cloud is integrated with the broader Oracle Supply Chain Management Cloud including capabilities that contain product innovation, strategic material sourcing, outsourced manufacturing, integrated logistics, omni-channel fulfillment, and integrated demand.

“We believe that our recognition as a supply chain planning leader comes from listening to our customers,” said Vikash Goyal, Vice President of Product Strategy at Oracle. “Supply Chain Planning Cloud uses Oracle’s modern, autonomous technologies to significantly improve both the speed and the quality of decision making for our customers. Equipped with best practice processes, guided user experience and intelligent recommendations, supply chain planning cloud is easy to implement and simple to use. We will continue to invest and innovate in this area and help our customers become leaders in their industries.”

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

Gartner, “Magic Quadrant for Supply Chain Planning System of Record,” Amber Salley, Tim Payne, Alex Pradhan, 21 August 2018.

Gartner Disclaimer
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
Vanessa Johnson
Oracle
+1.650.607.1692
vanessa.n.johnson@oracle.com
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at 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

Vanessa Johnson

  • +1.650.607.1692

Getting started with Red Hat Satellite – Initial configuration

Yann Neuhaus - Mon, 2018-10-15 04:13

In the last post it was all about the Installation of Red Hat Satellite and the components that are used under the hood. In this post it is about doing the initial configuration so that packages can be synchronized from the Red Hat content network and subscriptions are available to be consumed by clients. This requires some initial tasks to be done in the Satellite itself but also in the Red Hat portal where you can manage your subscriptions.

When you log on to the Satellite Console for the first time you’ll land on the monitoring page:
Selection_066
As we currently do not have any systems managed by this Satellite system the overview is quite boring at the moment. The first task we need to do for going further is to create an “Organization”. Organizations are logical groups you should use to divide your infrastructure to whatever makes sense in your case, could be a division, could be based on content, whatever. This can either be done using the Console but it can also be done by using the command line utility hammer. For the moment there is just the “Default Organization”:
Selection_068

[root@satellite lib]$ hammer organization list
---|----------------------|----------------------|-------------|----------------------|------------
ID | TITLE                | NAME                 | DESCRIPTION | LABEL                | DESCRIPTION
---|----------------------|----------------------|-------------|----------------------|------------
1  | Default Organization | Default Organization |             | Default_Organization |            
---|----------------------|----------------------|-------------|----------------------|------------

Lets create a new one we will use throughout this series of posts:

[root@satellite lib] hammer organization create --name "dbi services" --label "dbi-services" --description "dbi services headquarter"
Organization created
[root@satellite lib] hammer organization list
---|----------------------|----------------------|--------------------------|----------------------|-------------------------
ID | TITLE                | NAME                 | DESCRIPTION              | LABEL                | DESCRIPTION             
---|----------------------|----------------------|--------------------------|----------------------|-------------------------
3  | dbi services         | dbi services         | dbi services headquarter | dbi-services         | dbi services headquarter
1  | Default Organization | Default Organization |                          | Default_Organization |                         
---|----------------------|----------------------|--------------------------|----------------------|-------------------------

Once we have that we can switch to our new organization in the Console:
Selection_070

For being able to browse the content of our Organization we need to create a so called “Debug Certificate”. This can be done by switching to the “Administer->Organizations” screen:
Selection_072

Once you selected the organization the certificate can be generated:
Selection_073

For importing that certificate into Firefox it needs to be converted. Using the generated certificate file create two files, one containing the private key section and another one containing the certificate section, like here:

dwe@dwe:~/Downloads$ cat key.pem 
-----BEGIN RSA PRIVATE KEY-----
MIIEpAIBAAKCAQEAroq3rZuJ.....Q5eCqquzW4/Ie7SI3MQZQ==
-----END RSA PRIVATE KEY-----

dwe@dwe:~/Downloads$ cat cert.pem 
-----BEGIN CERTIFICATE-----
MIIG8jCCBdqgAwIB....Ix55eToRfqUZLzcAlrOFTaF8UrbDOoFTJldF
wxDDBpzk
-----END CERTIFICATE-----

These files can now be used to create a certificate that can be imported into Firefox:

dwe@dwe:~/Downloads$ openssl pkcs12 -keypbe PBE-SHA1-3DES -certpbe PBE-SHA1-3DES -export -in cert.pem -inkey key.pem -out dbi-services.pfx -name dbiservices
Enter Export Password:
Verifying - Enter Export Password:
dwe@dwe:~/Downloads$ ls -la *pfx*
-rw------- 1 dwe dwe 3460 Oct 12 10:36 dbi-services.pfx

Selection_074

Once we have that in Firefox we are able to browse the organization’s repository. The URL is of the following format: https://[SATELLITE-MACHINE]/pulp/repos/[ORGANIZATION-LABEL], so in my case: https://192.168.22.11/pulp/repos/dbi-services

Selection_075

For being able to attach systems to the Satellite need to create a so called “Subscription Allocation” in the Red Hat portal:
Selection_075
Selection_076
Selection_077

Once we have the “Subscription Allocation” we need to add subscriptions to it (I will use just two for the scope of this post):
Selection_078
Selection_079
Selection_080
Selection_081

These definitions need to be exported as a “Manifest” that then can be imported into our Satellite:
Selection_082

Importing the Manifest into the Satellite is done in the “Content > Red Hat Subscriptions” section:
Selection_084
Selection_086
Selection_087

From now on we are ready to synchronize content from the Red Hat content network. Again this can either be done via the Console or on the command line. To list all the products available using the hammer command line utility:

[root@satellite ~]$ hammer product list --organization "dbi services"
----|----------------------------------------------------------------------------------|-------------|--------------|--------------|-----------
ID  | NAME                                                                             | DESCRIPTION | ORGANIZATION | REPOSITORIES | SYNC STATE
----|----------------------------------------------------------------------------------|-------------|--------------|--------------|-----------
12  | dotNET on RHEL Beta for RHEL Server                                              |             | dbi services | 0            |           
99  | dotNET on RHEL for RHEL Server                                                   |             | dbi services | 0            |           
54  | MRG Realtime                                                                     |             | dbi services | 0            |           
1   | Oracle Java for RHEL Client                                                      |             | dbi services | 0            |           
94  | Oracle Java for RHEL Compute Node                                                |             | dbi services | 0            |           
18  | Oracle Java for RHEL Compute Node - Extended Update Support                      |             | dbi services | 0            |           
38  | Oracle Java for RHEL Server                                                      |             | dbi services | 0            |           
...

Each of those “products” are also a repository. To list the product set for Red Hat Enterprise Linux using hammer:

[root@satellite ~]$ hammer repository-set list --product "Red Hat Enterprise Linux Server" --organization "dbi services"
-----|-----------|---------------------------------------------------------------------------------
ID   | TYPE      | NAME                                                                            
-----|-----------|---------------------------------------------------------------------------------
2008 | yum       | Red Hat Enterprise Linux 4 AS Beta (RPMs)                                       
7750 | yum       | Red Hat Satellite Tools 6.4 (for RHEL 7 Server) (Debug RPMs)                    
2009 | yum       | Red Hat Enterprise Linux 4 AS Beta (Source RPMs)                                
2006 | yum       | Red Hat Enterprise Linux 4 AS Beta (Debug RPMs)                                 
2007 | file      | Red Hat Enterprise Linux 4 AS Beta (ISOs)                                       
7752 | yum       | Red Hat Satellite Tools 6.4 (for RHEL 7 Server) (Source RPMs)                   
7751 | yum       | Red Hat Satellite Tools 6.4 (for RHEL 7 Server) (RPMs)                          
...

For the scope of this blog post we are only interested in the Satellite tools and the latest Enterprise Linux products, so we enable only those two. For enabling the first one using the command line:

[root@satellite ~]$ hammer repository-set enable --name "Red Hat Enterprise Linux 7 Server (RPMs)" \
                                                 --releasever "7Server" \
                                                 --basearch "x86_64" \
                                                 --product "Red Hat Enterprise Linux Server" \
                                                 --organization "dbi services"
Repository enabled

For enabling the second one using the Console go to “Content->Red Hat Subscriptions”, locate the “Red Hat Enterprise Linux” section, expand that and enable “Red Hat Satellite Tools 6.3 (for RHEL 7 Server) (RPMs)”:

Selection_067
Selection_068
Selection_069

To verify what we did:

[root@satellite ~]$ hammer repository list --product "Red Hat Enterprise Linux Server" --organization "dbi services"
---|-----------------------------------------------------------|---------------------------------|--------------|---------------------------------------------------------------------------------
ID | NAME                                                      | PRODUCT                         | CONTENT TYPE | URL                                                                             
---|-----------------------------------------------------------|---------------------------------|--------------|---------------------------------------------------------------------------------
1  | Red Hat Enterprise Linux 7 Server RPMs x86_64 7Server     | Red Hat Enterprise Linux Server | yum          | https://cdn.redhat.com/content/dist/rhel/server/7/7Server/x86_64/os             
2  | Red Hat Satellite Tools 6.3 for RHEL 7 Server RPMs x86_64 | Red Hat Enterprise Linux Server | yum          | https://cdn.redhat.com/content/dist/rhel/server/7/7Server/x86_64/sat-tools/6....
---|-----------------------------------------------------------|---------------------------------|--------------|---------------------------------------------------------------------------------

Finally we need to synchronize these repositories (this will take some time):

[root@satellite ~]$ hammer product synchronize --name "Red Hat Enterprise Linux Server" --organization "dbi services"

You can monitor the progress in the Console:
Selection_071
Selection_072
Selection_074

Btw: When you want to check the overall status of the components can do do it like this on the command line:

[root@satellite pulp]$ hammer ping
candlepin:      
    Status:          ok
    Server Response: Duration: 19ms
candlepin_auth: 
    Status:          ok
    Server Response: Duration: 66ms
pulp:           
    Status:          ok
    Server Response: Duration: 111ms
pulp_auth:      
    Status:          ok
    Server Response: Duration: 52ms
foreman_tasks:  
    Status:          ok
    Server Response: Duration: 1163ms

That’s it for the basic configuration. Satellite is up and running and we have content clients can consume. In the next post we’ll attach a new Red Hat Linux installation to the Satellite.

 

Cet article Getting started with Red Hat Satellite – Initial configuration est apparu en premier sur Blog dbi services.

Soup

Jonathan Lewis - Sun, 2018-10-14 13:02

When my mother-in-law comes round to Sunday lunch we often have roast chicken – and a serious error in estimating the requirement for the vegetable bed I was roasting on led to the discovery of home-made soup. (I did warn you that my post-operative posts would be light-weight)

Ingredients
  • Remnants of cooked chicken
    • (or 250ml, 1/3rd pint, one cup of  boiled water with a vegetable or chicken stock cube)
  • One large carrot
  • One small parsnip
  • One medium onion
    • The three vegetables should be similar in weight: roughly 200g, a bit less than 1/2 lb.
    • (Or just about any leftover vegetables from a roast dinner – I’ve even used leeks in cheese sauce)
  • Greek yoghurt (One tablespoon)
  • Choice of herbs and seasoning.

 

Method
  • Discard any large areas of fatty skin from the chicken carcase
  • Break up the carcase and place in saucepan with 500ml (2 cups, 3/4 pint) water
  • Bring to the boil and simmer for about 30 minutes with saucepan lid on.
  • Strain into a fresh saucepan, discard the remnants of chicken

 

  • Top, tail and peel the carrot, cut into discs
  • Top, tail and peel turnip, cut into small chunks
  • Peel and dice the onion.
  • Mix the stock and vegetables in a fresh saucepan
  • add herbs and seasoning
    • (I like a teaspoon of chopped tarragon – fresh from the garden)
  • Simmer with lid on for about 20 minutes
    • (until the carrots are softened)

 

  • Tip contents into blender
  • Blend until smooth.
  • Add a rounded tablespoon of plain Greek yoghurt, and blend
  • Serve – 2 large or 3 small portions

Despite looking a bit boring before it goes into the blender the soup tends to come out a surprisingly cheerful sunshine yellow thanks to the carrot. If you’ve managed to get the same results as I do then, because of the yoghurt I think, the texture will be almost like a thick foam or very light mousse.

I typically end up making the stock immediately after lunch is over, then keep it in the fridge for a couple of days before making the soup; that does mean you can skim off any excess fat before using the stock for the soup. And if there’s any gravy left over from lunch that’s a bonus to go in the soup.

 

Query on system catalog is very slow

Tom Kyte - Sat, 2018-10-13 07:46
Hi I have a query in my application: SELECT NULL, p.owner, p.table_name, pc.column_name, NULL, f.owner, f.table_name, fc.column_name, fc.position, NULL, DECODE( f.delete_rule, 'CASCADE', 0, 'SET N...
Categories: DBA Blogs

Index creation on GTT

Tom Kyte - Sat, 2018-10-13 07:46
Hello, i want session specific data for my current requirement. i am doing some calculations so i need that data only. at a time multiple users can use screen and do operations so i am using GTT. i have created GTT and created index on that GTT. ...
Categories: DBA Blogs

filter and access in execution plan

Tom Kyte - Fri, 2018-10-12 13:26
<code> Hi,Tom I have a question and want to learn from you. the following is an execution plan from OTN,but I don't understand the difference between "filter" and "access" listed in "Predicate Information" and I did not find any OTN documents...
Categories: DBA Blogs

How to fetch one column from a sys_refcursor?

Tom Kyte - Fri, 2018-10-12 13:26
How do I get only few columns from a sys_refcursor and pass it as an input to another proc? I have a proc which returns the result set in a sys_refcursor. A column from this output has to be passed as an input to another proc. For eg: proc_a...
Categories: DBA Blogs

Procedure is taking too much time to execute

Tom Kyte - Fri, 2018-10-12 13:26
Hi, We have created procedure with below logic and it's taking too much time to execute, the main logic we've used as below, procedure: create or replace procedure test_parts ( P_QUOTE_NUMBER IN table_c.QUOTE_NUMBER%TYPE, ...
Categories: DBA Blogs

dbms_log

Jonathan Lewis - Fri, 2018-10-12 10:39

I’ve been a long time, though occasional, user of the undocumented dbms_system package, typically using it to write messages or insert break marks in trace files (or the alert log). Thanks to an email from Cary Millsap I’ve recently discovered that the procedures for writing to trace files have been copied to a separate dbms_log package – which is nice because some of the things in dbms_system shouldn’t be made available to general code, for example dbms_system has a procedure kcfrms which resets a number of the “max time” columns in various dynamic performance views. It can be very useful occasionally – you might even want to call it just before or just after every AWR snapshot – but I’d rather that no-one else was able to call if I thought that I needed to  do so.

The dbms_log package is also (currently – even in 18.3) undocumented, but maybe one day soon it will appear in the PL/SQL Packages and Types reference manual. The procedures available in the package are as follows:

SQL> desc dbms_log
PROCEDURE KSDDDT
PROCEDURE KSDFLS
PROCEDURE KSDIND
 Argument Name			Type			In/Out Default?
 ------------------------------ ----------------------- ------ --------
 LVL				BINARY_INTEGER		IN
PROCEDURE KSDWRT
 Argument Name			Type			In/Out Default?
 ------------------------------ ----------------------- ------ --------
 DEST				BINARY_INTEGER		IN
 TST				VARCHAR2		IN
  • ksdddt move to a new line in the trace file, writes the date and moves to the next line – but won’t do anything if the trace file has not already been opened so if you want a datestamp at the top of the output you actually have to start with a ksdwrt or ksdind call.
  • ksdfls flushes any pending writes to the trace file / alert log and closes the file – which isn’t relevant in my example, but would make a difference to when you see the text that has been written from inside a pl/sql block.
  • ksdind writes an “indent” of lvl colon (‘:’) symbols to the trace file. This is a one-off effect, it doesn’t set an indent for all future lines, it merely writes the ‘:’ so that the next call to ksdwrt appends its text after the colons.
  • ksdwrt writes tst to the trace file if dest = 1, to the alter log if dest = 2 and both if dest = 3, adding a new-line at the end of the text.

Here’s a sample of code calling the procedures to write something to my trace file:


execute dbms_log.ksdddt
execute dbms_log.ksdwrt(1,'Starting')
execute dbms_log.ksdddt
execute dbms_log.ksdwrt(1,'Underlining')
execute dbms_log.ksdind(20)
execute dbms_log.ksdwrt(1,'Indented')
execute dbms_log.ksdwrt(1,'Not Indented')
execute dbms_log.ksdind(30)
execute dbms_log.ksdddt
execute dbms_log.ksdwrt(1,'Finished')
execute dbms_log.ksdind(30)
execute dbms_log.ksdfls


Here’s the text that appears in the trace files:


Starting

*** 2018-10-04T16:31:15.525515+01:00 (ORCL(3))
Underlining
::::::::::::::::::::Indented
Not Indented
::::::::::::::::::::::::::::::
*** 2018-10-04T16:31:15.532881+01:00 (ORCL(3))
Finished
::::::::::::::::::::::::::::::

Note how the call to ksdddt in line 1 of code didn’t write a date into the trace file. The call to ksdwrt in line 2 writes ‘Starting’ and move to a new line so we get a blank line when the call to ksdddt in line 3 moves to a new line and writes the date. At line 5 we “indent 20”, so the ksdwrt at line 6 starts after the string of colons, then moves to a new line where the indent is not repeated. We indent again at line 8, which leaves us at the end of a line, so when we call ksdddt it moves to the start of the next line and writes the date there, we don’t get a blank line.

Footnote: when I saw Cary Millsap’s note I assumed that the procedures had been copied across in a recent version of Oracle; in fact dbms_log has been around since at least 11.2.0.4

Footnote 2: While checking my library for references to dbms_system I came across a script I’d used to create a local version of dbms_system that allowed me to execute a call to “dbms_system.set_bool_param_in_sesssion(‘#_SILVER_BULLET’, true)”. I used it at an IOUG conference a few years ago to demonstrate that if you set this “very hidden” parameter to true then some of your queries could run faster.  (What the call actually did was enable query rewrite and disable function-based indexes so that a special time-wasting index I’d created couldn’t get used.)

 

Pages

Subscribe to Oracle FAQ aggregator