Solutions to OUI-25031 during Oracle 10g RAC setup
The OS version is Enterprise Linux Server release 5.4.DB version: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64biWhen you install the clusterware component during RAC configuration, the following script execution prompt appears:
If the preceding error oc
Here a simple note, the National Day overtime recovery of a customer's 2 sets of Oracle RAC database, the entire recovery process, 2 sets of RAC similar, so here is a set of database recovery process as an example of simple analysis. Because the database is not archived, the system will not open properly due to power off and reboot.
In the normal open process, t
Tuning system time is not a trivial thing for a RAC environment, and Oracle is likely to reboot one of the nodes to ensure consistency between nodes.
The test found that if the system time is adjusted forward, no matter how long the adjustment will not cause the system to restart. However, if the system time is adjusted backwards, it will cause the whole node to reboot.
Even if you close the database, the
In 11.2, the CRSD process is no longer one of the most critical processes in RAC.
If you are familiar with 10g RAC, you should be aware of the importance of the CRSD process, and Oracle starts the process and then launches the entire cluster and database after the operating system starts.
In the 11.2 RAC,
) (HOST = RAC1-VIP) (PORT = 1521))(ADDRESS = (PROTOCOL = TCP) (HOST = RAC2-VIP) (PORT = 1521)))ALTER SYSTEM SET remote_listener = Listeners_rac;Sometimes the reporting load process delay leads to the balance effect is not obvious, when joined Prefer_least_loaded_node=off, the server will be allocated according to the number of connections.Starting with Oracle 10.2, Oracle introduced the load Balance Advisor
How to download the Grid method (Oracle RAC) on the OTN website, otngrid
How to download grid software required by RAC
Register an account and log on to the OTN website.
Go to the download options and find the "server and storage system" item.
Find Grid Infrastructure from the drop-down menu.
After entering, remember to click "accept license" to download the
Notes for installing Oracle 11g RAC
This article is only used to record some issues that occur during the installation of Oracle RAC at ordinary times. If you encounter minor issues, we will also add them.1. HAIP hosts file dual-inline Nic configuration example:
# Vi/etc/hosts127.0.0.1 localhost. localdomain localhost1
Install Oracle 10g + RAC in RedHat 5.5
The cost is relatively low, the technology is mature, and the function is powerful. This solution will become more and more favored by small and medium-sized enterprises.
I. Preparations before the experiment
Virtual Machine version: VMware server1.0.6
Linux version: RedHat 5.5 Enterprise Server version
Oracle 10g 10.2.1
1. Status of all instances and services
$ srvctl Status database-d ORCL
Instance ORCL1 is running on node linux1
Instance Orcl2 is running on node linux2
2, the status of a single instance
$ srvctl Status instance-d orcl-i Orcl2
Instance Orcl2 is running on node linux2
3, the state of the database global naming Service
$ srvctl Status service-d orcl-s orcltest
Service Orcltest is running on instance (s) Orcl2, ORCL1
4, the State of the node application on a specific node
$ srvctl Stat
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"
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------------------------------------
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 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
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.