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
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
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
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
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
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.
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
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
Server Load balancer distributes the load evenly to each node in the cluster to improve overall performance. Oracle RAC provides two methods to achieve load balancing. The following is a detailed introduction. For more information, see
Oracle RAC provides two methods to achieve load balancing. The first is pure technic
[Oracle] RAC-Server Load balancer distributes loads evenly to each node in the cluster to improve overall performance. Oracle RAC provides two methods to achieve load balancing. The first is pure technical means, that is, when a user connects, the node that determines based on the current load of the system to process
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
[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
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.