cluster. The global GIMR runs in the Oracle Domain Services cluster. Global GIMR enables local clusters to be exempt from private storage for this data in their disk groups and allows long-term historical data storage for diagnostic and performance analysis.2, the hardware requirements3. RAC Planning3.1. Shared disk p
A customer's 11.2 RAC environment, there is a node down the problem.
The client adjusted the system's time manually, making the two-node system time only a few seconds apart, and setting a 11.2 automatic time synchronization function. But in the afternoon found that the instance on a node down, and then two nodes of the time difference of about one hours.
Check the database alert file on the dead node:
Mon May 10 15:22:03 2010
NOTE:ASMB terminatin
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
How to download the Grid method (Oracle RAC) on the OTN website, otngrid
How to download grid software required by RAC
Register an account and log on to the OTN website.
Go to the download options and find the "server and storage system" item.
Find Grid Infrastructure from the drop-down menu.
After entering, remember to click "accept license" to download the
Oracle RAC also has HA (High Availiablity) and LB (LoadBalance), and its High availability is based onFailover (Failover)It means that the failure of any node in the cluster will not affect the user's use, and the user connected to the faulty node will be automatically transferred to the healthy node. In terms of user experience, this switchover is not felt.
A gold rule in RAC debugging1. Always ensure that each node has the same system time to achieve the following goals:-Easy log information analysis-Ensure accurate results are obtained when you read the GV $ view.-Avoid Premature instance eviction2. It is recommended that you use the Network Time Protocol to synchronize nodes.Major Oracle Clusterware log files
Diagnostic collection script1. scripts used to c
. Executes the root.sh script after the installation is complete.3.1. Run the installation script$Grid _home/gridsetup. SH3.2. Select Configure Grid Infrastructure for a New Cluster and click Next3.3. Select Configure an Oracle Standalone Cluster, then click Next3.4.scan-name to be the same as Scan-ip in/etc/hosts, cancel the GNS and click Next3.5. Choose Add nod
Updates,nextSelect the first item, install for a cluster, NextSelect Second, advanced installation, NextAdd Simplified Chinese support, NextSet cluster name and scan name, cancel check Configure Gns,nextAt this point the installer does not automatically recognize Node2 information and needs to add it manually.Add Good Node2,nextAhab, error, this mistake is two nodes ssh mutual trust caused, in fact, oracle
In Oracle RAC, in addition to the TFA Method Based on the client, there is also the TFA Method Based on the server. You can regard the TFA method of the server as an upgraded version of the TFA method of the client. The TFA on the server must be configured on the server. This is done through the Service. This article mainly describes how to configure the TFA of the server through service in
1. Clear TasksPrepare a RHEL5 PC to act as a San device, a SAN (both as a DNS and timing system)Prepare two RHEL5 PCs to act as RAC nodes, R1 and R2Install RAC on ASM disk, including OCR, voting, library2. Modify kernel parameters and shell limitations of R1 and R2On R1 and R2, respectively.Vim/etc/sysctl.conf------------------------------------------Kernel.shmmax = 4294967296Kernel.shmmni = 4096Kernel.shma
The obsolete maintenance command crs _ *, 12ccrs _ in Oracle 12c RAC _
Crs_stat is commonly used in Oracle 10g and 11g RAC to monitor the running status of RAC. However, the crs_stat display is incomplete, so we will perform a secondary encapsulation of crs_stat to make t
Oracle RAC is not supported for one node is rhel5.x and the other node is rhel6.xBecause rhel5.x and Rhel 6.x are seen by Oracle as "different operating system versions"The Oracle Solution SR engineers gave the following reply in full:There shouldn ' t is any problem in installing
Install Oracle 10g + RAC in RedHat 5.5
The cost is relatively low, the technology is mature, and the function is powerful. This solution will become more and more favored by small and medium-sized enterprises.
I. Preparations before the experiment
Virtual Machine version: VMware server1.0.6
Linux version: RedHat 5.5 Enterprise Server version
Oracle 10g 10.2.1
Tags: database oracle Oracle RAC Snapshot DBAStatspack is the product of the Oracle 9i ERA, and is the predecessor of AWR, which has a cross-milestone significance for monitoring and analyzing database performance. After the Oracle 10g, AWR replaced the statspack. Nonetheles
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
For Oracle RAC node eviction caused by heartbeat Network (not instance eviction), oraclerac
Node eviction of Oracle RAC caused by heartbeat Network (not instance eviction)
Q:Suppose the following scenario: for the four node rac, the heartbeat line uses a m network switch
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
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.