12.2

ODA 12.2.1.2.0: Some curious password management rules

While deploying an ODA based on the DCS stack (odacli), it is mandatory to provide a "master" password at appliance creation. The web GUI provides for that a small tooltip which describes the rules applied on password management. However it(…)

One command database upgrade on ODA

The 12.2 finally arrived on ODA and is now available on all generations. Modern ODAs are now supporting 11.2.0.4, 12.1.0.2 and 12.2.0.1 database engines, and these 3 versions can work together without any problem. You probably plan to upgrade some(…)

ODA 12.2.1.2.0 – VLAN Management

Virtual Local Area Network (VLAN) have become since several years a standard in enterprise class networks. Most enterprises are now segregating their network, especially for security reasons, between server and user or prod and test or applications and backup and(…)

12cR2 Application Containers and Foreign Keys

By Franck Pachot . Application Container brings a new way to share data among databases, and adds a new dimension to referential integrity. A foreign key in an application PDB can reference a row belonging to a root data link(…)

12cR2 auditing all users with a role granted

By Franck Pachot . 12.1 introduced Unified Auditing where you define policies and then enable them. As with the traditional audit, you enable them for all users or for specific users. The unified auditing adds a syntax to audit all(…)

Which privilege for CREATE PLUGGABLE DATABASE from DB LINK?

By Franck Pachot . When cloning a PDB from a remote CDB you need to define a database link to be used in the CREATE PLUGGABLE DATABASE … FROM …@… command. The documentation is not completely clear about the(…)

12cR2 needs to connect with password for Cross-PDB DML

By Franck Pachot . In a previous post, I explained that Cross-PDB DML, executing an update/delete/insert with the CONTAINERS() clause, seems to be implemented with implicit database links. Connecting through a database link requires a password(…)

random “ORA-01017: invalid username/password” in 12cR2

By Franck Pachot . Since 12cR2 is out, we give our 12c new feature workshop with hands-on exercises on 12.1 and 12.2 releases. When I gave it last month, I had a small problem when doing(…)

12cR2 Cross-container DML – insert into container()

By Franck Pachot . Multitenant has been introduced in 12.1.0.1 with the goal to share resources but isolate data. However, having all PDBs in the same root may be convenient to manipulate data in multiple PDBs. In the first patchset,(…)

Oracle 12cR2 : Optimizer Statistics Advisor

The Optimizer Statistics Advisor is a new Advisor in Oracle 12.2. The goal of this Advisor is to check the way you gather the statistics on your database, and depending on what is found, it will makes some recommendations(…)