WIXLIB

Oracle 11g on OpenVMS and Rdb 7.3Feature HighlightsWolfgang Kobarg-Sachsse, Oracle Rdb SupportBased on presentations from Gary Huffman,Oracle OpenVMS Engineering Group, and IanSmith, Oracle Rdb Engineering.

Oracle on OpenVMS UpdateAn overviewGary HuffmanSenior Development ManagerOracle OpenVMS Engineering Group

Safe Harbor StatementThe following is intended to outline our general product direction. It is intended forinformation purposes only, and may not be incorporated into any contract. It is not acommitment to deliver any material, code, or functionality, and should not be relied uponin making purchasing decisions. The development, release, and timing of any features orfunctionality described for Oracle’s products remains at the sole discretion of Oracle.Copyright 2014, Oracle and/or its affiliates. All rights reserved. 4

Program AgendaReview of Current ProductsReview Oracle Database 11gR2Features Available in Oracle Database 11gR2Copyright 2014, Oracle and/or its affiliates. All rights reserved. 5

10g Support Dates Extended Support ended 31-Jul-2013 Terminal PSU for both Alpha and Integrity– 10.2.0.5.12 July 2013 Limited Extended Support Added For All Platforms– From Aug 2013 through July 2015 Limited Extended Support is available, Sev 1fixes only (no Patch Set Update (PSU) or Security Patch Update (SPU) will beproduced) Additional Extended Support periods will be available for currentExtended Support feesCopyright 2014, Oracle and/or its affiliates. All rights reserved. 6

Limited Extended Support for OpenVMS Integrity Oracle is waiving all Extended Support fees until July 31, 2015 forcustomers running Oracle Database 10g Release 2 on OpenVMSIntegrity. After July 31, 2015 a Limited Extended Support service willbe available through July 31, 2017 to those customers at thencurrent charges for Extended Support, with the main limitation beingthat no Patch Set Updates or Critical Patch Updates will be produced.Please see the Oracle Software Technical Support Policies document(pages 6-7) for complete details.Copyright 2014, Oracle and/or its affiliates. All rights reserved. 7

Oracle Database 10gR2 Support DatesIntegrity PlatformsPlatformAdditional Extended Support: S1Fixes OnlyHP OpenVMS on IntegrityAugust 2015 – July 2017HP OpenVMS on AlphaAugust 2013 – July 2015HP-UXAugust 2013 – Dec 2015Linux IntegrityAugust 2013 – Dec 2015Windows IntegrityAugust 2013 – Dec 2015Copyright 2014, Oracle and/or its affiliates. All rights reserved.

Certification Documentation My Oracle Support (MOS) Document– https://support.oracle.com– Doc ID 742060.1 Note– Please use this document as the current support matrix It is updated frequently– This document does not limit Oracle in what will be delivered Primary function is to document high volume releasesCopyright 2014, Oracle and/or its affiliates. All rights reserved.

Review of Current Products for the Oracle Database onOpenVMS 10.2.0.5.0 Released 31-Oct-2012– 10.2.0.5.12 PSU available for Alpha & Integrity Grid Control Agent– 10.2.0.2 Agent for Integrity and Alpha shipping Patch kit 6 is availableCopyright 2014, Oracle and/or its affiliates. All rights reserved. 10

Review of Current Products for Oracle Database onOpenVMS 10.2.0.5.0 is a Patch Set– Suggest install in a new Oracle home– Install initial 10.2.0.2.0 release* For Alpha no need to apply any patchesFor Integrity you should apply the patch 5840282 before applying this patch setNo need to install 10.2.0.4.0 before installing 10.2.0.5.0Apply the 10.2.0.5.0 Patch Set OpenVMS 8.4 is the minimum OS version for both Alpha and Integrity Can be downloaded from My Oracle Support (MOS) – Patch # 8202632* MOS Note 1071023.1 documents how to request a DVD or access to a downloadable imageCopyright 2014, Oracle and/or its affiliates. All rights reserved. 11

