While Oracle has developed this release with the cloud\u00a0 in mind, the first word that comes out of my mind is “c<\/strong>onsolidation”. The new claimed feature\u00a0 Pluggable Database (aka Oracle Multitenancy) <\/strong>will be the dream of every datacenter manager along with CloneDB (well, it was somehow already available on 11.2.0.2) and ASM Thin_provisioned diskgroups.<\/p>\n But yes, it’s definitely the best for clouds<\/p>\n Other features like Flex ASM, Flex Cluster, several new security features, crossplatform backups<\/strong>… let imagine how deeply we can work to make private, multi-tenant clouds.<\/p>\n First steps, what changes with a typical installation<\/strong><\/p>\n The process for a traditional standalone DB+ASM installation is the same as the old 11gR2: You’ll need to install the Grid Infrastructure first (and then take advantage of the Oracle Restart feature) and subsequently the Database installation.<\/p>\n The installation documentation is complete as always and is getting quite huge as the Grid Infrastructure capabilities increment.<\/p>\n To meet most installation prerequisites, Oracle has prepared again an RPM that does the dirty work:<\/p>\n oracle-rdbms-server-12cR1-preinstall-1.0-3.el6.x86_64.rpm<\/p>\n Oracle suggests to use Ksplice <\/a>and also explicitly recommends to use the deadline I\/O scheduler (it has been longtime a best practice but I can’t remember it was documented officially).<\/p>\n The splash screen has become more “red” giving a\u00a0colorful experience on the installation process. \ud83d\ude09<\/p>\n Once the GI is installed, the Database installation asks for many new OS groups: OSBACKUPDBA, OSDGDBA, OSKMDBA. This give you more possibilities to split administration duties, not specifying them will lead to the “old behavior”.<\/p>\n You can decide to use an ACFS filesystem<\/strong> for<\/strong> both the installation AND the database files<\/strong> (with some exceptions, e.g. Windows servers). So, you can take advantage of the snapshot features of ACFS for your data, provided that the performance is acceptable (I’ll try to test and blog more about this). You can use the feature Copy-On-Write to provide writable snapshot copies, directly embedding a special syntax inside the “create pluggable database” command. Unfortunately, Oracle has decided to deliver pluggable databases as an extra-cost option. :-\/<\/p>\n The database creation with DBCA is even easier, you have an option for a very default installation, you can guess it uses templates with all options installed by default.<\/p>\n But the Hot topic is that you can create it as a “Container Database”. This is done by appending the keywords “enable pluggable database;” at the end of the create database command. The process will then put all the required bricks (creation of the pdb$seed database and so on), I’ll cover the topic in separate posts cause it’s the really biggest new feature.<\/p>\n You can still use advanced mode to have the “old style” database creation, where you can customize your database.<\/p>\n If you try to create only the scripts and run them manually (that’s my habit), you’ll notice that SQL scripts are not run directly within the opened SQL*Plus session, but they’re run from a perl script that basically suppresses all the output to terminal, giving the impression of a cleaner installation. IMO it could be better only if everything runs fine.<\/p>\n Finally, I’ll get something familiar, but with a brand new release number! \ud83d\ude42<\/p>\n Stay tuned, I’ll write soon about some really interesting features of the new Oracle Database 12c!<\/p>\n Cheers<\/p>\n —<\/p>\n Ludo<\/p>\n","protected":false},"excerpt":{"rendered":" After a long, long wait, Oracle finally announced the availability of his new generation database. And looking at the new features, I think it will take several months before I’ll learn them all. The impressive number of changes brings me … Continue reading ![\"splash\"](\"https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2013\/05\/splash.png\")
<\/a><\/p>\n<\/p>\n<\/a><\/p>\nhost perl \/u01\/app\/oracle\/product\/12.1.0\/rdbms\/admin\/catcon.pl -l \/u01\/app\/oracle\/admin\/CDBTEST\/scripts -b catalog \/u01\/app\/oracle\/product\/12.1.0\/rdbms\/admin\/catalog.sql;<\/pre>\n
[oracle@luc12c01 ~]$ sqlplus sys\/*****@classic as sysdba\r\n\r\nSQL*Plus: Release 12.1.0.1.0 Production on Thu May 9 22:36:27 2013\r\n\r\nCopyright (c) 1982, 2013, Oracle. All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production\r\nWith the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics\r\nand Real Application Testing options<\/pre>\n