Environment:
Two HP ML570 Linux AS4.5 Oracle 10g
The two servers perform Oracle RAC and connect to HP MSA1000 through SAN Switch
Fault symptom:
Because the cabinet where one Oracle rac node is located is out of power, two rac
After upgrading the database cluster to 10.2.0.5, the dual-node server continuously restarts and queries the oracle oprocd process logs. The information is as follows:
Jul 03 08:16:34.702 | INF | monitoring started with timeout(1000), margin(500), skewTimeout(125)Jul 03 08:16:34.704 | INF | fatal mode startup, setting process to fatal mode
You can see that the oprocd process interval is set
timeout(1000), margin(500), skewTimeout(125)
No obvious er
How RAC Works and related components (iii)
Overview: write down the original intent and motivation of this document, derived from the Oracle Basic operating Manual of the previous article. The Oracle Basic Operations Manual is a summary of the author's vacation on Oracle's foundational knowledge learning. Then form a summary of the system, a review revie
Label:RAC pre-Installation for NFS on Linux (vi)
Overview: write down the original intent and motivation of this document, derived from the Oracle Basic operating Manual of the previous article. The Oracle Basic Operations Manual is a summary of the author's vacation on Oracle's foundational knowledge learning. Then form a summary of the system, a review review, the other is easy to use. This docum
Oracle Cluster Concepts and principles (ii)
Overview: write down the original intent and motivation of this document, derived from the Oracle Basic operating Manual of the previous article. The Oracle Basic Operations Manual is a summary of the author's vacation on Oracle's foundational knowledge learning. Then form a summary of the system, a review rev
Why didn't Oracle RAC Opatch go to Rac database home during auto?
First explain the environment:Operating System: AIX 7.1Oracle version: Oracle Rac 11.2.0.3I used the 11.2.0.3.9 patch set before and it was not officially used for Rac
Explain the environment: operating system: AIX 7.1Oracle version: Oracle RAC 11.2.0.3 before the 11.2.0.3.9 patch set, the RAC is not formally used, so you can simply hit the latest 11.2.0.3.11 patch set.The two sets of RAC that were newly installed today in the new PSU, also use Opatch Auto to hit the PSU, but one set
RAC special problems and combat experience (V)
Overview: write down the original intent and motivation of this document, derived from the Oracle Basic operating Manual of the previous article. The Oracle Basic Operations Manual is a summary of the author's vacation on Oracle's foundational knowledge learning. Then form a summary of the system, a review r
Installing Oracle RAC on the AIX platform is a pitfall. I verified this again today because there are too many bugs! Record the problem because there are too many bugs! We strongly recommend and look forward to the development of Oracle RAC on the Linux platform. The following is a record of the problem:
> Server: IBM
if the related files are not deleted in the second part.
4. Delete the/etc/oracle/scls_scr/rac1/oracle/cssfatal files on each machine
If you do not delete this file, you will get an error when running the root.sh script.
Reference:
RAC root.sh Oracle CRS solution already configured and'll be running under init (1M)
Ht
Tags: NFS Install listen recommended move configuration between trading Geo Mic
Directory
Cache Fusion principle
What is Cache Fusion?
What is high availability
The difference between FAILSAFE and RAC
RAC and OPS differences
Differences between hot standby, RAC, and Data guard for dual machines
Communication between nodes (int
Cache fusion Technology and main background process (iv)
Overview: write down the original intent and motivation of this document, derived from the Oracle Basic operating Manual of the previous article. The Oracle Basic Operations Manual is a summary of the author's vacation on Oracle's foundational knowledge learning. Then form a summary of the system, a review review, the other is easy to use. Th
Sync Service (Cluster Synchronization Service)managing membership of a cluster node controls which node is the member of the cluster, the node notifies the cluster member when joining or leaving the cluster to control the cluster configuration information, which causes the cluster to restart, provides a heartbeat mechanism to monitor the cluster status (DISK HEARTBEAT and NETWORK Hearbeat), the process is run by Oracle User management EVMD Incident M
3.6. Cluster Management Command 3.6.1. Startup and shutdown of RAC
Oracle RAC is powered on by default and can be used with the following commands if maintenance is required:
Shut down:crsctl Stop cluster Stopping this node Cluster servicecrsctl Stop Cluster–all all node servicesOpen:crsctl start cluster turn on this node Cluster servi
message will be prompted.
[Grid @ rac-one install] $./rootcrs. plYou must be logged in as root to run this script.Log in as root and rerun this script.2014-04-01 17: 08: 12: Not running as authorized userInsufficient privileges to execute this script.Root or administrative privileges needed to run the script.
For more information about the script function, see-help. Such as upgrade, rollback, and reconfiguration wait
[Root @
Label:Data Guard is a remote replication technology for Oracle, it has physical and logical points, but in general, it needs a separate system in a remote location, two sets of hardware configurations can be different systems, but the software structure of the two systems are consistent, including the software version, directory storage structure, and data synchronization (in fact, is not real-time synchronization), the two sets of systems as long as
Label:Oracle 11G RAC Database installation (eight)
Overview: write down the original intent and motivation of this document, derived from the Oracle Basic operating Manual of the previous article. The Oracle Basic Operations Manual is a summary of the author's vacation on Oracle's foundational knowledge learning. Then form a summary of the system, a revi
On the AIX platform, Oracle software that is tar from the RAC environment is directly extracted to the new machine and the target environment is stand-alone, and the RAC option needs to be turned off.
RAC off
1. Login as the Oracle software owner and shutdown all database
Oracle lock table troubleshooting example: Oracle lock table troubleshooting
One time a developer directly runs the delete table operating system on the database server during peak hours, resulting in no response for a long period of execution. Then, the SQLPLUS client is closed and the delete statement is run again, t
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.