Additional Supported Features Mixed Architecture RAC – (MAR)– Released supporting 10.2.0.4.0– 10.2.0.5.0 is supported Both the Alpha and Integrity systems must run the same version of Oracle – matching patches as faras possible Data Vault– Released with 10.2.0.4.0– Updated with 10.2.0.5.0Copyright 2014, Oracle and/or its affiliates. All rights reserved. 12

Oracle MySupport OpenVMS Information OpenVMS: Master Note for Oracle 10.2 on hp OpenVMS [ID 726914.1] OpenVMS: Oracle Release 10gR2 Mixed Architecture (Multi-Home) CRS/RACInstallation on hp Integrity and Alpha [ID 785970.1] OpenVMS: Getting started with the 10.2 Grid Control Agent on OpenVMS [ID 739445.1] Installing AV Agent 10.2.3.2 on HP OpenVMS [ID 1111278.1] Master Note For Oracle Audit Vault– [ID 1199033.1]Copyright 2014, Oracle and/or its affiliates. All rights reserved. 13

Review of Oracle Database11gR2Copyright 2014, Oracle and/or its affiliates. All rights reserved.

Oracle Database 11gR2 on OpenVMS Will be a full release - Server/Client Kit– Web images No instant client Will provide new Oracle features to OpenVMS Integrity– Note: An incremental set of features will be available for OpenVMS Not all Oracle features will be available on OpenVMSCopyright 2014, Oracle and/or its affiliates. All rights reserved. 15

OpenVMS 11g Porting Environment (VPE) Integrity OpenVMS only planned 11gR2 only available for OpenVMS 8.4– We use OpenVMS sym-links to create the release We are doing labels and builds every two weeks as a default– This is including completing core testing 40% larger than 10.2.0.5.0Copyright 2014, Oracle and/or its affiliates. All rights reserved. 16

Status October 2014 November 2012 we resumed 11.2.0.2.0– Merged all changes from 10.2.0.5.0 release Skipped 11.2.0.3.0 Base Released 11.2.0.4.0 in August 2013– We merged to 11.2.0.4.0 label Starting Q3CY2013 Three months of work– CY2014 Operating System Code (OSD) development continues Short regressions in process Long regressions startedCopyright 2014, Oracle and/or its affiliates. All rights reserved. 17

Status October 2014 11.2.0.4.0 is final Patch Set for the 11.2 code line– PSU planned available until at least Jan 2018 See MOS note 742060.1– Plan is to release the current PSU approximately the same time as our 11gR2 releaseCopyright 2014, Oracle and/or its affiliates. All rights reserved. 18

Status October 2014 Approximately 1.1 Million entries in the label– 216110 source files .c,.h,.cpp,.hpp,.java .hxx .pl .pm– 304705 support files and test files Makefile,.mk,.tsc,.logCopyright 2014, Oracle and/or its affiliates. All rights reserved. 19

Status October 2014 End of October– 5828 files have been branched for OpenVMS 2398 source files 1089 support files 2341 various other– .txt .com ,sql ,sqlj .xml {installer files}Copyright 2014, Oracle and/or its affiliates. All rights reserved. 20

Porting Issues Encountered Compile time issues– Uninitialized variables– Type-casting miss matches– Implicitly declared routines– Compiler directives “ start" and " end"– Unsupported #pragmaCopyright 2014, Oracle and/or its affiliates. All rights reserved. 21

Porting Issues Encountered Java Porting (yes , there are porting issues with Java)– System.getenv() on Open VMS only returns specified variable Linux has option to return all of the environment variables– Difference in symbol interpretation i.e. ; : # !– Creation of external scripts DCL vs Unix shell– Device access Unix references RAW Devices Default Block Size (512 vs 1024)Copyright 2014, Oracle and/or its affiliates. All rights reserved. 22

Porting Issues Encountered Build Issue With 11.2.0.4 oracle.exe image too large to link static– Implemented shared libraries for the oracle.exe image 1.soCopyright 2014, Oracle and/or its affiliates. All rights reserved. 23

Porting Issues Encountered Environment issues– Base does component builds OpenVMS does full bundle builds– Base does all builds within source control system (ADE) OpenVMS does SRCHOME builds– Base promotes Derived Objects OpenVMS utilizes Repositories– These differences lead to process contentions that OpenVMS encountersCopyright 2014, Oracle and/or its affiliates. All rights reserved. 24

