Wednesday, 13 December 2017

How to Turn on Instant File Initialization

Do you have instant file initialization turned on?  If you do, then allocating your database data pages will go much faster.  Not having instant file initialization turned on slows down the process of adding pages to your database.  It slows down because prior to allocating the data pages to your database, SQL Server needs to zero out the newly allocated pages.

Monday, 11 December 2017

Oracle Database 12c Release 1 (12.1) Installation On Oracle Linux 5

This article describes the installation of Oracle Database 12c Release 1 (12.1) (64-bit) on Oracle Linux 5 (64-bit). The article is based on a server installation with a minimum of 2G swap, with SELinux set to permissive and the firewall disabled. The following package groups were included for this installation.

Thursday, 7 December 2017

Oracle Database 12c Release 1 (12.1) Installation On Oracle Linux 6

This article describes the installation of Oracle Database 12c Release 1 (12.1) (64-bit) on Oracle Linux 6 (64-bit). The article is based on a server installation with a minimum of 2G swap, with SELinux set to permissive and the firewall disabled. The following package groups were included for this installation.

Wednesday, 6 December 2017

Oracle Database 12c Release 1 (12.1) RAC On Oracle Linux 7 Using VirtualBox Part-2

◉ Install the Grid Infrastructure


Make sure both virtual machines are started. Install the following package from the Oracle grid media as the "root" user.

# cd /media/sf_12.1.0.2/grid/rpm
# rpm -Uvh cvuqdisk*

Monday, 4 December 2017

Oracle Database 12c Release 1 (12.1) RAC On Oracle Linux 7 Using VirtualBox Part-1

This article describes the installation of Oracle Database 12c release 1 (12.1 64-bit) RAC on Linux (Oracle Linux 7 64-bit) using VirtualBox (5.0.4) with no additional shared disk devices.

◉ Introduction


One of the biggest obstacles preventing people from setting up test RAC environments is the requirement for shared storage. In a production environment, shared storage is often provided by a SAN or high-end NAS device, but both of these options are very expensive when all you want to do is get some experience installing and using RAC. A cheaper alternative is to use a FireWire disk enclosure to allow two machines to access the same disk(s), but that still costs money and requires two servers. A third option is to use virtualization to fake the shared storage.

Friday, 1 December 2017

Oracle Database 12c Release 1 (12.1.) RAC on Oracle Linux 7 Using NFS

This article describes the installation of Oracle Database 12c Release 2 (12.1 64-bit) RAC on Oracle Linux 7.1 64-bit using NFS to provide the shared storage.

◉ Introduction


NFS is an abbreviation of Network File System, a platform independent technology created by Sun Microsystems that allows shared access to files stored on computers via an interface called the Virtual File System (VFS) that runs on top of TCP/IP. Computers that share files are considered NFS servers, while those that access shared files are considered NFS clients. An individual computer can be either an NFS server, a NFS client or both.