Oracle Grid Infrastructure Installation Study Notes

Oracle Grid Infrastructure Installation Notes

Introduction to Oracle Grid Infrastructure (GI)

  • Purpose of Oracle GI:

    • Prepares the storage and network layer for one or several new Oracle databases on a server.

  • Steps in the Installation Process:

    1. Install the GI software.

    2. Verify that the Automatic Storage Management (ASM) instance has been created.

  • Importance of Installing GI Software:

    • Essential for nearly all production Oracle environments, including single instance setups.

    • Provides automatic storage management features that enhance overall Input/Output (IO) performance.

    • Makes it easier for Database Administrators (DBAs) to manage storage through actions such as mirroring disks, adding disk space, and removing disk drives.

Advanced Benefits of GI

  • Management of Cluster Resources:

    • Operates in an Oracle Real Application Clusters (RAC) environment.

  • Standalone ASM Storage Layer:

    • Also known as FlexASM.

  • High Availability:

    • Features built-in redundancy levels that improve system resilience in the event of disk failure.

Installation Process Overview

  • Login Details:

    • Logged into the Linux server as the Oracle user to start the installation.

  • Preparation:

    • Installer files should be extracted to the directories under /u01/app/oracle.

Navigating to the GI Installation Directory

  • Commands Used:

    • ls: Lists the contents of the current directory.

    • cd: Changes directory to the specified path.

  • Setup Scripts:

    • Confirm the presence of gridSetup.sh, which is used to launch the GUI installer.

Initiating the Installation

  • Starting the Installer:

    • Run the shell script gridSetup.sh to start the GUI installer.

  • Choosing Installation Type:

    • Select the option for a standalone server to continue the installation.

Disk Storage Configuration

  • Disk Allocation:

    • Requires proper allocation of disks to Oracle.

    • Select option for external redundancy during configuration.

  • Discovery Path:

    • Modify discovery path to /dev/oracleASM/disks.

  • Disk Selection:

    • Select all disks available for use and proceed to the next step.

User Credentials and Administrative Setup

  • Password Setup:

    • Specify passwords for SYS and ASM_SNP users.

  • Enterprise Manager Registration:

    • Registration can be skipped at this time.

  • ASM Administrator Group:

    • Change to DBA from default settings.

  • Oracle Base and Software Location:

    • Default Oracle base directory is valid: /u01/app/oracle.

    • Set the software location to /u01/app/oracle/giHome19.

Oracle Inventory and Configuration Scripts

  • Oracle Inventory:

    • Default settings are acceptable for Oracle Inventory, which catalogues all installed Oracle programs.

  • Configuration Scripts:

    • Option to automatically run scripts at the end but manual execution is preferred in this context.

Requirement Verification and Installation Execution

  • System Requirement Checks:

    • Installer checks compatibility with the operating system.

  • Summary Page:

    • Displays the actions to be performed during installation for final review.

  • Installation Confirmation:

    • Click on install if all pre-checks are satisfactory.

Root User Script Execution

  • Running Root Scripts:

    • Two scripts must be executed as the root user:

    1. Copy the first script, switch to a root session, paste, and run.

    2. After completion, repeat with the second script.

  • Return to GUI Installer:

    • After running each root script, return to the installer and proceed through the installation process.

Completion of Installation

  • Final Messages:

    • Installer displays a success message upon completion of the installation.

  • Verification of ASM Instance:

    • Use command to check /etc/oratab for confirmation of the running ASM instance:

    • Ensure the ASM instance is listed in the output, indicating successful installation of Grid Infrastructure.

Conclusion

  • The installation of Oracle Grid Infrastructure is now complete, and the ASM instance is verified and running.