Transcription

Oracle Database 12c & Oracle Database12c RAC on IBM AIXTips and ConsiderationsRavisankar ShanmugamIBM Oracle International Competency CenterJuly, 2018Oracle Database 12c Release 1 & 2 and Oracle RAC 12c Release 1 & 2 on IBM AIX – Tips and Considerations Copyright 2018, IBM Corporation1

Table of contentsAbstract. 3Introduction . 3Terminology . 4IBM AIX. 4AIX support . 5C and C compilers . 6Oracle Database 12c Release 1 & 2 (Non RAC) . 7Current certifications . 7Oracle Database Latest patch set . 9Virtualization for Oracle Database 12c Release 1 & 2 (Non RAC) . 11Oracle Database 12c Release 1 & 2 RAC . 13Current certifications . 14Oracle Redundant Interconnect usage feature . 15Oracle Clusterware . 16IBM PowerHA (formerly High Availability Cluster Multi-Processing) . 16IBM Spectrum Scale (formerly General Parallel File System) . 16Virtualization for Oracle Database 12c Release 1 & 2 RAC . 17Network interconnects . 19Tuning tips . 21Automatic Storage Management . 22Asynchronous I/O . 23Concurrent I/O and direct I/O . 23File system cache size . 23RAC IPC . 24IBM Spectrum Scale (formerly General Parallel File System) . 24Oracle process memory footprint . 24Tuning resources . 25Summary . 27Resources . 28About the author. 29Trademarks and special notices . 30Oracle Database 12c Release 1 & 2 and Oracle RAC 12c Release 1 & 2 on IBM AIX – Tips and Considerations Copyright 2018, IBM Corporation2

AbstractThis paper consolidates the information necessary for planning and implementing Oracle Database 12c Release 1 & 2 (12.1 and 12.2) single instance database or Oracle Database 12c Release 1 & 2 Real Application Cluster (RAC) on the IBM AIX operating system.This paper summarizes the information available at the time of publication. It will be updated aschanges (eg. new certifications) occur. It is meant to be used only as a guide. For any officialOracle certification information, please consult Oracle’s “My Oracle Support” website.This paper is written to a level of detail that assumes readers have an in-depth knowledge ofAIX, Oracle Database 12c Release1 & 2, Oracle Database 12c Release 1 & 2 RAC and the related products.IntroductionThere are many technical topics to consider when running Oracle Database 12c Release 1 & 2 and Oracle Database 12c Release 1 & 2 RAC on AIX such as: status of Oracle certifications, 12c Release 1 & 2patch sets, AIX code levels, tuning and related software components - just to name a few. The documentation for these topics is spread across many websites, documents, presentations and forums. This paper consolidates that information for easy reference.This paper focuses on AIX 6.1, AIX 7.1 and AIX 7.2, since these are the AIX versions supported for Oracle Database 12c Release 1 & 2 (Stand-alone) and Oracle Database12c Release 1 & 2 RAC.This is a companion paper to three other papers. For 9i and 10gR1, Oracle 9i & 10gR1 on IBM AIX5L: Tips and ocs/atsmastr.nsf/WebIndex/WP100556For 10gR2, Oracle Database 10gR2 and Oracle RAC 10gR2 on IBM AIX: Tips and ocs/atsmastr.nsf/WebIndex/WP101089For 11g ,Oracle Database 11g R2 and Oracle RAC 11g R2 on IBM AIX: Tips and ocs/atsmastr.nsf/WebIndex/WP101176.The IBM Oracle International Competency Center (ICC) works closely with the IBM Oracle Center (IOC)in Montpellier, France and the IBM Oracle Competency Center in Tokyo, Japan. IBM Oracle Center, Montpellier, France – [email protected] Oracle Competency Center, Tokyo, Japan – [email protected]: Some of the "My Oracle Support" notes and web links referenced in this document for Oracle Database 12c Release 1 & 2 on IBM Power Systems/AIX are still being updated to reflect the up-to-date information.For question or feedback, please send a note to the IBM Oracle International Competency Center [email protected] Database 12c Release 1 & 2 and Oracle RAC 12c Release 1 & 2 on IBM AIX – Tips and Considerations Copyright 2018, IBM Corporation3

TerminologyIn 2008, the System p and System i product families were combined to create the IBM Power Systems product family. The IBM Power Systems product family includes systems previously referred to asSystem p, System p5 , eServer pSeries , RS6000 , System i , System i5 , eServer iSeries ,AS/400 ,Flex System, IBM PureFlex and IBM PureSystems.The brand name of “AIX 5L ” is no longer used. The term “AIX 5L” will still appear in some places in thisdocument, mostly in document titles which have yet to be updated.High Availability Cluster Multi-Processing (HACMP ) has been renamed to the PowerHA and PowerHA SystemMirror. This version of the document will use the name HACMP for version up to 5.4.1, PowerHA for version 5.5 and PowerHA SystemMirror for the version 6.1 and up.IBM AIXIBM AIX is an open standards-based, UNIX operating system. AIX in combination with IBM's virtualization offerings provides new levels of flexibility and performance to allow you to consolidate workloads onfewer servers, which can increase efficiency and conserve energy. AIX delivers high levels of security,integration, flexibility, scalability and reliability—essential for meeting the demands of today's informationtechnology environments. AIX operates on IBM Systems based on Power Architecture technology. Formore information about AIX, see this web page: BM and Oracle are advancing to focus on supporting AIX6.1, AIX7.1 and AIX 7.2 for Oracle Database12c Release 1 & 2. IBM’s latest certified AIX version for Oracle Database is AIX 7.2. It contains new features for virtualization, security, availability and manageability. AIX 7.2 is binary compatible with AIX 7.1,AIX 6.1 and AIX 5.x. AIX 7.2 includes supporting POWER9 , high-end POWER8 servers (E880) with192 CPUs can provide 1536 logical processors with the use of SMT8 and POWER7 servers with 256CPUs can provide up to 1024 logical processors with use of SMT 4 .For additional information and new features of AIX 7.2, and AIX 7.1 visit this web s/aixMost of the new features of AIX 7.2 and AIX 7.1 are available on earlier POWER platforms. However,the best capabilities are delivered on systems based on POWER9, POWER8 , POWER7 , POWER7 and POWER6 processors. POWER7 and later processors built for Smarter Planet and automatically optimize work load performance and capacity. New intelligent threads technology in POWER9,POWER8, POWER7 and Power7 dynamically switches the processor threading mode to deliver optimalperformance-either the highest per-thread performance or the maximum system throughput based onapplication requirements.POWER9, POWER8 and POWER7 Hardware Accelerator improve the efficiency of memory expansioneven more effectively allowing more memory expansion.On March 20, 2018 IBM introduced the next generation of new Power Systems servers, S924, S922, andS914 with POWER9 processor technology.These new Power Systems servers with POWER9 processors come with large memory footprint up to 4TB of DDR4 memory, up to 24 high speed POWER9 processor cores in one or two Single Chip ModuleOracle Database 12c Release 1 & 2 and Oracle RAC 12c Release 1 & 2 on IBM AIX – Tips and Considerations Copyright 2018, IBM Corporation4

(SCM) sockets, PCIe Gen4 to add more performance and flexibility for I/O configurations and Storagebackplane options. This system is designed to run commercial, cognitive, and database workloads.Customers can continue to choose IBM POWER8 processor based servers from one socket scale outserver with up to 8 cores to 16 sockets enterprise class servers up to 192 cores.For information about the POWER9, POWER8 processors, see this web page: https://www.ibm.com/itinfrastructure/powerRefer My Oracle Support Note 1587357.1, “Oracle Database (RDBMS) on Unix AIX,HP-UX,Linux,Solarisand MS Windows Operating Systems Installation and Configuration Requirements Quick Reference “ alsofor AIX pre-requisite requirement for Oracle Database 12c Release 1 & 2.IBM also produces benchmark reports that demonstrate the performance results of Power Systems running AIX. These benchmarks are run using Oracle E-Business Suite, yet they provide valuable dataabout Oracle Database and Oracle RAC. The benchmark results are published s-benchmark/index.htmlIBM will also provide sizing estimations to help predict the system resources necessary to support a givenworkload. To start the sizing process, visit this web g/Additional documentation resources for AIX can be found at: IBM Power Systems and AIX Information ex.htmIBM developerWorks AIX,https://www.ibm.com/developerworks/aix/AIX supportThe latest fixes and updates for your system’s hardware and operating system can be found at the FixCentral web page: https://www-933.ibm.com/support/fixcentral/ .Be sure to review My Oracle Support note 282036.1, “Minimum Software Versions and Patches Requiredto Support Oracle Products on IBM pSeries”, for the latest, up-to-date issues regarding AIX and OracleDatabase. This My Oracle Support note is the primary mechanism used to broadcast any breaking news,such as PTF’s or bug fixes, about AIX and Oracle Database.In general, the ICC recommends that you keep your TL’s and SP’s up to date for your AIX installation.Monitor My Oracle Support note 282036.1 and Fix Central for the latest issues. Always perform thoroughtesting on an OS update before deploying to production.Oracle Database 12c software Online Patching (Hot Patching) on AIX 6.1, AIX 7.1 andAIX 7.2From Oracle Database 11g Release 2, Oracle introduced a new feature called “online patching” forsome qualified interim Oracle DB patches. This “online patching” integrated with OPatch tool and provides the ability to patch the running processes of an Oracle instance without bringing down it. EachOracle Database 12c Release 1 & 2 and Oracle RAC 12c Release 1 & 2 on IBM AIX – Tips and Considerations Copyright 2018, IBM Corporation5

