Feed aggregator

How to read a value from the user at run time?

Tom Kyte - 9 hours 10 min ago
<b></b>Hey! I am a beginner. I was watching YouTube tutorials on Oracle PL/SQL and I came across this feature that uses the placeholder to assign a value to a variable by reading it from the user at the run time. I tried my best to use the given...
Categories: DBA Blogs

Is there way to convert user defined type to JSON?

Tom Kyte - 9 hours 10 min ago
Is there way to convert user defined types/collections to JSON (the same way as it's possible to convert them to XML via XMLTYPE)?
Categories: DBA Blogs

How does a global index behave on partitioned table

Tom Kyte - 9 hours 10 min ago
Suppose i have below table which has 1 billion record and partitioned based on Budget_Flag <code> CREATE TABLE xx_tab1 (budget_flag varchar(1), period_name VARCHAR2(10), begin_dr number, begin_cr number, creation_date DATE) PARTITI...
Categories: DBA Blogs

regarding exchange table partition

Tom Kyte - 9 hours 10 min ago
hi Team, currently, we are doing partition activity , in brief about the activity is we are using exchange partition with other table. While performing exchange we are facing issue of ORA-14097 : column type or size mismatch in ALTER TABLE EXC...
Categories: DBA Blogs

Query or report all runs of a scheduled job

Tom Kyte - 9 hours 10 min ago
It's possible someone has already written such a query, but how could I write a select statement that would report on all the expected times a scheduled job is going to run? So, for example, if I have 2 DBMS_SCHEDULED jobs: job_a runs at specifi...
Categories: DBA Blogs

Standby Database for Reporting Purpose

Tom Kyte - 9 hours 10 min ago
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 - 9 hours 10 min ago
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 - 9 hours 10 min ago
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 - 12 hours 37 min ago

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

Faking Histograms

Jonathan Lewis - 16 hours 18 min ago

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

 

Alshaya Partners with Oracle Cloud to Accelerate Growth and Expansion

Oracle Press Releases - 16 hours 56 min ago
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 - 16 hours 56 min ago
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 - 16 hours 56 min ago
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 - 16 hours 56 min ago
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 - 17 hours 26 min ago
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 - 19 hours 42 min ago

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

Pages

Subscribe to Oracle FAQ aggregator