Porting Issues Encountered Environment Issues (cont)– Affects build and QA process flow– VMS Pool and SGA sizes are larger than Linux defaults– Test environment relies on Unix style path's to access– OpenVMS has to change scripts to enable “T WORK", "T COM", "T SOURCE"– Frequently encounter path too long on OpenVMSCopyright 2014, Oracle and/or its affiliates. All rights reserved. 25

Porting Issues Encountered Implementation Issues for Oracle run-time– Perl is supported by PLSQL External Procedures Involved adding Perl support within the native framework of the QA and install environment– Filename conversion Often encounter strings like this– disk :[oracle home.]/trc/trace.dmpCopyright 2014, Oracle and/or its affiliates. All rights reserved. 26

Porting Issues Encountered Implementation Issues for Oracle run-time (cont)– Mixed case file-name support Implemented changes to the Server Background process– define/nolog DECC ARGV PARSE STYLE ENABLE ! preserve argv case– define/nolog DECC EFS CASE PRESERVE ENABLE ! enable ODS-5 names– define/nolog DECC EFS CASE SPECIAL ENABLE ! enable ODS-5 names– define/nolog DECC EFS CHARSETENABLE ! enable ODS-5 namesCopyright 2014, Oracle and/or its affiliates. All rights reserved. 27

Features available for Oracle Database 11gR2Overview of 11gR2 In Memory Database Cache Unstructured Data Types Real Applications TestingCopyright 2014, Oracle and/or its affiliates. All rights reserved.

PerformanceImprove performance by at least 10xCopyright 2014, Oracle and/or its affiliates. All rights reserved.

Oracle In Memory Database CacheOffload Workload to the Middle Tier Data cached in application memory– Database tables– Subsets of rows & hed tablesCached tables Standard SQL interface– Synchronized with Oracle Database Utilizes middle tier resources Fast, consistent response times– High transaction throughputCopyright 2014, Oracle and/or its affiliates. All rights reserved.

Oracle In Memory Database CacheCross-tier High Availability Automatic Client Connection Failover Integration with Oracle ClusterwareBusinessApplicationsCache tablesBusinessApplicationsCachetables Manages TimesTen / IMDB Cache processes Integration with Oracle RAC Automatic recovery from Oracle Database RACnode failures using TAF and FANIn-Memory Database Cache Support Data Guard synchronous physicalstandby Failover Switchover Rolling upgradeData GuardReal Application ClustersCopyright 2014, Oracle and/or its affiliates. All rights reserved. Standby Oracle Database

Oracle In Memory Database CacheApplication DevelopmentODBCttClassesOCIC/C Pro*CPL/SQLLanguageJ2EE App ServersIMDB CACHENew in 11g release PL/SQL, Oracle Call Interface (OCI) and Pro*C SupportCopyright 2014, Oracle and/or its affiliates. All rights reserved. OR Mapping

Oracle In Memory Database CacheLightning Fast Response Time14Microseconds1614millionthsofa second1210864204millionthsofa secondRead a RecordUpdate TransactionOracle TimesTen In-Memory Database 11g - Intel Xeon 3.0 Ghz 64-bit Oracle Enterprise LinuxCopyright 2014, Oracle and/or its affiliates. All rights reserved.

Oracle Database 11g Release 2In-Memory Parallel Execution Data warehouse environments can have largeamounts of memory that is not always used An algorithm places fragments of an object(partitions) in memory on different nodes Compression gets more data in memory Parallel servers (aka PQ Slaves) are thenexecuted on the corresponding nodesReal Application ClustersCopyright 2014, Oracle and/or its affiliates. All rights reserved.

Integrating Unstructured DataBetter business insight into all data typesCopyright 2014, Oracle and/or its affiliates. All rights reserved.

Integrating Unstructured DataNew in Oracle Database 11gRFID3DDICOMBinary XMLImagesSecureFilesCopyright 2014, Oracle and/or its affiliates. All rights reserved.