process associated with the Oracle instance checks for the patched code at a safe execution point,and then copies the code into its process space.The “online patching” of Oracle Database 12c Release 1 is also available for AIX 6.1 TL07 SP03 withAPAR IV16716 and above, AIX 7.1 TL01 SP03 with APAR IV16737 and above, and AIX 7.2For more detailed information on the “online patching” on AIX, refer the following flash mastr.nsf/WebIndex/WP102085Recommended Code LevelsThere are two tools to help determine the recommended code levels among AIX and Power Systemsrelated components.1. The Fix Level Recommendation Tool (FLRT) can determine the recommended code levelsamong a mixture of AIX, HMC, Server firmware, VIOS, GPFS and PowerHA . The FLRTweb page is: e. Note, the FLRT recommendation provides a minimum acceptable level of compatibility.2. The POWER code matrix indicates the recommended code levels for the HMC and Serverfirmware. The POWER code matrix web page /power5cm/home.html. Note, the POWERcode matrix recommendation provides the maximum stability code combinations.Service StrategyTo review the latest IBM AIX Operating System Service Strategy Details and Best Practices document, see this website: st/home.html.C and C compilersXL C/C is a standards-based, high performance C and C compiler with advanced optimizing anddebugging features. It gives you the ability to optimize and tune applications for optimal execution onsystems using POWER7 , POWER8 and the latest POWER9 processors from IBM. The compileris focused on IBM Power Systems servers capable of running IBM AIX 6.1, 7.1 and 7.2.To determine the current certifications for compilers on 12c Release 1 & 2, please review My OracleSupport note 43208.1, “Certified Compilers”. Currently, XL C/C 11.1.0.4 and later are supported forOracle Database 12c Release 1. XL C/C 13.1 is supported by Oracle Database 12c Release 2(12.2.0)If necessary, read My Oracle Support note 335569.1, “How to Find C or C version on AIX Platform” to determine your XL C/C compiler version.The XL C/C runtime environment is installed during the installation of base AIX. To update to the latestruntime environment, go to the web page Fix list for XL C/C Runtime for AIX.If the XL C/C Enterprise Edition for AIX compiler is installed, to get the latest updates, visit the product’s web page, Fix list for XL C/C for AIX.Oracle Database 12c Release 1 & 2 and Oracle RAC 12c Release 1 & 2 on IBM AIX – Tips and Considerations Copyright 2018, IBM Corporation6

