oracle rac troubleshooting

Oracle RAC migration OCR For how to add and delete Oracle rac ocr, see: Oracle RAC backup and recovery OCR reference: If you want to change an existing ocr location or a faulty ocr location, you can use the following procedure to

1. Install Oracle 10g RAC in the Oracle Linux environment on the vmvm This article references: Http://www.oracle.com/technology/global/cn/pub/articles/chan-ubl-vmware.html Http://www.oracle.com/technology/global/cn/pub/articles/smiley_rac10g_install.html Precautions for installing Linux: 1. When installing Linux, install all "development" and "Legacy development"

Install Goldengate On Oracle Rac 11.2.0.4, goldengate11.2.0.4 Installation environment: source:OS：redhat 6.3DB:11.2.0.4 racOGG:11.2.1.0.1target:OS:redhat 6.3DB:11.2.0.4OGG:11.2.1.0.1 A single data transfer configuration from rac to a single machine. The ogg test is not put into the shared storage. We recommend that you store ogg in the production environment for

Install Goldengate On Oracle Rac 11.2.0.4 Installation environment: source:OS：redhat 6.3DB:11.2.0.4 racOGG:11.2.1.0.1target:OS:redhat 6.3DB:11.2.0.4OGG:11.2.1.0.1 A single data transfer configuration from rac to a single machine. The ogg test is not put into the shared storage. We recommend that you store ogg in the production environment for shared storage to a

The obsolete maintenance command crs _ *, 12ccrs _ in Oracle 12c RAC _ Crs_stat is commonly used in Oracle 10g and 11g RAC to monitor the running status of RAC. However, the crs_stat display is incomplete, so we will perform a secondary encapsulation of crs_stat to make t

Look at me today this single node 12C RAC, suddenly feel that the disk group of OCR is called +dg_sys a little uncomfortable, want to change to +SYS_DG. The approach is to migrate the Ocr/votedisk/asm SPFile to an existing ASM, and then modify the disk group name and finally migrate to the new name Disk group (this process +DG_SYS-GT;+DATA-GT;+SYS_DG)Current operating conditions[Grid@xifenfei ~]$ crsctl status res-t------------------------------------

The result of the Oracle 11g RAC crs_stat command shows that the crs_stat command in Oracle 11g RAC has many new resource types compared with the previous version. By default, the use of crs_stat-t to view resources is a large piece of data that looks really laborious. The author Paul Elbow and Enkitec provided us with

The crs_stat command in Oracle 11g RAC has many new resource types compared with the previous version. By default, crs_stat-t is used to check that resources are a large piece of data, it looks really laborious. The author Paul Elbow and Enkitec provided us with a crsstat script to display all the resource types under Oracle 11g

Oracle Clusterware places the configuration information of the entire cluster on shared storage. The information includes the list of cluster nodes, the ing between cluster database instances and nodes, and the CRS Application resource information. That is, it is stored on the ocr disk (or ocfs file. Therefore, the importance of this configuration file is self-evident. We recommend that you back up ocr immediately between or after any operation that c

With Oracle's standby technology, a single-instance database can be upgraded to a RAC database. This approach can effectively reduce the downtime for single instance migration to the RAC environment. This article describes the establishment of the standby database. The last one completed most of the preparation of the work, the following open the database, but also to set the target database password file

Recently helped a customer recover 6 sets of Oracle RAC, both ASM and version 10.2.0.4. Stay up for several days, almost vomiting blood.Here is a brief description of the recovery of one of the libraries, to share with you.Several of these have basically encountered the following ORA-00600 error: Thu Dec 31 11:55:46 2015Success:diskgroup DG1 was mountedThu Dec 31 11:55:50 2015Errors in FILE/

OCR corresponds to the registry of Windows. For Windows, all software information, users, configuration, security, and so on are all in the registry. And the cluster, again, all cluster-related resources, configurations, nodes, and RAC databases are all in this warehouse. If OCR is corrupted, the Cluster service initiates an exception and needs to fix OCR. Therefore, the management and maintenance of OCR is very important for the whole cluster. This p

Starting to test Oracle 11g RAC, the current performance is limited, so a single node RAC is installed. The procedure is as follows: Nic binding Modify ifcfg-bond * ifcfg-eth * in/etc/modprobe. conf and/etc/sysconfig/network-scripts * I will not talk more here Configure xmanager connection VI/usr/share/TPD/defaults. conf Change enable = false under [XDMCP] t

Solution: Native: listNetInterfaces: [3] When Oracle 10201 RAC is rootI. Problem 10201 when RAC is installed on OEL5, the following error is reported for the root 2nd nodes:[Root @ o10n2 install] #/oracle/product/10.2.0/crs/root. shWARNING: directory '/oracle/product/10.2.0'

Oracle 11gR2 RAC 11.2.0.4 fully automated 11.2.0.4.20170418 psu steps, (The environment of patch p6880880_112000_Linux-x86-64.zip and p25476126_112040_Linux-x86-64.zip are put in/soft directory, Grid and oracle users have read and write permissions on the/soft directory, and only the root user can perform the whole process. Database Version 11.2.0.4

Tags: using IPCRM to clear the database HP UX memory utilization issuesTo account for the environment, is the real-time production database host network. HP-UX 11.31+oracle 10.2.0.4.0 RAC cluster.Two machines outdoor rac,essdb3 and ESSDB4 two machines.Physical memory 128g,sga allocated 64G,PGA 5G. Morning found ESSDB4 host glance run only 6G of free memory.Use th

Online Online RAC2 ORA.RAC2.VIP Application Online Online RAC2 Now the RAC State is all right and all services have been started. Here's how to modify the SID of 2 RAC Machines, respectively: Orcl3, Orcl4 1. Create Pfile, then ORCL1--->orcl3 orcl2--->orcl4, and transfer to another node, other parameters are not changed Sql> Conn/as SYSDBA Connected. sql> create pfile= '/tmp/pfile ' from SPFile; File

With Oracle's standby technology, a single-instance database can be upgraded to a RAC database. This approach can effectively reduce the downtime for single instance migration to the RAC environment. This article describes the switchover process of a single-instance environment and a RAC environment. The RAC Environm

In Oracle RAC, in addition to the TAF Method Based on the client, there is also the TAF Method Based on the server. You can regard the TAF method of the server as an upgraded version of the TAF method of the client. The TAF of the server must be configured on the server. This is done through the Service. This article describes how to configure the server-side TAF in Ora