Explain the environment: operating system: AIX 7.1Oracle version: Oracle RAC 11.2.0.3 before the 11.2.0.3.9 patch set, the RAC is not formally used, so you can simply hit the latest 11.2.0.3.11 patch set.The two sets of RAC that were newly installed today in the new PSU, also use Opatch Auto to hit the PSU, but one set
The crsctl, ocrcheck, ocrdump, and ocrconfig commands on the RAC cluster layer are detailed. The cluster layer is a core cluster composed of Clusterware, which maintains the shared devices in the cluster, and provides a complete cluster
. Add Authenticated Users
This is the user and password used by the client to connect to the shared storage. Remember, the password I set here is oracle999.
9. configure global Parameters
10. Add target
Note the content in the red box:
11. associated targets
In this way, the configuration of the ISCSI shared storage server is complete,
Next article: Oracle10.2.0.4-RAC two-node cluster environment
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 t
An article written in the previous troubleshooting section was accidentally found in the analysis of node cascade restart failures of rac clusters, which was recorded for future search. Www.2cto.com rac cluster node cascade restart Fault Analysis Environment: OS: linuxdb: rac10g + ocfs2 rac database environment actuall
ORA.SCAN1.VIP NB Sp 1 online online RHEL1 NBS P ORA.SCAN2.VIP NB Sp 1 online online RHEL2 NBS P ORA.SCAN3.VIP NB Sp 1 online online RHEL2 As can be seen from the above state, both the target and the value of the Ractest1 and Ractest2 two instances of the Ractest database are offline. Try to change this state by doing the following:[Oracle@rhel1 ~]$ Srvctl
Installing Oracle RAC on the AIX platform is a pitfall. I verified this again today because there are too many bugs! Record the problem because there are too many bugs! We strongly recommend and look forward to the development of Oracle RAC on the Linux platform. The following is a record of the problem:
> Server: IBM
network administration ):
Install the operating system and upgrade it to a version that meets the Oracle installation requirements.
Create the group, user, and software home directory required for installation.
Set GNS domain name if you plan to deploy GNS and configure the network address on the DNS and server.
Set the required storage.
Copy all the installation files to one node.
2. Install the infrastructure of the
Author: skateTime: 2012/07/16
I accidentally found an article written for troubleshooting and recorded it for search.
Fault Analysis on Cascade restart of RAC cluster nodes
Environment:OS: LinuxDB: rac10g + ocfs2
The RAC database environment actually contains two clusters: clusterware cluster and instance
reproduced from: Http://www.cnblogs.com/baiboy/p/orc2.html#_label1
three highly available cluster scenarios for Oracle
1 RAC (real application clusters)
Multiple Oracle servers form a shared cache, and these Oracle servers share a network-based storage. This system can to
On the AIX platform, Oracle software that is tar from the RAC environment is directly extracted to the new machine and the target environment is stand-alone, and the RAC option needs to be turned off.
RAC off
1. Login as the Oracle software owner and shutdown all database
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 orcltestServi
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 nod
Recently, the Oracle 10g RAC migration under the virtual machine, after the migration is completed, the Oracle cluster resource VIP cannot start normally, received the CRS-0233: resource or relatives are currently involved with another operation error prompt. Why? It turns out that the migrated address has changed. You
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
The newly installed rac,rdbms11.2.0.4 two-node. After restarting the server, it is discovered that the database on Node 1 can start with the system (cluster).
The database on Node 2 cannot be started with the system (cluster) booting.
Solution Ideas
1 let the database start as the system starts, using the following command.
Usage:srvctl Enable database-d
After
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
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
Tags: des c tar ext color http1. Build Oracle RAC 11g cluster on Oracle Enterprise Linux and ISCSI2. All shared disk storage for Oracle RAC will be based on ISCSI,ISCSI using Openfiler version 2.3, which runs on the third node, wh
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.