Oracle Database 12c Release 1 & 2 (Non RAC)This section contains the Oracle Database 12c non-RAC technical information that needs to be considered in an AIX installation. Oracle 11g Release 2 introduced the Grid Infrastructure installation for bothstand alone and Real Application Cluster (RAC) databases. In Oracle Database 12c, Grid Infrastructure isalso an option which includes Automatic Storage Management (ASM) and Oracle Restart. Oracle Restartis a new feature that provides the ability to monitor, manage, and automatically restart the Oracle components, including the Oracle database Single Instance, Oracle Net Listener, database services and OracleASM. Grid infrastructure is needed for the stand alone database server if the ASM is selected as a storage option for the database filesIn May, 2017, Oracle released 12c Database Release 2 for IBM AIX. The Oracle Database 12c Release 2new features can be found in a document available T.pdfThese are the basic documents to refer for an Oracle Database 12c installation on AIX.Oracle Database 12c Release 2: Oracle Grid Infrastructure Installation and Upgrade Guide 12c Release 2 (12.2) for IBM AIX onPOWER Systems (64-Bit)E85691-02, https://docs.oracle.com/database/122/CWAIX/toc.htm Oracle Database Installation Guide 12c Release 2 (12.2) for IBM AIX on POWER Systems (64-bit)E85764-03 tm Oracle Database Release Notes - 12c Release 2 (12.2) for IBM AIX on POWER Systems (64-Bit)E85844-01 https://docs.oracle.com/database/122/AXDBN/toc.htm Oracle Database Licensing Information User Manual – Oracle Database 12c Release 2.E85683-03 Oracle Database 12c Release 1: Oracle Grid Infrastructure Installation Guide 12c Release 1 (12.1) for IBM AIX Based Systems (64-bit)E51133-07, racle Database Installation Guide 12c Release 1 (12.1) for AIX on POWER Systems (64-bit) ,E52188-06, Oracle Database Release Notes 12c Release 1 (12.1) for AIX on POWER Systems (64-bit),E52118-06, racle Database product Editions and /editions.htm#DBLIC109My Oracle Support note 282036.1, “Minimum Software Versions and Patches Required to SupportOracle Products on IBM pSeries” for the latest, up-to-date issues regarding Oracle Database 12c Release 1 and AIX.Current certificationsTo determine the current certifications for Oracle Database 12c Release 1 on AIX, Sign into Oracle’s My Oracle Support website (UserID/Password is required) athttps://support.oracle.com/CSP/ui/flash.html and click on “Certifications” tab, look for “CertificationOracle Database 12c Release 1 & 2 and Oracle RAC 12c Release 1 & 2 on IBM AIX – Tips and Considerations Copyright 2018, IBM Corporation7

Search” section. In the “Product” field. Type “Oracle Database”, the second field is “Release”. Selectone of them from the list. It has the release 12.1.0.2.0., next field is “Platform”, select ”IBM AIX onPOWER Systems (64-bit) 7.1” or ”IBM AIX on POWER Systems (64-bit) 6.1, Then click “Search” button. The search result will show the certification status in the link “See Certification Details for Notesand Support information”Additionally, refer “My Oracle Support” document 1307544.1 for the latest certification information for Oracle Database on IBM AIX on Power Systems.IBM and Oracle recommend using the following versions of the AIX to minimize the number of AIX patches for Oracle Database 12c Release 1 & 2.OSProductStatusAIX 6.1 TL09 or laterAIX 7.1 TL03 or laterAIX 7.2 TL0 or laterOracle Database 12cRelease 1 (64-bit) 1Oracle Database 12cRelease 2 (64-bit) 2CertifiedTable 1: Oracle Database Enterprise Edition 12c Release 1 certifications of AIX as of publication date1The minimum recommended AIX version which is supported to use with Oracle Database 12c Release 1 isAIX6.1 TL07 SP03 or AIX7.1 TL01 SP03 or AIX7.2 TL0 SP01.2The minimum recommended AIX version which is supported to use with Oracle Database 12c Release 2 is AIX6.1 TL09 SP04 or AIX7.1 TL03 SP04 or AIX7.2 TL0 SP01.The IBM Power System servers with POWER9 processor need minimum recommended AIX levels as shown below,AIX 7.2 TL2 SP02 or laterAIX 7.1 TL05 SP02 or laterAIX 6.1 TL09 SP11 or laterThe same certifications are in place for Standard Edition 2 (SE2) as Enterprise Edition (EE) of 12.1 and12.2. There is no current Standard Edition for Oracle Database version 12.1 and 12.2. IBM and Oraclerecommend Oracle Database version 12.1 and 12.2 to use with the above certified AIX versions.For Oracle Database 12.1.0.2 on AIX 7.2 TL0 SP01, download the following APARs from IBM fix centraland apply.IV79639 - after live update ifix state may be left as Q; reboot requiredIV79848 - mirrorvg/syncvg on minimal and migration install failsV80412 - system crash application sets signal maskIV81482 - MULTIBOS MAY FAIL TO MOUNT OR REMOVE A STANDBY INSTANCEIV82224 - CORE DUMP IN MANY COMMANDS WHEN USING NISFor Oracle Database 12.1 and 12.2 on AIX 7.2 TL1 SP01, download the following APARs from IBM fixcentral and apply.Oracle Database 12c Release 1 & 2 and Oracle RAC 12c Release 1 & 2 on IBM AIX – Tips and Considerations Copyright 2018, IBM Corporation8

