Just another Oracle blog

Oracle Database 18c – Read-Only Oracle Homes

Posted by Balazs Papp on 2019-10-06

Starting with Oracle Database 18c, an Oracle home can be configured in read only mode. In such homes, configuration and log files are located outside the Oracle home.
Read the rest of this entry »

Posted in 18c, Database | Leave a Comment »

18c Data Guard NOLOGGING options – Part 2: NOLOGGING FOR DATA AVAILABILITY

Posted by Balazs Papp on 2019-01-05

In Part 1, I saw that the NOLOGGING FOR DATA AVAILABILITY option worked as expected.
Read the rest of this entry »

Posted in 18c, Data Guard, Database, Oracle | Leave a Comment »

18c Data Guard NOLOGGING options – Part 1: Introduction

Posted by Balazs Papp on 2019-01-05

In versions before 18c, when configuring Data Guard, the only option we had for the logging property of the databases other than the default, was enabling FORCE LOGGING as:

ALTER DATABASE FORCE LOGGING;

Starting with 18c, we have the following new options:

ALTER DATABASE SET STANDBY NOLOGGING FOR DATA AVAILABILITY;

or

ALTER DATABASE SET STANDBY NOLOGGING FOR LOAD PERFORMANCE;

Read the rest of this entry »

Posted in 18c, Data Guard, Database, Oracle | Leave a Comment »

You may not run MultiNode RAC because it is not supported or certified

Posted by Balazs Papp on 2018-12-09

So I have a perfectly working 2-node cluster:

Read the rest of this entry »

Posted in 11.2, 11g, Grid Infrastructure, Oracle | Leave a Comment »

Oracle 18.2 RU install

Posted by Balazs Papp on 2018-04-19

The patch number for Oracle 18.2 is 27676517.
Read the rest of this entry »

Posted in 18c, Database, Installation, Oracle | 1 Comment »

Oracle 18c – RECOVER STANDBY DATABASE FROM SERVICE

Posted by Balazs Papp on 2018-04-05

Oracle 12c introduced a RMAN feature: RECOVER/RESTORE … FROM SERVICE. When rolling forward a standby database, this involved the below steps on the standby database:
Read the rest of this entry »

Posted in 18c, Data Guard, Oracle, RMAN | 1 Comment »

12c – Incorrect NESTED LOOPS SEMI cost when a query is executed in PL/SQL context

Posted by Balazs Papp on 2018-01-16

In the middle of performance tests at one of my clients while migrating from 10.2.0.5 to 12.1.0.2.
A specific query performs poorly in PL/SQL context on 12c.
When the same query is executed as a single SQL statement, it performs well.
On versions below 12c, there is no difference between SQL and PL/SQL context, the query performs well in both contexts.
Read the rest of this entry »

Posted in 12c, Oracle, Performance, SQL | 1 Comment »

Installing Oracle 12c Release 2 (12.2) RAC on VirtualBox – silent installation – Part 4

Posted by Balazs Papp on 2017-03-20

With a working 12c Release 2 (12.2) Grid Infrastructure cluster, the only remaining tasks left are installing the database software and creating a database.

Part 1 – https://balazspapp.wordpress.com/2017/03/19/installing-oracle-12c-release-2-12-2-rac-on-virtualbox-silent-installation-part-1/
Part 2 – https://balazspapp.wordpress.com/2017/03/19/installing-oracle-12c-release-2-12-2-rac-on-virtualbox-silent-installation-part-2/
Part 3 – https://balazspapp.wordpress.com/2017/03/20/installing-oracle-12c-release-2-12-2-rac-on-virtualbox-silent-installation-part-3/
Part 4 – https://balazspapp.wordpress.com/2017/03/20/installing-oracle-12c-release-2-12-2-rac-on-virtualbox-silent-installation-part-4/
Read the rest of this entry »

Posted in 12.2, 12c Release 2, Database, Installation, Oracle, VirtualBox | 1 Comment »

Installing Oracle 12c Release 2 (12.2) RAC on VirtualBox – silent installation – Part 3

Posted by Balazs Papp on 2017-03-20

After setting up the virtual machines, time has come for installing Grid Infrastructure.

Part 1 – https://balazspapp.wordpress.com/2017/03/19/installing-oracle-12c-release-2-12-2-rac-on-virtualbox-silent-installation-part-1/
Part 2 – https://balazspapp.wordpress.com/2017/03/19/installing-oracle-12c-release-2-12-2-rac-on-virtualbox-silent-installation-part-2/
Part 3 – https://balazspapp.wordpress.com/2017/03/20/installing-oracle-12c-release-2-12-2-rac-on-virtualbox-silent-installation-part-3/
Part 4 – https://balazspapp.wordpress.com/2017/03/20/installing-oracle-12c-release-2-12-2-rac-on-virtualbox-silent-installation-part-4/
Read the rest of this entry »

Posted in 12.2, 12c Release 2, Database, Installation, Oracle, VirtualBox | Leave a Comment »

Installing Oracle 12c Release 2 (12.2) RAC on VirtualBox – silent installation – Part 2

Posted by Balazs Papp on 2017-03-19

This part covers preparing the operating system for installation, configuring shared storage and DNS.

Part 1 – https://balazspapp.wordpress.com/2017/03/19/installing-oracle-12c-release-2-12-2-rac-on-virtualbox-silent-installation-part-1/
Part 2 – https://balazspapp.wordpress.com/2017/03/19/installing-oracle-12c-release-2-12-2-rac-on-virtualbox-silent-installation-part-2/
Part 3 – https://balazspapp.wordpress.com/2017/03/20/installing-oracle-12c-release-2-12-2-rac-on-virtualbox-silent-installation-part-3/
Part 4 – https://balazspapp.wordpress.com/2017/03/20/installing-oracle-12c-release-2-12-2-rac-on-virtualbox-silent-installation-part-4/
Read the rest of this entry »

Posted in 12.2, 12c Release 2, Database, Installation, Oracle, VirtualBox | Leave a Comment »

 
%d bloggers like this: