Infrastructure at your Service

Oracle 12.2 Archives - Blog dbi services

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
Mouhamadou Diaw

Automatic Block Media Recovery in a DataGuard

By | Database Administration & Monitoring | No Comments

With Oracle 12.2, in a Data Guard environment corrupted data blocks can be automatically replaced with uncorrupted copies of those blocks. There are just some requirements: • The physical standby database must be operating in real-time query mode, which requires an Oracle Active Data Guard license. • The physical standby database must be running real-time apply. Automatic block media recovery works in two directions depending on whether the corrupted blocks are encountered on the primary…

 
Read More
Franck Pachot

12cR2 PDB archive

By | Oracle | No Comments

By Franck Pachot . In 12.1 we had the possibility to unplug a PDB by closing it and generating a .xml file that describes the PDB metadata required to plug the datafiles into another CDB. In 12.2 we got an additional possibility to have this .xml file zipped together with the datafiles, for an easy transport. But that was not working for ASM files. The latest Release Update, Oct 17 includes the patch that fixes…

 
Read More
Mouhamadou Diaw

Online datafile move in a 12c dataguard environment

By | Database Administration & Monitoring | No Comments

Oracle 12c introduces moving online datafile. One question we might ask is what about moving datafile online in a dataguard environment. In this blog we will do some tests Below our configuration, we are using oracle 12.2 DGMGRL> show configuration; Configuration – MYCONT_DR Protection Mode: MaxPerformance Members: MYCONT_SITE – Primary database MYCONT_SITE1 – Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS (status updated 8 seconds ago) DGMGRL> The StandbyFileManagement property is set to auto…

 
Read More
Mouhamadou Diaw

Oracle 12.2 Dataguard : PDB Flashback on the Primary

By | Database Administration & Monitoring | No Comments

The last day I was discussing with one colleague about database flashback for a pluggable database in a dataguard environment. I did some tests and I present results in this blog. Below our broker configuration. Oracle 12.2 is used. DGMGRL> show configuration; Configuration – MYCONT_DR Protection Mode: MaxPerformance Members: MYCONT_SITE – Primary database MYCONT_SITE1 – Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS (status updated 35 seconds ago) DGMGRL> The primary database has the…

 
Read More
Mouhamadou Diaw

Dataguard: QUIZZ on Snapshot Standby

By | Database Administration & Monitoring | No Comments

In oracle documentation we can find this about snapshot standby: A snapshot standby database is a fully updatable standby database that provides disaster recovery and data protection benefits that are similar to those of a physical standby database. The concept of snapshot standby is that we can temporary convert a physical standby to an updatable database for different purposes and then convert back to a physical standby. During the time that the database is a…

 
Read More
Mouhamadou Diaw

Grid Infrastructure 12.2: Are all Redhat 7 kernels compatible?

By | Database Administration & Monitoring | No Comments

In this blog I am going to share an issue I had when installing grid infrastructure 12.2 on Redhat 7.3. I was configuring grid infrastructure 12.2 for a standlone server. Below the release and the version of my operating system root@dbserver /etc $ cat redhat-release Red Hat Enterprise Linux Server release 7.3 (Maipo) root@dbserver ~ $ uname -a Linux dbserver 3.10.0-514.21.2.el7.x86_64 #1 SMP Sun May 28 17:08:21 EDT 2017 x86_64 x86_64 x86_64 GNU/Linux root@dbserver ~…

 
Read More
Oracle Team

Oracle 12.2 – How to rotate the 12.2 listener log (DIAG_ADR_ENABLED_LISTENER = OFF) – Follow Up

By | Database Administration & Monitoring | No Comments

By William Sescu My blog about listener rotation caused some discussion, which is great. It sounds like an easy stuff, but in case of listener logging it isn’t. https://blog.dbi-services.com/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off/ Many ways do exist to rotate the listener log, but I was trying to point out some issues, because there are a few, e.g. What happens when the log file reaches 4G? What are the performance implications? What happens if I move the listener.log while the…

 
Read More
Oracle Team

Oracle 12.2 – How to run a consistent full database export with dbms_datapump and parallel degree of 8

By | Database Administration & Monitoring | 3 Comments

By William Sescu Nowadays, since the cloud is becoming more and more important, the PL/SQL API’s become more and more important too. Fortunately, Oracle has quite a lot of them. E.g. How do you run a Data Pump export if you have no ssh connectivity to the server? You could use the old exp tool, which is still available even with Oracle 12.2, or you can use DBMS_DATAPUMP. The Data Pump API is quite good…

 
Read More
Oracle Team

Oracle 12.2 – How to rotate the 12.2 listener log (DIAG_ADR_ENABLED_LISTENER = OFF)

By | Database Administration & Monitoring, Database management | 7 Comments

By William Sescu The listener log file contains a lot of very useful information, like the program which was used for the connection, the IP address where the connection is coming from, the OS user which was used on the client  and many many more. 05-JUN-2017 12:36:19 * service_update * DBIT122 * 0 05-JUN-2017 12:36:19 * (CONNECT_DATA=(SERVICE_NAME=DBIT122_SITE1_DGMGRL)(UR=A)(CID=(PROGRAM=sqlplus@dbidg01)(HOST=dbidg01)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.201)(PORT=42619)) * establish * DBIT122_SITE1_DGMGRL * 0 05-JUN-2017 12:36:19 * (CONNECT_DATA=(SERVICE_NAME=DBIT122_SITE1_DGMGRL)(UR=A)(CID=(PROGRAM=sqlplus@dbidg01)(HOST=dbidg01)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.201)(PORT=42620)) * establish * DBIT122_SITE1_DGMGRL…

 
Read More