The most common error in Oracle RAC is that the functions and restrictions of Oracle RAC are misunderstood. The following article lists some of the most common errors in Oracle RAC. The following is an introduction to the article.
Several Common Errors of Oracle RAC
As end users are used to getting instant response tim
Label:Data Guard is a remote replication technology for Oracle, it has physical and logical points, but in general, it needs a separate system in a remote location, two sets of hardware configurations can be different systems, but the software structure of the two systems are consistent, including the software version, directory storage structure, and data synchronization (in fact, is not real-time synchronization), the two sets of systems as long as the network is a pass, is a disaster-tolerant
2011.11.23 the ASM disk block of the Virtual Machine RAC results in DB ReconstructionWe just built a 10gr2 rac environment on a company's PC machine with vmware workstation8 and built it with bare equipment + ASM. After the installation is successful, I accidentally restarted the host directly. As a result, when I started the VM again, I was prompted that the disk was damaged. However, a problem occurred wh
Requirements: Create a new standby RAC library in the same environment, that is, the same disk group as the primary RAC.Description: The production environment is generally not recommended for this configuration of DG, because the storage plane is the same disk group, the actual significance of disaster preparedness. I'm here to use as a read-write separation.Basic information:Db_name:jyzhaoPrimary RAC Db_u
There are more processes on the RAC database than on a single instance database. These processes are unique to RAC and are set to implement cluster database functions. This article will introduce RAC-specific processes. 1. LMSn: GlobalCacheServiceProcess. The LMSn Process maintains data files in GlobalResourceDirectory (GRD) and
There are more processes on the
Generally, in the Oracle RAC environment, V $ view can query information about the instance you are connected to, while GV $ view contains information about all instances. However, in the RAC environment, when we query the V $ log view, it is common sense that the V $ log view should see the information of the log group that you connect to the instance. However, V $ log is an exception. That is to say, in t
The most outstanding performance of Oracle RAC clusters is high availability, which mainly includes load balance and failover. These technologies enable single point of failure (spof) to prevent normal access to the database by client applications, and load balancing between nodes by creating a service. This article describes the Oracle failover test in the Oracle 10g RAC environment.The following are some
Tags: let stp knowledge iptables Owner system SPFile splay Post Oracle LINUX 6.3 + Oracle 11.2.0.3 RAC + vbox Installation documentation 2015-10-21 12:51 525 people read Comments (0) favorite reports Classification:Oracle RAC Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced. VBOX + Oracle Linux 6U3 + Oracle 11.2.0.3.0
The PXE method is used to batch push the Complete Oracle 11gR2 RAC environment from bare metal, and the Shell script is used to deploy 32 Oracle11gR2 RAC backup and recovery cases on the launched RAC nodes in batches.
Consultant for ARP Project Implementation of the Chinese Emy of sciences, Tang Bo, a member of the Shanghai Oracle user group
Summary
In the first
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
Routine basic maintenance commands for Oracle RAC
Status of all instances and services
$ Srvctl status database-d orclInstance orcl1 is running on node linux1Instance orcl2 is running on node linux2
Status of a single instance
$ Srvctl status instance-d orcl-I orcl2Instance orcl2 is running on node linux2
The status of the global Naming Service in the database
$ Srvctl status service-d orcl-s orcltestService orcltest is running on instance (s) orcl2,
How to update a patch (Rolling Patch) in the Oracle RAC EnvironmentThe Oracle RAC database environment has many similarities and differences with the single-instance database environment. You can use opatch to update database patches. However, there are several different update Methods for the RAC environment patch update, and you can even implement rolling upgra
The Data Guard is Oracle's remote replication technology, which has physical and logical points, but in general it needs to have a separate system in place, where two hardware configurations can be different, but the software structure of the two systems is consistent, including software versions, directory storage structures, As well as the data synchronization (in fact, is not real-time synchronization), the two systems as long as the network is available, is a remote disaster-tolerant solutio
When activating and disabling OracleRAC, you must pay attention to the following points: 1. Check the shared device 2. Automatically Start RAC and check the related process 3. manually start RAC 4.
When starting and disabling Oracle RAC, you must pay attention to the following points: 1. Check the shared device 2. Automatically Start
Status of all instances and services
$ Srvctl status database-D orclInstance orcl1 is running on node linux1Instance orcl2 is running on node linux2
Status of a single instance
$ Srvctl status instance-D orcl-I orcl2Instance orcl2 is running on node linux2
The status of the global Naming Service in the database
$ Srvctl Status Service-D orcl-s orcltestService orcltest is running on instance (s) orcl2, orcl1
Node applications on specific nodesProgramStatus
$ Srvctl status node
Tags: Oracle Tutorials Oracle Training Oracle Database Tutorials Oracle Engineers training Oracle Database TrainingI. Subject of the course
Brother Feng Oracle Database Tutorial 12CR2 (Project Combat VI): Increased management of Oracle12.2 RAC cluster based on Linux operating system delete node (RAC node Add,rac node Delete).Oracle12.2
OCR is like a Windows registry that stores all configuration information related to the cluster and Rac database. It is also a public configuration, that is, multiple nodes share the same configuration information. Therefore, this configuration should be stored on the shared disk. This article mainly describes the OCR of the cluster and the amnesia caused by OCR based on Oracle 10g RAC.
I. OCR featuresSimi
Label:Oracle 11G RAC cluster installation (vii)
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 also derived from this text. Before rea
Label:Oracle 11G RAC Database installation (eight)
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 also derived from this text. Before
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.