IV94362: SOME APPLICATIONS MAY FAIL AFTER BEING LINKED ON AIX 7.2 TL1 APPLIES TO AIX 7200-01For Oracle Database 12.1 and 12.2 on AIX 7.1 TL02 SP03 obtain and apply the following APARs,IV48895: A SPECIAL-PURPOSE LINKER FLAG WORKS INCORRECTLY. APPLIES TO AIX 7100-02IV48898: ADD ABIILITY TO REORDER TOC SYMBOLS IN LIMITED CIRCUMSTANCES APPLIES TO AIX 7100-02For Oracle Database 12.1 and 12.2, obtain the following Interim fix (ifix) and apply on the AIX versions,AIX 7.2 TL02: IJ04933: GETSOCKNAME RETURNS INVALID PATH NAME FOR AF UNIX SOCKETSAIX 71. TL05: IJ04311: GETSOCKNAME RETURNS INVALID PATH NAME FOR AF UNIX SOCKETSBe aware of the following issue which might occur to the Database Release from 11.2 to 12.2, and obtainthe fix to resolve the issue.Database Corruption ORA-600 ORA-7445 errors after applying AIX SP patches - AIX 6.1TL09SP08 or AIX 7.1 TL03 SP08 or AIX 7.1 TL04 SP03 or AIX 7.2.TL0 SP03 or AIX 7.2.TL01 SP01- Refer My Oracle Support note 2237498.1Affected AIX LevelsFixed IniFix / APAR (ftp://aix.software.ibm.com/aix/ifixes/)o 6100-09-086100-09-09IV93840o 7100-03-087100-03-09IV93884o 7100-04-037100-04-04IV93845o 7200-00-037200-00-04IV93883o 7200-01-017200-01-02IV93885Here are some certification details to be aware of: These products are certified for AIX 6.1, 7.1, and 7.2 on all Power Systems servers supported bythose versions of AIX.64-bit hardware is required for a 64-bit application such as Oracle Database 12c for AIX.Servers capable of more than 4 processors are certified only for EE.Logical Partitioning (LPARs) and Micro-Partitioning are supported.Virtual IO Server (VIOS) is supported.Oracle Database Latest patch setOracle has released Component-Specific release, version 12.1.0.2.0 on Nov 2014 for AIX. It has manynew features such as Full Database Caching, In-Memory Column Store, and so on. All new features ofOracle Database 12c version 12.1.0.2.0 can be found er12102.htm#NEWFT003.Oracle Database 12c version 12.1.0.2.0 and 12.2.0.1.0 are released as Enterprise Edition and StandardEdition 2.To find the documentation for the latest Oracle Database 12c Release 1 & 2 patch sets, sign into Oracle’sMy Oracle Support website at https://support.oracle.com/CSP/ui/flash.html. In the Quick Find pull down,specify “Document ID”. Then specify Document Number 161818.1, “Oracle Server (RDBMS) ReleasesSupport Status Summary”. Then click on “12.1.0.X”, this will bring up My Oracle Support note 1565065.1,Oracle Database 12c Release 1 & 2 and Oracle RAC 12c Release 1 & 2 on IBM AIX – Tips and Considerations Copyright 2018, IBM Corporation9

“Support Status and Alerts for Oracle 12c Release 1(12.1.0.X)”. My Oracle Support note 2239821.1, “Oracle 12c Release 2 (12.2) Support Status and Alerts” shows availability and known issues for 12.2.0.1.Critical Patch Update scheduleThe Critical Patch Update (CPU) program is the method by which Oracle delivers security patch updatesand security fixes for all their products. A CPU is a collection of patches for multiple security vulnerabilities. It also includes non-security fixes that are required (because of interdependencies) by those securitypatches. Oracle provides CPUs for all product offerings on a quarterly schedule.For more information about CPUs and watch for Critical Patch Updates at this ity/alerts.htm.Patch Set Update (PSU)Beginning with October 2009 Critical Patch Update release, Oracle delivers Patch Set Updates for allplatforms on the release date. PSUs are proactive cumulative patches containing recommended bug fixesthat are released on a regular and predictable schedule. PSUs are on the same quarterly schedules asthe Critical Patch Update (CPU). From Oracle Database version 12.1.0.1 onwards PSUs also consist ofSecurity Patch Update (SPU) along with CPU, generic patch bundles, RAC patch bundle, and DataGuard patch bundles. Refer My Oracle Support note 1962125.1.Release Update (RU) and Release Update Revisions (RUR)Starting with Database 12.2.0.1, the Quarterly Release Updates (RUs) will replace Bundle patches andQuarterly Release Update Revisions (RURs) will replace the PSU's to improve the quality and experienceof proactive maintenance. For more information on Database Release Update (RU) and Release UpdateRevision (RUR) see My Oracle Support Note 2285040.1 Release Update and Release Update Revisionsfor Database Proactive Patch Program.Which Patching Method to use?Oracle makes the following recommendation for which patch method to use for Database related installations: Every customer should at least install PSUs. Minimal testing required.12.1.0.2 Customers wanting a more comprehensive set of fixes should install the Database Proactive Bundle patch. This requires a bit more testing than a Patch Set Update (PSU), but deliversa larger set of fixes.ReleaseNon RACRAC12.2.0.1Release Update(RU)/ReleaseUpdate Revision(RUR)Release Update(RU)/ReleaseUpdate Revision(RUR)12.1.0.2 Database Proactive BundlePatch 1 (DBBP) PSUDatabase Proactive BundlePatch 1 (DBBP)Oracle Database 12c Release 1 & 2 and Oracle RAC 12c Release 1 & 2 on IBM AIX – Tips and Considerations Copyright 2018, IBM Corporation10

12.1.0.1Database PSUDatabase Grid InfrastructurePSU(GI PSU)1The "Database Proactive Bundle Patch" requires a bit more testing than a Patch Set Update (PSU) as itdelivers a larger set of fixes.Database patch content for the various pro-active patch methods might be visualized like this:BP/RU-RUR PSUSPUSecurity Patch Update (SPU) contains only the CPU program security fixesPSU contains the CPU program security fixes and additional high-impact/low-risk critical bug fixesBP includes all PSU fixes along with fixes targeted at the specific BP environment for 12.1RU-RUR includes all PSU fixes along with fixes targeted at the specific BP environment for 12.2and higherAn installation can only use one of the SPU, PSU, BP, or RU-RUR patching methods.You cannot mix BP and DB PSU (or SPU) patching methods in the same ORACLE HOME.For example, If you install "Database Proactive Bundle Patch" on a system then you cannot subsequentlyinstall a later "Database PSU" (DB PSU) on top of that. You would need to stay on the DBBP path ORfully roll out the DBBP patches and apply DB PSU patches to switch patching methods. It is not generallyadvisable to switch from "Database PSU" to "Database SPU" method.For more information on patching methods, refer My Oracle Support note “Overview of Database PatchDelivery Methods (Doc ID 1962125.1)”.Refer My Oracle Support note 2394520.1 for latest PSU, Proactive bundle patch, Release Updateand Release Update Revision patches.Also refer the note 756671.1 for Oracle recommended patches for Oracle Database versions from11.2.0.4 and later.Virtualization for Oracle Database 12c Release 1 & 2 (Non RAC)As mentioned in the Current Certifications sub-section (see above) for Oracle Database 12c Release 1 &2, IBM PowerVM features such as LPARs, Micro-Partitioning and VIOS are supported. PowerVM is thefamily of technologies, capabilities and offerings that deliver industry-leading virtualization on IBM POWER processor-based systems.Oracle Database 12c Release 1 & 2 and Oracle RAC 12c Release 1 & 2 on IBM AIX – Tips and Considerations Copyright 2018, IBM Corporation11

Power System featuresCertified WithStatusDedicated processor LPARShared processor LPARWorkload Partition (WPAR)Oracle DB 12c R1 & R2CertifiedDynamic Logical Partitions(DLPAR)Oracle DB 12c R1Live Partition Mobility withOracle- ASMLive Partition Mobility with IBMSpector Scale (formerly GPFS)Oracle DB 12c R1CertifiedOracle DB 12c R1 & R2CertifiedVirtual I/O server CertifiedLogical Partitions subdivide a computer's processors, memory, and hardware resources into multiple environments so that each environment can be operated independently with its own operatingsystem and applications. Dedicated processor partitions are LPARs that use dedicated processors. Dedicated processors are whole physical processors that are assigned to a singleLPAR. Shared Processor partitions are LPARs that use Micro-Partitioning in conjunction with a sharedprocessor pool. Micro-Partitioning divides a physical pr

Mar 20, 2018 · Oracle certification information, please consult Oracle’s “My Oracle Support” website. This paper is written to a level of detail that assumes readers have an in-depth knowledge of AIX, Oracle