Demystifying ASM spfile

   Starting with ASM version 11.2, the ASM spfile can be stored in an ASM disk group. Indeed, during a new ASM installation, the Oracle Universal Installer (OUI) will place the ASM spfile in the disk group that gets created during the installation. This is true for both Oracle Restart (single instance environments) and Cluster installations. It should be noted that the first disk group created during the installation is the default spfile location, but not a requirement. The spfile can still be on a file system, in say $ORACLE_HOME/dbs directory.

Continue reading

Grid and Database installation issues with CentOS 7.2

   A few days ago I got an email request about to create test database from scratch for software testing team. Despite the fact that it was Saturday I had plenty of free time and I decided to take on the task immediately. Logging in to system with provided credentials attached to an email, I found that OS version is CentOS 7.2. Of course I know that CentOS is not officially supported by Oracle RDBMS. This means if any issue occurs, Oracle could ask customer to duplicate the issue on certified OS before allocating their support resources.

   But as this installation was intended for testing purposes and for a short period of time, I decided continue with installation. We usually use Oracle Restart almost on every single database instance. It’s a great option which delivers automatic start of resources such as database instance, listener and so on. So the first step was grid infrastructure software only installation.

Continue reading

Oracle 11g Release 2 – Single Client Access Name (SCAN)

Introduction

   Single Client Access Name (SCAN) concept was first introduced in Oracle 11g Release 2 is a feature used in Oracle Real Application Cluster environments that provides a single connection name for clients. By using SCAN you don’t need to keep all cluster node entries in client’s tnsnames.ora file. Instead you use single SCAN address or hostname to access any Oracle Database running in a cluster by making it more dynamic. In other words, SCAN is an alias for databases in the cluster. The main purpose is that the client’s connect information does not needs to be changed if you add to or remove nodes from cluster. New terms such as SCAN Name, SCAN VIP, SCAN Listener, Node VIP comes with this feature and sometimes makes it complicated for new DBA’s.

Note: You can read this post in more conventional format from here

Continue reading

Oracle 11g Release 2 Clusterware Stack

Introduction

Before we start let’s fresh our memory and try to remember what is Oracle Clusterware.

Oracle Clusterware is the software which enables the nodes to communicate with each other, allowing them to form the cluster of nodes which behaves as a single logical server.

Oracle 11g Release 2 Clusterware consists of two separate stacks:

  • Oracle High Availability Services Stack – a lower stack anchored by the Oracle High Availability Services daemon (ohasd).
  • Cluster Ready Services Stack – an upper stack anchored by the Cluster Ready Services (CRS) daemon (crsd)

These two stacks have several processes that facilitate cluster operations.

Note: You can read this post in more conventional format from here

Continue reading

World-wide Oracle specialists in Azerbaijan

Determine and Set Sizing Parameters for Database Structures

   Great Oracle conference was held on May 14 in Azerbaijan for the first time. This initiative which was organized by the Oracle USA and supported by Azercell was held in the form of a meeting within OTN (Oracle Technology Network) EMEA tour.

The most popular 4 Oracle specialists met IT amateurs first in Germany, then in Italy and Azerbaijan within the framework of EMEA tour under the sponsorship of Azercell. Conference opened by Kamran Agayev  – founder of Azerbaijan Oracle Users Group (AZEROUG). Then Oracle specialists shared their experiences and introduced the latest technological innovations to the participants. Different lectures were delivered on Upgrading Large Databases, preventing delays in data query, software used for database operation during OTN meeting. İn general 7 speeches were made at the meeting. 1 hour-panel discussion was organized and the questions by the participants were responded in the final session. The most famous Oracle specialists in the world, such as Christian Antognini, Mike Dietrich, Joel Perez and Bjoern Rost took the floor in the conference. Entry to this interesting event was free and more than 160 persons attended the conference.

Continue reading

Creating and Preparing VMware Virtual Machine for Oracle Database and/or ASM Installation

In this step by step tutorial we will learn how to prepare VMware Virtual Machine for Oracle Database and/or Automatic Storage Management Installation.

You can download this post as pdf file.

1. After installing VMware software on your PC or Laptop open VMware Workstation.

Javid Hasanov's ORACLE Blog
VMware Workstation 10 Home Page

Continue reading