Release Notes
Step by Step Oracle 12c Database Install on Oracle Virtual Machine. Oracle has only released 12C database for Linux and Solaris platforms. We have already covered how to install the newest database version on Linux here. In this article we will look at Installing Oracle 12C database on Solaris x86 64bit version.
- In previous release 11G to manage database you could use Oracle Enterprise Database Console. In Oracle 12C it is replaced by new lightweight administration tool Enterprise Manager Database Express. Features of the new version: out-of-box simple management for single database (or database cluster) small footprint 50-100 MB in database.
- Describes last-minute features and changes that are not included in the Oracle Database Documentation Library for Oracle Database 12c Release 2 (12.2). Database Client Installation Guide for IBM AIX on.
12c Release 2 (12.2) for Linux
E85828-01
May 2017
This document contains information that was not included in the platform-specific or product-specific documentation for this release. This document supplements Oracle Database Readme.
This document may be updated after it is released. You can check for updates to this document and view other Oracle documentation at
This document contains the following topics:
Unsupported Products
In addition to the list of unavailable products or features in section, ”Features Not Available or Restricted in This Release of Oracle Database 12c Release 2 (12.2.0.1)” in Oracle Database Readme, the following products and features are not supported:
Oracle Database Quality of Service Support
Oracle Database Quality of Service Management is not supported on IBM: Linux on System z.
Product Support
The list of supported products or features for Oracle Database 12c Release 2 (12.2.0.1) are as follows:
Database Smart Flash Cache Support
Database Smart Flash Cache is supported only on Oracle Solaris and Oracle Linux.
Oracle Automatic Storage Management Cluster File System (Oracle ACFS) and Oracle Automatic Storage Management Dynamic Volume Manager (Oracle ADVM) Support
Although Oracle ADVM supports raw disks in Oracle Automatic Storage Management disk groups, Oracle ADVM device special files created through raw(8) are not supported; Oracle ADVM only supports block device special files.
For the latest information about supported platforms and releases, see the Note 1369107.1 on My Oracle Support at
Oracle ASM Filter Driver Support
Oracle Automatic Storage Management Filter Driver (Oracle ASMFD) is supported only on Linux x86-64.
Share-based Instance Caging
Share-based Instance Caging is supported only on Oracle Solaris and Oracle Linux.
IPv6 Networks Support
The IPv6 based IP addresses to configure the private networks for a cluster is not supported on IBM: Linux on System z. It is currently under testing and the support will be announced after testing is successfully complete.
Linking Applications with Oracle Client Libraries
You must use the dynamic Oracle client libraries to link the client code on Linux. Do not link the static Oracle client libraries.
Preinstallation Requirements for Release 12.2
Refer to the installation guides for the preinstallation requirements.
Installation, Configuration, and Upgrade Issues for Release 12.2
There are no installation, configuration, and upgrade issues at the time of this release.
Other Known Issues for Release 12.2
The following section contains information about issues related to Oracle Database 12c and associated products:
DBCA Displays Incorrect Memory of the Host Server
When creating a database on Linux Container, Database Configuration Assistant (DBCA) incorrectly shows the available memory of the host server instead of the Linux Container on the Specify Configuration Options page. When you choose to allocate the percentage of memory based on the value shown, the database creation may fail in the case where total consumable memory for that Linux Container is less than the allocated memory.
Workaround:
You must allocate physical memory for the database according to the configuration of the Linux Container system.
This issue is tracked with Oracle bug 21546793.
Oracle R Enterprise Fails Due to Libtiff Library Version Mismatch
The Cairo package in Oracle R Enterprise fails to load on SUSE Linux Enterprise Server 12 when the libtiff.so.3 version is missing.
Workaround:
Create a symlink for libtiff.so.3 from libtiff5.so.5.
This issue is tracked with Oracle bug 24939744.
Oracle Grid Infrastructure Installer Prerequisite Check May Fail Due to Incorrect RPM Versions
The Oracle Grid Infrastructure installer prerequisite check for 12c Release 2 (12.2) may fail if you use the e2fsprogs-1.42.8-1.0.2 (x86_64) and e2fsprogs-libs-1.42.8-1.0.2 (x86_64) packages.
Workaround:
Ensure that you meet the following minimum RPM version requirements:
e2fsprogs-1.41.12-14.el6 (x86_64)or latere2fsprogs-libs-1.41.12-14.el6 (x86_64)or laterIgnore the
e2fsprogsande2fsprogs-libsfailure notifications and proceed with the Oracle Grid Infrastructure installation.
This issue is tracked with Oracle bug 25232262.
Documentation Accessibility
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support
Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.
Oracle Database Release Notes, 12c Release 2 (12.2) for Linux
E85828-01
Copyright © 2014, 2017, Oracle and/or its affiliates. All rights reserved.
Primary Author: Tanaya Bhattacharjee
This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are 'commercial computer software' pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.
This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.
This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.
ORACLE 12cOracle 12c Database: New Features
The Oracle 12c Database has the most new features ever released with any version of any database. As you might have guessed from it’s name, the new version is more focused on Cloud Computing.
Oracle 12c RAC: New Features
Oracle has come a long way from its inception of the 9i RAC database to its current 12c version. I remember the days when we had to deal with RAC related issues, ranging from performance to stability which gradually improved as this product matured. Learn more about the new feature now available with RAC.
Oracle 12c Database: De-Supported & Deprecated Features
While it is important to be familiar with new features of Oracle 12c, it is imporatant to be aware of features which are either being de-supported or deprecated with this database version. Learn more about this important topic.
Oracle 12c Database: Online Table Redefinition and Datafile Movement
Moving objects and datafiles around is required when you need to either change the physical location of the data files or when you want to migrate to ASM or some other Storage system. In Oracle 12c this can be minimized to almost no downtime. Let’s look at how online table redefinition and datafile movement can help us in achieving zero downtime.
Oracle 12c Database Heat Maps and Automatic Data Optimization
When installing Oracle Software, you can create 12c CDB, PDB Databases using OUI, just like you used to do in the previous versions of the Oracle database.
Oracle 12c Last login time for Non-Sys Users
Oracle 12c introduced a new, very useful security feature to store and display the last login information for non-sys users, logging in via SQL*PLUS. The last login time is displayed in the banner by default when we log into the database using SQL*PLUS in 12c.
Manage Multitenant CDB and PDBs with EM Express
Manage Multitenant CDB and PDBs with EM Express. Quick and easy steps to create, setup and deploy EM Express.
Oracle 12c Database: Moving to Multithreaded Configuration
Starting in Oracle 12c database, you can change this and enable the new Multithreaded configuration! And that too by merely setting one parameter. You can change the architecture by making Oracle database use thread based architecture instead of process based. Once changed, all Oracle processes will be threads within a few Oracle processes.
Oracle 12c Database Default Column Value Enhancement
I remember that a number of times, developers have approached me with the question – How do I auto increment a default value in a table column? These were mostly folks who had worked in the MS SQL, Mysql and other database environments where this features exists. Now, Oracle 12c Default Column Value feature has been incorporated and puts this to rest.
Oracle 12c Database Identity Columns
Having a built-in mechanism to populate the identity columns was something that developers have been looking forward to as a feature in the Oracle database. Finally Oracle has finally provided a built-in feature, Oracle 12c Database Identity Columns, to populate these Identity Columns. Let’s look at how you can use this new feature in Oracle 12c.
Oracle 12c Database Multiple Indexes On Same Set of Columns
Oracle database 12c has about 500+ new features when compared to 11gR2. Among these features there will be some which get the mainstream attention. But often little caveats or enhancements prove to be as vital as the big ones. One such enhancement is the ability to have multiple indexes on same column or same set of columns. Lets look at this feature and the possible uses cases.
Oracle Database 12c Download Aix
Oracle 12c DDL Logging in Oracle
By default Oracle database does not log any DDL operations performed by any user. The default settings for auditing only logs DML operations. However that does not mean that you cannot do anything about it. Oracle has provided several ways by which you can track the DDL operations performed on the database. In this article we will look at two of the most common and easy to use ways.