cluster time synchronization service to provide synchronization services in the cluster, you need to uninstall the Network Time Protocol (NTP) and its configuration.To deactivate the NTP service, you must stop the current NTPD service, disable the service from the initialization sequence, and delete the ntp.conf file.To complete these steps on Oracle Enterprise Linux, run the following command on two Oracle
OCR and voting Disk backups in Oracle RAC are described in my blog: oracle RAC Common maintenance tools and commands , and now take it separately to make a note, because OCR and voting disk Is too important for a RAC system.Oracle RAC
Football and oracle series (4): from Brazil to Germany, think of the different RAC topology comparison !, OracleracFootball and oracle series (4): from Brazil to Germany, think of the different RAC topology comparison!
Preliminary review:
I was going to say that tonight, I thought it would be the second semi-finals th
1. RAC global wait Event Description
In the RAC environment, the most common wait events related to global cache adjustment are global cache Cr request, global cache busy, and equeue.
When a process needs to access one or more blocks, Oracle first checks whether the block exists in its cache, the shared access permission is granted to these blocks through global
Oracle RAC background process Introduction
There are more processes in the Oracle RAC database than in a single instance database. These processes are unique to RAC and are set to implement cluster database functions. This article will introduce
Label:OCR is like a registry of Windows that stores all the configuration information associated with a cluster, RAC database. It is also a common configuration, which means that multiple nodes share the same configuration information. Therefore, the configuration should be stored on the shared disk. This paper mainly describes the OCR of cluster and the forgetfulness problem of OCR based on Oracle 10g
-brain mode caused by the network.If I have three RAC instance nodes, namely A, B, and C, when node A goes down, I try to stop the response resource in 11 GB and then remove the node, so why does it remove the node? That's because when split-brain occursWhen split-brain occurs, it is divided into two parts: A is A part of the vote for 1, BC is A part of the vote for 2, then more election will select the party with more votes, thus removing; this is an
In the RAC environment, Oracle uses GRD (Global Resource Service) to record the Resource information of each RAC node. The Resource information of each RAC node is recorded by using GCS (Global Cache Service) and GES (Global Enqueue Service) these two services are managed.
In RAC
$thread does does show all the threads:--ALTER DATABASE enable public thread 2;
--Repeat for other threads if applicable 4. Close all instances of the database $ srvctl Stop database-d Orcl-o Immediate
5. Back up the current control file 6. Make sure that the instance settings are for thread 1 Instance = 1
thread = 1
7. Set the cluster_database in the parameter file to FalseIf you are using SPFile: sql> startup Nomount
sql> alter system set CLUSTER_DATABASE=FALSE Scope=spfile;
sql> shutdown
In an application environment, all servers use and manage the same database to distribute the workload of each server. The hardware requires at least two services.
In an application environment, all servers use and manage the same database to distribute the workload of each server. The hardware requires at least two services.
In an application environment, all servers use and manage the same database to distribute the workload of each server. The hardware requires at least two servers, A sh
[Oracle] RAC deletes a node
Environment:
OS: OEL5.6
RAC: 10.2.0.1.0
There are currently three rac1, rac2, and rac3 nodes. The following describes how to delete a rac3 node.
1. Delete the database instance on the rac3 Node
[Oracle @ rac1 ~] $ Dbca-silent-deleteInstance-gdbName RACDB-instanceName RACDB3-sysDBAUserName sy
I. Problem Description
Install RAC of 11.2.0.1 on Oracle Linux 6.1 and run the root. Sh script when installing grid. The error is as follows:
[Root @ Rac1 bin] #/u01/APP/11.2.0/GRID/root. Sh
Running Oracle 11g root. Sh script...
The following environment variables are Setas:
Oracle_owner = Oracle
ORACLE_HOME =/u01/AP
Test Purpose: Single Instance database conversion to RAC databaseTest environment: Oracle 11.2.0.4Test method: Manual Conversion.First, install a set of RAC environments and restore single-instance databases to this environment through Rman (typically, in production environments, we build ADG from RAC to single-instanc
machines to connect to each other, and SSH itself is required to connect, otherwise an error will be reported on the oracle cluster nodeTo create a raw device, you must modify the two configuration files on the node of the RAC machine.You also need to pay attention to the raw permission issues chmodchownNote: The raw device port numbers on both sides must be the same. Otherwise, an error will be reported,F
Summary of Oracle 11gR2 RAC cluster Service Startup and Shutdown
Introduction: the source of this article is that one of my students recently set up a RAC cluster in the company, but the sequence and principle of its startup and shutdown are not very clear, I also found that many students have little knowledge about RAC
Tags: ETL kettle jdbc Oracle RAC1 problem Phenomena:Previously done Kettle connect an Oracle database for table extractionThe table input information for the script is as follows:Error message in the table input report when executing (script uploaded to Linux machine with sh command) :But in the machine with the Sqlplus command login can be successful:2 resolution process:After the problem, the first contac
Tags: style blog using strong file dataOracle RAC 10.2 storage options on LinuxBlog Category:
Oracle
Oraclelinux Project Management configuration ManagementOracle clusters require storage of software and data
Project
Content
Minimum disk space
Clusterware Software
Cluster software
500M (does not change after installation is complete)
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.