Home
Search results “Interconnect oracle rac”
What is Cluster Interconnect or Private Network in Oracle Grid Infrastructure - RAC  06
 
04:41
In this video you understand about the need for Cluster Interconnect / Private network in an Oracle Grid Infrastructure / RAC Database environment. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 4796 Ramkumar Swaminathan
Basic network details every RAC DBA should know | Public and private IP addresses
 
36:02
https://dbagenesis.com/p/oracle-11gr2-rac-for-beginners Oracle RAC technology is the advance level of database which is designed to provide high availability and scalability. Oracle RAC is installed on multiple servers and it forms the foundation for database cloud. Build a Strong Foundation in Oracle grid, Clusterware Installation with this Video Course for Beginners. Introduction to clusterware technology Oracle cluster node setup Oracle 11g grid software installation Setup two node RAC Create first Oracle RAC database Oracle RAC and ASM administration A strong RAC Beginners Course for IT Professionals World Wide! Oracle RAC allows multiple computers to run Oracle RDBMS software simultaneously while accessing a single database, thus providing clustering. The main aim of Oracle RAC online course is to implement a clustered database to provide performance, scalability and resilience. It’s a clustered version of Oracle Database based on a comprehensive high availability stack The Oracle 11gR2 Real Application Clusters Administration course describes the Oracle RAC architecture, hands on experience and Oracle Real Application Clusters multi node installations. This course is for people who have prior knowledge on Oracle database administration and covers knowledge on topics like Oracle RAC Cluster, Oracle AMS, Oracle RAC administration, Oracle RAC Installation, Oracle RAC on VirtualBox and many more.
Views: 23133 DBA Genesis
ORACLE RAC Networks CheckingPublic,Private,VIP,SCAN name for pre grid installaion
 
12:50
Before starting the Grid infrastructure installation, we should check the private, publi,VIP, SCAN name(and SCAN IPs) are correctly configured or not. this is the best test i ever seen.
Views: 2418 RAMESH NAIDU
Concept of VIP in Oracle RAC - SCAN part 1 - RAC 03
 
04:08
In this video you will understand about VIP/ VIPNAME which are used in Oracle RAC. This understanding is necessary to understand about SCAN in Oracle RAC/ GI. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 16357 Ramkumar Swaminathan
Oracle RAC IP Private IP Virtual IP Concepts
 
10:49
Oracle RAC IP Private IP Virtual IP Concepts
Views: 2319 He He
Need for Shared Storage in Oracle Cluster and RAC Databases - RAC 07
 
04:02
In this video you will be introduced to the concept of SHared Storage and why its required for Oracle Clusterware ( VOting Disks) and for an RAC Database Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 3313 Ramkumar Swaminathan
Oracle RAC 12C Installation -3- Network Setup.
 
