oracle rac troubleshooting

Tri Hua, Network name DbsnakeOracle ACE Director,acoug Core expert("Tri Hua article series" has been Tri Hua exclusive authorized in the cloud and the official account of the ink will be released, please continue to pay attention to)This article details the connection management in the Oracle RAC environment, and describes what the connect time load Balancing, Runtime Connection load Balancing, connect is 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

will be created in the local directory. BasData_rac1.gz-> logs, traces from Oracle base Collecting oracle base data /Bin/tar: Removing leading '/' from member names Root @ rac1/oracle/backup $ ll | grep tar -Rw-r -- 1 root 13233982 Feb 28 22: 37 basData_rac1.tar.gz -Rw-r -- 1 root 232 Feb 28 22: 36 coreData_rac1.tar.gz -Rw-r -- 1 root 40923089 Feb 28 22:

In the Oracle RAC environment under VMWare, multi-path images of OCR or votingdisk are not enough for shared storage or need to be added to a new shared disk, we can add shared storage through the command line under VMWare, and then append these new disks to the virtual machines one by one. The following is a detailed description. 1. Add a virtual disk # Here we will add two shared disks for the virtual ma

the Oracle RAC database environment has a lot in common with a single-instance database environment, as well as many heterosexual. The same is true for updates to database patches, which can be done through Opatch. However, patch updates for the RAC environment are updated in several different ways, and even rolling upgrades can be implemented for all nodes in th

Oracle study--oracle 11gR2 RAC CRS startup failureSystem environment:Operating system: RedHat EL5Cluster:oracle 11gR2 GridOracle:oracle 11gR2In a RAC environment, one of the nodes CRSD the process failed to start:[[email protected] ~]$ CRSCTL Check CRSCrs-4638:oracle High Av

Oracle study--oracle 11gR2 RAC CRS startup failure (CRS-4000)System environment:Operating system: RedHat EL5Cluster:oracle 11gR2 GridOracle:oracle 11gR2The following error occurred while initiating a node CRS:[[email protected] ~]# crsctl start CRS Failure at Scls_scr_getval with code 1 Internal Error information:category: -2 operation:opendir location:scrsearch1

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

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

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

Kernel parameters Net.ipv4.ipfrag_low/high_thresh, Net.ipv4.ipfrag_time GC Lost block problem Gns Optimizing the RAC database grd* RAC Wait Event * GC Current Block 2-way/3-way GC CR Block 2-way/3-way GC CR Grant 2-WAY/GC current Grant 2-way GC CR Block BUSY/GC current block Busy GC CR Block CONGESTED/GC current block c

Oracle 11g R2 RAC: Configure DNS resolution scan vip Oracle 11gR2Grid Infrastructure (CRS) introduces Single Client Access Name (SCAN) to simplify Client Access to database services. This article will introduce in detail how to configure DNS to resolve scan vip demonstration environment OracleEnterprise Linux 5.6 I. Install DNS Server Rpm-ivhbind-9.3.6-16.P1.el5.

Tags: oracle RAC [[EMAILNBSP;PROTECTED]NBSP;~]#NBSP;GROUPADDNBSP;-GNBSP;1300NBSP;DBA [[emailprotected]~]# groupadd-g1301oper [[emailprotected]~]#groupadd-g1000 oinstall [[emailprotected]~]#groupadd-g1200asmadmin [email protected]~]#groupadd-g1201asmdba [[emailprotected]~]# groupadd-g1202asmoper [[emailprotected]~]#useradd-u 1100-goinstall-gasmadmin,asmdba,asmoper,dbagrid [[emailprotected]~]# echogrid|passw

Kind Oracle 11GR2 RAC installation configuration-Prerequisite configuration phase Installing the Oracle 11GR2 11.2.0.4 RAC cluster based on Linux RedHat 6.4 in Vmwarevcenter server 1. Network Planning Where public and private are divided into different network segments. Guaranteed Safe Transmission [root@zracnode1~]#

/group_4.266.685491921 Name---------------------------+ Rac_disk/novadb/tempfile/temp.263.685491617 12 rows selected. SQL> All ASM disks belonging to the "rac_disk" disk group SQL> select path from V $ asm_disk where group_number in (select group_number from V $ asm_diskgroup where name = 'rac _ disk '); Path---------------------------/Dev/raw/raw3/Dev/raw/raw4Orcl: nova3 Start/stop a RAC cluster Make sure

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

Tag: DDR Oracle command file recommended key load ISP cannotFirst, the basic conceptORACLE11GR2 RAC began to introduce the scan concept, usually through a DNS server or GNS server to resolve the scan, you can also use the/etc/hosts file to parse scan, but Oracle is not recommended to do so, the hosts file can only parse a scan IP Another aspect the listener moves

Here, you will not use the installation media CD or DVD to install the Linux system from scratch, but use the VMLinux template provided by Oracle. The VMLinux template is a binary file, Here, you will not use the installation media CD or DVD to install the Linux system from scratch, but use the VM Linux template provided by Oracle. The VM Linux template is a binary file, How to Create a cost-effective

Oracle RAC Database 11.1.0.6 listening fault case After receiving a call, the customer's core Oracle RAC database cannot be connected, and no listening program is available at the time of connection. The customer's Oracle RAC vers