oracle rac troubleshooting

: modifythe/etc/sysctl.conf. #Usage: Logonasthesuperuser (' root '), andthenexecutethecommand:#. /6presysctl.sh #Author: Asherhuang echo "nowmodifythe/etc/sysctl.conf,but withabackupnamed/etc/sysctl.bak "cp/etc/sysctl.conf/etc/ Sysctl.conf.bak echo "fs.aio-max-nr=1048576" >>/etc/sysctl.conf Echo "fs.file-max=6815744" >>/etc/sysctl.conf echo "kernel.shmall= 2097152 ">>/etc/sysctl.conf echo" kernel.shmmax=1054472192 "> >/etc/sysctl.conf echo "kernel.shmmni=4096" >>/etc/sysctl.conf Echo "kernel

Tags: installer CLI read PPS DBCA process. sh/tmp Pop Environment: os:oel5.6 rac:10.2.0.1.0 There are rac1 at the moment. Rac2. RAC3 three nodes, the following is the process of deleting the RAC3 node 1. Delete The DB instance on the RAC3 node [Email protected] ~]$ dbca-silent-deleteinstance-gdbname racdb-instancename racdb3-sysdbausername sys-sysdbapasswor D Oracle Deleting instance 20% Complete 21% Compl

I have prepared several documents about Oracle patch installation, as follows: Introduction to Oracle patch system and opatch tools Http://blog.csdn.net/tianlesoftware/article/details/5809526 New Features of Oracle 11g -- online patching (hot Patching) Description Http://blog.csdn.net/tianlesoftware/article/details/8214412 How to update the opatch tool version

My RAC Virtual Machine reported that diskgroup space was insufficient during Backup yesterday, so I added asmdisk to my schedule. When installing RAC, I had 2 ASM diskgroups + DG, respectively, + recoverydest: Now + recoverydest has insufficient space, and no redundant asmdisk is created during installation. Only now can the remaining space be recovered. At the same time, two nodes can create asmdisk with v

Oracle RAC 10.2.0.5 Install For redhat 5.8 (use raw device) Because the customer's database needs to be patched, similar test environments are installed. You must first install Oracle RAC 10.2.0.1 and then upgrade it to 10.2.0.5. Because I have many articles about installation, this article only describes the key steps

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 based on Oracle 10g

Oracle RAC normal restart sequence:Oracle 10g rac:Generally, the 10g RAC (ASM) Switch sequence is as follows:1) Stop Oracle RAC 10g environmentStop the Oracle instance first. When this instance (and related services) is closed, th

Someone asked me how to differentiate whether RAC is Admin or Policy managed after it is created.First, we should look at the definition:Administrator-managed: Database administrators define the servers on which databases resource run, and place resources manually as needed. This is the management strategy used in previous releases. Policy managed: Database administrators specify in which server pool (excluding generic or free) the database resource w

Oracle Rac 11.2.0.3 migrate OCR and VOTEDISK, 11.2.0.3votediskEnvironment: AIX7.1 + Oracle Rac 11.2.0.3Migration Description: When Oracle Rac is installed today, the GB Data disk is incorrectly used as OCRDG. Therefore, it will be

Oracle 11gR2 RAC database cannot be connected (Ora-12537:tns:connection closed) Resolution[Email protected] ~]$ Sqlplus/nologSql*plus:release 11.2.0.1.0 Production on Wed 29 21:06:10 2012Copyright (c) 1982, Oracle. All rights reserved.Sql> Connect system/*** @asttERROR:Ora-12537:tns:connection closed[Email protected] app]# ls-ltrDrwxr-xr-x 3 root oinstall 409608-

RAC is a cluster of Oracle companies, and there are many articles on the web that introduce the RAC configuration. But holding these wonderful documents doesn't necessarily make the RAC configuration successful. Because RAC is a very complex software, most of these documents

RAC is a cluster of Oracle companies, and there are many articles on the web that introduce the RAC configuration. But holding these wonderful documents doesn't necessarily make the RAC configuration successful. Because RAC is a very complex software, most of these documents

Install Oracle 10g RAC on VMware Server 2.0.2, no error is reported at all for www.2cto.com IP planning 192.168.8.241194258.242192.168.8.248192.168.8.249 rac1-> export LANG = en_US.UTF-8 vi/etc/sysconfig/network-scripts/ifcfg-eth0vi [root @ rac2 ~] # More/etc/sysconfig/network-scripts/ifcfg-eth0 # Advanced Micro Devices [AMD] 79c970 [PCnet32 LANCE] DEVICE = eth0BOOTPROTO = noneIPADDR = 192.168.8.242ONBOOT =

[Translated from mos] What is split-brain in Oracle Clusterware and RAC? mosclusterware What is split-brain in Oracle Clusterware and RAC? Source:What is Split Brain in Oracle Clusterware and Real Application Cluster (Document ID 1425586.1) Applicable:Oracle Database-Enterpr

Rac1 is not running on node Rac1Instance Rac2 is not running on node race2. Stop have (high availability Services), must be operated as root user[Email protected] oracle]# Cd/u01/grid/11.2.0/grid/bin[Email protected] bin]#./crsctl Stop Has-f[Email protected] bin]#./crsctl Stop Crs-fThis command only shuts down the CRS service for the current node, so it needs to be executed on all nodes of the RAC, as well

Label:What are the brain fissures in Oracle Clusterware and RAC From:What's Split Brain in Oracle clusterware and Real application Cluster (document ID 1425586.1) Suitable for:Oracle database-enterprise edition-version 10.1.0.2 and laterInformation in this document applies to any platform. Objective:This article explains the brain fissures in

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

Os:redhat as 4 Oracle:oracle10gr2 The customer presents a request to demonstrate the recovery of RAC DB to single-instance, and their purpose is to verify the backup effectiveness of the production environment Here are the ideas and the main steps: 1. First generate an init parameter file under RAC DB 2, modify parameters, Cluster_database to false and shielding Local_listener and other parameters rela