oracle rac troubleshooting

as the logical volume manager of the cluster, you can easily monitor a single-instance Oracle database without interruption. When a node fails, the database is automatically migrated to the slave node. Based on the size of the initialization parameters fast_start_mttr_target and recovery set, this failover may be very fast. However, as part of the Failover process, the user's database connection will be disconnected. Active/passive mode can be enable

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 RAC are also ana

Oracle RAC Load Balancing allows connections initiated from clients to be effectively allocated to instances with low listener load. There are two methods to achieve load balancing on the client. One is to configure the load_balance of the client, and the other is to configure the remote_listener parameter on the server. The two methods have their own advantages and disadvantages, and they are not mutually

CRS-0184/PRCR-1070 when Oracle 11g RAC executes root. sh Oracle 11g RAC installation, the first node to execute root. sh encountered a CRS-0184/PRCR-1070, Google a lot of posts have not found a solution. Hey, let's calm down and look at the log !! The conclusion is a casual problem, as described below. 1. Fault # Insta

1. Check the database status. The status is normal. [Oracle @ racdb01 RAC] $ crs_stat-TName type target State host------------------------------------------------------------Ora. RAC. DB application online racdb01Ora... s1.inst application online racdb01Ora... s2.inst application online racdb02Ora... esdb. CS application online racdb01Ora... es1.srv application o

Tags: des os io ar for art CTI Log SPThis article provides the basic DNS configuration steps necessary for use of the single Client Access Name (SCAN) introduced I n Oracle 11g Release 2 RAC. Consider the following caveats before following the instructions here:I ' m not a network guy and don ' t claim to know much about DNS.The article only discusses the use of BIND as the DNS server on

Oracle 11g RAC executes root. sh encountered CRS-0184/PRCR-1070 problems Oracle 11g RAC installation, at the first node execute root. sh encountered a CRS-0184/PRCR-1070, Google a lot of posts have not found a solution. Hey, let's calm down and look at the log !! The conclusion is a casual problem, as described below.

Dave, resulting in no startup. Of course, after manual modification, the sqlplus instance can be started normally, but the srvctl instance is used to check whether the instance status is not started. This is also why srvctl is recommended in the RAC environment to start and close the database, rather than using sqlplus directly. [Oracle @ rac2 DBS] $ cat initdave2.ora Spfile = '+ Data/Dave/spfiledave. or

Tags: command execution wget Restart Speed Hyper Fusion is open OGGOracle 12c was released for a long time, although several sets of single-instance Oracle 12c have been deployed in the near future, there has been no opportunity to implement 12c RAC in the production environment, of course, can not eliminate the existing 11g RAC, replaced by 12c

Oracle Study-aix6.1 Building Oracle 10GR2 RAC (2)First, view system I/O (asynchronous I/O is enabled for Oracle database)For AIX6.1, the default asynchronous I/O is automatically activated when there is a requirement, and no configuration is required.[[email protected]/] #ioo-a |grep AIO aio_active=0 aio_maxreqs=65536

For RAC, the most important thing is to understand the internal principles and architecture. Installation is not very difficult. Both troubleshooting and maintenance are inseparable from the architecture and Internal principles. Cluster category 1. High-performance computing Computing tasks are assigned to different computer nodes to improve the overall computing capability. They are mainly used in the fiel

I see a lot of questions on shared file systems the can used when people move from single instance to Oracle RAC Datab ASE and Grid Infrastructure. The most common question are the following: "should I place archive logs in OCFS2 or ASM or ACFS of 11g?" I ' ll try to clarify this topic below.First we need to understand a separation between Oracle database files a

Oracle 11g two nodes RAC build a single instance DG Process Problems and Solutions I used to build a single-instance database of DG, and it was quite simple. Later I came to the company's first project to build a DG for RAC. I was confident that I was so confident that I had to go through all kinds of questions, baidu finally completed the task with great difficu

Oracle 12CR2 version has been released for some time, and has been trying to test the installation of RAC, from last weekend to today for two weekends and today's time to finally put the RAC installed successfully. This records the configuration of the operating system during installation and some of the pits encountered during installation. 1, the fir

' node2 ' succeeded crs-2672: attemptingtostart ' ORA.CTSSD ' on ' Node2 'Failure with signal 2 from command:/u01/11.2.0/grid/bin/crsctl start resource ora.ctssd-init-env Usr_ora_env=ctss_reboo T=trueStart of resource "Ora.ctssd-init-env Usr_ora_env=ctss_reboot=true" failedFailed to start CTSSFailed to start Oracle clusterware stackOracle Root Script Execution aborted!-----Failed to start the CTSSD process!The check found that the following error occ

The application workload can be defined as services in Oracle 10 Gb, also known as services. It can be used in a single instance or separately used and managed in RAC. Therefore, the entire database load can be divided into multiple different services. The management service can simplify the management of users or sessions. Second, the importance of services is reflected in

Label:To the new company, the company is using RAC, I am more familiar with MySQL third-party cluster scheme Galera cluster This kind of multi-master cluster, The following is a comparison of the assumptions that I made about the RAC, and then the guesswork level that I did with the MySQL scenario. The comparison of RAC and MySQL Galera Cluster (MGC), 1, implemen

Introduction to Oracle RAC clusters, processes, and logs In a single-host environment, Oracle runs on the OS Kernel. OS Kernel manages hardware devices and provides hardware access interfaces. Oracle does not directly operate the hardware, but has an OS Kernel instead to complete the hardware call request. In a cluster

Failed to upgrade Oracle Cluster Registry configuration, raccluster during 10g rac Installation Failed to upgrade Oracle Cluster Registry configuration was encountered during 10g rac installation, because the BUG was triggered by using the DMM multi-path software device-mapper-multipath. For more information about inst

Label: The loadbalance is to distribute the load evenly to each node in the cluster, thus improving the overall throughput capacity. The Oracle 10g RAC provides two different ways to spread the load: 1. By connection balancing, the user is assigned to a different node according to an algorithm. It can also be considered as a decentralized load of pure technology. 2. Through the service, dispersed on the app