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