oracle rac training

After two tests, RAC is very fragile.1. Remove the public network cable of Rac1 and stand next to rac2 to see the changes. It is found that the VIP is quickly converted to rac2 and users can still use it.2.1 minutes later, rac2 restarts automatically. Check that the shared disk cannot be mounted. Another colleague is in config San and cannot determine whether the shared disk is actually faulty.3. Simply perform a more aggressive test, remove the power

RedHat EL5 Installing the Oracle 10g RAC--oracle Software InstallationSystem environment:Operating system: RedHat EL5Cluster:oracle CRS 10.2.0.1.0Oracle:oracle 10.2.0.1.0: RAC System Architecture650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/26/28/wKioL1Np_tziLDXcAAGvUOVml00321.jpg "title=" Rac.png "alt=" W

First, view RAC Environment RAC Architecture, 2 node information Node 1 Sql> Show Parameter instance NAME TYPE VALUE ------------------------------------ ----------- ----------------------------------------------- Active_instance_count integer Cluster_database_instances Integer 2 Instance_groups string instance_name string RACDB1 Instance_number Integer 1 Instance_type string RDBMS Open_links_per_instanc

In Oracle 11g RAC, it is found that both the Solaris and GSD services are in the offline status, which is the default situation of Oracle 11g RAC. Even so, the use of the database is not affected, because the resource for the WLM is used, WLM is available in 11.2.0.2. GSD is used to support interaction tools such as db

Tri Hua, Network name DbsnakeOracle ACE Director,acoug Core expert("Tri Hua article series" has been Tri Hua exclusive authorized in the cloud and the official account of the ink will be released, please continue to pay attention to)This article details the connection management in the Oracle RAC environment, and describes what the connect time load Balancing, Runtime Connection load Balancing, connect is C

I. Introduction One of the most effective ways to familiarize yourself with Oracle's true application cluster (RAC) 10g technology is to access an actual Oracle RAC 10g cluster. There is no way to better understand their benefits than simply experiencing them-including fault tolerance, security, load balancing, and scalability. The core of

In the Oracle RAC environment under VMWare, multi-path images of OCR or votingdisk are not enough for shared storage or need to be added to a new shared disk, we can add shared storage through the command line under VMWare, and then append these new disks to the virtual machines one by one. The following is a detailed description. 1. Add a virtual disk # Here we will add two shared disks for the virtual ma

the Oracle RAC database environment has a lot in common with a single-instance database environment, as well as many heterosexual. The same is true for updates to database patches, which can be done through Opatch. However, patch updates for the RAC environment are updated in several different ways, and even rolling upgrades can be implemented for all nodes in th

Oracle study--oracle 11gR2 RAC CRS startup failureSystem environment:Operating system: RedHat EL5Cluster:oracle 11gR2 GridOracle:oracle 11gR2In a RAC environment, one of the nodes CRSD the process failed to start:[[email protected] ~]$ CRSCTL Check CRSCrs-4638:oracle High Av

Oracle study--oracle 11gR2 RAC CRS startup failure (CRS-4000)System environment:Operating system: RedHat EL5Cluster:oracle 11gR2 GridOracle:oracle 11gR2The following error occurred while initiating a node CRS:[[email protected] ~]# crsctl start CRS Failure at Scls_scr_getval with code 1 Internal Error information:category: -2 operation:opendir location:scrsearch1

Oracle RAC runs on top of the cluster, providing the highest levels of availability, scalability, and low-cost computing power for Oracle databases. If one node in the cluster fails, Oracle can continue to run on the remaining nodes. Oracle's main innovation is a technology called cache merging. Cache merging enables n

Label:Introduction to cluster concept (i) Overview: write down the original intent and motivation of this document, derived from the Oracle Basic operating Manual of the previous article. The Oracle Basic Operations Manual is a summary of the author's vacation on Oracle's foundational knowledge learning. Then form a summary of the system, a review review, the other is easy to use. This document is

Tags: OracleOracle Study-aix6.1 Building Oracle 10GR2 RAC (1)Environment:Operating System: AIX 6100-09 (SP3)Cluster Software: CRS 10.2.0.1Database: Oracle 10.2.0.1There are two ways in which RAC can be used to build an AIX platform based on shared storage:1. Establish shared storage based on concurrent volume group (VG

In some specific circumstances, sometimes you need to connect to the specified instance in RAC from the client, instead of dynamically selecting the client load_balance or forwarding the server listener Based on the load situation. In this case, you can add the instance_name subitem to the network service name specified in tnsnames. ora, or create a network service Name Pointing to the desired instance separately, which is described below. I. Test En

After Oracle 11g RAC is installed, why does crsd on the second node fail to start? The error message is CRS-4535: cannot communicate with cluster ready services. The specific error information must be viewed in the crsd. log. 1. Environment [root @ linux2 ~] # Cat/etc/issue Enterprise Linux Server Release 5.5 (Carthage) kernel \ r on an \ m [root @ linux2 bin] #. /crsctl query CRS activeversion

Oracle 11g R2 RAC: Configure DNS resolution scan vip Oracle 11gR2Grid Infrastructure (CRS) introduces Single Client Access Name (SCAN) to simplify Client Access to database services. This article will introduce in detail how to configure DNS to resolve scan vip demonstration environment OracleEnterprise Linux 5.6 I. Install DNS Server Rpm-ivhbind-9.3.6-16.P1.el5.

Tags: oracle RAC [[EMAILNBSP;PROTECTED]NBSP;~]#NBSP;GROUPADDNBSP;-GNBSP;1300NBSP;DBA [[emailprotected]~]# groupadd-g1301oper [[emailprotected]~]#groupadd-g1000 oinstall [[emailprotected]~]#groupadd-g1200asmadmin [email protected]~]#groupadd-g1201asmdba [[emailprotected]~]# groupadd-g1202asmoper [[emailprotected]~]#useradd-u 1100-goinstall-gasmadmin,asmdba,asmoper,dbagrid [[emailprotected]~]# echogrid|passw

Kind Oracle 11GR2 RAC installation configuration-Prerequisite configuration phase Installing the Oracle 11GR2 11.2.0.4 RAC cluster based on Linux RedHat 6.4 in Vmwarevcenter server 1. Network Planning Where public and private are divided into different network segments. Guaranteed Safe Transmission [root@zracnode1~]#

/group_4.266.685491921 Name---------------------------+ Rac_disk/novadb/tempfile/temp.263.685491617 12 rows selected. SQL> All ASM disks belonging to the "rac_disk" disk group SQL> select path from V $ asm_disk where group_number in (select group_number from V $ asm_diskgroup where name = 'rac _ disk '); Path---------------------------/Dev/raw/raw3/Dev/raw/raw4Orcl: nova3 Start/stop a RAC cluster Make sure

Previously, Oracle's Real Application Cluster (RAC) has always been promoted. We recommend that you use RAC for large database applications, because RAC also addresses the performance expansion and high reliability requirements of these customers. The other two competitors of Oracle, IBMDB2 and Microsoft SQL Server, on