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
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
Install Oracle 11g R2 + RAC + ASM in Oracle Linux 6.4
I. Version descriptionMany articles related to the Internet are found, but they are not very specific. Therefore, the detailed version is used to make the article more practical.This is the RAC environment of Oracle 11g R
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
the databaseConfigure dynamic service registration for non-default portsConfigure sqlnet. ora to restrict IP Access to OracleConfigure and manage Oracle listener logsSet the Oracle listener password (listener)Oracle RAC Listener ConfigurationNon-Default port listening configuration in
3.5. Install the ORACLE11GR2 database software with 3.5.1. Install Oracle 11GR2 DBLog on to node one with the Oracle user, switch to the Software installation directory, and perform the installation.
In Oracle user installation, first extract two Oracle installation files in one folder
[[emai
services.
6. More references:
For more information about the basics and concepts of Oracle network configuration, see:
Services in Oracle Database 10g
Configure the Oracle client to connect to the databaseConfigure dynamic service registration for non-default portsConfigure sqlnet. ora to restrict IP Access to OracleConfigure and manage
This article mainly introduces the installation of Oracle 11g RAC and the creation and migration of 10g databases in the 11g RAC environment, and how to upgrade the database to the 11g version. The architecture of the 11g RAC and some new features of the 11g
Friends who are interested in this course can add my QQ2059055336 and contact me.This course focuses on Oracle RAC architecture and how it works, understanding and mastering the relevant technologies under the RAC database, such as cache Fusion, Failover, load balance, FAN, OCR, and voting disk. Through the implementat
Tags: RAC stores dual live across data centersORACLE RAC was designed to be dual-live across data centers, designed to load balance and high availability for multiple hosts with shared storage in a data center. But since its architecture does have the potential to load balance and high availability across data centers, several storage vendors have expanded its us
For listeners that are not on the default port (1521), The pmon process does not register the service/instance to the listener, that is, dynamic registration is not implemented. Similar to a single instance, listeners with non-default RAC ports also set the local_listener parameter. In addition, you can remotely register an instance to achieve load balancing. This is achieved through the remote_listener parameter.
For more information about the basic
Oracle Study-Oracle RAC reconstruction Control File
System Environment:Operating System: AIX5.3
Cluster: Oracle 10gR2 CRSOracle: Oracle 10gR2
Rebuild the control file in the RAC environment is similar to that in a single instance,
Sid_list_listener_nodename entries so that the information obtained by LISTENER is dynamically registered, not static information that is read from the file. We want to delete: SID_LIST_LISTENER_RAC1 = (Sid_list = (Sid_desc = (Sid_name = Plsextproc) (Oracle_home =/u01/app/oracle/product/10.2.0/db_1) (program = Extproc) ) ) Keep only: LISTENER_RAC1 = (Description_list = (DESCRIPTION = (address = (PROTOCOL = TCP) (HOST = RAC1-VIP) (PORT = 1521) (IP =
Quickly deploy an Oracle RAC environment using an Oracle VM Template
Oracle VM templates are pre-packaged and pre-configured virtual machines. In the communication between enterprise-level customers, I often use "simple, fast, and error-free" to deploy applications using Oracle
different cluster products have their own characteristics, RAC features include the following points:• Dual-machine parallel. RAC is a parallel mode, not a traditional master and standby mode. That is, all members of the RAC cluster can receive client requests at the same time.• High availability. RAC is a high-availab
After installing grid infrastructure, RAC will focus on installing the Oracle software on the cluster. Grid infrasctructure provides a framework for running RAC, including cluster communication links, node separation, and node member relationships. ASM is the first choice for Oracle database storage.
Followed by the above article: http://ixdba.blog.51cto.com/2895551/880511
14. Install Oracle Clusterware
1) decompress the Software PackageAssume that all the database software is in the/rac directory. First, extract the two Oracle software packages as follows:[Root @ node-rac1 rac] # lsLinux_11gR1_database_1013.zip li
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
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.