Test Purpose: Single Instance database conversion to RAC databaseTest environment: Oracle 11.2.0.4Test method: Manual Conversion.First, install a set of RAC environments and restore single-instance databases to this environment through Rman (typically, in production environments, we build ADG from RAC to single-instanc
machines to connect to each other, and SSH itself is required to connect, otherwise an error will be reported on the oracle cluster nodeTo create a raw device, you must modify the two configuration files on the node of the RAC machine.You also need to pay attention to the raw permission issues chmodchownNote: The raw device port numbers on both sides must be the same. Otherwise, an error will be reported,F
Tags: RAC stores dual live across data centersORACLE RAC was designed to be dual-live across data centers, designed to load balance and high availability for multiple hosts with shared storage in a data center. But since its architecture does have the potential to load balance and high availability across data centers, several storage vendors have expanded its use environment and presented solutions across
Summary of Oracle 11gR2 RAC cluster Service Startup and Shutdown
Introduction: the source of this article is that one of my students recently set up a RAC cluster in the company, but the sequence and principle of its startup and shutdown are not very clear, I also found that many students have little knowledge about RAC
Tags: ETL kettle jdbc Oracle RAC1 problem Phenomena:Previously done Kettle connect an Oracle database for table extractionThe table input information for the script is as follows:Error message in the table input report when executing (script uploaded to Linux machine with sh command) :But in the machine with the Sqlplus command login can be successful:2 resolution process:After the problem, the first contac
Tags: style blog using strong file dataOracle RAC 10.2 storage options on LinuxBlog Category:
Oracle
Oraclelinux Project Management configuration ManagementOracle clusters require storage of software and data
Project
Content
Minimum disk space
Clusterware Software
Cluster software
500M (does not change after installation is complete)
Oracle RAC clusterRAC, short for real application clusters, is a new technology used in the new version of Oracle Database,
It is a type of high availability and the core technology that Oracle databases support the grid computing environment.
An example of how to connect an application to
The most outstanding performance of Oracle RAC clusters is high availability, which mainly includes load balance and failover. These technologies enable single point of failure (spof) to prevent normal access to the database by client applications, and load balancing between nodes by creating a service. This article describes the Oracle failover test in the
The OCR and Voting Disk backups in Oracle RAC are described in my blog: common maintenance tools and commands of Oracle RAC. Now I will explain it separately, because OCR and Voting Disk are too important for the RAC system.Oracle RAC
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
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
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.