rac graphics

This test copies the dual-node RAC deployed on ASM to the ASM of a single instance. This test is also based on the needs of a project. The drill operations on the virtual machine are hereby recorded. Previously This test copies the dual-node RAC deployed on ASM to the ASM of a single instance. This test is also based on the needs of a project. The drill operations on the virtual machine are hereby recorded.

RAC exceptions caused by storage link problems. The RAC exception caused by storage link problems was added to me yesterday, saying that the RAC problem was encountered. The environment is oracle11.0.2.4 and 2 nodes. As shown in the following figure, the cluster will not automatically switch when the CRSD is down. RAC

Oracle 10g 10.2.0.1 RAC ORA-12520This error is very common. I have encountered it once on a single machine. The solution is to set local_listener. This time, I will try to see how it works.[Oracle @ R1 ~] $ Sqlplus system/test @ RACSQL * Plus: Release 10.2.0.1.0-Production on Fri Feb 3 11:24:31 2012Copyright (c) 1982,200 5, Oracle. All rights reserved.ERROR:ORA-12520: TNS: listener cocould not find available handler for requested typeServerEnter user-

RAC Environment: RAC version similarities and differences: [10R2,11R1 (and 10 similar)],11R2,12C: Directory: ASM 10.2 requires a separate directory (Oracle home): RDBMS Home,asm home, CRS Home 11.2:rdbms,grid (CRS+ASM) Ip: 10.2 has a private IP (public IP) and a virtual IP (VIP); Private IP is used to make an internal connection, and the c

I. Introduction One of the most effective ways to familiarize yourself with Oracle's true application cluster (RAC) 10g technology is to access an actual Oracle RAC 10g cluster. There is no way to better understand their benefits than simply experiencing them-including fault tolerance, security, load balancing, and scalability. The core of Oracle RAC is the share

Oracle Cluster (RAC) startup and shutdown The following points need to be noted when Oracle RAC starts and shuts down: First, check the shared device Second, automatically start RAC and check related processes Third, manually start RAC In the start-up process, it is best to detect CRS, ASM, and database logs. First, c

Tags: RAC oracle Oracle 11g LinuxLinux under oracle11g RAC Construction (i) Document description Author Blue Project Visualbox Analog RAC Build (Dual node) (redhat5+oracle11g) Environment RedHat Enterprise5.5, Oracle 11g 11.2.0 Date April 12, 2014 Version

In many cases, we need to use alter system kill session to terminate a session in the database and release the resources occupied by the session to solve the problem. For example, daniel's environment often uses the following statement to kill sessions in the database in batches. Select 'alter system kill session ''' | B. sid | ',' | B. serial # | '''; 'from gv $ access a, gv $ session bwhere. SID = B. SIDand B. program like 'dis % 'group by B. sid, B. serial #; this script is very effective in

RAC exceptions due to storage link problems Yesterday, someone added me, said to have met the RAC problem. The environment is an Oracle 11.0.2.4,2 node. as follows, the CRSD is down and the cluster does not automatically switch. And there were several times. I gave the guy a log. Through the log, you can see 1, 2 nodes CRSD service reboot only 1 seconds, voting FILE/DEV/RAW/RAW1 can not provide serv

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

List all configured Databases [Root @ node1 ~] # Srvctl config DatabaseNovadb Status of all instances and services [Root @ node1 ~] # Srvctl status database-D novadbInstance novadb1 is running on node node1Instance novadb2 is running on node node2 Status of a single instance [Root @ node1 ~] # Srvctl status instance-D novadb-I novadb1Instance novadb1 is running on node node1 The status of the global Naming Service in the database $ Srvctl Status Service-D orcl-s orcltestService orcltest is runni

Business segmentation of RAC Architecture As we have discussed earlier, RAC is actually an instance-level redundant architecture. Applications can connect to an instance randomly or randomly as needed for business operations. As far as I know, most RAC architectures are designed in this way. The advantage of doing so is to achieve instance redundancy, even if an

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 linux_x86_11gR1_clusterware.zip[Root @ node-rac1 rac