Welcome!

Weblogic Authors: Yeshim Deniz, Elizabeth White, Michael Meiner, Michael Bushong, Avi Rosenthal

Related Topics: Recurring Revenue

Recurring Revenue: Article

Oracle Database Upgrades Faster and Safer in Amazon Web Services

AWS quick provisioning capabilities redefine Oracle upgrades

Oracle database upgrades are a stressful exercise. Normally you need to backup production database, upgrade database software, then run database scripts that will upgrade dictionary. Once it is all done and success is confirmed you can start using upgraded database. If something goes wrong then you rely on backups to restore to a  previous state. In other words, there is complete dependency on backups and restore success if things go wrong.

AWS gives us possibility to quickly and cheaply create new database instances where an upgrade can be tested. We can also instantly create completely new database environment as replacement for regular backups during actual upgrade. This environment is ready to take over the role of main database in case upgrade fails, thus sparing us time and stress of restore process. Last but not least, we can quickly commission and decommission as many servers as we need to comfortably complete upgrade exercise. This is usually not easily achieved in normal circumstances where new servers and storage provisioning requires long lead times and lengthy discussions with various departments.

For purposes of this article we will suppose that our main, production Oracle database server already runs in AWS.  In order to safely test database upgrade we need to create another instance as copy of main database. This can be done very quickly by starting another AWS instance, copying Oracle binaries from main database, then performing RMAN duplicate or similar to copy database files to our test instance. Now we can test an Oracle upgrade from 10g to 11i,  for example. Once testing is successfully completed we will shut down this instance and "decommission" it i.e. completely stop further charges.

When we decide to perform actual production database upgrade steps would be:

- create an AWS instance as copy of database to be upgraded ( start an AWS instance, copy database files ); test if copy is functional

- perform main database upgrade

- test

- if testing is successful, continue using main database; "decommission" auxiliary database server; our upgrade is completed

- if testing is not successful then failover to database copy; we are safely aborting upgrade process and avoiding potentially lengthy and risky restore

AWS gives us possibility to quickly and cheaply create and decommission additional copies of main database, thus enabling more comfortable, less risky operations on main databases.

More Stories By Ranko Mosic

Ranko Mosic, BScEng, is specializing in Big Data/Data Architecture consulting services ( database/data architecture, machine learning ). His clients are in finance, retail, telecommunications industries. Ranko is welcoming inquiries about his availability for consulting engagements and can be reached at 408-757-0053 or [email protected]

IoT & Smart Cities Stories
When talking IoT we often focus on the devices, the sensors, the hardware itself. The new smart appliances, the new smart or self-driving cars (which are amalgamations of many ‘things'). When we are looking at the world of IoT, we should take a step back, look at the big picture. What value are these devices providing. IoT is not about the devices, its about the data consumed and generated. The devices are tools, mechanisms, conduits. This paper discusses the considerations when dealing with the...
SYS-CON Events announced today that IoT Global Network has been named “Media Sponsor” of SYS-CON's @ThingsExpo, which will take place on June 6–8, 2017, at the Javits Center in New York City, NY. The IoT Global Network is a platform where you can connect with industry experts and network across the IoT community to build the successful IoT business of the future.
Poor data quality and analytics drive down business value. In fact, Gartner estimated that the average financial impact of poor data quality on organizations is $9.7 million per year. But bad data is much more than a cost center. By eroding trust in information, analytics and the business decisions based on these, it is a serious impediment to digital transformation.
To Really Work for Enterprises, MultiCloud Adoption Requires Far Better and Inclusive Cloud Monitoring and Cost Management … But How? Overwhelmingly, even as enterprises have adopted cloud computing and are expanding to multi-cloud computing, IT leaders remain concerned about how to monitor, manage and control costs across hybrid and multi-cloud deployments. It’s clear that traditional IT monitoring and management approaches, designed after all for on-premises data centers, are falling short in ...
Machine learning has taken residence at our cities' cores and now we can finally have "smart cities." Cities are a collection of buildings made to provide the structure and safety necessary for people to function, create and survive. Buildings are a pool of ever-changing performance data from large automated systems such as heating and cooling to the people that live and work within them. Through machine learning, buildings can optimize performance, reduce costs, and improve occupant comfort by ...
The best way to leverage your Cloud Expo presence as a sponsor and exhibitor is to plan your news announcements around our events. The press covering Cloud Expo and @ThingsExpo will have access to these releases and will amplify your news announcements. More than two dozen Cloud companies either set deals at our shows or have announced their mergers and acquisitions at Cloud Expo. Product announcements during our show provide your company with the most reach through our targeted audiences.
CloudEXPO New York 2018, colocated with DXWorldEXPO New York 2018 will be held November 11-13, 2018, in New York City and will bring together Cloud Computing, FinTech and Blockchain, Digital Transformation, Big Data, Internet of Things, DevOps, AI, Machine Learning and WebRTC to one location.
Andrew Keys is Co-Founder of ConsenSys Enterprise. He comes to ConsenSys Enterprise with capital markets, technology and entrepreneurial experience. Previously, he worked for UBS investment bank in equities analysis. Later, he was responsible for the creation and distribution of life settlement products to hedge funds and investment banks. After, he co-founded a revenue cycle management company where he learned about Bitcoin and eventually Ethereal. Andrew's role at ConsenSys Enterprise is a mul...
DXWorldEXPO | CloudEXPO are the world's most influential, independent events where Cloud Computing was coined and where technology buyers and vendors meet to experience and discuss the big picture of Digital Transformation and all of the strategies, tactics, and tools they need to realize their goals. Sponsors of DXWorldEXPO | CloudEXPO benefit from unmatched branding, profile building and lead generation opportunities.
Disruption, Innovation, Artificial Intelligence and Machine Learning, Leadership and Management hear these words all day every day... lofty goals but how do we make it real? Add to that, that simply put, people don't like change. But what if we could implement and utilize these enterprise tools in a fast and "Non-Disruptive" way, enabling us to glean insights about our business, identify and reduce exposure, risk and liability, and secure business continuity?