Oracle® Database 2 Day + Real Application Clusters Guide
Oracle® Database 2 Day + Real Application Clusters Guide
Introduction to Deploying a Real Application Clusters Environment
“Introduction to Deploying a Real Application Clusters Environment”
About Oracle Grid Infrastructure and Oracle RAC
“About Oracle Grid Infrastructure and Oracle RAC”
About Automatic Storage Management
“About Automatic Storage Management”
About Oracle Real Application Clusters
“About Oracle Real Application Clusters”
About Installing Oracle RAC on Different Operating Systems
“About Installing Oracle RAC on Different Operating Systems”
Tools for Installing, Configuring, and Managing Oracle RAC
“Tools for Installing, Configuring, and Managing Oracle RAC”
Preparing Your Cluster
“Preparing Your Cluster”
Verifying System Requirements
“Verifying System Requirements”
About Hardware Requirements
“About Hardware Requirements”
About Network Hardware Requirements
“About Network Hardware Requirements”
About IP Address Requirements
“About IP Address Requirements”
Verifying Operating System and Software Requirements
“Verifying Operating System and Software Requirements”
To determine if the operating system requirements for Oracle Enterprise Linux have been met:
“To determine if the operating system requirements for Oracle Enterprise Linux have been met:”
Preparing the Server
“Preparing the Server”
About Operating System Users and Groups
“About Operating System Users and Groups”
Required Operating System Users and Groups
“Required Operating System Users and Groups”
Optional Operating System Users and Groups
“Optional Operating System Users and Groups”
Configuring Operating System Users and Groups
“Configuring Operating System Users and Groups”
To create one software owner with all operating system-authenticated administration privileges:
“To create one software owner with all operating system-authenticated administration privileges:”
Configuring Secure Shell
“Configuring Secure Shell”
About Configuring the Software Owner's Shell Environment
“About Configuring the Software Owner's Shell Environment”
Configuring the Network
“Configuring the Network”
To configure the network in preparation for installing Oracle Grid Infrastructure:
“To configure the network in preparation for installing Oracle Grid Infrastructure:”
Verifying the Network Configuration
“Verifying the Network Configuration”
To verify the network configuration on a two-node cluster that is running Oracle Enterprise Linux:
“To verify the network configuration on a two-node cluster that is running Oracle Enterprise Linux:”
Preparing the Operating System and Software
“Preparing the Operating System and Software”
About Setting the Time on Both Nodes
“About Setting the Time on Both Nodes”
About Configuring Kernel Parameters
“About Configuring Kernel Parameters”
About Performing Platform-Specific Configuration Tasks
“About Performing Platform-Specific Configuration Tasks”
Configuring Installation Directories and Shared Storage
“Configuring Installation Directories and Shared Storage”
About the Oracle Inventory Directory
“About the Oracle Inventory Directory”
Creating the Oracle Grid Infrastructure Home Directory
“Creating the Oracle Grid Infrastructure Home Directory”
Creating the Oracle Base Directory
“Creating the Oracle Base Directory”
Example: Creating an Oracle Base Directory
“Example: Creating an Oracle Base Directory”
To create the Oracle base directory:
“To create the Oracle base directory:”
About the Oracle Home Directory
“About the Oracle Home Directory”
About Shared Storage
“About Shared Storage”
Configuring Files on an NAS Device for Use with ASM
“Configuring Files on an NAS Device for Use with ASM”
To configure NAS device files for creating disk groups:
“To configure NAS device files for creating disk groups:”
Configuring Default Ownership for Shared Disk Devices
“Configuring Default Ownership for Shared Disk Devices”
Using a Permissions File with Oracle Enterprise Linux 4.0
“Using a Permissions File with Oracle Enterprise Linux 4.0”
To create a permissions file if you are using Red Hat Enterprise Linux 4.0:
“To create a permissions file if you are using Red Hat Enterprise Linux 4.0:”
Using a Rules File with Oracle Enterprise Linux 5.0
“Using a Rules File with Oracle Enterprise Linux 5.0”
To create a rules file for shared disk devices, complete the following tasks:
“To create a rules file for shared disk devices, complete the following tasks:”
Installing Oracle Grid Infrastructure and Oracle RAC
“Installing Oracle Grid Infrastructure and Oracle RAC”
Preparing the Oracle Media Installation File
“Preparing the Oracle Media Installation File”
To prepare the Oracle Media installation files:
“To prepare the Oracle Media installation files:”
Installing the Oracle Grid Infrastructure
“Installing the Oracle Grid Infrastructure”
Configuring the Operating System Environment
“Configuring the Operating System Environment”
To modify the user environment prior to installing Oracle Grid Infrastructure on Oracle Enterprise Linux:
“To modify the user environment prior to installing Oracle Grid Infrastructure on Oracle Enterprise Linux:”
To modify the user environment prior to installing Oracle Database on Oracle Enterprise Linux:
“To modify the user environment prior to installing Oracle Database on Oracle Enterprise Linux:”
Verifying the Configuration Using the Cluster Verification Utility
“Verifying the Configuration Using the Cluster Verification Utility”
To verify your hardware and operating system setup prior to installing Oracle Clusterware:
“To verify your hardware and operating system setup prior to installing Oracle Clusterware:”
About CVU Fixup Scripts
“About CVU Fixup Scripts”
Using Oracle Universal Installer to Install the Oracle Grid Infrastructure
“Using Oracle Universal Installer to Install the Oracle Grid Infrastructure”
To install the Oracle Grid Infrastructure software:
“To install the Oracle Grid Infrastructure software:”
Completing the Oracle Clusterware Configuration
“Completing the Oracle Clusterware Configuration”
To complete the Oracle Clusterware configuration on Oracle Enterprise Linux:
“To complete the Oracle Clusterware configuration on Oracle Enterprise Linux:”
Installing the Oracle Database Software and Creating a Cluster Database
“Installing the Oracle Database Software and Creating a Cluster Database ”
To install Oracle Database on your cluster:
“To install Oracle Database on your cluster:”
Verifying Your Oracle RAC Database Installation
“Verifying Your Oracle RAC Database Installation”
To verify the Oracle RAC database services are running:
“To verify the Oracle RAC database services are running:”
Performing Postinstallation Tasks
“Performing Postinstallation Tasks”
About Verifying the Oracle Clusterware Installation
“About Verifying the Oracle Clusterware Installation”
About Downloading and Installing RDBMS Patches
“About Downloading and Installing RDBMS Patches”
Verifying Oracle Enterprise Manager Operations
“Verifying Oracle Enterprise Manager Operations”
To verify Oracle Enterprise Manager Database Control has been started in your new Oracle RAC environment:
“To verify Oracle Enterprise Manager Database Control has been started in your new Oracle RAC environment:”
Recommended Postinstallation Tasks
“Recommended Postinstallation Tasks”
About Backing Up the root.sh Script
“About Backing Up the root.sh Script”
About Configuring User Accounts
“About Configuring User Accounts”
About Converting an Oracle Database to an Oracle RAC Database
“About Converting an Oracle Database to an Oracle RAC Database”
About Preparing for Database Conversion
“About Preparing for Database Conversion”
Overview of the Database Conversion Process Using Grid Control
“Overview of the Database Conversion Process Using Grid Control”
Overview of the Database Conversion Process Using rconfig
“Overview of the Database Conversion Process Using rconfig”
Administering Database Instances and Cluster Databases
“ Administering Database Instances and Cluster Databases”
About Oracle RAC Database Management
“About Oracle RAC Database Management”
About Oracle RAC Management Using Enterprise Manager
“About Oracle RAC Management Using Enterprise Manager”
Starting and Stopping Oracle RAC Databases and Database Instances
“Starting and Stopping Oracle RAC Databases and Database Instances”
To start and stop an entire Oracle RAC database, assuming you are using a server parameter file (SPFILE):
“To start and stop an entire Oracle RAC database, assuming you are using a server parameter file (SPFILE):”
About Oracle RAC Initialization Parameters
“About Oracle RAC Initialization Parameters”
About Configuring Initialization Parameters for an Oracle RAC Database
“About Configuring Initialization Parameters for an Oracle RAC Database”
Parameters that Must Have Identical Settings on All Instances
“Parameters that Must Have Identical Settings on All Instances”
Parameters that Must Have Unique Settings on All Instances
“Parameters that Must Have Unique Settings on All Instances”
Parameters that Should Have Identical Settings on All Instances
“Parameters that Should Have Identical Settings on All Instances”
About Modifying the SERVICE_NAMES Parameter for Oracle RAC
“About Modifying the SERVICE_NAMES Parameter for Oracle RAC”
About the Server Parameter File for Oracle Real Application Clusters
“About the Server Parameter File for Oracle Real Application Clusters”
Editing Initialization Parameter Settings for an Oracle RAC Database
“Editing Initialization Parameter Settings for an Oracle RAC Database”
To view or modify the initialization parameters using Enterprise Manager:
“To view or modify the initialization parameters using Enterprise Manager:”
Modifying the Initialization Parameter for Oracle RAC Using the Current Tab
“Modifying the Initialization Parameter for Oracle RAC Using the Current Tab”
To modify parameter values using the Current tab:
“To modify parameter values using the Current tab:”
Modifying the Initialization Parameter for Oracle RAC Using the SPFile Tab
“Modifying the Initialization Parameter for Oracle RAC Using the SPFile Tab”
To modify parameter values using the SPFile tab:
“To modify parameter values using the SPFile tab:”
Example: Modifying the OPEN_CURSORS Parameter
“Example: Modifying the OPEN_CURSORS Parameter”
About Administering Storage in Oracle RAC
“About Administering Storage in Oracle RAC”
About Automatic Undo Management in Oracle RAC
“About Automatic Undo Management in Oracle RAC”
Automatic Storage Management in Oracle RAC
“Automatic Storage Management in Oracle RAC”
About ASM Components in Oracle RAC
“About ASM Components in Oracle RAC”
About Disk Group Configurations for ASM in Oracle RAC
“About Disk Group Configurations for ASM in Oracle RAC”
About Standalone ASM Disk Group Management
“About Standalone ASM Disk Group Management”
About ASM Instance and Disk Group Management Using Enterprise Manager
“About ASM Instance and Disk Group Management Using Enterprise Manager”
Administering Redo Logs in Oracle RAC
“Administering Redo Logs in Oracle RAC”
About Redo Log Groups and Redo Threads in Oracle RAC Databases
“About Redo Log Groups and Redo Threads in Oracle RAC Databases”
Using Enterprise Manager to View and Create Online Redo Log Files
“Using Enterprise Manager to View and Create Online Redo Log Files”
To access the redo log file groups Using Enterprise Manager:
“To access the redo log file groups Using Enterprise Manager:”
Administering Oracle Clusterware Components
“ Administering Oracle Clusterware Components”
About Oracle Clusterware
“About Oracle Clusterware”
Adding and Removing Voting Disks
“Adding and Removing Voting Disks”
To add or remove a voting disk:
“To add or remove a voting disk:”
Backing Up and Recovering Voting Disks
“Backing Up and Recovering Voting Disks”
About Backing Up and Recovering Voting Disks
“About Backing Up and Recovering Voting Disks”
Backing Up Voting Disks
“Backing Up Voting Disks”
Recovering Voting Disks
“Recovering Voting Disks”
Backing Up and Recovering the Oracle Cluster Registry
“Backing Up and Recovering the Oracle Cluster Registry”
Viewing Available OCR Backups
“Viewing Available OCR Backups”
To find the most recent backup of the OCR:
“To find the most recent backup of the OCR:”
Manually Backing Up the OCR
“Manually Backing Up the OCR”
To manually backup the contents of the OCR:
“To manually backup the contents of the OCR:”
Copying the Contents of an OCR Backup to a File
“Copying the Contents of an OCR Backup to a File”
To export the contents of the OCR to a file:
“To export the contents of the OCR to a file:”
Recovering the OCR
“Recovering the OCR”
Checking the Status of the OCR
“Checking the Status of the OCR”
To check the status of the OCR:
“To check the status of the OCR:”
Restoring the OCR from Automatically Generated OCR Backups
“Restoring the OCR from Automatically Generated OCR Backups”
To restore the OCR from an automatically generated backup on an Oracle Enterprise Linux system:
“To restore the OCR from an automatically generated backup on an Oracle Enterprise Linux system:”
Recovering the OCR from an OCR Export File
“Recovering the OCR from an OCR Export File”
To restore the previous configuration stored in the OCR from an OCR export file:
“To restore the previous configuration stored in the OCR from an OCR export file:”
Maintaining the Oracle Local Registry
“Maintaining the Oracle Local Registry”
To check the status of the OLR:
“To check the status of the OLR:”
To view the contents of the OLR:
“To view the contents of the OLR:”
To export the OLR to a file:
“To export the OLR to a file:”
To import a specified file to the OLR:
“To import a specified file to the OLR:”
To change the location of the OLR file on the local node:
“To change the location of the OLR file on the local node:”
Changing the Oracle Cluster Registry Configuration
“Changing the Oracle Cluster Registry Configuration”
Adding an OCR Location
“Adding an OCR Location”
To add a primary or secondary OCR location:
“To add a primary or secondary OCR location:”
Replacing an OCR
“Replacing an OCR”
To change the location of an OCR:
“To change the location of an OCR:”
Repairing an OCR Configuration on a Local Node
“Repairing an OCR Configuration on a Local Node”
To repair an OCR configuration:
“To repair an OCR configuration:”
Removing an OCR
“Removing an OCR”
To remove an OCR location from your Oracle RAC cluster:
“To remove an OCR location from your Oracle RAC cluster:”
Troubleshooting the Oracle Cluster Registry
“Troubleshooting the Oracle Cluster Registry”
About the OCRCHECK Utility
“About the OCRCHECK Utility”
Common Oracle Cluster Registry Problems and Solutions
“Common Oracle Cluster Registry Problems and Solutions”
Common OCR Problems and Solutions
“Common OCR Problems and Solutions”
Administering Backup and Recovery
“Administering Backup and Recovery”
Overview of Oracle RAC Database Backup and Recovery
“Overview of Oracle RAC Database Backup and Recovery”
About the Flash Recovery Area in Oracle RAC
“About the Flash Recovery Area in Oracle RAC”
Archiving the Oracle RAC Database Redo Logs
“Archiving the Oracle RAC Database Redo Logs”
About Archived Redo Log Files for an Oracle RAC Database
“About Archived Redo Log Files for an Oracle RAC Database”
About Parallelism and Backups Across Multiple RMAN Channels
“About Parallelism and Backups Across Multiple RMAN Channels”
Configuring Archiving for Your Oracle RAC Database
“Configuring Archiving for Your Oracle RAC Database”
To configure archiving for your Oracle RAC database:
“To configure archiving for your Oracle RAC database:”
About Preparing for Backup and Recovery Operations
“About Preparing for Backup and Recovery Operations”
About Credentials for Performing Backup and Recovery
“About Credentials for Performing Backup and Recovery”
About Configuring Backup Settings
“About Configuring Backup Settings”
Performing Backups of Your Oracle RAC Database
“Performing Backups of Your Oracle RAC Database”
To back up an Oracle RAC database:
“To back up an Oracle RAC database:”
Backing Up Archived Redo Log Files
“Backing Up Archived Redo Log Files”
To configure RMAN to automatically delete the archived redo log file files from disk after they have been safely backed up, when creating or scheduling your database backups:
“To configure RMAN to automatically delete the archived redo log file files from disk after they have been safely backed up, when creating or scheduling your database backups:”
Recovering Your Oracle RAC Database
“Recovering Your Oracle RAC Database”
About Preparing to Restore and Recover Your Oracle RAC Database
“About Preparing to Restore and Recover Your Oracle RAC Database”
About Configuring Access to the Archive Log
“About Configuring Access to the Archive Log”
About Putting the Oracle RAC Database Instances into the Correct State
“About Putting the Oracle RAC Database Instances into the Correct State”
About Restoring Archived Redo Log File Files
“About Restoring Archived Redo Log File Files”
About Performing Recovery Using Parallelism
“About Performing Recovery Using Parallelism”
Recovering the Oracle RAC Database Using Enterprise Manager
“Recovering the Oracle RAC Database Using Enterprise Manager”
To use Enterprise Manager and RMAN to restore and recover an Oracle RAC database:
“To use Enterprise Manager and RMAN to restore and recover an Oracle RAC database:”
Recovering the Parameter File from an Automatic File Backup
“Recovering the Parameter File from an Automatic File Backup”
To recover an SPFILE for an Oracle RAC database:
“To recover an SPFILE for an Oracle RAC database:”
About Managing Your Database Backup Files
“About Managing Your Database Backup Files”
Displaying Backup Reports for Your Oracle RAC Database
“Displaying Backup Reports for Your Oracle RAC Database”
To view backup reports:
“To view backup reports:”
Managing Database Workload Using Services
“ Managing Database Workload Using Services”
About Workload Management
“About Workload Management”
About Oracle Services
“About Oracle Services”
About Configuring Services for High Availability
“About Configuring Services for High Availability”
About the Database Resource Manager
“About the Database Resource Manager”
About Oracle RAC High Availability Framework
“About Oracle RAC High Availability Framework”
About Fast Application Notification (FAN)
“About Fast Application Notification (FAN)”
About FAN Callouts
“About FAN Callouts”
About the Load Balancing Advisory
“About the Load Balancing Advisory”
About Connection Load Balancing
“About Connection Load Balancing”
Client-Side Load Balancing
“Client-Side Load Balancing”
Server-Side Load Balancing
“Server-Side Load Balancing”
About Runtime Connection Load Balancing
“About Runtime Connection Load Balancing”
Runtime Connection Load Balancing
“Runtime Connection Load Balancing”
Creating Services
“Creating Services”
To create a service:
“To create a service:”
Verifying Oracle Net Supports Newly Created Services
“Verifying Oracle Net Supports Newly Created Services”
To verify Oracle Net Services supports the newly created service:
“To verify Oracle Net Services supports the newly created service:”
Administering Services
“Administering Services”
About Service Administration Using Enterprise Manager
“About Service Administration Using Enterprise Manager”
Using the Cluster Managed Database Services Page
“Using the Cluster Managed Database Services Page”
To access the Cluster Managed Database Services page:
“To access the Cluster Managed Database Services page:”
Configuring Clients for High Availability
“Configuring Clients for High Availability”
Configuring JDBC Clients
“Configuring JDBC Clients”
Configuring JDBC Clients for Fast Connection Failover
“Configuring JDBC Clients for Fast Connection Failover”
To configure JDBC clients for Fast Connection Failover:
“To configure JDBC clients for Fast Connection Failover:”
Configuring JDBC Clients for Connection Failure Notification
“Configuring JDBC Clients for Connection Failure Notification”
To configure JDBC clients for Connection Failure Notification:
“To configure JDBC clients for Connection Failure Notification:”
Configuring OCI Clients
“Configuring OCI Clients”
To configure OCI clients to receive FAN notifications:
“To configure OCI clients to receive FAN notifications:”
Configuring ODP.NET Clients
“Configuring ODP.NET Clients”
To configure ODP.Net clients to receive FAN notifications:
“To configure ODP.Net clients to receive FAN notifications:”
Monitoring Performance and Troubleshooting
“Monitoring Performance and Troubleshooting”
Monitoring Oracle RAC Database and Cluster Performance
“Monitoring Oracle RAC Database and Cluster Performance”
About Automatic Database Diagnostic Monitor and Oracle RAC Performance
“About Automatic Database Diagnostic Monitor and Oracle RAC Performance”
Viewing ADDM for Oracle RAC Findings
“Viewing ADDM for Oracle RAC Findings”
To view ADDM findings from the Cluster Database Home page:
“To view ADDM findings from the Cluster Database Home page:”
Using the Cluster Database Performance Page
“Using the Cluster Database Performance Page”
Viewing the Chart for Cluster Host Load Average
“Viewing the Chart for Cluster Host Load Average”
Viewing the Chart for Global Cache Block Access Latency
“Viewing the Chart for Global Cache Block Access Latency”
Viewing the Chart for Average Active Sessions
“Viewing the Chart for Average Active Sessions”
Viewing the Database Throughput Chart
“Viewing the Database Throughput Chart”
Viewing the Services Chart
“Viewing the Services Chart”
Viewing the Active Sessions by Instance Chart
“Viewing the Active Sessions by Instance Chart”
Viewing Other Performance Related Charts
“Viewing Other Performance Related Charts”
Accessing the Cluster Cache Coherency Page
“Accessing the Cluster Cache Coherency Page”
Cluster Cache Coherency Charts
“Cluster Cache Coherency Charts”
To access the Cluster Cache Coherency page:
“To access the Cluster Cache Coherency page:”
Accessing the Top Consumers Page
“Accessing the Top Consumers Page”
To access the Top Consumers page:
“To access the Top Consumers page:”
Accessing the Top Sessions Page
“Accessing the Top Sessions Page”
To access the Top Sessions page:
“To access the Top Sessions page:”
Accessing the Top Activity Page
“Accessing the Top Activity Page”
To access the Top Activity page:
“To access the Top Activity page:”
Accessing the Instance Activity Page
“Accessing the Instance Activity Page”
To access the Instance Activity page:
“To access the Instance Activity page:”
Accessing the Top Segments Page
“Accessing the Top Segments Page”
To access the Top Segments page:
“To access the Top Segments page:”
Accessing the Database Locks Page
“Accessing the Database Locks Page”
To access the Database Locks page:
“To access the Database Locks page:”
Viewing the Cluster Database Topology
“Viewing the Cluster Database Topology”
To view the topology for your cluster database environment:
“To view the topology for your cluster database environment:”
Monitoring Oracle Clusterware
“Monitoring Oracle Clusterware”
Accessing the Oracle Clusterware Information
“Accessing the Oracle Clusterware Information”
To access Oracle Clusterware information:
“To access Oracle Clusterware information:”
Reviewing the Oracle Clusterware Home Page
“Reviewing the Oracle Clusterware Home Page”
To monitor the general state of the cluster:
“To monitor the general state of the cluster:”
Viewing the Cluster Performance Page
“Viewing the Cluster Performance Page”
Viewing the Cluster Targets Page
“Viewing the Cluster Targets Page”
Viewing the Cluster Administration Page
“Viewing the Cluster Administration Page”
About the Cluster Interconnects Page
“About the Cluster Interconnects Page”
Viewing the Cluster Topology Page
“Viewing the Cluster Topology Page”
Troubleshooting Configuration Problems in Oracle RAC Environments
“Troubleshooting Configuration Problems in Oracle RAC Environments”
Using CRSCTL to Diagnose Cluster Issues
“Using CRSCTL to Diagnose Cluster Issues”
About the Oracle Clusterware Alert Log
“About the Oracle Clusterware Alert Log”
About the Oracle Clusterware Component Log Files
“About the Oracle Clusterware Component Log Files”
Checking the Status of the Oracle Clusterware Installation
“Checking the Status of the Oracle Clusterware Installation”
To determine the condition of your clusterware installation:
“To determine the condition of your clusterware installation:”
Running the Oracle Clusterware Diagnostics Collection Script
“Running the Oracle Clusterware Diagnostics Collection Script”
To run the Oracle Clusterware Diagnostics Collection script:
“To run the Oracle Clusterware Diagnostics Collection script:”
Enabling Debugging of Oracle Clusterware Components
“Enabling Debugging of Oracle Clusterware Components”
To enable debugging of Oracle Clusterware components:
“To enable debugging of Oracle Clusterware components:”
Enabling Debugging for an Oracle Clusterware Resource
“Enabling Debugging for an Oracle Clusterware Resource”
To enable debugging of an Oracle Clusterware resource:
“To enable debugging of an Oracle Clusterware resource:”
Enabling and Disabling Oracle Clusterware Daemons
“Enabling and Disabling Oracle Clusterware Daemons”
To enable automatic startup for all Oracle Clusterware daemons:
“To enable automatic startup for all Oracle Clusterware daemons:”
To disable automatic startup for all Oracle Clusterware daemons:
“To disable automatic startup for all Oracle Clusterware daemons:”
Using the Cluster Verification Utility to Diagnose Problems
“Using the Cluster Verification Utility to Diagnose Problems”
Verifying the Existence of Node Applications
“Verifying the Existence of Node Applications”
To verify the existence of node applications:
“To verify the existence of node applications:”
Verifying the Integrity of Oracle Clusterware Components
“Verifying the Integrity of Oracle Clusterware Components”
To verify the integrity of Oracle Clusterware components:
“To verify the integrity of Oracle Clusterware components:”
Verifying the Integrity of the Oracle Cluster Registry
“Verifying the Integrity of the Oracle Cluster Registry”
To verify the integrity of the Oracle Clusterware registry:
“To verify the integrity of the Oracle Clusterware registry:”
Verifying the Integrity of Your Entire Cluster
“Verifying the Integrity of Your Entire Cluster”
To verify the integrity of your Oracle RAC cluster:
“To verify the integrity of your Oracle RAC cluster:”
Checking the Settings for the Interconnect
“Checking the Settings for the Interconnect”
To check the settings for the interconnect:
“To check the settings for the interconnect:”
Enabling Tracing
“Enabling Tracing”
To enable tracing using CVU:
“To enable tracing using CVU:”
Viewing Oracle RAC Database Alerts
“Viewing Oracle RAC Database Alerts”
To view the alert messages for an Oracle RAC database:
“To view the alert messages for an Oracle RAC database:”
Viewing Oracle RAC Database Alert Log Messages
“Viewing Oracle RAC Database Alert Log Messages”
To view the alert log for an Oracle RAC database instance:
“To view the alert log for an Oracle RAC database instance:”
Adding and Deleting Nodes and Instances
“ Adding and Deleting Nodes and Instances”
Preparing the New Node
“Preparing the New Node”
Verifying the New Node Meets the Prerequisites for Installation
“Verifying the New Node Meets the Prerequisites for Installation”
Extending the Oracle Grid Infrastructure Home to the New Node
“Extending the Oracle Grid Infrastructure Home to the New Node”
To extend the Oracle Grid Infrastructure to include the new node:
“To extend the Oracle Grid Infrastructure to include the new node:”
Extending the Oracle RAC Home Directory
“Extending the Oracle RAC Home Directory”
To extend the Oracle RAC installation to include the new node:
“To extend the Oracle RAC installation to include the new node:”
Adding the New Node to the Cluster
“Adding the New Node to the Cluster”
Adding an Instance to the Cluster Database
“Adding an Instance to the Cluster Database”
To add an instance to the cluster database:
“To add an instance to the cluster database:”
Deleting an Instance From the Cluster Database
“Deleting an Instance From the Cluster Database”
To delete an instance from the cluster:
“To delete an instance from the cluster:”
Removing a Node From the Cluster
“Removing a Node From the Cluster”
Managing Oracle Software and Applying Patches
“ Managing Oracle Software and Applying Patches”
Configuring the Enterprise Manager Patch Interface
“Configuring the Enterprise Manager Patch Interface”
Configure the Software Library
“Configure the Software Library”
To configure the Software Library prior to using the Patch Interface of Database Control:
“To configure the Software Library prior to using the Patch Interface of Database Control:”
About My Oracle Support Credentials
“About My Oracle Support Credentials”
Start the Provisioning Daemon
“Start the Provisioning Daemon”
Obtaining Patches
“Obtaining Patches”
Uploading Patches to the Software Library
“Uploading Patches to the Software Library”
To upload patches to the Software Library:
“To upload patches to the Software Library:”
Using DB Control to Apply Patches to a Cluster Database
“Using DB Control to Apply Patches to a Cluster Database”
Patching Oracle Home Directories
“Patching Oracle Home Directories”
Patching an Oracle RAC Database Using the Rolling Upgrade Method
“Patching an Oracle RAC Database Using the Rolling Upgrade Method”
To patch a non-shared Oracle home using the rolling patch method:
“To patch a non-shared Oracle home using the rolling patch method:”
Applying Patches to Oracle Clusterware Using DB Control
“Applying Patches to Oracle Clusterware Using DB Control”
To patch Oracle Oracle Grid Infrastructure home using DB Control, perform the following steps:
“To patch Oracle Oracle Grid Infrastructure home using DB Control, perform the following steps:”
Applying Patch Sets
“Applying Patch Sets”
To locate the Patchset notes on My Oracle Support:
“To locate the Patchset notes on My Oracle Support:”
Applying Patches Using OPatch and the Minimum Downtime Method
“Applying Patches Using OPatch and the Minimum Downtime Method”
Preparing to Use OPatch
“Preparing to Use OPatch”
Checking the ORACLE_HOME Environment Variable
“Checking the ORACLE_HOME Environment Variable”
To check the current setting of the ORACLE_HOME variable on Linux:
“To check the current setting of the ORACLE_HOME variable on Linux:”
Performing a Backup Prior to Patching Software
“Performing a Backup Prior to Patching Software”
To back up the software installation:
“To back up the software installation:”
Staging the Patch on Each Node
“Staging the Patch on Each Node”
Updating the PATH Environment Variable
“Updating the PATH Environment Variable”
To update the PATH environment variable on Oracle Enterprise Linux systems:
“To update the PATH environment variable on Oracle Enterprise Linux systems:”
Configuring SSH User Equivalency
“Configuring SSH User Equivalency”
To test SSH user equivalency:
“To test SSH user equivalency:”
To enable SSH user equivalency:
“To enable SSH user equivalency:”
Minimum Downtime Patching
“Minimum Downtime Patching”
To apply a patch to your cluster database using the minimum downtime method:
“To apply a patch to your cluster database using the minimum downtime method:”
Troubleshooting Patch Deployment
“Troubleshooting Patch Deployment”
About OPatch Log and Trace Files
“About OPatch Log and Trace Files”
Resolving the "Unable to remove a partially installed interim patch" Error
“Resolving the "Unable to remove a partially installed interim patch" Error”
To resolve the partially installed patch error:
“To resolve the partially installed patch error:”
Upgrading the Oracle Software
“Upgrading the Oracle Software”