How to Disable Transparent HugePages on Oracle Linux 7

It is recommended by Oracle to disable Linux native Transparent HugePages on Oracle database servers, to avoid potential Oracle database performance issues.

This post introduces how to disable Linux native Transparent HugePages, and verify Transparent Hugepages disabled or not.

Subscribe to get access

Read more of this content when you subscribe today.

Upgrade Oracle Grid Infrastructure from 12.2.0.1 to 18c

Contents

  • Pre-requisite checks
    • User ID for both oracle and grid user
    • Oracle ASM LIB configurations
    • Oracle Grid Infrastructure and Oracle RAC Packages
    • Stop Transparent HugePages
    • install cvuqdisk
    • grid/oracle profiles
    • Check and setup resource Limits
    • Run ORAchk utility to have pre-upgrading checks
    • run the command runcluvfy.sh stage -pre crsinst -upgrade to check the readiness of your Oracle Clusterware installation for upgrades
    • Download and apply the latest opatch utility onto GI home and DB homes
  • Upgrading Oracle Grid Infrastructure
  • Post Oracle Grid Infrastructure Upgrading
    • Check SCAN configuration
    • Post Upgrading Cluster Verification
    • Run Orachk -u -o post
    • Check all cluster resource status

Subscribe to get access

Read more of this content when you subscribe today.

Cleanup .patch_storage Directory under ORACLE_HOME

Now and then, DBA might experience disk space issues while patching and upgrading GI or DB. Under ORACLE_HOME there is a .patch_storage directory which uses huge disk space and stores all the patches already applied onto ORACLE_HOME.  Some are backup files and directories.

Following are the common methods to solve the disk space issues under ORACLE_HOME due to huge .patch_storage directory size.

Subscribe to get access

Read more of this content when you subscribe today.