What's the level of effort to convert existing databases to pluggable databases.
None at all. Just upgrade in place to 12.1.0.1 and plug in.
We have not fond download for Windows
After an upgrade to 12c , how does one change a database to be "pluggable"?
Upgrade the existing database to a 12.1.0.1 non-CDB. The plug it in to a CDB as a PDB. Then run a simple post-plug one-time script.
If the tenant database fails do the pluggable databases fail?
You should configure a multitenant container database for high availability (for example with ASM, RAC, Data Guard, etc.) just as you do today for any Oracle Database that requires HA.
Can I migrate and run an 11gR2 DB into a Pluggable DB on 12c? Without change?
Yes. This is simple. You upgrade in place to a 12.1.0.1 non-CDB and then plug that in as a PDB. Then you run a single post-plug step. The time time takes is independent of the size of the former non-CDB.
How does licensing work for PDBs?
We hear this question of ten. We will soon link to a FAQ from the Oracle Multitenant page on OTN.
is there a limit on # of pluggable databases per container?
We support up to 252 PDBs per CDB.
how much data 12c can store?>500GB
12c can store as much data as 11g - depending on your block size, the maximum size of a single Oracle 12c db can range into multiple petabytes...
Is Oracle Multitenant option an additional license cost?
Oracle Multitenant is a new option with Oracle Database 12c. The single tenant configuration - one PDB per CDB is a no cost configuration. Two or more PDBs per CDB require the Multitenant Option license.
Can a RAC one node PDB be relocated to another server?
YES - A Pluggable Database will be hosted in an Oracle RAC-based multitenant container database. You can start the PDB on any server that hosts an Oracle RAC-based multitenant container database instance in the cluster.
What's the level of effort to convert existing databases to pluggable databases.
None at all. Just upgrade in place to 12.1.0.1 and plug in.
What are the new features for data replication using 12c?
Hi, Data Replication is a big topic, it includes Active Data Guard, GoldenGate, and some new topics in Oracle Database 12c such as Global Data Services. Look at these links: http://www.oracle.com/technetwork/database/features/availability/global-data-services-1949717.html and: http://www.oracle.com/technetwork/database/availability/active-data-guard-wp-12c-1896127.pdf and:http://www.oracle.com/technetwork/middleware/goldengate/overview/index.html
Will there be a Windows 32-bit release of 12c?
Client only.
is upgrade path to 12c from earlier version available?
YES. Please, see https://blogs.oracle.com/upgrade/ - White Paper: Upgrading to Oracle Database 12c - http://www.oracle.com/technetwork/database/upgrade/upgrading-oracle-database-wp-12c-1896123.pdf
when will be oracle 12 c supported in the new supercluster with t5?
Yes 12c is supported in the new supercluster - see database notes for specifics
what will be the RAC architecture in 12c release?
We will support the current architectures Flex ASM Flex cluster Oracle will support Multitenant - please, see: http://www.oracle.com/goto/rac and related technolgies. The white papers will provide more details.
12c plug able databases, what that mean?
Stay tuned. Details will be explained in a few minutes. Also, much more info at: http://www.oracle.com/multitenant
Is Licensing impacted due to Container/tenant databases?
Oracle Multitenant is a new licensed option with Oracle Database 12c.
Can a PDB be an active dataguard?
Yes. Active Data Guard supports Oracle Multitenant and pluggable databases. For more Active Data Guard 12c info see: http://www.oracle.com/technetwork/database/availability/active-data-guard-wp-12c-1896127.pdf
How does HeatMap impact the performance of the OLTP DB - does it cause a performance degradation due to the auditing effort?
The performance impact of Heat Map is negligible. The info is kept in memory, and periodically flushed to disk - but it's not transactional data, so it doesn't affect the response time for transactions that modify data, and for queries, we are tracking Heat Map info at the partition and table level, so there is minimal overhead.
Can we plug different versions of Databases together with 12c?
Within a multitenant container database, all PDBs are of the same version. You can have multple containers on one server and then the containers can be of different versions, assuming they run out of different Oracle Homes.
In Oracle 12c is it still available Tablespace Encryption?
Yes. Transparent Data Encryption is available in Oracle Database 12c. This enables you to do both tablespace and column level encryption.
Do DB links work in the same manner with 12c CDB/PDB as prior versions?
Functionally, DB links between PDBs work just as they did between databases in prior versions of Oracle. Some perfrormance enhancements have been implemented for DB Links between PDBs in a single CDB.
Is RAC enabled at the CDB or PDB level ?
On the CDB level. Please, see: http://www.oracle.com/technetwork/products/clustering/rac-wp-12c-1896129.pdf
On the concept of pluggable DB: Is it possible to "daisy chain" them, such that an app sees the daisy chained ones as a single DB?
No sure that I understand your point. Think of a PDB as functionally indistinguishable from a non-CDB.
Is there a release for Mac OS X?
Client only
Are there any new features that will help with automatically reorganizing data or shrinking objects to improve perfomance.
Heat Map and Automatic Data Optimization are designed to do exactly that - automatically move and / or compress data based on access patterns, or based on user-customized conditions.
what is the communication between two PDBS? db links that has to go through network interfaces or any direct channels?
Yes, you use a db link to communicate between PDBs just as you did between non-CDBs. For two PDBs in the same CDB, we can optimize the transport.
can you have different language settings for each PDB?
This topic is discussed in the "Oracle Multitenant" technical whitepaper on OTN.
can a backup/restore be performed on an individual pluggable database ?
Yes, but we expect most customers to backup the entire container database because you just backup once and have all the pluggable databases backed up in one go. You can do recovery, and in particular, point-in-time recovery on an individual pluggable database without impacting the other pluggable databases in the container database
How RAC in Oracle 11g and 12c differ?
The Oracle Documentation will have a new features list. This paper: http://www.oracle.com/technetwork/products/clustering/rac-wp-12c-1896129.pdf will provide an overview. More presentations will be made available shortly.
is data optimization another licensable product?
Heat Map and Automatic Data Optimization are part of the Advanced Compression Option in Oracle Database 12c.
When is 12c going to be available/supported on the exadata systems?
Oracle Database 12.1 is supported on Exadata. The minimum Exadata storage server software version required to run an Oracle 12.1 database is 11.2.3.2.1. You can also run a mix of 12.1 and 11.2 databases on Exadata. All features of the Oracle Database 12.1, including the multitenant pluggable databases are supported on Exadata. However, please note that the 12.1 smart scans will not filter rows in the Exadata storage and the 12.1 IORM plans will not be enforced in the storage. These limitations will be removed in a future Exadata storage server software version 12.1.1.1.0. Please look at the MOS note 1537407.1 for details. All other Exadata storage features like HCC, Smart Flash Cache, Smart Logging work as before.
Is "Heat Map and Automatic Data Optimization" a feature or an option?
Heat Map and Automatic Data Optimization are features of Oracle Database 12c that are part of the Advanced Compression Option.
I have download OWB but it is not working with 12c
Try looking at the posts on the OWB Blog: https://blogs.oracle.com/warehousebuilder/entry/oracle_database_12c and I would suggest posting question on the OWB forum https://forums.oracle.com/community/developer/english/business_intelligence/data_warehousing/warehouse_builder
Tom,
Do we have any mapreduce support in plsql for Oracle 12c ?
Hi this is keith laker from DW PM team There is a series of articles about how to access use MapReduce features directly from within Oracle Database. Try this link: https://blogs.oracle.com/datawarehousing/tags/mapreduce
Do you recommend to replace Oracle ASM with dNFS with InfiniBand' RDMA accelerated backend ?
Within Exadata, we use Infiniband to provide maximum throughput and performance for storage access. Outside of Exadata, we recommend using either dNFS (Direct NFS Client) for NAS or ASM (for SAN / Direct Attach Storage). We also support dNFS in combination with ASM, but that's less common. If you have servers and storage that supports Infiniband with RDMA, you might still need to use dNFS to access the storage.
Do we gain any PDB benefits by using the no cost one PDB per one CDB configuration, or does it just increase complexity?
No, this configuration simplifies patch application. Patch CDB2 and migrate PDB from CDB1 to CDB2 to apply the patch.
IS there any plan to extend HCC beyond Exadata,Pillar Axiom and ZFS on commodity hardware?
There are no plans to extend support for HCC beyond the existing Oracle storage platforms.
How is memory used with pluggable databaes ... each have their own memory_targets ?
This topic is discussed in the "Oracle Multitenant" technical whitepaper on OTN.
Can you move PDB running under non-RAC container to RAC container?
YES.
Will there be an Oracle 12c Express Edition?
It is planned, but there are no dates yet.
Is the heat map based on row level select/update/delete ? For example a row with no access over n seconds is tiered off to a lower online tier.
Heat Map and Automatic Data Optimization are designed to operate on the order of days, not hours / minutes / seconds. Heat Map data is tracked at the partition and table level for queries, and at the block level for modifications.
When upgrading, an existing database becomes a PDB. Right?
Not exactly. Upgrade to Oracle Multitenant is a 2-stage process. 1. Upgrade to Oracle Database 12c - non-CDB (the old architecture). 2. Adopt the non-CDB as a PDB. Step 2 is optional.
Are there any new features that will help with automatically reorganizing data or shrinking objects to improve perfomance.
Heat Map and Automatic Data Optimization are designed to do exactly that - automatically move and / or compress data based on access patterns, or based on user-customized conditions.
Is the Hybrid Columnar Compression (HCC) available on Oracle Solaris local ZFS (not ZFSSA) or is there another approach ?
HCC is not available on local ZFS; it is only available with Exadata storage, ZFSSA, and Pillar Axiom.
On the concept of pluggable DB: Is it possible to "daisy chain" them, such that an app sees the daisy chained ones as a single DB?
No sure that I understand your point. Think of a PDB as functionally indistinguishable from a non-CDB.
How SGA would be managed with multiple pluggable database ?
The SGA is shared across the entire CDB. This shared overhead allows us to achieve maximum consolidation density.
Can a RAC one node PDB be relocated to another server?
YES - A Pluggable Database will be hosted in an Oracle RAC-based multitenant container database. You can start the PDB on any server that hosts an Oracle RAC-based multitenant container database instance in the cluster.
Can you have multiple tablespaces in a pluggable database?
Yes.
Does all PDB's share datafiles?
No, data files are dedicated to specific PDBs.
Does Oracle multitenancy provide backwards compatibility to older versions, such as 11g? In other words, if I have 50 11g databases, do I have to upgrade them all to take advantage of this new architecture?
Oracle Multitenant is a new option with Oracle Database 12c. Prior versions must be upgraded to 12.1 (or later) before being adopted as PDBs.
how much performance overhead do we expect to see with heat map data optimization?
The performance impact of Heat Map is negligible. The info is kept in memory, and periodically flushed to disk - but it’s not transactional data, so it doesn’t affect the response time for transactions that modify data, and for queries, we are tracking Heat Map info at the partition and table level, so there is minimal overhead.
What are the considerations/pre-requisites in migrating an Oracle 11gR2 database to Oracle 12c database?
There's a fair amount of information about installing and upgrading here: http://www.oracle.com/pls/db121/portal.portal_db?selected=11&frame=
when the windows release of 12c will be published ?
Oracle Database 12c on Windows 64 bit was released yesterday. See: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-win64-download-1968077.html
Will 12c be available for other platforms?
It's already available on Linux (OL and RHEL), on Solaris (on x86 and SPARC), and Windows. Please look for exact versions in the docs. -> Other main "Unixes" are planned for 2014.
Can you partition cache to a PDB or all the PDBs share the SGA equally?
This topic is discussed in the "Oracle Multitenant" technical whitepaper on OTN.
Can you have different database Oracle versions within the same tenant?
The benefit of Oracle Multitenant is the flexibility and agility of consolidating the container database management system and abstracting that from the data contained in pluggable databases. This consolidation is enabled by ensuring that all pluggable databases plugged into a container database to be on the same version/patchset level.
With a single CDB - do you have a single SGA? If so if there is a high load trasnaction on a given PDB - would its load have imapct on another PDB having less load and transaction - since hte segregation is only for the Data?
This topic is discussed in the "Oracle Multitenant" technical whitepaper on OTN.
When is 12c for AIX going to be available?
from the 12c release FAQ: What is the platform release schedule for Oracle Database 12c?Oracle Database 12c released on Linux and Solaris June 25th 2013. Windows is planned for July 2013 [released yesterday] Other UNIX ports and zLinux are planned for FY14.
How is this different from Sybase?
The big difference is that we offer a much better consolidation environment with technologies like RAC, ASM, and Exadata which Sybase and other vendors cannot match. This allows you to consolidate more and save more in reduced management costs and hardware costs. With other vendors you are really limited to a single server.
Is Oracle Streams still supported on Oracle 12C?
Yes it is still supported, but it is in maintenance, and will not be seeing any new enhancements. For new projects that require logical replication Oracle is recommending Oracle GoldenGate
Is there an Express edition of 12c available?
Planned, but no dates yet.
Is data easy to move between the PDBs of a CDB using SQL. Example: could I do something like: INSERT INTO HR.EMP SELECT * FROM PDB1.HR.EMP; ?
We do not support 3-part naming like you show. Nor do we want to. Use a database link.
can a backup/restore be performed on an individual pluggable
database ?
Yes, but we expect most customers to backup the entire container database because you just backup once and have all the pluggable databases backed up in one go. You can do recovery, and in particular, point-in-time recovery on an individual pluggable database without impacting the other pluggable databases in the container database
What may influence the performance of one PDB over another in the same CDB apart from application codes?
Resource Manager can control the contention for resources (such as CPU) between PDBs.
Are heatmap mettics avaialbe in v$ and dba_hist views like AWR and ASH ?
Detailed Heat Map data is available through PL/SQL table functions, and some summary / histogram-style data through dictionary views.
Can you migrate between oses wih plugable databases easily?
Reasonably easily. Cross-endian migration is not currently supported.
Can the container database be 12c and some of the plugged in databases of lower version, say 11g and lower?
No. A database must be upgraded to 12c before being adopted as a PDB.
In Oracle 12c is it still available Tablespace Encryption?
Yes. Transparent Data Encryption is available in Oracle Database 12c. This enables you to do both tablespace and column level encryption.
If you move PDB from one multitenant db to other if datagard is configured the standby database will be updated I mean removed from the standby where the PDB was unpluged and added into the database where it was plugged in automatically I mean with no ext
This is not yet fully automatic. Some manual intervention is needed. On the other hand, the standby responds automatically to "create new PDB" and to "clone PDB".
Is ASM required for 12c?
Oracle ASM is recommended, but not required. Please, see: http://www.oracle.com/technetwork/products/cloud-storage/index-100339.html
Will any database in 12c be "pluggable", or is there conditions on the database which make in "unpluggable"?
Oracle Multitenant is a new option with Oracle Database 12c. The upgrade is a 2-step process.
1. Upgrade to Oracle Database 12c - this results in a non-CDB. This is not yet pluggable. 2. Adopt the non-CDB as a PDB. This is the optional step.
PDB's use the same home, same SGA/PGA etc... so... what's the difference between a CDB and an instance...? Is that in the white paper?
Yes, all this is in the "Oracle Multitenant" technical whitepaper on OTN. An internet search for "Customer challenges addressed by Oracle Multitenant" finds it immediately. Despite what this section heading implies for the approach, the paper is very solidly technical. It aims for precision and completeness -- and not at all for brevity.
Is 12c available on all Unix platforms
Database 12c released on Linux andDatabase 12c released on Linux and Solaris June 25th 2013.
Windows was released yesterday.
Other UNIX ports and zLinux are planned for FY14. Solaris June 25th 2013.
Windows is planned for July 2013.
Other UNIX ports and zLinux are planned for FY14.
Is there a 12c equivalent of grid Infrastructure?
There is Oracle Grid Infrastructure 12c with new features. Please, see: http://www.oracle.com/technetwork/products/cloud-storage/index-100339.html
Can I convert a non-CDB to a CDB/PDB environment using a DBMS package or do I need to stand up a new CDB environment and migrate the data to that DB?
This is simple. You upgrade in place to a 12.1.0.1 non-CDB and then plug that in as a PDB. Then you run a single post-plug step. The time time takes is independent of the size of the former non-CDB.
If the tenant database fails do the plugable databases fail?
You should configure a multitenant container database for high availability (for example with ASM, RAC, Data Guard, etc.) just as you do today for any Oracle Database that requires HA.
How will the patching work when you have pluggable databases? Do they all have to have the same patch set applied?
The patch set level applies at the CDB level. All PDBs plugged into the CDB will be at the same patch set level. The beauty is that the patch only needs to be applied once - at the CDB level - and all tenants benefit. If you want to migrate individual PDBs to a new patch set level, use 2 CDBs, one at patch level x, the other at level x 1. Apply patches to individual PDBs by unplugging them from one CDB and plugging into the other one.
what is a typical size of an unplugged database, I would assume it is more than just an export. Is an unplugged database an improvement upon typical backup/recovery functionality?
A pluggable database consists of a set of schemas and tablespaces which contain the data and the meta information for this data that is in the data dictionary. All this is packaged together in a neat bundle so it can be moved (unplugged from one container database and plugged into another) and backed up and recovered independently of other pluggable databases. We expect most customers will backup whole container databases rather than each pluggable database separately because it is much easier to do this. A major benefit of pluggable database is reduced management costs.
What factors should a DBA consider if he/she wants to move from "multiple databases sitting on multiple servers " to one "12c pluggable databases sitting on a single server or RAC"? What will be the pros/cons of this consolidation move?
This topic is discussed in the "Oracle Multitenant" technical whitepaper on OTN.
How does APEX work with CDB and PDCs, is there a single instance or multiple?
You can choose. Either, install APEX in the root (see the docs) and then all PDBs see the same APEX version. Or don't do that but install APEX in each PDB that wants it. Then you can choose the APEX version per PDB.
it sounds like you can only plug in 12c databases in the 12c container. is this true? or can i have 11g databases inside the 12c container?
True. All databases must be upgraded to Oracle Database 12c before being adopted as PDBs.
If CBD fails then all PBD fails then it will be single point of failure, so how can we deal with it. keep apart about HA for CBD
Active Data Guard or Data Guard provide the mechanism for preventing a CDB from being a potential for a single point of failure - each will maintain a synchronized replica of the CDB on seperate system and storage. There are also management efficiencies. Where before, if you had 50 independent databases, you would have 50 standbys to manage. With Oracle Multitenant, you have a single primary (the CDB) and a single standby to manage. For more on Data Guard see: http://www.oracle.com/technetwork/database/availability/active-data-guard-wp-12c-1896127.pdf . If you wish to do granular replication at the level of an individual pdb, then GoldenGate provides that answer: http://www.oracle.com/technetwork/middleware/goldengate/overview/index.html
IS the license for CDP on a per core basis?
You can license Oracle Multitenant on a per named user basis, or per processor. Then, for all platforms, there is the Oracle Processor Core Factor Table: http://www.oracle.com/us/corporate/contracts/processor-core-factor-table-070634.pdf
Is there a size limit for PDB or is it the same as managing a regular database with no limitation of growing?
It's just like a non-CDB. However, if you want to, the CDB administrator, can set a size limit for a PDB.
Concerning the three part naming – so within one Database Container the combination of SchemaName.TableName is still be unique?
We don't have three-part naming. This topic is discussed in the "Oracle Multitenant" technical whitepaper on OTN.
DBFS and PDB ... are they mutually exclusive ?
No, DBFS works just fine with PDB. You can create a DBFS file system inside a plugged-in db, and then mount it using the dbfs_client executable from any linux or Solaris 11 client that has network access to that database.
Does unplugging and plugging require downtime?
Yes, a PDB must be closed before being unplugged.
Can we have different compitable parameter values for different plugable databases?
No, "compatible" is for the whole CDB.
Is GoldenGate a feature of 12c by default for replication?
Active Data Guard, Data Guard, and GoldenGate are all replication options for 12c. The first two provide simple, complete, one way physical replication with target able to be open read-only. The later provides advanced logical replication (subsets, bi-directional, transformations, many-to-one, etc) with target open read-write. See:http://www.oracle.com/us/products/database/options/active-data-guard/overview/index.html and http://www.oracle.com/technetwork/middleware/goldengate/overview/index.html
Is "heat map" persistent between shutdown/startup ?
Heat Map is persistent across instance restart. Because the block-level Heat Map info is not guaranteed to be transactionally consistent, it's possible that a small amount of the block-level info will be lost if the instance crashes.
Hi folks, which hypervisors will be supported for PDB?
Wrong question! PDBs run inside a CDB. So the question is "On what hypervisors is Oracle Database 12c supported". The answer is independent of the advent of the multitenant architecture.
How does flashback work in a multi-tennant database?
Flashback DB is not supported at a PDB-level, only at CDB-level. Other Flashback operations work at a PDB-level.
Is the CPU resource control (shares) between PDB in CDB available on all platforms ? Is it compatible with Oracle Solaris zone "shares" and project "shares" delivered by kernel FSS schedules ?
Yes, Resource Manager is available on all supported platforms.
what are the minumum requirements for installing Oracle Multitenant and CBD, in terms of disk space and memory?
Same as a database itself.
I am currently running 11g R2 database, what does it take to mave them to oracle 12C.
Very good resources here: http://www.oracle.com/technetwork/products/upgrade/index-088044.html
Does Oracle GoldenGate needs license?
Yes, GoldenGate is a seperately licensed product
can you move PDB running in FS container to ASM container, and vice versa?
Yes. Just copy the datafiles in the ordinary way, while the PDB is unplugged.
Does 12c RMAN catalog support 10g dB client?
Yes
will there be performance tuning in 12c?
Yes.
maybe off topic, Oracle does provide tools to structure the unstructure dta based on some criteria, patterns or glossary ? for analytical purposes ?
Absolutely. Oracle offers a Big Data Appliance that is an engineered system containing Cloudera Hadoop, Oracle NoSQL, and Oracle R that is useful for pre-processing unstructured data before loading into the Oracle Database. For more information about the Big Data Appliance, visit http://www.oracle.com/us/products/database/big-data-appliance/overview/index.html
Plugable dataabase: What does this mean for future upgrades from 11g to 12c? Will that require lot of project management to plan the consolidation? Will database needs to be on common characterset / parameters to upgrade and consolidate?
Consolidation is a process which will always require careful planning. This applies to upgrades to Oracle Multitenant as well. To be plug-compatible with a CDB, a PDB must be in a compatible character set.
The relation between PDB and CDB is many to one? menaing multiple PDB can be placed in one CDB?
That's correct. A multitenant container database (CDB) can hold many pluggable databases (PDB).
Please, can you provide the url to the "Oracle Multitenant" technical whitepaper on OTN?
http://www.oracle.com/technetwork/database/multitenant-wp-12c-1949736.pdf?ssSourceSiteId=ocomen We recommend the "Oracle Multitenant" technical whitepaper on OTN. An internet search for "Customer challenges addressed by Oracle Multitenant" finds it immediately. Despite what this section heading implies for the approach, the paper is very solidly technical. It aims for precision and completeness -- and not at all for brevity.
Can one CDB have primary PDB and its corresponding standby PDB?
Data Guard in 12c Release 1 works with Container Databases. So all the Pluggable Databases in a Container Database will be protected by Data Guard, When you add Pluggable Databases to a container database it is automatically protected by Data Guard which is a nice benefit.
Any improvements related to optimizer?
Checkout the latest post on the Optimizer blog: https://blogs.oracle.com/optimizer/entry/oracle_database_12c_is_here
Is Oracle 12C support ASM and Non ASM both?
YES, you can use Oracle ASM and FS with Oracle Database 12c. Within on DB (multitenant DB or non-cdb) we recommend to standardize on either for managerial reasons.
Will 12c be available for Express Edition? If so, schedule?
Planned but no dates yet.
can we have different charactersets with in a Container database ?
No, for PDBs to be plug-compatible, they must be in a compatible character set with the CDB. Effectively this means the same character set.
what is the backup & recovery of CDB & PDB's ??
We expect you to run scheduled backups for the whole CDB to win the "manage as one" benefit. But you'll probably want to do point-in-time-recovery for a single PDB. So, yes, PDB PITR is supported!
Do we have whitepapers about heat map & multi tenants?
You can find whitepapers and other info on multitenant on OTN here: http://www.oracle.com/us/products/database/options/multitenant/overview/index.html and for Heat Map and ADO here: http://www.oracle.com/technetwork/database/enterprise-edition/index-090321.html
Can different PDBs in the same CDB have different log mode, some archivelog and some others no archivelog?
No. You make this choice for the CDB as a whole.
Would each plugable database has their own undo and temp tablespaces ? or they share the same undo & temp tablespaces ?
Redo and undo are shared across the entire CDB.
is it possbile to backup PDB separatly and recover it?
Yes. We do support PDB PITR!
Is there any changes in OWB(Warehouse Builder) structure?
Checkout the latest post on the OWB blog: https://blogs.oracle.com/warehousebuilder/entry/oracle_database_12c
Is there a document describing all the 500+ improvements/new feature of 12c?
Comprehensive information here: http://docs.oracle.com/cd/E16655_01/server.121/e17906/chapter1.htm#NEWFTCH1
Dataguard FastSync require separate license ?
Hi Balaji, this Joseph Meeks in HA Product Management. FastSync does NOT require a seperate license, it is included with Data Guard feature set that comes with Oracle Database 12c EE. There are other new features that are included with the Active Data Guard option (Far Sync for example). See licensing details in the doc at: http://docs.oracle.com/cd/E16655_01/license.121/e17614/options.htm#CIHDDBCG - also, always happy to take Data Guard/Active Data Guard questions directly at joseph.meeks@oracle.com
if we are going to have one CDB with many PDB, with just one SGA, does it means we will have more performance issue, contention, and etc.
Oracle Enterprise Manager 12c works in concert with Oracle Database 12c to ensure the highest performance and most optimal resource management. To learn more, visit http://www.oracle.com/us/products/enterprise-manager/index.html
In 12c CDB we are sharing undo & redo log files among CDB & PBD...what if current redo logfile get lost due to catastropic failure, in that case all the pluggable database will be unavailable. Isn't a drawback of 12c CDB feature?
You can protect a CDB against catastropic failures with Data Guard. All the PDBs in the CDB are protected. If you create new PDBs in the CDB they are automatically protected as well. This reduces management costs significantly because you don't need to setup Data Guard or other facilities like RAC for every new database to give it good HA protections.
When many databases are consolidated with PDBs, during patching, can I choose which database to patch because I don't have common down time window?
There are two options for applying patches with Oracle Multitenant. 1. Apply patch at the CDB level. All PDBs will benefit. 2. Create a second CDB and patch that. When your application is ready to be patched, simply unplug the PDB fro the old CDB and move it to the patched CDB.
how standby databse would be created for CDB and multiple PDBs ?
This topic is discussed in the "Oracle Multitenant" technical whitepaper on OTN.
Is the command set for controlling the CDB able to shutdown all PDBs under a CDB?
The instance opens the CDB as a whole. You acn set the open mode (read-write, read-only, or "closed") for an individual PDB -- and you can make a different choice for this in each different RAC instance.
Is the command set for controlling the CDB able to shutdown all PDBs under a CDB?
The instance opens the CDB as a whole. You acn set the open mode (read-write, read-only, or "closed") for an individual PDB -- and you can make a different choice for this in each different RAC instance.
We expect (but do not require) that a CDB will be operated using RAC. That will imply that you control everything using services.
Is there direct upgrade path to 12cR1from 10gR2?
Plenty of upgrade information here: http://www.oracle.com/technetwork/products/upgrade/index-088044.html
if we are going to have one CDB with many PDB, with just one SGA, does it means we will have more performance issue, contention, and etc.
Oracle Enterprise Manager 12c works in concert with Oracle Database 12c to ensure the highest performance and most optimal resource management. To learn more, visit http://www.oracle.com/us/products/enterprise-manager/index.html
Can primary-PDB and it coresponding standby-PDB coexist in one CDB?
No, you operate Data Guard for the CDB as a whole.
How is Database Smart Flash Cache implemented in a CDB/PDB relationship?
All plugged-in databases share one SGA. Database Smart Flash Cache is essentially a read-only extension to the buffer cache in the SGA, so it doesn't really work any differently than before. When blocks age out of the DRAM-based buffer cache, they are migrated to Database Smart Flash Cache.
how standby databse would be created for CDB and multiple PDBs ?
This topic is discussed in the "Oracle Multitenant" technical whitepaper on OTN.
the solution he just described with no data loss for far async dataguard configs, is this different than traditional dataguard? Is there an additional cost?
the feature described is Far Sync. It is a feature of Active Data Guard (so primary sending and the standby receiving redo from Far Sync needs to be licensed for Active Data Guard) - you don't need a seperate license for the server that Far Sync runs on. It is very different in that the Far Sync instance has no data files, does not run recovery - it just forwards redo to a remote standby and enables zero data loss failover. See more about Far Sync in the technical white paper: http://www.oracle.com/technetwork/database/availability/active-data-guard-wp-12c-1896127.pdf
what is the impact of ASM on the implementation of pluggable databases?
You can continue to use Oracle ASM as with previous releases. These layers are unrelated and Oracle ASM will manage the storage regardless of what type of Oracle Database is used. Oracle ASM provides further enhancements in Oracle ASM 12c, such as Flex ASM: http://www.oracle.com/technetwork/products/cloud-storage/index-100339.html
Can we patch single PDB database instead of CDB?
No. All PDBs in the CDB must be at the same patch level. Patches are applied at the CDB level - manage many as one.
Redo and undo are shared across the entire CDB ,what about TEMP tablespace ,is it individual for each PDB ?
Each PDB has its own temp.
Can you have multiple tennants with the same datafile names? For example CDB holds the DEV1/DEV2 databases which are identical but server a different business purpose.
This topic is discussed in the "Oracle Multitenant" technical whitepaper on OTN.
can we have different storage parameters & different other parameters with in a container database ?
Yes. Look at v$System_Parameter.IsPDB_Settable.
Any enhancement done in RESOUrCE MANAGER ?
Resource Manager has been enhanced to manage pluggable databases within a container, so that you can ensure they are well-behaved. There are other enhancements related to managing PGA memory etc. You can find more info in the documentation: http://www.oracle.com/technetwork/database/enterprise-edition/documentation/database-093888.html
what is the impact of ASM on the implementation of pluggable databases?
You can continue to use Oracle ASM as with previous releases. These layers are unrelated and Oracle ASM will manage the storage regardless of what type of Oracle Database is used. Oracle ASM provides further enhancements in Oracle ASM 12c, such as Flex ASM: http://www.oracle.com/technetwork/products/cloud-storage/index-100339.html
If the application connects using JDBC thin, can it take advantage of TAF/Application Continuity in 12c?
YES - we would recommend FAN and Application Continuity. Please, see: http://www.oracle.com/technetwork/products/clustering/ac-overview-1967264.html
Has the length of table/column names been raised above 30 characters in 12c?
No.
if you are running multiple databases on one instance, would it not impact performance?
Resource contention is an important consideration when consolidating application databases. Resource Manager can be used to define policies for how resources are partitioned between PDBs in a single CDB.
how we can estimate the size of the SGA of CDB?
Best to do this by empirical testing using Resal Application Testing.
Any improvements to DatagUARD and Broker in 12C?
Very significant improvements, most notable is validate database command that automates extensive healt checks, particularly useful before executing switchovers. Also there is the concept of resumable switchover, to gracefully handle any unexpected errors during role transtions, see more in the technical white paper http://www.oracle.com/technetwork/database/availability/active-data-guard-wp-12c-1896127.pdf and on OTN at http://www.oracle.com/goto/dataguard
Will oracle streams works in 12 c ?
yes
How does 12c database make it plugable ?
Very detailed explanations here: http://www.oracle.com/technetwork/database/multitenant-wp-12c-1949736.pdf
question for pluggable db - if 2 databases use TDE and have different wallet files, can they be put into one database? how the wallet being managed?
The wallet is managed for the CDB as a whole.
In Heat Map, Hot is RW. What does Warm and Cold means to?
It's up to you to decide what is "hot", "warm", "cold", etc, using Automatic Data Optimization policies. In an ADO policy, you specify conditions and actions, and your conditions determine when data is eligible to be compressed or moved.
Is independent flashback available on PDB's
We don't support flashback PDB in 12c Release 1 but you can do point-in-time recovery easily with individual PDBs. We can do other types of flashback in 12c Release 1 such as doing flashback for a CDB.
is compression still an option that must be licensed in 12c
Advanced Compression Option, yes. But some compression features that are no licensed separately (e.g., RMAN BASIC) remain included in the server license.
Can we clone entire container db with its plugable databases?
PDB cloning is supported by the Oracle Multitenant architecture.
CDB level cloning is not a capability of the multitenant architecture itself. However, other technologies may support this.
can we have length of PDB and CDB more then 8 character?
The usual rules apply.
Does APEX work in Pluggable DB?
YES - you can have APEX deployed on a per PDB level.
How can I get a dump of all these Q and As ?
We plan to answer the most common questions at blogs.oracle.com
Will there be a view to the heatmap data?
There are PL/SQL table functions to access detailed heap map data.
