Note: This article is excerpt from Zhang Xiaoming Oracle RAC: Cluster high availability backup and recoveryBecause the cluster environment needs multiple computers to work together, to achieve the ideal state, we must consider the new challenges facing the cluster environment.1. Concurrency controlIn a clustered environment, critical data is usually stored concurrently, such as on a shared disk. The identit
Tags: OData method store Management RAC data causes error sharing technologyReprint please specify the original address: http://www.cnblogs.com/litou/p/8028843.html Environment: Oracle 11g 11.2.0.1.0 (Dual-node RAC cluster), ArcGIS Desktop 10.1. Typically, you need to store ArcGIS spatial data in the case of an Oracle
Modify Oracle RAC Database Name
Briefly record some methods for modifying the name of Oracle RAC.
1. Close an instance
[Oracle @ rac11g2 ~] $ Sqlplus/as sysdba
SQL> shutdown immediate;
2. Back up the spfile File
SQL> create pfile = '/home/
Tags: style blog http io ar color OS using SPOracle RAC (12.1) installs virtual machines on Linux, step-by-step wizardtoday we will see how to installC version 1 RAC (real application cluster) database 2 Linux 64-bit virtual machineuse vmware or Oracle VirtualBox. Oracle's "C" C represents "Cloud"There are some important and interesting changes when installing a
4 scripts are required to perform RAC installation
1) $ORACLE _base/orainventory/orainstroot.sh (performed at end of Clusterware)
2) $CRS _home/root.sh (performed at end of Clusterware)
3) $CRS _home/bin/vipca.sh (the script is automatically invoked when the second node executes $crs_home/root.sh)
4) $ORACLE _home/root.sh (after installing the database to per
Oracle RAC also has ha (high availiablity) and lb (loadbalance). And its high availability is based on failover (failover). It means that the failure of any node in the cluster will not affect the user's use, the user connected to the failed node will be automatically transferred to the health node, from the user experience, is not feel this switch.
The Oracle 1
.......
If the table does not have a primary key or a unique key, a warning is generated, for example:22:53:11 warning OGG-00869 no unique key is defined for table udppackportset. All viable columns will be used to represent the key, but may not guarantee uniqueness. keycols may be used to define the key.
Ggsci (Rac1) 19> Add trandata dyulcentermanage .*......Ggsci (Rac1) 20> Add trandata dyacdb34 .*......Ggsci (Rac1) 21> Add trandata dyulcenterm_bak .*......
There is no primary key or unique ke
OCR is equivalent to the Windows registry. For Windows, all software information, users, configurations, and security are stored in the registry. In the same way, all cluster-related resources, configurations, nodes, and RAC databases are stored in this warehouse. If OCR is damaged, the cluster Service Startup exception occurs. You need to fix OCR. Therefore, OCR management and maintenance are very important for the entire cluster. This document descr
Oracle 11g RAC listener offline
After the Oracle 11g RAC listener has changed the network, the listener process offline appears, and the two nodes are switched frequently. Check the log/var/log/message to find frequent registration and revocation actions.
Listening log/u01/app/orac
Resolving Oracle clients can connect to 11g RAC VIP, but cannot connect scan IP issues
Some time ago configured a set of HP ux11.31 oracle11g R2 RAC, after the configuration is completed, the client can connect VIP and Scan IP connection database, remote clients can only connect VIP access to the database, through the scan IP access to the database can not connec
Oracle 10g rac ip/VIP address modification exampleI. Preparations 1. Database Information
Operating system version: OEL5.4 x64Database Version: Oracle 10.2.0.5 x64 RAC2. IP address information
Note: The server host name cannot be changed. If you want to change the name, you need to reinstall CRS to solve the problem. It is better to reinstall it.The environment i
[Oracle] Some Common commands in RAC (1)
Node layer:
Olsnodes
-N: displays the number of each node.
[Oracle @ rac1 ~] # Olsnodes-n
Rac1 1
Rac2 2 2
-P: displays the name of the network interface used by each node for private interconnect.
[Oracle @ rac1 ~] # Olsnodes-p
Rac1 rac1-priv
Rac2 rac2-priv
-I: displays the VIP
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.
Oracle
Oracle RAC provides two ways to achieve load balancing, the first is pure technology, that is, when users connect, depending on the current load of the system to decide which node to handle the user request; the second is business-oriented, and the application is cut into a lot of service, A connection request coming through a service is handled by a node. Here 's a concrete look at these two ways:
Pure te
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.