Infrastructure at your Service

12.2 Archives - Blog dbi services

Oct 12 2018
Petre Radut

How to migrate Grid Infrastructure from release 12c to release 18c

By | Application integration & Middleware, Database Administration & Monitoring, Database management, Oracle | No Comments

Oracle Clusterware 18c builds on this innovative technology by further enhancing support for larger multi-cluster environments and improving the overall ease of use. Oracle Clusterware is leveraged in the cloud in order to provide enterprise-class resiliency where required and dynamic as well as online allocation of compute resources where needed, when needed. Oracle Grid Infrastructure provides the necessary components to manage high availability (HA) for any business critical application. HA in consolidated environments is no…

Read More
Sep 18 2018
Petre Radut

Configure AFD with Grid Infrastructure software (SIHA & CRS) from very beginning.

By | Database Administration & Monitoring | No Comments

Introduction : Oracle ASM Filter Driver (Oracle ASMFD) simplifies the configuration and management of disk devices by eliminating the need to rebind disk devices used with Oracle ASM each time the system is restarted. Oracle ASM Filter Driver (Oracle ASMFD) is a kernel module that resides in the I/O path of the Oracle ASM disks. Oracle ASM uses the filter driver to validate write I/O requests to Oracle ASM disks. In this blog I will…

Read More
Aug 03 2018
Petre Radut

Upgrade Oracle Grid Infrastructure from 12.1.0.2.0 to 12.2.0.1.0

By | Database Administration & Monitoring, Database management, Oracle | No Comments

The following blog will provide the necessary steps to upgrade the Grid Infrastructure from 12.1 to 12.2, for a Standalone Server. One of the new features of GI 12.2 is the usage of the AFD (Oracle ASMFD Filter Driver). Assumptions : You have installed Oracle GI 12.1 as grid user You have installed Oracle Database 12.1 as oracle user You have configured the groups asmadmin,asmoper,asmdba You installed oracle-rdbms-server-12cr2-preinstall rpm You patched your Oracle GI to…

Read More
Feb 22 2018
David Hueber

ODA 12.2.1.2.0: Some curious password management rules

By | Database Administration & Monitoring, Hardware & Storage | One Comment

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 looks like there is some flexibility with those rules. Lets try to check this out with some basics tests.

Read More
Feb 20 2018
Jérôme Dubar

One command database upgrade on ODA

By | Database Administration & Monitoring | No Comments

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 old databases to the latest engine, at least those still running on 11.2. As you may know, 11.2  is no more supported with premier support since January 2015: it’s time to think about an upgrade….

Read More
Feb 20 2018
David Hueber

ODA 12.2.1.2.0 – VLAN Management

By | Database Administration & Monitoring | 2 Comments

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 aso. In the new release of ODA we finally get the support for VLAN on the bare metal platform. This article will briefly demonstrate how these are managed using ODAADMCLI.

Read More
Jun 19 2017
Oracle Team

12cR2 Application Containers and Foreign Keys

By | Database management, Oracle | 2 Comments

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 table. But then, should a delete on the root validate that there are no orpheans in the application PDBs? And what if those PDBs are closed at the time of this delete? Here is a…

Read More
Jun 04 2017
Oracle Team

12cR2 auditing all users with a role granted

By | Database management | 2 Comments

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 users except some listed ones. 12.2 adds a syntax to audit a group of users, defined by the role granted. This is the best way to enable a policy for a group of users, including…

Read More
May 29 2017
Oracle Team

Which privilege for CREATE PLUGGABLE DATABASE from DB LINK?

By | Database management | One Comment

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 privileges required on the source for the user defined in the database link, so here are the different possibilities. Remote clone Here is what the documentation says: So you can connect to the CDB or to…

Read More
May 26 2017
Oracle Team

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

By | Database management | No Comments

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 and this blog post is about an error you may encounter: ORA-01017: invalid username/password; logon denied This blog post also explains a consequence of this implementation, the big inconsistency of CONTAINERS() function because the implementation is completely different for…

Read More