Feed aggregator
Azure DevOps Service Hooks | Subscription Of Service Hooks | Release Approvals
DevOps is the most trending technology in the IT world with massive demand in big organizations. Are you looking for achieving a better Event and Activity management by using automation, but you’ve no idea about Service Hooks and how to set-up it? No worries! Check out the blog post at k21academy.com/az40018 & get a step-by-step […]
The post Azure DevOps Service Hooks | Subscription Of Service Hooks | Release Approvals appeared first on Oracle Trainings for Apps & Fusion DBA.
[AZ-400] SonarCloud Azure DevOps | Integrating SonarCloud In Azure
Is your organization planning to adopt Azure DevOps for achieving better Code Quality & Code Security, but you’ve no idea about SonarCloud and how to set-up it? No worries! Check out the blog post at https://k21academy.com/az40017. Get a step-by-step walkthrough of integrating SonarCloud With Azure cloud with our Demo in an Azure environment. The blog […]
The post [AZ-400] SonarCloud Azure DevOps | Integrating SonarCloud In Azure appeared first on Oracle Trainings for Apps & Fusion DBA.
Oracle EBS Upgrade Methodology | Analyzer Tool | K21Academy
Upgrading your EBS base version to R12.2 can be quite complicated tasks and to make things a bit easier for you we have compiled a step-wise help for you in our blog https://k21academy.com/ebsupgrade15. The blog covers: · Oracle EBS upgrade Methodology · EBS Upgrade Analyzer Overview · Key Features Of An EBS Upgrade Analyzer Want […]
The post Oracle EBS Upgrade Methodology | Analyzer Tool | K21Academy appeared first on Oracle Trainings for Apps & Fusion DBA.
AI 900 | Azure AI Fundamentals Exam | Everything You Need To Know
All IT organizations are adopting Artificial Intelligence for enhancing their productivity. Are you planning a future in AI as well? Don’t worry! We are here to your rescue. We have compiled everything you need to know about clearing the AI-900 Exam in the blog post-https://k21academy.com/ai90011 -What is Azure AI Fundamentals Certification? -Why Use Azure AI […]
The post AI 900 | Azure AI Fundamentals Exam | Everything You Need To Know appeared first on Oracle Trainings for Apps & Fusion DBA.
Billing and Cost Management in Oracle Cloud (OCI)
Did you ever receive a Cloud usage bill that’s higher than what you were expecting?:scream: Want to know how to reduce Oracle cost billings? We are here with our blog https://k21academy.com/1z0108515 telling you about the best practices that will help you make the most of your money with Oracle Cloud by cutting off the costs […]
The post Billing and Cost Management in Oracle Cloud (OCI) appeared first on Oracle Trainings for Apps & Fusion DBA.
Global variables vs parameters
Week of Year in SQL - Confusing
How to get current schema
PeopleSoft Developer Day August 20, 2020
Announcing PeopleTools Developer Day! Join me online Thursday, August 20th for a full day PeopleTools experience. I will share a full day of PeopleTools tips and best practices. Space is limited so register now!
Here is a sample of the topics:
FLUID- Layouts,
- CSS,
- JavaScript
I'll demonstrate a variety of Oracle-delivered style classes and how to use them to control layout. You will learn how to incorporate your own CSS into PeopleSoft and discuss when or why you might use custom CSS. And reasons you may want to avoid writing your own CSS.
REST/JSON- Documents
- JSON Services
- Content Negotiation
- PeopleCode JSON Classes
Expose PeopleSoft data as a REST service including all of the supporting structures (Documents, Service Operations, etc.). We might even consume an Oracle HCM Cloud REST Service!
CONFIGURATION- Event Mapping
- Drop Zones
With selective adoption and continuous delivery, staying current could mean continuous retrofitting. Event Mapping and Drop Zones are configurable alternatives to customization, allowing us to move forward with new projects.
The cost is $250 per person, which is nearly 70% off our standard daily rate! We are recording the event and are offering 60-days access to registered attendees. This is going to be so much fun! Bring your questions. We'll have time for Q&A. The chat bar will be available and monitored all day.
Understanding purpose of undo for Global Temporary Tables DML operation
Not being utilized all the processors capacity
Oracle Data Guard RedoRoutes : What is Priority 8 ?
When dealing with cascading or far sync in a Data Guard environment, it is important to understand how to configure the RedoRoutes property.
By default, a primary database sends redo to each transport destination that is configured in the destination. We can create more complex transport topology, depending of our environment, using the RedoRoutes property.
Basically the RedoRoutes property has this format
(redo_routing_rule_1) [(redo_routing_rule_n)]
Where each routing rule contains a redo source field and a redo destination field separated by a colon:
(redo source : redo destination)
One can have more information in Oracle documentation
In this blog I am trying to simply explain how to configure the RedoRoutes property in a Data Guard environment with Far Sync Instance. See my previous blog for far sync instance creation.
I am using Oracle 20c.
The first configuration we consider is the following one
We have
1 primary database: prod20_site1
2 standby databases: prod20_site2 and prod20_site4
1 far sync instance fs_site3
For far sync creation with Oracle 20c see my previous blog
Below the status of the broker configuration
DGMGRL> show configuration
Configuration - prod20
Protection Mode: MaxAvailability
Members:
prod20_site1 - Primary database
prod20_site2 - Physical standby database
prod20_site4 - Physical standby database
fs_site3 - Far sync instance
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 47 seconds ago)
Actually, there is no configured RedoRoutes
DGMGRL> show database prod20_site1 redoroutes; RedoRoutes = '' DGMGRL> show database prod20_site2 redoroutes; RedoRoutes = '' DGMGRL> show database prod20_site4 redoroutes; RedoRoutes = '' DGMGRL>
For this configuration I want the primary database to send the redo according following rules
prod20_site2 will receive redo directly from prod20_site1
prod20_site1 =====> prod20_site2
prod20_site4 will receive redo via fs_site3 which will forward redo to prod20_site4
prod20_site1 =====> fs_site3 =====> prod20_site4
and if fs_site3 is not available, prod20_site4 will receive directly redo from prod20_site1
prod20_site1 =====> prod20_site4
For this we have to first edit the primary database RedoRoutes property like
DGMGRL> edit database prod20_site1 set property redoroutes='(local:prod20_site2,(fs_site3 priority=1,prod20_site4 priority=2))'; Property "redoroutes" updated
In this rule we have these meanings
local:prod20_site2: if prod20_site1 is the primary database then redo will be sent to prod20_site2
local: (fs_site3 priority=1,prod20_site4 priority=2 ): if prod20_site1 is the primary database then redo will be sent to fs_site3 or to prod20_site4. As the priority of the fs_site3 is higher, indeed smaller priority numbers mean higher priority, redo will be sent first to fs_site3, and if fs_site3 is unavailable, changes will be sent to prod20_site4.
Just note that as fs_site3 has a higher priority, if fs_site3 becomes available, redo will be again sent to fs_site3.
And then we have to tell to fs_site3 to forward redo received from prod20_site1 to prod20_site4.
DGMGRL> edit far_sync fs_site3 set property redoroutes='(prod20_site1:prod20_site4 ASYNC)'; Property "redoroutes" updated
Below the redoroutes we have configured for prod20_site1 and fs_site3
DGMGRL> show database prod20_site1 redoroutes; RedoRoutes = '(local:prod20_site2,(fs_site3 priority=1,prod20_site4 priority=2))' DGMGRL> show database prod20_site2 redoroutes; RedoRoutes = '' DGMGRL> show database prod20_site4 redoroutes; RedoRoutes = '' DGMGRL> show far_sync fs_site3 redoroutes; RedoRoutes = '(prod20_site1:prod20_site4 ASYNC)' DGMGRL>
And we can verify the status of our configuration
DGMGRL> show configuration verbose
Configuration - prod20
Protection Mode: MaxPerformance
Members:
prod20_site1 - Primary database
prod20_site2 - Physical standby database
fs_site3 - Far sync instance
prod20_site4 - Physical standby database
prod20_site4 - Physical standby database (alternate of fs_site3)
…
…
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS
DGMGRL>
Let’s now consider this configuration where we have two far syn instances. As in the first configuration, we want to send first the redo to far sync instances if possible, otherwise redo will be send directly to standby databases
The RedoRoutes property of the primary can be configured as below
DGMGRL> edit database prod20_site1 set property redoroutes='(local:(fs_site5 priority=1,prod20_site2 priority=2),(fs_site3 priority=1,prod20_site4 priority=2))'; Warning: ORA-16677: Standby database has the same or higher priority than other members specified in the RedoRoutes group. Property "redoroutes" updated DGMGRL>
And the redoroutes for the far sysnc fs_site5 can be adjusted like
DGMGRL> edit far_sync fs_site5 set property redoroutes='(prod20_site1:prod20_site2 ASYNC)'; Property "redoroutes" updated DGMGRL>
We can then verify the satus of the configuration
DGMGRL> show configuration verbose
Configuration - prod20
Protection Mode: MaxPerformance
Members:
prod20_site1 - Primary database
fs_site5 - Far sync instance
prod20_site2 - Physical standby database
prod20_site2 - Physical standby database (alternate of fs_site5)
fs_site3 - Far sync instance
prod20_site4 - Physical standby database
prod20_site4 - Physical standby database (alternate of fs_site3)
…
…
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS
DGMGRL>
As we can see when configuring RedoRoutes, we sometimes have to deal with the property PRIORITY.
This property can have a value between 1 and 8. 1 as the highest priority and 8 the lowest priority.
Let’s consider two destination A and B in the same group
Case 1: A and B with the same prority
Redo will be sent to A or B, let’s say A. When A is unavailable, redo will be then sent to B. And when A become reachable again, redo will continue to be sent to B.
(local:(A priority=1,B priority=1))
Case 2: A has a higher priority then B
Redo will be sent to A. If A becomes unavailable, redo will be sent to B. And if A becomes again reachable, redo will be sent to A as it has the highest priority
(local:(A priority=1,B priority=2))
But sometimes in the same group, we may want to send redo to both members. For example if we consider the following configuration, we just want that redo will be sent to fs_site3 if possible and if fs_site3 is not reachable then changes will be sent to both prod20_site2 et prod20_site4.
In this case we can use the PRIORITY 8 which has a special meaning. If the primary sends redo to a member with PRIORITY 8, then it must also send these redo to each member with the PRIORITY 8 in the group
In the configuration above, we want following rules
prod20_site1 will send changes to fs_site3 which will forward to prod20_site2 and prod20_site4 and if fs_site3 is not avalaible, prod20_site1 will ship redo to both standby databases.
And when fs_site3 becomes again available, redo will be send again to fs_site3
The redoRoutes for the primary database can be like
DGMGRL> edit database prod20_site1 set property redoroutes='(local:(fs_site3 priority=1,prod20_site2 priority=8,prod20_site4 priority=8))'; Warning: ORA-16677: Standby database has the same or higher priority than other members specified in the RedoRoutes group. Property "redoroutes" updated DGMGRL>
And for the far sync instance
DGMGRL> edit far_sync fs_site3 set property redoroutes='(prod20_site1:prod20_site2 ASYNC,prod20_site4 ASYNC)'; Property "redoroutes" updated DGMGRL>
The status of the configuration
DGMGRL> show configuration verbose
Configuration - prod20
Protection Mode: MaxPerformance
Members:
prod20_site1 - Primary database
fs_site3 - Far sync instance
prod20_site2 - Physical standby database
prod20_site4 - Physical standby database
prod20_site2 - Physical standby database (alternate of fs_site3)
prod20_site4 - Physical standby database (alternate of fs_site3)
…
…
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS
DGMGRL>
Conclusion
Depending to the configuration, the redo transport topology can be very complex. What I can recommend when dealing with far sync instances, is to think about all possible cases, including switchover and failover. And based of all possible cases to design an architecture for the redo transport. In this blog we just consider the case when prod20_site1 is the primary.
Cet article Oracle Data Guard RedoRoutes : What is Priority 8 ? est apparu en premier sur Blog dbi services.
Oracle Recognized Again as a Leader in Gartner Magic Quadrant for Cloud Core Financial Management Suites for Midsize, Large and Global Enterprises
Redwood Shores, Calif.—Jul 1, 2020
Oracle (NYSE: ORCL) has been named a Leader in Gartner’s “Magic Quadrant for Cloud Core Financial Management Suites for Midsize, Large and Global Enterprises” analysis,[1] with the furthest overall position for Completeness of Vision and highest overall position for Ability to Execute. This is the fourth consecutive year that Gartner has named the company a Leader based on its ability to execute and completeness of vision. A complimentary copy of the report is available here.
According to the report, “Leaders demonstrate a market-defining vision of how core financial management systems and processes can be supported and improved by moving them to the cloud. They couple this with a clear ability to execute this vision through products, services and go-to-market strategies. They have a strong presence in the market and are growing their revenue and market share. In this market, Leaders show a consistent ability to secure deals with enterprises of different sizes and have a good depth of functionality across all areas of core financial management. They have multiple proofs of successful deployments by customers, both in their home region and elsewhere. Their offerings are often used by system integrator partners to support financial transformation initiatives. Leaders typically address a wide market audience by supporting broad market requirements. However, they may fail to meet the specific needs of vertical markets or other, more specialized segments, which might be better addressed by Niche Players in particular.”
“We are once again delighted with Gartner’s recognition of Oracle’s Leader position in the cloud ERP market.” said Rondy Ng, senior vice president, Applications Development, Oracle. “We believe our continued leadership highlights our success in addressing the complex and evolving needs of the world’s leading organizations. Importantly, we further believe the breadth, depth, and continuous innovations of our solutions are a must-have for CFO’s navigating today’s fluid corporate finance environment.”
More than 7,100 organizations across 23 industries and in over 125 countries have adopted Oracle to help drive their finance transformation. Customers are rapidly taking advantage of on-going quarterly innovation updates in machine learning/AI, digital assistants, and world-class analytics to help their finance teams improve decision-making, accelerate processes, and drive efficiencies to deliver the real-time insights needed for competitive advantage.
Over seven years of unparalleled partnership between these customer organizations, implementation partners, and Oracle have also created a mature global ecosystem of expertise to enable fast time-to-value journey to cloud. Oracle and its partner community offer world-class proven services from best practice cloud adoption strategy, to implementation and go-live support, and ultimately ongoing business process optimization and innovation adoption. In addition, customers also benefit from Cloud Customer Connect, a premier, vibrant, 200,000 member strong community, designed to promote peer-to-peer collaboration and engagement with Oracle’s product development experts.
Oracle Fusion Cloud Enterprise Resource Planning (ERP) features a full range of business capabilities including Financials, Procurement, Project Management, Enterprise Performance Management (EPM) and Risk Management & Compliance. With native integration to the broader suite of Oracle Cloud Applications, including supply chain and manufacturing, human resources, and sales, service, and marketing, Oracle provides a complete solution to help customers enhance productivity, reduce costs and improve controls.
Oracle has been named a Leader in more finance and ERP-related Gartner Magic Quadrants. In addition to being recognized as a Leader in Gartner’s 2020 “Magic Quadrant for Cloud Core Financial Management Suites for Midsize, Large and Global Enterprises,1” Oracle was also recently named a Leader in Gartner’s 2020 “Magic Quadrant for Cloud ERP for Product-Centric Enterprises2” and the 2019 “Magic Quadrant for Cloud Financial Close Solutions3” and “Magic Quadrant for Cloud Financial Planning and Analysis Solutions4” reports.
1Gartner Magic Quadrant for Cloud Core Financial Management Suites for Midsize, Large and Global Enterprises, Robert Anderson, John Van Decker, Greg Leiter, 29 June 2020
2Gartner, Magic Quadrant for Cloud ERP for Product-Centric Enterprises, Tim Faith, Duy Nguyen, Denis Torii, Paul Schenck, Christian Hestermann, 22 June 2020
3Gartner, Magic Quadrant for Cloud Financial Close Solutions, Robert Anderson, John Van Decker, Greg Leiter, 21 October 2019
4Gartner, Magic Quadrant for Cloud Financial Planning and Analysis Solutions, Robert Anderson, John Van Decker, Greg Leiter, 8 August 2019
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.
The Oracle Cloud offers a complete suite of integrated applications for Sales, Service, Marketing, Human Resources, Finance, Supply Chain and Manufacturing, plus Highly Automated and Secure Generation 2 Infrastructure featuring the Oracle Autonomous Database. For more information about Oracle (NYSE: ORCL), please visit us at www.oracle.com.
TrademarksOracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Oracle Ecosystem Ignites Innovation to Accelerate Hospitality Recovery
Redwood Shores, Calif.—Jul 1, 2020
Oracle Hospitality is committed to helping the hospitality industry get back to business. To support this effort, Oracle, with support from HTNG, recently hosted Innovation Week, a collaborative event dedicated to accelerating the industry’s recovery and accommodating the rapidly evolving demand for low or contactless guest and employee interactions. The inaugural event drew 465 attendees across more than 200 hospitality technology organizations from 48 countries who came together to not only foster dialogue about innovation, but make it a reality. The event offered an expedited pathway to integration with Oracle Hospitality solutions, offering hoteliers more choices in technology to help them prepare for the new next.
During the five-day event, many vendors were able to make significant progress in the development of their integrations.
“We expected to spend weeks building our integration, but with the help of Oracle Hospitality experts, we were able to do it within days,” said Andreas Loeseth, COO of Fácil, which worked on an OPERA Cloud PMS integration enabling self-service check-in and check-out using a mobile app or kiosk. “Innovation Week showed us the level of Oracle’s commitment to open APIs and helping vendors develop new solutions for hoteliers. It’s exactly the type of assistance we need to fuel an industry recovery.”
Learn more about Innovation week and access the on-demand sessions.
“Oracle Hospitality stands apart in terms of the depth and breadth of the partners who integrate with our flagship platforms OPERA Cloud, OPERA 5 and Simphony. It is unparalleled. We also understand how critical technology is to deliver a great guest experience, especially during this time,” said Alex Alt, senior vice president and general manager of Oracle Hospitality. “Innovation Week successfully paved the way for new and existing vendor-partners to ramp up innovation and help solutions get to market much faster.”
A League of Their OwnIn addition to the many hospitality vendors new to the Oracle ecosystem, Innovation Week also featured several Oracle PartnerNetwork (OPN) members with Oracle Validated Integrations focused on low-touch or contactless solutions, including:
- ALICE: Offers an all-in-one solution that enables hotel staff to do the most impactful work without all the guesses. The ALICE/Oracle integration is a two-way, real-time interface that connects all hotel operations to the hotel’s PMS, enabling increased visibility across departments. The seamless communication between OPERA and ALICE removes the need for hoteliers to switch between two systems and focus their time and attention on delivering exceptional hospitality. Some of the properties leveraging the ALICE/Oracle integration include Montage Hotels & Resorts, Omni Hotels & Resorts properties, Viceroy Hotels and Resorts and Calamigos Guest Ranch.
- Hapi: Offers a cloud data hub that enables centralized exposure of data from disparate systems, spanning on premise and hosted. Hapi builds on the Oracle OPERA Cloud’s promise of centralized, open APIs by bringing this functionality to legacy customers now and enabling a smoother transition to the cloud. Integration partners can also use multiple OPERA interface protocols in a single Hapi connection, and large hotel chains can benefit from custom OPERA integrations into their tech ecosystems. The Hapi/ Oracle integration is currently being used by IHG, Accor, Red Lion Hotels, Rosewood Hotels and Resorts, Langham Hotels and Resorts, just to name a few.
- InnSpire: This 2020 HTNG TechOvation award-winning company offers a contactless, all-in-one technology suite that seamlessly helps drive a world class digital guest experience for some of the world’s most iconic hotels and brands. The key benefits of the company’s integration include accelerating the personalization of the guest experience, leveraging demographics and personal interests to customize in-room digital interfaces, such as Apps, TV-experience and voice. Today, the InnSpire/Oracle integration is being used by LUX* Resorts and Hotels, ME Dubai by Melia and many more.
- INTELITY: As the leading provider of guest experience management solutions for the hospitality industry, INTELITY unites mobile, in-room and back-office tools into one robust, fully-integrated hospitality platform. INTELITY’s integration with OPERA PMS enhances and streamlines a wide range of guest-facing activities, including contactless check-in, mobile key, touchless service requests and more. INTELITY also integrates with MICROS Simphony, allowing guests to place dining orders from their devices or an in-room tablet. With mutual customers worldwide, some hotels taking advantage of the INTELITY/Oracle integration include Fairmont Hotels & Resorts, Hyatt, YOTEL and Mystic Lake Casino Hotel.
- Nonius: This 2020 HTNG TechOvation award-winning company offers solutions to help hoteliers provide a great and contactless guest experience. Nonius has integrated its products with Oracle, including Mobile check-in and Key, Guest internet access, TV, Voice & Cast. Some hotels leveraging the Nonius/Oracle integration are from renowned groups such as Belmond, Accor, IHG, Four Seasons, GHM Hotels, Hard Rock Hotels, Marriot, Pestana and many more.
- Zaplox: Offers contact-free mobile guest journey and mobile key services for the global hotel market. Zaplox solutions save time and costs while providing hotels with a direct channel to communicate with the guests and the opportunity to generate additional revenue. The contact-free mobile guest journey also supports the "Safe Stay” guidelines providing contact-free and touchless options for guests during their stay. The Zaplox/Oracle integration is currently being used by Arlo Hotels, Union Hoteli, ARP Hansen Hotel Group and many other global properties.
“Oracle’s architecture is truly open and that directly helps to ignite and accelerate industry innovation,” said Luis Weir, director of product management, Oracle Hospitality integration and APIs. “Our approach allows hoteliers to work directly with our partners to build experiences that are better suited to tackle new challenges and meet evolving guest expectations. And by providing a standardized set of modern, secure APIs, we allow them to do it quickly and cost effectively – delivering innovation by encouraging customization.”
Resources to Accelerate Innovation for the New Next- Hospitality Cloud Marketplace: A cloud-based marketplace where certified partners can list their offerings, systems, product descriptions and demo links.
- New Next Vendor-Partner Integrations: An extensive listing of integrations specifically built to enable contactless operations.
- Technology Guide for a Touchless Guest Journey: This comprehensive playbook covers contactless operations, integration challenges and solutions, technology budgeting, low-touch solutions and advice to help hotels differentiate their offerings with innovative and emerging technology.
- Oracle Hospitality Resource Center: A global information and resource hub to help all those within the hospitality industry.
Oracle Hospitality brings over 40 years of experience in providing technology solutions to independent hoteliers, global and regional chains, gaming, and cruise lines. We provide hardware, software, and services that allow our customers to act on rich data insights that deliver personalized guest experiences, maximize profitability and encourage long-term loyalty. Our solutions include platforms for property management, point-of-sale, distribution, reporting and analytics all delivered from the cloud to lower IT cost and maximize business agility. Oracle Hospitality’s OPERA is recognized globally as the leading property management platform and continues to serve as a foundation for industry innovation. For more information about Oracle Hospitality, please visit www.oracle.com/Hospitality
About Oracle PartnerNetworkOracle PartnerNetwork (OPN) is Oracle’s partner program designed to enable partners to accelerate the transition to cloud and drive superior customer business outcomes. The OPN program allows partners to engage with Oracle through track(s) aligned to how they go to market: Cloud Build for partners that provide products or services built on or integrated with Oracle Cloud; Cloud Sell for partners that resell Oracle Cloud technology; Cloud Service for partners that implement, deploy and manage Oracle Cloud Services; and License & Hardware for partners that build, service or sell Oracle software licenses or hardware products. Customers can expedite their business objectives with OPN partners who have achieved Expertise in a product family or cloud service. To learn more visit: http://www.oracle.com/partnernetwork
About OracleThe Oracle Cloud offers a complete suite of integrated applications for Sales, Service, Marketing, Human Resources, Finance, Supply Chain and Manufacturing, plus Highly Automated and Secure Generation 2 Infrastructure featuring the Oracle Autonomous Database. For more information about Oracle (NYSE: ORCL), please visit us at www.oracle.com.
TrademarksOracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
[AZ-400] Azure DevOps – Environments (YAML CICD Pipelines)
Is your organization planning to adopt Azure DevOps for achieving its goals quicker, but you’ve no idea about Azure DevOps environments and how to set-up it? No worries! Check out the blog post at https://k21academy.com/az40016 Get a step-by-step walkthrough implementing CICD in an Azure environment using YAML and pipelines. The blog post covers: • What […]
The post [AZ-400] Azure DevOps – Environments (YAML CICD Pipelines) appeared first on Oracle Trainings for Apps & Fusion DBA.
why dba_extents has no answer but dba_segments has results
Oracle Autonomous Linux: cron’d ksplice and yum updates
.
Oracle Enterprise Linux (OEL) is a Linux distribution which is binary compatible with Red Hat Enterprise Linux (RHEL). However, unlike RHEL, OEL is open source, free to download, free to use, free to distribute, free to update and gets free bug fixes. And there are more frequent updates in OEL than in CentOS, the free base of RHEL. You can pay a subscription for additional support and features (like Ksplice or Dtrace) in OEL. It can run the same kernel as RHEL but also provides, still for free, the ‘unbreakable kernel’ (UEK) which is still compatible with RHEL but enhanced with optimizations, recommended especially when running Oracle products.
This is not new and I didn’t resist to illustrate the previous paragraph with the animated gif from the years of this UEK arrival. What is new is that OEL is also the base for the new Autonomous Linux which can run in the Oracle Cloud, automates Ksplice for updating the system online, without restart, and sending notifications about these updates. You can use it in the Oracle Cloud Free Tier.
When creating an Always Free compute instance you select the Oracle Autonomous Linux image. I’ve summarized all steps there:
Autonomous Linux image
[opc@al ~]$ mkdir ~/.oci
[opc@al ~]$ openssl genrsa -out ~/.oci/oci_api_key.pem 2048 # no passphrase
[opc@al ~]$ chmod go-rwx ~/.oci/oci_api_key.pem
[opc@al ~]$ openssl rsa -pubout -in ~/.oci/oci_api_key.pem -out ~/.oci/oci_api_key_public.pem
writing RSA key
This generates an API key temporarily.
Configure OCI CLI profile
[opc@al ~]$ sudo al-config -u ocid1.user.oc1..aaaaaaaafo2liscovfefeubflxm2rswrzpnnmosue4lczmgaaodwtqdljj3q -t ocid1.tenancy.oc1..aaaaaaaazlv5wxkdhldyvxkkta7rjn25ocovfefexhidte5zgiyauut2i2gq -k ~/.oci/oci_api_key.pem
Configured OCI CLI profile.
Please delete /home/opc/.oci/oci_api_key.pem
This configures the OCI CLI profile for my user (ocid1.user.oc1.. is my user OCID which I find in Oracle Cloud » Governance and Administration » Identity » Users » Users Detail » OCID copy) in my tenancy (ocid1.tenancy.oc1.. is my tenancy OCI I find in Oracle Cloud » Governance and Administration » Administration » Tenancy Details » OCID copy).
NotificationsWhen something happens autonomously you want to be notified for it. This uses the OCI notification service with a topic you subscribe to. This is also available in the Free Tier. The topic is created with Oracle Cloud » Application Integration » Notifications » Create Topic, where you just put a name and a description and get the OCID for it (ocid1.onstopic.oc1.eu-frankfurt-1… for me).
While in the console, on this topic I’ve created a subscription where I have put my e-mail address. I’ll receive by e-mail all notifications sent to this topic.
Configure OCI notification service topic OCID
[opc@al ~]$ sudo al-config -T ocid1.onstopic.oc1.eu-frankfurt-1.aaaaaaaaamo7khj3xab6oec5xtcovfefeokqszapwsafeje6g6ltlnhd363a
Configured OCI notification service topic OCID.
Publishing message 'AL: Notification enabled on instance AL'
Published message 'AL: Notification enabled on instance AL'
In the Autonomous Linux instance I’ve setup the OCI notification service topic OCID. And that’s all.
Check your e-mails, you have to acknowledge the reception of notifications of course.
Kernel version
[opc@al ~]$ uname -a
Linux al 4.14.35-1902.301.1.el7uek.x86_64 #2 SMP Tue Mar 31 16:50:32 PDT 2020 x86_64 x86_64 x86_64 GNU/Linux
Here is the kernel version that has been installed
[opc@al ~]$ sudo uptrack-uname -a
Linux al 4.14.35-1902.302.2.el7uek.x86_64 #2 SMP Fri Apr 24 14:24:11 PDT 2020 x86_64 x86_64 x86_64 GNU/Linux
This is the effective kernel updated with Ksplice
[opc@al ~]$ sudo uptrack-show
Installed updates:
[cp1p7rl5] Known exploit detection.
[3kfqruxl] Known exploit detection for CVE-2017-7308.
[6vy9wlov] Known exploit detection for CVE-2018-14634.
[r8wncd28] KPTI enablement for Ksplice.
[3e9je971] Known exploit detection for CVE-2018-18445.
[20bmudk6] Out-of-bounds access when classifying network packets with traffic control index.
[oy5cke5u] NULL dereference while writing Hyper-V SINT14 MSR.
[5jsm8lzj] CVE-2020-9383: Information leak in floppy disk driver.
[5p7yd05e] NULL pointer dereference when initializing Differentiated Services marker driver.
[sajmv0xh] CVE-2018-19854: Information leak in cryptography socket NETLINK_CRYPTO call.
[1gefn4lp] CVE-2019-19965: Denial-of-service in SCSI device removal.
[6hu77eez] Invalid memory access when sending an excessively large packet using Segmentation Offloads.
[f0zxddhg] Livelock in loop device block resize operation.
[2lgm3hz9] CVE-2019-14814, CVE-2019-14815, CVE-2019-14816: Denial-of-service when parsing access point settings in Marvell WiFi-Ex driver.
[3yqxyw42] CVE-2019-20096: Memory leak while changing DCCP socket SP feature values.
[9g5kf79r] Improved fix for CVE-2020-2732: Privilege escalation in Intel KVM nested emulation.
[bq9hiiuj] Race condition in ipoib during high request load causes denial-of-service.
[3youemoz] CVE-2020-11494: Information leak in serial line CAN device communication.
[jpbi3wnm] Use-after-free when removing generic block device.
[if1ety6t] Memory corruption when reading EFI sysfs entries.
[iv8r17d8] CVE-2020-8648: Use-after-free in virtual terminal selection buffer.
[mojwd0zk] Various Spectre-V1 information leaks in KVM.
[nvi6r5wx] CVE-2019-19527: Denial-of-service in USB HID device open.
[o3df6mds] CVE-2020-8647, CVE-2020-8649: Use-after-free in the VGA text console driver.
[kjyqg48a] CVE-2019-19532: Denial-of-service when initializing HID devices.
[74j9dhee] Divide-by-zero when CPU capacity changes causes denial-of-service.
[lgsoxuy7] CVE-2019-19768: Use-after-free when reporting an IO trace.
Effective kernel version is 4.14.35-1902.302.2.el7uek
all details are there about the fixes applied by Ksplice, without any reboot.
One month laterI’ve created that on May 23th, 2020 and writing this one month later.
Here are the e-mails I’ve received from the topic subscription:
And my current machine state:
[opc@al ~]$ uptime
19:26:39 up 38 days, 13:49, 2 users, load average: 0.07, 0.02, 0.00
[opc@al ~]$ uname -a
Linux al 4.14.35-1902.301.1.el7uek.x86_64 #2 SMP Tue Mar 31 16:50:32 PDT 2020 x86_64 x86_64 x86_64 GNU/Linux
[opc@al ~]$ sudo uptrack-uname -a
Linux al 4.14.35-1902.303.4.1.el7uek.x86_64 #2 SMP Fri May 29 14:56:41 PDT 2020 x86_64 x86_64 x86_64 GNU/Linux
[opc@al ~]$
The VM has been running 24/7 without outage and the effective kernel is now higher than when installed.
Ksplice updatesThis effective kernel has been updated on Tue Jun 16 08:04:33 GMT 2020 as reported by this e-mail I received:
noreply@notification.eu-frankfurt-1.oraclecloud.com
Jun 16, 2020, 10:04 AM
to AutonomousLinux
+------------------------------------------------------------------------+
| Summary (Tue Jun 16 08:04:33 GMT 2020) |
+------------------------------------------------------------------------+
Ksplice updates installed: yes
Yum updates installed: no
Uptime: 08:04:33 up 24 days, 2:27, 0 users, load average: 0.72, 0.20, 0.06
+------------------------------------------------------------------------+
| Ksplice upgrade report |
+------------------------------------------------------------------------+
Running 'ksplice -y all upgrade'.
Updating on-disk packages for new processes
Loaded plugins: langpacks
No packages marked for update
Nothing to do.
The following steps will be taken:
Install [i622mubr] Information leak in KVM_HC_CLOCK_PAIRING hypercall.
Install [35xnb9pi] CVE-2019-9500: Potential heap overflow in Broadcom FullMAC WLAN driver.
Install [ppqwl5uh] CVE-2019-15505: Out-of-bounds access in Technisat DVB-S/S2 USB2.0 driver.
Install [ctobm6wo] CVE-2019-19767: Use-after-free in with malformed ext4 filesystems.
Install [l5so0kqe] CVE-2019-19056, CVE-2019-19057: Denial-of-service in the Marvell mwifiex PCIe driver.
Install [b4iszmv7] CVE-2019-20636: Out-of-bounds write via crafted keycode table.
Install [5oec4s3n] Denial-of-service when mounting an ocfs2 filesystem.
Install [rafq9pe9] CVE-2019-9503: Denial-of-service when receiving firmware event frames over a Broadcom WLAN USB dongle.
Install [nlpu7kxi] Denial-of-service when initializing a serial CAN device.
Install [lnz9di5t] CVE-2020-11608: NULL pointer dereference when initializing USB GSPCA based webcams.
Install [2bodr9yk] CVE-2019-19537: Denial-of-service in USB character device registration.
Install [9iw2y1wn] CVE-2019-19524: Use-after-free when unregistering memoryless force-feedback driver.
Install [h5s7eh41] CVE-2020-11609: NULL pointer dereference when initializing STV06XX USB Camera device.
Install [behlqry8] Denial-of-service via invalid TSC values in KVM.
Install [onllaobw] CVE-2019-12819: Use-after-free during initialization of MDIO bus driver.
Install [fdn63bdc] CVE-2019-11599: Information leak in the coredump implementation.
Install [kb3b03z9] CVE-2019-19058: Denial-of-service in iwlwifi firmware interface.
Install [mgfi6p6r] Use-after-free when writing to SLIP serial line.
Install [hs2h9j8w] CVE-2019-14896, CVE-2019-14897: Denial-of-service when parsing BSS in Marvell 8xxx Libertas WLAN driver.
Install [bb9sd52m] CVE-2020-11668: NULL pointer dereference when initializing Xirlink C-It USB camera device.
Install [p4ygwgyj] Information leak in KVM's VMX operation path.
Install [1uxt1xo6] NFSv4 client fails to correctly renew lease when using fsinfo.
Install [hjoeh3zi] CVE-2020-0543: Side-channel information leak using SRBDS.
Installing [i622mubr] Information leak in KVM_HC_CLOCK_PAIRING hypercall.
Installing [35xnb9pi] CVE-2019-9500: Potential heap overflow in Broadcom FullMAC WLAN driver.
Installing [ppqwl5uh] CVE-2019-15505: Out-of-bounds access in Technisat DVB-S/S2 USB2.0 driver.
Installing [ctobm6wo] CVE-2019-19767: Use-after-free in with malformed ext4 filesystems.
Installing [l5so0kqe] CVE-2019-19056, CVE-2019-19057: Denial-of-service in the Marvell mwifiex PCIe driver.
Installing [b4iszmv7] CVE-2019-20636: Out-of-bounds write via crafted keycode table.
Installing [5oec4s3n] Denial-of-service when mounting an ocfs2 filesystem.
Installing [rafq9pe9] CVE-2019-9503: Denial-of-service when receiving firmware event frames over a Broadcom WLAN USB dongle.
Installing [nlpu7kxi] Denial-of-service when initializing a serial CAN device.
Installing [lnz9di5t] CVE-2020-11608: NULL pointer dereference when initializing USB GSPCA based webcams.
Installing [2bodr9yk] CVE-2019-19537: Denial-of-service in USB character device registration.
Installing [9iw2y1wn] CVE-2019-19524: Use-after-free when unregistering memoryless force-feedback driver.
Installing [h5s7eh41] CVE-2020-11609: NULL pointer dereference when initializing STV06XX USB Camera device.
Installing [behlqry8] Denial-of-service via invalid TSC values in KVM.
Installing [onllaobw] CVE-2019-12819: Use-after-free during initialization of MDIO bus driver.
Installing [fdn63bdc] CVE-2019-11599: Information leak in the coredump implementation.
Installing [kb3b03z9] CVE-2019-19058: Denial-of-service in iwlwifi firmware interface.
Installing [mgfi6p6r] Use-after-free when writing to SLIP serial line.
Installing [hs2h9j8w] CVE-2019-14896, CVE-2019-14897: Denial-of-service when parsing BSS in Marvell 8xxx Libertas WLAN driver.
Installing [bb9sd52m] CVE-2020-11668: NULL pointer dereference when initializing Xirlink C-It USB camera device.
Installing [p4ygwgyj] Information leak in KVM's VMX operation path.
Installing [1uxt1xo6] NFSv4 client fails to correctly renew lease when using fsinfo.
Installing [hjoeh3zi] CVE-2020-0543: Side-channel information leak using SRBDS.
Your kernel is fully up to date.
Effective kernel version is 4.14.35-1902.303.4.1.el7uek
+------------------------------------------------------------------------+
| Yum upgrade report |
+------------------------------------------------------------------------+
Running 'yum-cron' with update cmd: default.
+------------------------------------------------------------------------+
| Ksplice updates status |
+------------------------------------------------------------------------+
Running 'ksplice all show'.
Ksplice user-space updates:
No Ksplice user-space updates installed
Ksplice kernel updates:
Installed updates:
[cp1p7rl5] Known exploit detection.
[3kfqruxl] Known exploit detection for CVE-2017-7308.
[6vy9wlov] Known exploit detection for CVE-2018-14634.
[r8wncd28] KPTI enablement for Ksplice.
[3e9je971] Known exploit detection for CVE-2018-18445.
[20bmudk6] Out-of-bounds access when classifying network packets with traffic control index.
[oy5cke5u] NULL dereference while writing Hyper-V SINT14 MSR.
[5jsm8lzj] CVE-2020-9383: Information leak in floppy disk driver.
[5p7yd05e] NULL pointer dereference when initializing Differentiated Services marker driver.
[sajmv0xh] CVE-2018-19854: Information leak in cryptography socket NETLINK_CRYPTO call.
[1gefn4lp] CVE-2019-19965: Denial-of-service in SCSI device removal.
[6hu77eez] Invalid memory access when sending an excessively large packet using Segmentation Offloads.
[f0zxddhg] Livelock in loop device block resize operation.
[2lgm3hz9] CVE-2019-14814, CVE-2019-14815, CVE-2019-14816: Denial-of-service when parsing access point settings in Marvell WiFi-Ex driver.
[3yqxyw42] CVE-2019-20096: Memory leak while changing DCCP socket SP feature values.
[9g5kf79r] Improved fix for CVE-2020-2732: Privilege escalation in Intel KVM nested emulation.
[bq9hiiuj] Race condition in ipoib during high request load causes denial-of-service.
[3youemoz] CVE-2020-11494: Information leak in serial line CAN device communication.
[jpbi3wnm] Use-after-free when removing generic block device.
[if1ety6t] Memory corruption when reading EFI sysfs entries.
[iv8r17d8] CVE-2020-8648: Use-after-free in virtual terminal selection buffer.
[mojwd0zk] Various Spectre-V1 information leaks in KVM.
[nvi6r5wx] CVE-2019-19527: Denial-of-service in USB HID device open.
[o3df6mds] CVE-2020-8647, CVE-2020-8649: Use-after-free in the VGA text console driver.
[kjyqg48a] CVE-2019-19532: Denial-of-service when initializing HID devices.
[74j9dhee] Divide-by-zero when CPU capacity changes causes denial-of-service.
[lgsoxuy7] CVE-2019-19768: Use-after-free when reporting an IO trace.
[i622mubr] Information leak in KVM_HC_CLOCK_PAIRING hypercall.
[35xnb9pi] CVE-2019-9500: Potential heap overflow in Broadcom FullMAC WLAN driver.
[ppqwl5uh] CVE-2019-15505: Out-of-bounds access in Technisat DVB-S/S2 USB2.0 driver.
[ctobm6wo] CVE-2019-19767: Use-after-free in with malformed ext4 filesystems.
[l5so0kqe] CVE-2019-19056, CVE-2019-19057: Denial-of-service in the Marvell mwifiex PCIe driver.
[b4iszmv7] CVE-2019-20636: Out-of-bounds write via crafted keycode table.
[5oec4s3n] Denial-of-service when mounting an ocfs2 filesystem.
[rafq9pe9] CVE-2019-9503: Denial-of-service when receiving firmware event frames over a Broadcom WLAN USB dongle.
[nlpu7kxi] Denial-of-service when initializing a serial CAN device.
[lnz9di5t] CVE-2020-11608: NULL pointer dereference when initializing USB GSPCA based webcams.
[2bodr9yk] CVE-2019-19537: Denial-of-service in USB character device registration.
[9iw2y1wn] CVE-2019-19524: Use-after-free when unregistering memoryless force-feedback driver.
[h5s7eh41] CVE-2020-11609: NULL pointer dereference when initializing STV06XX USB Camera device.
[behlqry8] Denial-of-service via invalid TSC values in KVM.
[onllaobw] CVE-2019-12819: Use-after-free during initialization of MDIO bus driver.
[fdn63bdc] CVE-2019-11599: Information leak in the coredump implementation.
[kb3b03z9] CVE-2019-19058: Denial-of-service in iwlwifi firmware interface.
[mgfi6p6r] Use-after-free when writing to SLIP serial line.
[hs2h9j8w] CVE-2019-14896, CVE-2019-14897: Denial-of-service when parsing BSS in Marvell 8xxx Libertas WLAN driver.
[bb9sd52m] CVE-2020-11668: NULL pointer dereference when initializing Xirlink C-It USB camera device.
[p4ygwgyj] Information leak in KVM's VMX operation path.
[1uxt1xo6] NFSv4 client fails to correctly renew lease when using fsinfo.
[hjoeh3zi] CVE-2020-0543: Side-channel information leak using SRBDS.
Effective kernel version is 4.14.35-1902.303.4.1.el7uek
--
You are receiving notifications as a subscriber to the topic: AL (Topic OCID: ocid1.onstopic.oc1.eu-frankfurt-1.aaaaaaaaamo7khj3xab6oec5xt5c7ia6eokqszapwsafeje6g6ltlnhd363a). To stop receiving notifications from this topic, unsubscribe.
Please do not reply directly to this email. If you have any questions or comments regarding this email, contact your account administrator.
I’ve also seen a notification about failed updates:
+------------------------------------------------------------------------+
| Summary (Mon Jun 29 08:03:19 GMT 2020) |
+------------------------------------------------------------------------+
Ksplice updates installed: failed
Yum updates installed: no
Uptime: 08:03:19 up 37 days, 2:25, 0 users, load average: 0.31, 0.08, 0.03
+------------------------------------------------------------------------+
| Ksplice upgrade report |
+------------------------------------------------------------------------+
Running 'ksplice -y all upgrade'.
Updating on-disk packages for new processes
Loaded plugins: langpacks
No packages marked for update
Nothing to do.
Unexpected error communicating with the Ksplice Uptrack server. Please
check your network connection and try again. If this error re-occurs,
e-mail ksplice-support_ww@oracle.com.
(Network error: TCP connection reset by peer)
Ok, network error at that time.
However, the next run was ok:
+------------------------------------------------------------------------+
| Summary (Tue Jun 30 08:03:13 GMT 2020) |
+------------------------------------------------------------------------+
Ksplice updates installed: no
Yum updates installed: no
Uptime: 08:03:13 up 38 days, 2:25, 1 user, load average: 0.00, 0.00, 0.00
and I can confirm by running manually:
[opc@al ~]$ ksplice -y all upgrade
Error: failed to configure the logger
[opc@al ~]$ sudo ksplice -y all upgrade
Updating on-disk packages for new processes
Loaded plugins: langpacks
ol7_x86_64_userspace_ksplice | 2.8 kB 00:00:00
No packages marked for update
100% |################################################################################################################################################################|
Nothing to do.
Nothing to be done.
Your kernel is fully up to date.
Effective kernel version is 4.14.35-1902.303.4.1.el7uek
Ksplice is about the kernel and some user space libraries such as glibc and openssl.
But Autonomous Linux also updates the packages.
In addition to kernel patches, the packages are also updated:
The following updates will be applied on al:
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
kernel x86_64 3.10.0-1127.13.1.el7 al7 50 M
Updating:
bpftool x86_64 3.10.0-1127.13.1.el7 al7 8.4 M
ca-certificates noarch 2020.2.41-70.0.el7_8 al7 382 k
kernel-tools x86_64 3.10.0-1127.13.1.el7 al7 8.0 M
kernel-tools-libs x86_64 3.10.0-1127.13.1.el7 al7 8.0 M
libgudev1 x86_64 219-73.0.1.el7_8.8 al7 107 k
microcode_ctl x86_64 2:2.1-61.10.0.1.el7_8 al7 2.7 M
ntpdate x86_64 4.2.6p5-29.0.1.el7_8.2 al7 86 k
python-perf x86_64 3.10.0-1127.13.1.el7 al7 8.0 M
python36-oci-cli noarch 2.12.0-1.el7 al7 4.4 M
python36-oci-sdk x86_64 2.17.0-1.el7 al7 10 M
rsyslog x86_64 8.24.0-52.el7_8.2 al7 620 k
selinux-policy noarch 3.13.1-266.0.3.el7_8.1 al7 497 k
selinux-policy-targeted noarch 3.13.1-266.0.3.el7_8.1 al7 7.2 M
systemd x86_64 219-73.0.1.el7_8.8 al7 5.1 M
systemd-libs x86_64 219-73.0.1.el7_8.8 al7 416 k
systemd-python x86_64 219-73.0.1.el7_8.8 al7 143 k
systemd-sysv x86_64 219-73.0.1.el7_8.8 al7 95 k
Removing:
kernel x86_64 3.10.0-1127.el7 @anaconda/7.8 64 M
Transaction Summary
================================================================================
Install 1 Package
Upgrade 17 Packages
Remove 1 Package
The updates were successfully applied
All packages are maintained up-to-date without human intervention and without downtime.
Package repositoryThe package repository is limited:
[opc@al ~]$ yum repolist
Loaded plugins: langpacks
ol7_x86_64_userspace_ksplice/primary_db | 193 kB 00:00:00
repo id repo name status
!al7/x86_64 Autonomous Linux 7Server (x86_64) 3,392
ol7_x86_64_userspace_ksplice Ksplice aware userspace packages for Oracle Linux 7Server (x86_64) 438
repolist: 3,830
[opc@al ~]$ yum list all | wc -l
1462
1462 packages in one repo.
As a comparison, here is an Oracle Enterprise Linux image:
[opc@ol ~]$ yum repolist
Loaded plugins: langpacks, ulninfo
Repodata is over 2 weeks old. Install yum-cron? Or run: yum makecache fast
repo id repo name status
!ol7_UEKR5/x86_64 Latest Unbreakable Enterprise Kernel Release 5 for Oracle Linux 7Server (x86_64) 200
!ol7_addons/x86_64 Oracle Linux 7Server Add ons (x86_64) 421
!ol7_developer/x86_64 Oracle Linux 7Server Development Packages (x86_64) 1,319
!ol7_developer_EPEL/x86_64 Oracle Linux 7Server Development Packages (x86_64) 31,78$
!ol7_ksplice Ksplice for Oracle Linux 7Server (x86_64) 6,41$
!ol7_latest/x86_64 Oracle Linux 7Server Latest (x86_64) 18,86$
!ol7_oci_included/x86_64 Oracle Software for OCI users on Oracle Linux 7Server (x86_64) 26$
!ol7_optional_latest/x86_64 Oracle Linux 7Server Optional Latest (x86_64) 13,91$
!ol7_software_collections/x86_64 Software Collection Library release 3.0 packages for Oracle Linux 7 (x86_64) 14,47$
repolist: 87,645
[opc@ol ~]$ yum list all | wc -l
Repodata is over 2 weeks old. Install yum-cron? Or run: yum makecache fast
36720
[opc@ol ~]$
There is a lot more here. Remember that OEL is compatible with RHEL.
If you need more packages you can open a SR and ask to have it added to the Autonomous Linux repository. For example, I use tmux everyday, especially in a free tier VM (see https://blog.dbi-services.com/always-free-always-up-tmux-in-the-oracle-cloud-with-ksplice-updates/).
If you don’t want to ask for it, there’s the possibility to add public-yum-ol7.repo there:
[opc@al ~]$ sudo yum-config-manager --add-repo http://yum.oracle.com/public-yum-ol7.repo
Loaded plugins: langpacks
adding repo from: http://yum.oracle.com/public-yum-ol7.repo
grabbing file http://yum.oracle.com/public-yum-ol7.repo to /etc/yum.repos.d/public-yum-ol7.repo
repo saved to /etc/yum.repos.d/public-yum-ol7.repo
This added the public Oracle Enterprise Linux repository. Is it correct to do that? It depends what you want: the minimum validated by Oracle to be autonomously updated without any problem, or a little additional customization.
And then install the package you want:
[opc@al ~]$ sudo yum install -y tmux
Loaded plugins: langpacks
Resolving Dependencies
--> Running transaction check
---> Package tmux.x86_64 0:1.8-4.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
========================================================================================================================================================================
Package Arch Version Repository Size
========================================================================================================================================================================
Installing:
tmux x86_64 1.8-4.el7 ol7_latest 241 k
Transaction Summary
========================================================================================================================================================================
Install 1 Package
Total download size: 241 k
Installed size: 554 k
Downloading packages:
tmux-1.8-4.el7.x86_64.rpm | 241 kB 00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : tmux-1.8-4.el7.x86_64 1/1
Verifying : tmux-1.8-4.el7.x86_64 1/1
Installed:
tmux.x86_64 0:1.8-4.el7
Now the package is installed and will be updated
Autonomous cronThose updates are scheduled by cron but you change the schedule through the al-config bash script provided:
[opc@al ~]$ sudo al-config -s
Current daily auto update time window(24-hour): 7-11
Current daily auto update time(24-hour): 08:03
This has set a random time during the 7am to 11 am window, which is here 08:03
[opc@al ~]$ cat /etc/cron.d/al-update
# Daily cron job for AL auto updates.
# Created by al-config, do not modify this file.
# If you want to change update time, use
# 'sudo al-config -w ' to set auto update time window
3 8 * * * root /usr/sbin/al-update >/dev/null
That’s the autonomous thing here: you don’t set the crontab job. You just call the al-config with a time window and it sets the crontab for you in a random time within this window.
Let’s play with this:
[opc@al ~]$ sudo al-config -w 0-2
Configured daily auto update time window(24-hour): 0-2
Configured daily auto update time(24-hour): 01:12
Created cron job file /etc/cron.d/al-update .
[opc@al ~]$ sudo al-config -w 0-2
Configured daily auto update time window(24-hour): 0-2
Configured daily auto update time(24-hour): 01:33
Created cron job file /etc/cron.d/al-update .
[opc@al ~]$ sudo al-config -w 0-2
Configured daily auto update time window(24-hour): 0-2
Configured daily auto update time(24-hour): 00:47
Created cron job file /etc/cron.d/al-update .
[opc@al ~]$ sudo al-config -w 0-2
Configured daily auto update time window(24-hour): 0-2
Configured daily auto update time(24-hour): 00:00
Created cron job file /etc/cron.d/al-update .
[opc@al ~]$ sudo al-config -w 0-2
Configured daily auto update time window(24-hour): 0-2
Configured daily auto update time(24-hour): 00:41
Created cron job file /etc/cron.d/al-update .
You see the idea. Very simple. But simple is awesome, right?
What is this scheduled job doing autonomously every day? You see it in the notification e-mail. Basically it runs:
ksplice -y all upgrade
yum-cron
ksplice all show
and sends the output to your e-mail
This is what keeps your Autonomous Linux up-to-date: ksplice, yum, and the output sent to your e-mail through:
Received: by omta-ad1-fd1-102-eu-frankfurt-1.omtaad1.vcndpfra.oraclevcn.com (Oracle Communications Messaging Server 8.1.0.1.20200619 64bit (built Jun 19 2020)) w
This is an excerpt from the notification e-mail headers. “Oracle Communications Messaging Server” is a heritage from Sun which, according to wikipedia, has its roots in Netscape Messaging Server. All those little bricks from years of enterprise IT are nicely wired together to bring this automation known as Autonomous.
Cet article Oracle Autonomous Linux: cron’d ksplice and yum updates est apparu en premier sur Blog dbi services.
Panini Internazionale Achieves Zero Waste Goal with Oracle
Stockholm, Sweden and Redwood Shores, Calif.—Jun 30, 2020
Panini Internazionale was borne out of a passion for food held by four brothers who opened their first deli in Stockholm, Sweden in 1990. Thirty years later, the fast-food brand delivers fresh and healthy food from 29 shops across Stockholm.
With a focus on contemporary fast-food that is both healthy and green, the only thing fast about Panini is its service. To deliver on its brand promise, goal of zero food waste, and exemplary service, the company relies on Oracle Food and Beverage MICROS Simphony Point-of-Sale (POS).
“We pride ourselves on not only delivering good food and service but also in doing good for our communities,” said Pierre Constantinou, co-founder Panini Internazionale. “With Oracle as our core foundation, we can easily pivot to new channels for our customers to engage how and when they desire while using back-end data to understand our inventory and eliminate waste by sharing our excess stock with those in need.”
Tech Helps Panini Deliver on Brand Values and Bottom LinePanini Cooks Up Innovation and Growth
Panini has been an early adopter of technology, introducing online ordering in the late 1990s. But as the business grew, it realized adding new channels to their POS added complexity and put their zero-waste commitment at risk. Operating a business based on fresh production and same-day consumption requires real-time supply and demand. Panini needed a better way to manage its menu and inventory, and streamline kitchen operations. The company adopted Oracle MICROS Simphony to get the intelligence they needed to manage everything from menu design and supplier relationships to forecasting demand down to the day and time. Panini also used Simphony to identify partnerships that are mutually beneficial to the brand.
Simphony also helped Panini reach its goal of zero waste. It uses technology to allocate remaining stock at a 50 percent discount to students for the last two hours of business, and at the end of the day nearby charities are alerted to pick up final stock. This commitment to zero waste is not only in alignment with their brand values, but it also supports a healthy bottom line.
“Data intelligence will be increasingly important as the restaurant industry rebounds,” said Simon de Montfort Walker, senior vice president and general manager for Oracle Food and Beverage. “Simphony gives Panini Internazionale a single view of their business so they can run operations efficiently, better manage the bottom line, and support their customers and communities.”
The Oracle Cloud offers a complete suite of integrated applications for Sales, Service, Marketing, Human Resources, Finance, Supply Chain and Manufacturing, plus Highly Automated and Secure Generation 2 Infrastructure featuring the Oracle Autonomous Database. For more information about Oracle (NYSE: ORCL), please visit us at www.oracle.com.
TrademarksOracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
AZ-204 | Azure Developer Associate | Everything You Need To Know
Azure provides businesses with resources to run their computing operations on the Cloud, which is why more and more organizations are gradually moving their operations to the Cloud. Wouldn’t it be just great if you have the right skills to help these organizations take their operations to Cloud? Becoming a Microsoft Certified Azure Developer by […]
The post AZ-204 | Azure Developer Associate | Everything You Need To Know appeared first on Oracle Trainings for Apps & Fusion DBA.
High Availability and Scalable Application In Kubernetes
High Availability In Kubernetes is a very important task to minimize the failover in Cluster. Having hands-on experience of Step High Availability and scalable application In Kubernetes will help you land up in a highly paid job and have the edge over the others. Check out our Part 4 of 5 part video series on […]
The post High Availability and Scalable Application In Kubernetes appeared first on Oracle Trainings for Apps & Fusion DBA.
Pages