10:14
This is third Video of RAC 12c Installation Tutorials, in this video I talk about: 1- RAC network Private Public theoretical. 2- VMware Create Adapters. 3- RAC networking Practical. 4- Configure the Oracle Linux Public and Private. 5- connect to Oracle linux using Putty (SSH) from outside the VMware. Please Subscribe like and share. Find us on facebook (https://www.facebook.com/IMK.DBA)
Views: 2403 ibrahim kmail
Single-Client Access Name In an Oracle RAC environment
 
02:44
Single Client Access Name (SCAN) is an Oracle Real Application Clusters (Oracle RAC) feature that provides a single name for clients to access Oracle Databases running in a cluster. For more information please visit https://www.koenig-solutions.com/oracle-database-12c-rac-administration-training.aspx
Views: 759 Koenig Solutions
GNS Explained - RAC 08
 
04:30
In this video you will understand what is GNS - Grid Naming Service in Oracle Grid Infrastructure Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 4085 Ramkumar Swaminathan
Understanding ODA Releases and their Size options - ODA 02
 
06:15
In this video you will understand about the release history of ODA X2 to X7 and the meaning of HA/Small / Medium / Large introduced from ODA X6 onwards. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 1179 Ramkumar Swaminathan
【VDEDU】AIX environment check before installation RAC
 
13:22
Before installing RAC on AIX, it is recommended to check the environment, such as network, space, SSH trust and so on. Oracle provides runcluvfy.sh script to perform this check.
Views: 264 崔旭
TAF Demonstration on Oracle RAC 11g
 
02:50
Demonstration of TAF (Transparent Application Failover)
Views: 316 Bruno
Pack Rows Tightly setting PCTFREE correctly - With Demo - DBPerf Video 14
 
04:36
In this video you will understanding about setting PCTFREE correctly and its impact in I/O and Memory / SGA utilization. At the end there is a demo to show you the same. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 1885 Ramkumar Swaminathan
Understanding Node Eviction - RAC 10
 
08:29
In this video you will understand what is Node Eviction and why it happens.. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 6623 Ramkumar Swaminathan
Oracle RAC - Networking : Public & Private (03)
 
09:13
Networking for Oracle Real Application Cluster. Private and Public networking segments are required for oracle database clustering. This video discussed both with practical examples.
Views: 22 G Tech
OCR and OLR - RAC 09
 
04:36
In this video you will learn what is OCR and OLR. These are files maintained by Oracle Clustereware to manage the resources that are to be made available in the cluster across the nodes. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 5868 Ramkumar Swaminathan
Cache Fusion Theory
 
51:15
By this video, you can have a clear understanding about Cache Fusion and its components.
Views: 1428 Anonymous far
What are Database Services - RAC 02
 
05:52
In this video you will understand the concept of Services in Oracle Database. This is the underlying framework with which High Availability and Failover is implemented in RAC. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 11134 Ramkumar Swaminathan
Oracle RAC Components | Basic cluster components
 
12:51
https://dbagenesis.com/p/oracle-11gr2-rac-for-beginners A computer cluster consists of a set of loosely or tightly connected computers that work together so that, in many respects, they can be viewed as a single system. Unlike grid computers, computer clusters have each node set to perform the same task, controlled and scheduled by software. The components of a cluster are usually connected to each other through fast local area networks, with each node (computer used as a server) running its own instance of an operating system. In most circumstances, all of the nodes use the same hardware and the same operating system, although in some setups (i.e. using Open Source Cluster Application Resources (OSCAR)), different operating systems can be used on each computer, and/or different hardware.
Views: 14448 DBA Genesis
퀘스트 스팟라이트(Spotlight on Oracle)로 오라클 RAC 모니터링 설정하기
 
04:32
오늘 영상은 Spotlight on Oracle RAC 에디션을 이용한 오라클 RAC 모니터링 설정에 관한 영상입니다. Spotlight on Oracle RAC 에디션은 일반 Spotlight on Oracle 에디션의 상위 에디션으로서 Toad for Oracle DBA – RAC 에디션에도 포함되어 있는 기능입니다. Spotlight RAC 에디션을 사용하면 각 인스턴스별 모니터링 정보 뿐만 아니라 Interconnect, Global Cache, 인스턴스별 Balance, IO 등 오라클 RAC를 모니터링에 필요한 주요 정보도 모니터링 할 수 있습니다. 보다 자세한 정보는 영상을 확인하시고, 토드 제품에 대한 더 많은 정보는 한국 사용자를 위한 커뮤니티 www.toad.co.kr를 방문하세요!
Cache Fusion Mechanism in Oracle RAC
 
41:27
Cache Fusion is simply fusing or adding of cache memory so that the availability of the data will be increased and time to fetch a particular block will be decreased because the cache is shared from one instance to the other.
Views: 2335 Anonymous far
How Oracle RAC Cache Fusion Works Part 1 of 6
 
06:02
Learn the mysteries of how Oracle RAC Cache Fusion works. In this lesson you will see the tutorial agenda plus a brief history of Oracle clustering (parallel server) and the problems associated with disk pinging. Cache Fusion is the secret to making Oracle Real Application Clusters (clustering) a scalable database platform. You will learn how cache fusion works, the differences between global cache current and consistent read transfers, the differences between two-way and three-way transfers and the associated wait events. Oracle Ace and author Brian Peasland provides a demonstration of global cache transfers in action by utilizing Oracle Trace. Prerequisites: Knowledge of Oracle Architecture including the concept of an Oracle instance, the buffer cache, how data is moved into the buffer cache and an understanding of wait events. Brian is a certified Oracle ACE who has been in the IT field for over 25 years and has worked as a computer operator, operations analyst, systems administrator, application developer and for more than half of his career as a database administrator. He holds a B.S. in Computer Science and a M.S. in Computer Science, specializing in database systems. Brian has been a member of SearchOracle.com’s Ask The Experts since 2001 and now contributes articles to the site. He regularly contributes to the My Oracle Support and Oracle Technet communities. He can be followed on Twitter on @BPeaslandDBA and maintains a blog at http://www.peasland.net. Brian is the author of “Oracle RAC Performance Tuning” on Rampant TechPress.
Views: 7369 SkillBuilders
OraRac11g Enable Jumbo Frames demo
 
03:16
In this video I am demonstrating on a virtual lab how to change the interconnect MTU from 1500 to 9000 without changing the current IP. In a real world scenario this should be done by the network administrator also in the switches used for the interconnect. I've said I was pinging with 8KB which is wrong, it is slightly over 8KB... my bad... sorry :) If you want to setup a demo RAC like this one, check out the link below, I strongly recommend the articles from Oracle Base: https://oracle-base.com/articles/11g/oracle-db-11gr2-rac-installation-on-oel5-using-virtualbox Thanks for letting me use the image in the video, Tim. =)
Views: 541 Bruno Carvalho
How Oracle RAC Cache Fusion Works Part 3 of 6
 
09:13
Learn How Oracle RAC Cache Fusion Works Really Works. Download Free Scripts at http://skillbuilders.com/How-Oracle-RAC-Cache-Fusion-Works. A continuation of the cache fusion demonstration, with a detailed look at session statistics and the raw trace file contents. You will learn about the "gc" wait events (Global Cache) including 'gc current block 2-way' and 'gc cr multi block request'.
Views: 3248 SkillBuilders
How to Check scan listener log
 
03:33
How to Check scan listener log
Views: 1801 Jamaal Khan
rac database ocr voting disk and olr
 
03:22
Check ocr ,olr and voting disk location Check ocr and olr backup
Views: 1110 Oracle database help
How To Install Grid In oracle 11g
 
05:01
Hi.. Guys In This Video We Learn How To Install Grid In Oracle 11g On Windows First - Make A Stamp Disk Partition In This Video Used 2 Disk Partitions But Using 1 Partition For ASM disk Groups Second - After Runs Grid Binary
Views: 33 PGT POINT
Part 1: Redhat linux Installation for RAC
 
09:59
Real Application Clusters Oracle Real Application Clusters (RAC) is a database clustering solution that allows more than one instance to mount and open an Oracle database. RAC can only be used on special clustered systems with shared disk storage and a private network interconnect. A normal Oracle installation consists of a single Oracle instance that accesses a database on the same computer system. In contrast, RAC allows multiple instances on different computer systems (nodes in a cluster) to access the same database files simultaneously. Communication between instances is managed by the Distributed Lock Manager (DLM). To address the possibility of two or more instances attempting to modify the same information simultaneously, Oracle uses up to ten additional background processes, named LCK0 through LCK9, to lock the resources in use by these instances. RAC is available with Oracle Enterprise Edition, and under certain conditions, with Standard Edition as well. These restrictions (for Standard Edition) include: • Must use Oracle Clusterware (no third-party clusterware allowed); • Must use ASM to store database files; and • Can only use a max of 4 CPU sockets in the cluster (either 2 nodes with 2 CPUs each, or 4 nodes with 1 CPU each). • RAC was previously called Oracle Parallel Server (OPS). Oracle re-branded OPS as RAC when they released Oracle 9i. Benefits Running Oracle in RAC mode can benefit you in the following ways: • High availability - If some nodes fail, the remainder of the nodes will still be available for processing requests. Failover support is available from Oracle 8 with Oracle's Transparent Application Failover (TAF) technology and from Oracle 10g, server side load balancing. • Speedup (increased transaction response time) - RAC normally adds some overhead. However, for some DSS applications one can achieve increased performance by running operations in parallel (mainly for DSS applications). • Scale-up (increased transaction volume) - RAC can be used to provide increased application scalability (mainly used for OLTP applications).
Views: 325 Md Arshad
Find out MASTER node in RAC database
 
02:49
Find out MASTER node in RAC database
1Z0-432 – Oracle Exam Real Application Clusters 12c Test Essentials Questions
 
00:58
For more information on Oracle 1Z0-432 Practice Test Questions Please Visit: https://www.Pass-Guaranteed.com/1Z0-432.htm What am I going to be tested for? Individuals that might be interested in taking the 1Z0-432 test should already know about describing an Oracle RAC environment and the components. The 1Z0-432 exam may also contain some test queries regarding installing Grid Infrastructure for a cluster and upgrading to Grid Infrastructure 12cR1. Some questions from the 1Z0-432 test can be about describing online storage reconfigurations and dynamic rebalancing in ASM. It can be helpful for the 1Z0-432 exam if the student can define how ACFS integrates with Oracle ASM. Which are some of the topics of the 1Z0-432 Essentials exam? Test Topic 1: Installing a RAC Environment Questions (Exam Coverage 31%) Test Topic 2: Automatic Storage Management Questions (Exam Coverage 20%) Test Topic 3: Cloud FS Questions (Exam Coverage 18%) Test Topic 4: Managing and Monitoring Oracle RAC Environments Questions (Exam Coverage 17%) Test Topic 5: Clusterware Overview Questions (Exam Coverage 14%) Who can attend to the Oracle Real Application Clusters 12c Essentials test? The 1Z0-432 test is designed for those who want to learn about implementing cluster interconnect best practices and describing services using server pools. The questions in 1Z0-432 exam have been selected using feedback from specialists in the field and put together by experts to create the 1Z0-432 exam Can you give me some in-depth information on the 1Z0-432 exam topics? • Describe WebCenter Portal Concepts • Differentiate Public Web Sites and Enterprise Portals • Describe the system architecture model, including a reference architecture • Explain options available for a highly available architecture • Describe Portal Builder, Resource Catalog and Catalog Filters • Create a Portal Template • Configure and Customize Document Library • Configure and use Content Presenter What’s the 1Z0-432 passing score and duration? The duration of this exam is 120 minutes (85 questions) and the minimum passing score is 74%.
Views: 49 James Beck
Deployment of a Highly Available Memcached Cluster on Oracle Cloud Infrastructure using Terraform
 
06:58
Memcached is a widely adopted in-memory cache that will allow you to get the most out of your website. This video demonstrates the different scenarios for deployment of Memcached Clusters on Oracle Cloud Infrastructure using Terraform. ================================= To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. For more information, see http://www.oracle.com/goto/oll and http://docs.oracle.com Copyright © 2018 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Oracle Database  - Listener Process - DBArch Video 6
 
07:33
You will learn about the Oracle Listener, The purpose of Listener and what is the impact if its down... Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 23462 Ramkumar Swaminathan
Introduction to AWR - DBPerf Video 16
 
05:27
In this video you will understand what are V$ views and whats in the AWR. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 4854 Ramkumar Swaminathan
Free webinar on Oracle RAC, An opportunity no potential Administrators will miss
 
01:09:05
The free webinar on Oracle RAC will precisely talk about Oracle® 11g R2 Oracle® Grid Infrastructure and Real Application Cluster (RAC) Concepts. The webinar will certainly take you through cluster processes, cluster networking as well as Oracle Cluster ware Services.
Part 2:  Network, user & group, etc host file configuration
 
12:39
Real Application Clusters Oracle Real Application Clusters (RAC) is a database clustering solution that allows more than one instance to mount and open an Oracle database. RAC can only be used on special clustered systems with shared disk storage and a private network interconnect. A normal Oracle installation consists of a single Oracle instance that accesses a database on the same computer system. In contrast, RAC allows multiple instances on different computer systems (nodes in a cluster) to access the same database files simultaneously. Communication between instances is managed by the Distributed Lock Manager (DLM). To address the possibility of two or more instances attempting to modify the same information simultaneously, Oracle uses up to ten additional background processes, named LCK0 through LCK9, to lock the resources in use by these instances. RAC is available with Oracle Enterprise Edition, and under certain conditions, with Standard Edition as well. These restrictions (for Standard Edition) include: • Must use Oracle Clusterware (no third-party clusterware allowed); • Must use ASM to store database files; and • Can only use a max of 4 CPU sockets in the cluster (either 2 nodes with 2 CPUs each, or 4 nodes with 1 CPU each). • RAC was previously called Oracle Parallel Server (OPS). Oracle re-branded OPS as RAC when they released Oracle 9i. Benefits Running Oracle in RAC mode can benefit you in the following ways: • High availability - If some nodes fail, the remainder of the nodes will still be available for processing requests. Failover support is available from Oracle 8 with Oracle's Transparent Application Failover (TAF) technology and from Oracle 10g, server side load balancing. • Speedup (increased transaction response time) - RAC normally adds some overhead. However, for some DSS applications one can achieve increased performance by running operations in parallel (mainly for DSS applications). • Scale-up (increased transaction volume) - RAC can be used to provide increased application scalability (mainly used for OLTP applications).
Views: 235 Md Arshad
rac 06
 
00:31
croft at night
Views: 170 mitevo7
Part 5: Partition creation, ASM RPM installation & ASM DISK creation & grid software Installation
 
22:03
Real Application Clusters Oracle Real Application Clusters (RAC) is a database clustering solution that allows more than one instance to mount and open an Oracle database. RAC can only be used on special clustered systems with shared disk storage and a private network interconnect. A normal Oracle installation consists of a single Oracle instance that accesses a database on the same computer system. In contrast, RAC allows multiple instances on different computer systems (nodes in a cluster) to access the same database files simultaneously. Communication between instances is managed by the Distributed Lock Manager (DLM). To address the possibility of two or more instances attempting to modify the same information simultaneously, Oracle uses up to ten additional background processes, named LCK0 through LCK9, to lock the resources in use by these instances. RAC is available with Oracle Enterprise Edition, and under certain conditions, with Standard Edition as well. These restrictions (for Standard Edition) include: • Must use Oracle Clusterware (no third-party clusterware allowed); • Must use ASM to store database files; and • Can only use a max of 4 CPU sockets in the cluster (either 2 nodes with 2 CPUs each, or 4 nodes with 1 CPU each). • RAC was previously called Oracle Parallel Server (OPS). Oracle re-branded OPS as RAC when they released Oracle 9i. Benefits Running Oracle in RAC mode can benefit you in the following ways: • High availability - If some nodes fail, the remainder of the nodes will still be available for processing requests. Failover support is available from Oracle 8 with Oracle's Transparent Application Failover (TAF) technology and from Oracle 10g, server side load balancing. • Speedup (increased transaction response time) - RAC normally adds some overhead. However, for some DSS applications one can achieve increased performance by running operations in parallel (mainly for DSS applications). • Scale-up (increased transaction volume) - RAC can be used to provide increased application scalability (mainly used for OLTP applications).
Views: 790 Md Arshad
installation of oracle grid infrastructure 11gr2
 
04:31
installation of oracle grid infrastructure 11gr2
Views: 547 Jamaal Khan
Part 3: Making clone of RAC1 node for preparing RAC2 node & create share drive
 
03:33
Real Application Clusters Oracle Real Application Clusters (RAC) is a database clustering solution that allows more than one instance to mount and open an Oracle database. RAC can only be used on special clustered systems with shared disk storage and a private network interconnect. A normal Oracle installation consists of a single Oracle instance that accesses a database on the same computer system. In contrast, RAC allows multiple instances on different computer systems (nodes in a cluster) to access the same database files simultaneously. Communication between instances is managed by the Distributed Lock Manager (DLM). To address the possibility of two or more instances attempting to modify the same information simultaneously, Oracle uses up to ten additional background processes, named LCK0 through LCK9, to lock the resources in use by these instances. RAC is available with Oracle Enterprise Edition, and under certain conditions, with Standard Edition as well. These restrictions (for Standard Edition) include: • Must use Oracle Clusterware (no third-party clusterware allowed); • Must use ASM to store database files; and • Can only use a max of 4 CPU sockets in the cluster (either 2 nodes with 2 CPUs each, or 4 nodes with 1 CPU each). • RAC was previously called Oracle Parallel Server (OPS). Oracle re-branded OPS as RAC when they released Oracle 9i. Benefits Running Oracle in RAC mode can benefit you in the following ways: • High availability - If some nodes fail, the remainder of the nodes will still be available for processing requests. Failover support is available from Oracle 8 with Oracle's Transparent Application Failover (TAF) technology and from Oracle 10g, server side load balancing. • Speedup (increased transaction response time) - RAC normally adds some overhead. However, for some DSS applications one can achieve increased performance by running operations in parallel (mainly for DSS applications). • Scale-up (increased transaction volume) - RAC can be used to provide increased application scalability (mainly used for OLTP applications).
Views: 189 Md Arshad
CSS Voting Disk
 
03:28
CSS voting disk records node membership information in Oracle clusterware. For more information on this course, please visit https://www.koenig-solutions.com/oracle-training-certification-courses.aspx
Views: 854 Koenig Solutions
Oracle Real Application Clusters on Cisco Unified Computing Systems
 
03:21
Cisco Doug Beasley, Consulting Engineer talks about 3 demos created for Oracle Open World 2010 in collaboration with Oracle on Cisco UCS :1/N=1 failure scenario- 2/capacity on demand 3/ Node upgrade
Views: 1078 CiscoDataCenter2009
Part 4: Prepare RAC2 node, oracle grid & database Software transfer & Unzip
 
13:15
Real Application Clusters Oracle Real Application Clusters (RAC) is a database clustering solution that allows more than one instance to mount and open an Oracle database. RAC can only be used on special clustered systems with shared disk storage and a private network interconnect. A normal Oracle installation consists of a single Oracle instance that accesses a database on the same computer system. In contrast, RAC allows multiple instances on different computer systems (nodes in a cluster) to access the same database files simultaneously. Communication between instances is managed by the Distributed Lock Manager (DLM). To address the possibility of two or more instances attempting to modify the same information simultaneously, Oracle uses up to ten additional background processes, named LCK0 through LCK9, to lock the resources in use by these instances. RAC is available with Oracle Enterprise Edition, and under certain conditions, with Standard Edition as well. These restrictions (for Standard Edition) include: • Must use Oracle Clusterware (no third-party clusterware allowed); • Must use ASM to store database files; and • Can only use a max of 4 CPU sockets in the cluster (either 2 nodes with 2 CPUs each, or 4 nodes with 1 CPU each). • RAC was previously called Oracle Parallel Server (OPS). Oracle re-branded OPS as RAC when they released Oracle 9i. Benefits Running Oracle in RAC mode can benefit you in the following ways: • High availability - If some nodes fail, the remainder of the nodes will still be available for processing requests. Failover support is available from Oracle 8 with Oracle's Transparent Application Failover (TAF) technology and from Oracle 10g, server side load balancing. • Speedup (increased transaction response time) - RAC normally adds some overhead. However, for some DSS applications one can achieve increased performance by running operations in parallel (mainly for DSS applications). • Scale-up (increased transaction volume) - RAC can be used to provide increased application scalability (mainly used for OLTP applications).
Views: 179 Md Arshad
What are failure groups in Oracle ASM - ASM Video 09
 
06:37
In this video you will learn about Failure Groups in ASM disk groups . Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 4713 Ramkumar Swaminathan
Creating a Physical Standby database using RMAN - DG Video 4
 
08:10
In this video you will learn about creating a Physical Standby Database using RMAN in an Oracle Data Guard environment. This video explains about the pre-requisites that are to be done before you run the RMAN command to create a standby database. . Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 10910 Ramkumar Swaminathan
Lock Waits
 
10:41
Row Lock Holder and Waiter
Views: 112 Hemant K Chitale