请加入QQ群参加Oracle 10g/11g RAC DataGuard, Goldengate交流和免费提供99%正确率
的Oracle RAC, DataGuard, Goldengate, Streams部分实战文档和实战视频。
Oracle RAC, DataGuard, GoldenGate, Streams
Hands-on Practice QQ Groups:
212975915 / 212976048 / 213082853
Backup and Recovery, Performance Tuning are coming soon.....
Oracle Database 10gR2 High Availability with RAC on Linux
------Installation, Administration, and Performance Tuning
1. Building an Oracle RAC 10g R2 (10.2.0.1) on Linux
1.1 Install Linux OS(CentOS 5.3) - ()
1.2 Install Required Linux Packages for Oracle RAC - (Video)
1.3 Network Configuration - (Video)
1.4 Create "oracle" User and Directories - (Video)
1.5 Configure the Linux Servers for Oracle - (Video)
1.6 Configure the "hangcheck-timer" Kernel Module - (Video)
1.7 Configure RAC Nodes for Remote Access using SSH - (Video)
1.8 IP SAN Configuration - Openfiler - ()
1.9 Install Openfiler - ()
1.10 Configure iSCSI Volumes using openfiler - (Video)
1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video)
1.12 Install and configure Oracle Cluster File System(OCFS2) - (Video)
1.13 Install and Configure ASM (ASMLib2.0) - (Video)
1.14 Download Oracle RAC 10g Software - (Video)
1.15 Pre-Installation Tasks for Oracle10g Release 2 - (Video)
1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video)
1.17 Install and configure Automatic Storage Management (ASM) - (Video)
1.18 Install Oracle Database 10gR2 Software - (Video)
1.19 Install Oracle Database 10g Companion CD Software - (Video)
1.20 Create TNS Listener Process - (Video)
1.21 Create ASM Instance - (Video)
1.22 Create a Cluster Database - (Video)
1.23 Post-Installation Tasks - (Optional) - (Video)
1.23.1 Re-compile Invalid Objects - (Video)
1.23.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video)
1.23.3 Create Shared Oracle Password Files - (Video)
1.24 Verify TNS Networking Files - (Video)
1.25 Create / Alter Tablespaces - ()
1.26 Verify the RAC Cluster & Database Configuration - (Video)
1.27 Verify Cluster Network Configuration - (Video)
2. RAC Database Administration and Workload Management
2.1 Starting / Stopping the Cluster - (Video)
2.2 Transparent Application Failover - (TAF) - ()
2.3 Configuring the Server Parameter File(SPFILE) in RAC - (Video)
3. Upgrading Oracle CRS, ASM, RDBMS and Database 10.2.0.3
3.1 Download and Extract the Installation Software - (Video)
3.2 Pre-installation Tasks for Patch set and Release Upgrades - (Video)
3.3 Oracle Clusterware Rolling Upgrade - (Video)
3.4 Apply the patch 10.2.0.3.0 to the ASM Home - (Video)
3.5 Applying Patch set to Oracle RAC - (Video)
3.6 Upgrading Oracle Database 10.2.0.x to 10.2.0.3.0 Using DBUA - (Video)
4. Building an Oracle RAC 10gR2 (10.2.0.3) on Linux
4.1 Install Linux OS(CentOS 5.3) - ()
4.2 Install Required Linux Packages for Oracle RAC - (Video)
4.3 Network Configuration - (Video)
4.4 Create "oracle" User and Directories - (Video)
4.5 Configure the Linux Servers for Oracle - (Video)
4.6 Configure the "hangcheck-timer" Kernel Module - (Video)
4.7 Configure RAC Nodes for Remote Access using SSH - (Video)
4.8 IP SAN Configuration - Openfiler - ()
4.9 Install Openfiler - SAN - ()
4.10 Configure iSCSI Volumes using openfiler - (Video)
4.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video)
4.12 Install and configure Oracle Cluster File System(OCFS2) - (Video)
4.13 Install and Configure ASM (ASMLib2.0) - (Video)
4.14 Download Oracle RAC 10g Software - (Video)
4.15 Pre-Installation Tasks for Oracle 10g Release 2 - (Video)
4.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video)
4.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video)
4.18 Install and configure Automatic Storage Management (ASM) - (Video)
4.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video)
4.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video)
4.21 Install Oracle Database 10g Companion CD Software - (Video)
4.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video)
4.23 Create TNS Listener Process - (Video)
4.24 Create ASM Instance - (Video)
4.25 Create a Cluster Database - (Video)
4.26 Post-Installation Tasks - (Optional) - (Video)
4.26.1 Re-compile Invalid Objects - (Video)
4.26.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video)
4.26.3 Create Shared Oracle Password Files - (Video)
4.27 Verify TNS Networking Files - (Video)
4.28 Create / Alter Tablespaces - ()
4.29 Verify the RAC Cluster & Database Configuration - (Video)
4.30 Configuring the Initialization Parameters - (Video)
4.31 Startup / Shutdown the Oracle RAC 10gR2 - ()
5. Create Oracle RAC 10gR2 (10.2.0.3) Database Using Scripts
5.1 Install Linux OS(CentOS 5.3) - ()
5.2 Install Required Linux Packages for Oracle RAC - (Video)
5.3 Network Configuration - (Video)
5.4 Create "oracle" User and Directories - (Video)
5.5 Configure the Linux Servers for Oracle - (Video)
5.6 Configure the "hangcheck-timer" Kernel Module - (Video)
5.7 Configure RAC Nodes for Remote Access using SSH - (Video)
5.8 IP SAN Configuration - Openfiler - ()
5.9 Install Openfiler - SAN - ()
5.10 Configure iSCSI Volumes using openfiler - (Video)
5.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video)
5.12 Install and configure Oracle Cluster File System(OCFS2) - (Video)
5.13 Install and Configure ASM (ASMLib2.0) - (Video)
5.14 Download Oracle RAC 10g Software - (Video)
5.15 Pre-Installation Tasks for Oracle 10g Release 2 - (Video)
5.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - ()
5.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video)
5.18 Install and configure Automatic Storage Management (ASM) - (Video)
5.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video)
5.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video)
5.21 Install Oracle Database 10g Companion CD Software - (Video)
5.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video)
5.23 Create TNS Listener Process - (Video)
5.24 Create ASM Instance - (Video)
5.25 Create a Cluster Database Using Scripts - (Video)
5.25.1 Overview - ()
5.25.2 Verifying Terminal Shell Environment - ()
5.25.3 Run the Oracle Cluster Verification Utility - (Video)
5.25.4 Create the Cluster Database Using Scripts - (Video)
5.25.5 Oracle RAC Database Creation Scripts - ()
5.25.6 Primary node - (Video)
5.25.7 Secondary Nodes - (Video)
5.25.8 Creating an Oracle RAC Database by running the Scripts - (Video)
5.25.9 Creating an Oracle RAC Database Manually - ()
5.25.10 Verify Oracle Cluster Database - ()
5.25.11 Verify the racdb_srvc Service - ()
5.25.12 Deleting an Oracle RAC Database with DBCA - ()
5.26 Post-Installation Tasks - (Optional) - (Video)
5.26.1 Re-compile Invalid Objects - (Video)
5.26.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video)
5.26.3 Create Shared Oracle Password Files - (Video)
5.27 Verify TNS Networking Files - (Video)
5.28 Create / Alter Tablespaces - ()
5.29 Verify the RAC Cluster & Database Configuration - (Video)
5.30 Configuring the Initialization Parameters - ()
5.31 Startup / Shutdown the Oracle RAC 10gR2 - ()
6. Administering Voting Disk and OCR File
6.1 Overview - ()
6.2 Example Configuration - (Video)
6.3 Create RAW devices on all nodes - (Video)
6.3.1 Stop the RAC cluster and CRS - (Video)
6.3.2 Create logical (iSCSI) volumes - (Video)
6.3.3 Create iSCSI Targets - (Video)
6.3.4 Discover all available targets - (Video)
6.3.5 Manually Log In to iSCSI Targets - (Video)
6.3.6 Configure Automatic Log in - (Video)
6.3.7 Verify Persistent Local SCSI Device Names - (Video)
6.3.8 Create Partitions on iSCSI Volumes - (Video)
6.3.9 Re-scan the SCSI bus - (Video)
6.3.10 Bind the Clusterware component devices to RAW devices - (Video)
6.3.11 Check the RAW devices - (Video)
6.3.12 Zero out the RAW devices - (Video)
6.3.13 Restart the RAC cluster and CRS - (Video)
6.4 Administering the OCR File - (Video)
6.4.1 View OCR Configuration Information - (Video)
6.4.2 Usage of ocrconfig command - ()
6.4.3 Remove an OCR File - (Video)
6.4.4 Add an OCR File - (Video)
6.4.5 Relocate an OCR File - (Video)
6.4.6 Repair an OCR File on a Local Node - (Video)
6.4.7 Relocate OCR Files to Original - (Video)
6.5 Backup the OCR File - (Video)
6.6 Recover the OCR File - (Video)
6.6.1 Recover OCR from Valid OCR Mirror - ()
6.6.2 Recover OCR from Automatically Generated Physical Backup - (Video)
6.6.3 Recover OCR from an OCR Export File - (Video)
6.7 Administering the Voting Disk - (Video)
6.7.1 View Voting Disk Configuration Information - ()
6.7.2 Usage of crsctl command - ()
6.7.3 Overview of Adding or Remvoing a voting disk - ()
6.7.4 Remove a Voting Disk - (Video)
6.7.5 Add a Voting Disk - (Video)
6.7.6 Relocate a Voting Disk - (Video)
6.7.7 Get Voting Disk to Original - (Video)
6.8 Backup the Voting Disk - (Video)
6.9 Recover the Voting Disk - (Video)
6.10 Remove RAW devices on all nodes - (Video)
6.11 Recover Corrupt/Missing OCR with No Backup - (Video)
Step 1: Simulate Corrupt/Missing OCR - (Video)
Step 2: Shutdown Oracle Clusterware on All Nodes - (Video)
Step 3: Execute rootdelete.sh from All Nodes - (Video)
Step 4: Run rootdeinstall.sh from the Primary Node - (Video)
Step 5: Run root.sh from the Primary Node. (same node as above) - (Video)
Step 6: Run root.sh from All Remaining Nodes - (Video)
Step 7: Configure Server-Side ONS using racgons - (Video)
Step 8: Configure Network Interfaces for Clusterware - (Video)
Step 9: Add TNS Listener using NETCA - (Video)
Step 10: Add all Resources Back to OCR using srvctl - (Video)
Step 11: Verify the New OCR/Voting Disk - (Video)
6.12 Recover Corrupt/Missing OCR and Voting Disk with No Backup - (Video)
Step 1: Simulate Corrupt/Missing OCR and Voting Disk - (Video)
Step 2: Shutdown Oracle Clusterware on All Nodes - (Video)
Step 3: Execute rootdelete.sh from All Nodes - (Video)
Step 4: Run rootdeinstall.sh from the Primary Node - (Video)
Step 5: Run root.sh from the Primary Node. (same node as above) - (Video)
Step 6: Run root.sh from All Remaining Nodes - (Video)
Step 7: Configure Server-Side ONS using racgons - (Video)
Step 8: Configure Network Interfaces for Clusterware - (Video)
Step 9: Add TNS Listener using NETCA - (Video)
Step 10: Add all Resources Back to OCR using srvctl - (Video)
Step 11: Verify the New OCR/Voting Disk - (Video)
7. Add a Node to an Oracle RAC Cluster
7.1 Install the Linux OS (CentOS 5.3) - ()
7.2 Install Required Linux Packages for Oracle RAC - (Video)
7.3 Network Configuration - (Video)
7.4 Configure Network Security on the Openfiler Storage Server - (Video)
7.5 Configure the iSCSI Initiator - (Video)
7.6 Create "oracle" User and Directories - (Video)
7.7 Configure the Linux Servers for Oracle - (Video)
7.8 Configure the "hangcheck-timer" Kernel Module - (Video)
7.9 Configure RAC Nodes for Remote Access using SSH - (Video)
7.10 Install and Configure Oracle Cluster File System (OCFS2) - (Video)
7.11 Install and Configure ASM(ASMLib 2.0) - (Video)
7.12 Pre-Installation Tasks for Oracle 10gR2 - (Video)
7.13 Extend Oracle Clusterware Software to the New Node - (Video)
7.14 Extand Oracle ASM Home to the New Node - (Video)
7.15 Extend Oracle Database Software to the New Node - (Video)
7.16 Add Listener to New Node - (Video)
7.17 Adding a new ASM instance to the New Node - (Video)
7.18 Add Database Instance to the New Node - (Video)
7.19 Verify the 3 nodes RAC Cluster & Database Configuration - (Video)
7.20 Starting / Stopping the Cluster - ()
7.21 Configuring the Initialization Parameter Files in RAC - ()
8. Remove a Node from an Oracle RAC Cluster
8.1 Remove the Oracle Instance on the Node to be Deleted - (Video)
8.2 ASM Instance Clean-Up Procedures - (Video)
8.3 Remove the Listener From the Node to be Deleted - (Video)
8.4 Remove the Oracle Database Software From the Node to be Deleted - (Video)
8.5 Remove the ASM Software From the Node to be Deleted - (Video)
8.6 Remove the Node to be Deleted from Oracle Clusterware - (Video)
8.7 OCFS2 Clean-Up Procedures - (Video)
8.8 Remove Access Permissions on Openfiler for the Node to be Deleted - (Video)
8.9 Verify the 2 nodes RAC Cluster & Database Configuration - (Video)
8.10 Configuring the Initialization Parameter Files in RAC - ()
9. Upgrading Oracle CRS, ASM, RDBMS and Database 10.2.0.4
9.1 Download and Extract the Installation Software
9.2 Pre-installation Tasks for Patch set and Release Upgrades
9.3 Rolling Upgrading Oracle Clusterware
Step 1: Shutdown Database Control on the node 1 - racnode1
Step 2: Shut down all Oracle RAC instances on the node 1 - racnode1
Step 3: Shutdown the ASM instance on the node 1 - racnode1
Step 4: Stop all node application on the node 1 - racnode1
Step 5: Shutdown the Oracle Clusterware
Step 6: As root, run the preupdate.sh script
Step 7: Upgrade Oracle Clusterware from 10.2.0.3 to 10.2.0.4
Step 8: Verify Oracle Clusterware
Step 9: Rolling Upgrading on Next Node - racnode2
Step 10: Verify the New Oracle Clusterware 10.2.0.4.0
9.4 Apply the patch 10.2.0.4 to the ASM Home
Step 1: Verify the Oracle Clusterware Version and ASM Version
Step 2: Stopping All Process for an ASM Home
Step 3: Installing the 10.2.0.4 patch
Step 4: Verify the ASM 10.2.0.3.0
9.5 Applying Patch set to Oracle RAC Home
Step 1: Create a backup of the Oracle Inventory, home and Database
Step 2: Stopping All Process for an Oracle RAC Installation
Step 3: Installing the Oracle Database 10g Patch Set Interactively
9.6 Upgrading Oracle Database Using DBUA
Step 1: Restart the Database with the UPGRADE option
Step 2: Run the Pre-Upgrade Information Tool
Step 3: Back up the Database
Step 4: Set the values for the environment variables
Step 5: Start ASM Instances if necessary
Step 6: Disabling Oracle Database Vault (More Need to be done) - ()
Step 7: Run Database Upgrade Assistant (DBUA)
Step 8: Upgrade Oracle Recovery Manager catalog if necessary
Step 9: Re-enabling Oracle Database Vault (More Need to be done) - ()
10. Upgrading Oracle CRS, ASM, RDBMS and Database 10.2.0.5
10.1 Download and Extract the Installation Software
10.2 Pre-installation Tasks for Patch set and Release Upgrades
10.3 Rolling Upgrading Oracle Clusterware
Step 1: Shutdown Database Control on the node 1 - racnode1
Step 2: Shut down all Oracle RAC instances on the node 1 - racnode1
Step 3: Shutdown the ASM instance on the node 1 - racnode1
Step 4: Stop all node application on the node 1 - racnode1
Step 5: Shutdown the Oracle Clusterware
Step 6: As root, run the preupdate.sh script
Step 7: Upgrade Oracle Clusterware from 10.2.0.4 to 10.2.0.5
Step 8: Verify Oracle Clusterware
Step 9: Rolling Upgrading on Next Node - racnode2
Step 10: Verify the New Oracle Clusterware 10.2.0.4.0
10.4 Apply the patch 10.2.0.5 to the ASM Home
Step 1: Verify the Oracle Clusterware Version and ASM Version
Step 2: Stopping All Process for an ASM Home
Step 3: Installing the 10.2.0.5 patch
Step 4: Verify the ASM 10.2.0.5.0
10.5 Applying Patch set to Oracle RAC Home
Step 1: Create a backup of the Oracle Inventory, home and Database
Step 2: Stopping All Process for an Oracle RAC Installation
Step 3: Installing the Oracle Database 10g Patch Set Interactively
10.6 Upgrading Oracle Database Using DBUA
Step 1: Restart the Database with the UPGRADE option
Step 2: Run the Pre-Upgrade Information Tool
Step 3: Back up the Database
Step 4: Set the values for the environment variables
Step 5: Start ASM Instances if necessary
Step 6: Disabling Oracle Database Vault (More Need to be done)
Step 7: Run Database Upgrade Assistant (DBUA)
Step 8: Upgrade Oracle Recovery Manager catalog if necessary
Step 9: Re-enabling Oracle Database Vault(More Need to be done)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26664718/viewspace-716207/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26664718/viewspace-716207/