Q
Manage Learn to apply best practices and optimize your operations.

Can an Oracle database update from mainframe jobs?

Can administrators set IBM mainframe jobs to update Oracle databases directly, or are there incompatibilities between the systems?

It all depends on your current version of Oracle Database.

You can do a direct Oracle database update with mainframe jobs provided you have an older version of the product.

Updating the database works with Oracle Database v10 clients. The functionality to update Oracle Database directly with a mainframe job is no longer supported on the 11g or 12c deployments.

If you have a version of Oracle Database that supports this direct update, you will need to install the z/OS client or the Oracle Access Manager for CICS on the mainframe, if you do not already have them. The application architecture determines which of these to use.

Editor's note: Oracle Database 10g has been unsupported since July 2013 (for version 2). Oracle 11g, released in 2009, and 12c, released in 2013, succeed the database. Oracle 12c marked a change in the database strategy from grid computing (g) to multi-tenancy with cloud (c).

Oracle introduced 11g for improved data manageability, availability, data storage and security compared with previous versions. It includes upgrades to clustering, data center automation and workload management components. XML upgrades were designed to improve user access to data.

Oracle Database 12c's multitenant architecture allows users to consolidate databases to the cloud and manage them as one entity. Applications can access these multi-tenant databases in the same manner as they do a standard database. It also expedites cloning and provisioning of databases.

About the author:
Joe Clabby is the president of Clabby Analytics and has more than 32 years of experience in the IT industry, with positions in marketing, research and analysis. Clabby is an expert in application reengineering services, systems and storage design, data center infrastructure, and integrated service management. He has produced in-depth technical reports on various technologies, such as virtualization, provisioning, cloud computing and application design.

This was last published in January 2015

Dig Deeper on IBM system z and mainframe systems

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Join the conversation

1 comment

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

Do you have problems integrating Oracle database updates with the mainframe?
Cancel

-ADS BY GOOGLE

SearchWindowsServer

SearchServerVirtualization

SearchCloudComputing

Close