oracle rac concepts

Tags: OracleOracle Study-aix6.1 Building Oracle 10GR2 RAC (1)Environment:Operating System: AIX 6100-09 (SP3)Cluster Software: CRS 10.2.0.1Database: Oracle 10.2.0.1There are two ways in which RAC can be used to build an AIX platform based on shared storage:1. Establish shared storage based on concurrent volume group (VG

same time period. When an instance fails, other instances will automatically serve, to ensure the safe operation of the database ). An instance is a group of operating system processes (or multi-threaded processes) and some memory. These processes can operate databases; the database is just a collection of files (including data files, temporary files, redo log files, and control files ). At any time, an instance can only have a group of related files (associated with a database ). In most cases

Oracle 11g R2 RAC: Configure DNS resolution scan vip Oracle 11gR2Grid Infrastructure (CRS) introduces Single Client Access Name (SCAN) to simplify Client Access to database services. This article will introduce in detail how to configure DNS to resolve scan vip demonstration environment OracleEnterprise Linux 5.6 I. Install DNS Server Rpm-ivhbind-9.3.6-16.P1.el5.

Tags: oracle RAC [[EMAILNBSP;PROTECTED]NBSP;~]#NBSP;GROUPADDNBSP;-GNBSP;1300NBSP;DBA [[emailprotected]~]# groupadd-g1301oper [[emailprotected]~]#groupadd-g1000 oinstall [[emailprotected]~]#groupadd-g1200asmadmin [email protected]~]#groupadd-g1201asmdba [[emailprotected]~]# groupadd-g1202asmoper [[emailprotected]~]#useradd-u 1100-goinstall-gasmadmin,asmdba,asmoper,dbagrid [[emailprotected]~]# echogrid|passw

Kind Oracle 11GR2 RAC installation configuration-Prerequisite configuration phase Installing the Oracle 11GR2 11.2.0.4 RAC cluster based on Linux RedHat 6.4 in Vmwarevcenter server 1. Network Planning Where public and private are divided into different network segments. Guaranteed Safe Transmission [root@zracnode1~]#

/group_4.266.685491921 Name---------------------------+ Rac_disk/novadb/tempfile/temp.263.685491617 12 rows selected. SQL> All ASM disks belonging to the "rac_disk" disk group SQL> select path from V $ asm_disk where group_number in (select group_number from V $ asm_diskgroup where name = 'rac _ disk '); Path---------------------------/Dev/raw/raw3/Dev/raw/raw4Orcl: nova3 Start/stop a RAC cluster Make sure

Previously, Oracle's Real Application Cluster (RAC) has always been promoted. We recommend that you use RAC for large database applications, because RAC also addresses the performance expansion and high reliability requirements of these customers. The other two competitors of Oracle, IBMDB2 and Microsoft SQL Server, on

Tag: DDR Oracle command file recommended key load ISP cannotFirst, the basic conceptORACLE11GR2 RAC began to introduce the scan concept, usually through a DNS server or GNS server to resolve the scan, you can also use the/etc/hosts file to parse scan, but Oracle is not recommended to do so, the hosts file can only parse a scan IP Another aspect the listener moves

Here, you will not use the installation media CD or DVD to install the Linux system from scratch, but use the VMLinux template provided by Oracle. The VMLinux template is a binary file, Here, you will not use the installation media CD or DVD to install the Linux system from scratch, but use the VM Linux template provided by Oracle. The VM Linux template is a binary file, How to Create a cost-effective

Oracle RAC Database 11.1.0.6 listening fault case After receiving a call, the customer's core Oracle RAC database cannot be connected, and no listening program is available at the time of connection. The customer's Oracle RAC vers

This article mainly introduces the installation of Oracle 11g RAC and the creation and migration of 10g databases in the 11g RAC environment, and how to upgrade the database to the 11g version. The architecture of the 11g RAC and some new features of the 11g RAC are also ana

1. Check the database status. The status is normal. [Oracle @ racdb01 RAC] $ crs_stat-TName type target State host------------------------------------------------------------Ora. RAC. DB application online racdb01Ora... s1.inst application online racdb01Ora... s2.inst application online racdb02Ora... esdb. CS application online racdb01Ora... es1.srv application o

Tags: des os io ar for art CTI Log SPThis article provides the basic DNS configuration steps necessary for use of the single Client Access Name (SCAN) introduced I n Oracle 11g Release 2 RAC. Consider the following caveats before following the instructions here:I ' m not a network guy and don ' t claim to know much about DNS.The article only discusses the use of BIND as the DNS server on

Dave, resulting in no startup. Of course, after manual modification, the sqlplus instance can be started normally, but the srvctl instance is used to check whether the instance status is not started. This is also why srvctl is recommended in the RAC environment to start and close the database, rather than using sqlplus directly. [Oracle @ rac2 DBS] $ cat initdave2.ora Spfile = '+ Data/Dave/spfiledave. or

Tags: command execution wget Restart Speed Hyper Fusion is open OGGOracle 12c was released for a long time, although several sets of single-instance Oracle 12c have been deployed in the near future, there has been no opportunity to implement 12c RAC in the production environment, of course, can not eliminate the existing 11g RAC, replaced by 12c

Oracle Study-aix6.1 Building Oracle 10GR2 RAC (2)First, view system I/O (asynchronous I/O is enabled for Oracle database)For AIX6.1, the default asynchronous I/O is automatically activated when there is a requirement, and no configuration is required.[[email protected]/] #ioo-a |grep AIO aio_active=0 aio_maxreqs=65536

I see a lot of questions on shared file systems the can used when people move from single instance to Oracle RAC Datab ASE and Grid Infrastructure. The most common question are the following: "should I place archive logs in OCFS2 or ASM or ACFS of 11g?" I ' ll try to clarify this topic below.First we need to understand a separation between Oracle database files a

Oracle 11g two nodes RAC build a single instance DG Process Problems and Solutions I used to build a single-instance database of DG, and it was quite simple. Later I came to the company's first project to build a DG for RAC. I was confident that I was so confident that I had to go through all kinds of questions, baidu finally completed the task with great difficu

Oracle 12CR2 version has been released for some time, and has been trying to test the installation of RAC, from last weekend to today for two weekends and today's time to finally put the RAC installed successfully. This records the configuration of the operating system during installation and some of the pits encountered during installation. 1, the fir

' node2 ' succeeded crs-2672: attemptingtostart ' ORA.CTSSD ' on ' Node2 'Failure with signal 2 from command:/u01/11.2.0/grid/bin/crsctl start resource ora.ctssd-init-env Usr_ora_env=ctss_reboo T=trueStart of resource "Ora.ctssd-init-env Usr_ora_env=ctss_reboot=true" failedFailed to start CTSSFailed to start Oracle clusterware stackOracle Root Script Execution aborted!-----Failed to start the CTSSD process!The check found that the following error occ