Friday, 29 December 2017

An Oracle DBA's Guide to WebLogic Server

Like it or not, knowledge of WebLogic is now part of the DBA role. You don’t have to know a great deal to be useful with basic WebLogic setups, but the whole Fusion Middleware stack is big and complicated.Once you step beyond the basics, IMHO it is time for you to hire a full time Middle Tier Administrator.

Wednesday, 27 December 2017

WebLogic Server 12cR1 (12.1.2 and 12.1.3) : ADF Application Development Runtime Installation on Oracle Linux

This article assumes you already have a working WebLogic 12cR1 (12.1.2 or 12.1.3) installation. The 12.1.2 and 12.1.3 runtimes are full installations applied directly over the application servers.

Friday, 22 December 2017

Step by Step Guide to Migrate SQL Server Data to SQL Server 2017

We discussed Data Migration Assistant (DMA) and how DMA can help in migrating an older version of SQL Server to SQL Server 2017. In this article, we will walk through a step by step approach to assess your SQL Server migration using DMA. This activity will help you to understand the behavior of the existing SQL Server and what changes need to be made to migrate to a newer version of SQL Server.

Wednesday, 20 December 2017

WebLogic Server 12cR1 (12.1.2 and 12.1.3) : Clustered Domains

This article describes how to create a two-node clustered domain using Oracle WebLogic 12cR1 (12.1.2 and 12.1.3).

◉ Install WebLogic 12cR1 (12.1.2)


Make sure both machines have WebLogic 12cR1 (12.1.2 or 12.1.3) installed. An example of these installations can be found here:

Friday, 15 December 2017

WebLogic Server 12cR2 (12.2.1) : ADF Application Development Runtime - Repository Configuration Utility (RCU)

The Repository Configuration Utility (RCU) is a necessary prerequisite for the creation of clustered domains in WebLogic 12c. It is recommended to install Forms and Reports Services as a clustered domain, even if it is for a single node, so it is also a prerequisite for those installations.

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.