oracle rac training

Label:Said too classic, dare not translate, directly on the original. From: Network protocols and Real application Clusters (document ID 278132.1) PURPOSE------- Purpose of this document are to give DBAs and Systems Administrators interestedIn Real application Clusters an overview and a comparison of network protocolsAvailable. SCOPE Application------------------- DBAs and IT professionals may use this note for their physical cluster layoutAnd the options they has available on their platform.

Solution Process 1) understand the basic information The previous night, around, shut down RAC, restarted the minicomputer, restarted RAC, and found that four instances in two RAC groups started normally, and the other RAC instances failed to start normally. 2) the minicomputer engineer can diagnose the datavg and arch

are changed, and the fault occurs. Therefore, everyone in the operation of the time do not blindly to do not grasp the matter, master each operation behind the principle and its consequences, so that the full preparation of the fallback method.There was a time when the-R changed the entire directory permission, resulting in an unrecognized ASM disk group.Changing the directory permissions according to the normal RAC is still not recognized, the main

Recently, many employees who have installed Oracle 10g RAC on the RHEL 5.X platform do not have much difficulty, but repetitive manual work is still relatively high. Therefore, a semi-automatic installation script is compiled by the way. Install operating system patches, create database users, and modify user configuration files. Issues to be resolved:1. The host name is automatically configured, which requ

Now there is this environment: A web Server, a pure Java app program The database is made up of two forms of RAC. Web server and app programs are connected through OCI (RAC) Database. Out of such a strange problem, webserver update or an illustration into a data, followed by the app in the query can not be, until the use of tools to query there is no problem. Initial suspicion 1.

The character set is accidentally not changed when the database is installed today (oracle10.2.0.4), leading to garbled interface because the rac environment is not the same as that of a single instance.Http://blog.csdn.net/rulev5/article/details/7020134 1. query the Current Character SetSQL> select userenv ('language') from dual; USERENV ('language ') -------------------------------------------------------------------------------- AMERICAN_AMERICA.W

Tags: Oracle 10g RAC Rebuilding CRS1.crs file is corrupt, remove CRS informationRAC10G1 node:[Email protected] install]# ./rootdelete.shShutting down Oracle Cluster ready Services (CRS):Stopping resources.Error while stopping resources. Possible CAUSE:CRSD is down.Stopping CSSD.Shutting down CSS daemon.Shutdown request successfully issued.Shutdown has begun. The

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 shared storage device is also required. At the same time, two types of software are required: Cluster software and RAC components in the Oracle database. At the same time, the operating systems on all servers should be the same type of OS. Accor

install the required software packages, such as libaio, unixODBC, and sysstat. 2. Set User Groups on nodes 1 and 2: oinstall, dba, role, asmadmin, asmdba, and asmoper. 3. Create the software installation directory/opt/oracle,/opt/grid (custom), and set the directory permissions. 4. Set User Environment Variables ~ /. Bash_profle 5. Install the rlwrap and readline toolkit ~ /. Bashrc. 6. Set the memory and virtual memory of the virtual platform RHEL5.

There are a lot of friends who are confused about the 4 IPs when configuring Oracle 11GR2 RAC, this article explains here.Open a/etc/hosts file for a RAC nodeCat/etc/hosts# public IP192.168.1.138rac1.localdomain Rac1192.168.1.139rac2.localdomain RAC2#Private IP172.16.10.138rac1-priv.localdomain Rac1-priv172.16.10.139rac2-priv.localdomain Rac2-priv#Virtual IP192.1

Tags: Name service access RAC Cluster DBA span color Ted ResourceScan conceptLet's start with what is called Scan,scan (single client Access name), which was launched by Oracle from 11g R2, and the client can load-balance connections to the RAC database via the SCAN feature. Scan provides a domain name to access the RAC