DBA Tips Archive for Oracle DBA Tips Archive for Oracle [an error occurred while processing this directive] No Title [an error occurred while processing this directive] by Michael New,, Gradation LLC Contents • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • Introduction Oracle RAC 11 g Release 2 allows DBA's to configure a cluster database solution with superior fault tolerance, load balancing, and scalability. However, DBA's who want to become more familiar with the features and benefits of database clustering, will find the costs of configuring even a small RAC cluster costing in the range of US$10,000 to US$20,000. This cost would not even include the heart of a production RAC configuration, the shared storage. In most cases, this would be a Storage Area Network (SAN), which generally start at US$10,000.

Download the free trial version below to get started. Double-click the downloaded file to install the software.

Unfortunately, for many shops, the price of the hardware required for a typical RAC configuration exceeds most training budgets. What Does Diagonal Lines On The Pavement Warn Drivers Of. For those who want to become familiar with Oracle RAC 11 g without a major cash outlay, this guide provides a low-cost alternative to configuring an Oracle RAC 11 g Release 2 system using commercial off-the-shelf components and downloadable software at an estimated cost of US$2,800. The system will consist of a two node cluster, both running Linux (CentOS 5.5 for x86_64), Oracle RAC 11 g Release 2 for Linux x86_64, and ASMLib 2.0. Pokemon Rosso Versione Giapponese Maglia.

All shared disk storage for Oracle RAC will be based on using Openfiler release 2.3 x86_64 running on a third node (known in this article as the Network Storage Server). This guide is provided for educational purposes only, so the setup is kept simple to demonstrate ideas and concepts. For example, the shared Oracle Clusterware files (OCR and voting files) and all physical database files in this article will be set up on only one physical disk, while in practice that should be stored on multiple physical drives configured for increased performance and redundancy (i.e. In addition, each Linux node will only be configured with two network interfaces — one for the public network ( eth0) and one that will be used for both the Oracle RAC private interconnect 'and' the network storage server for shared iSCSI access ( eth1). For a production RAC implementation, the private interconnect should be at least Gigabit (or more) with redundant paths and 'only' be used by Oracle to transfer Cluster Manager and Cache Fusion related data. A third dedicated network interface ( eth2, for example) should be configured on another redundant Gigabit network for access to the network storage server (Openfiler).

In addition to this guide, please see the following extensions to this article that describe how to add and remove nodes from the Oracle RAC. • • Oracle Documentation While this guide provides detailed instructions for successfully installing a complete Oracle RAC 11 g system, it is by no means a substitute for the official Oracle documentation (see list below).

In addition to this guide, users should also consult the following Oracle documents to gain a full understanding of alternative configuration options, installation, and administration with Oracle RAC 11 g. Oracle's official documentation site is. • - 11g Release 2 (11.2) for Linux • - 11g Release 2 (11.2) • - 11g Release 2 (11.2) for Linux and UNIX • - 11g Release 2 (11.2) • - 11g Release 2 (11.2) • - 11g Release 2 (11.2) Network Storage Server Powered by, is a free browser-based network storage management utility that delivers file-based Network Attached Storage (NAS) and block-based Storage Area Networking (SAN) in a single framework.

The entire software stack interfaces with open source applications such as Apache, Samba, LVM2, ext3, Linux NFS and iSCSI Enterprise Target. Openfiler combines these ubiquitous technologies into a small, easy to manage solution fronted by a powerful web-based management interface. Openfiler supports CIFS, NFS, HTTP/DAV, FTP, however, we will only be making use of its iSCSI capabilities to implement an inexpensive SAN for the shared storage components required by Oracle RAC 11 g. The operating system (rPath Linux) and the Openfiler application will be installed on one internal SATA disk. A second internal 73GB 15K SCSI hard disk will be configured as a single that will be used for all shared disk storage requirements. Prime31 Plugins Free. The Openfiler server will be configured to use this volume group for iSCSI based storage and will be used in our Oracle RAC 11 g configuration to store the shared files required by Oracle Grid Infrastructure and the Oracle RAC database.