My Oracle Support Banner

SOLARIS: How to Relocate the SGA (By Changing the SGABEG Parameter) (Doc ID 1028623.6)

Last updated on JANUARY 09, 2024

Applies to:

Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Solaris on SPARC (32-bit)

Purpose

This note describes how to relocate the SGA of an Oracle 32-bit database on the 32-bit or 64-bit Solaris operating system (SPARC).
The SGA of an Oracle 64-bit database can be > 4GB on the 64-bit Solaris operating system (SPARC).

Scope

This applies to Oracle 32-bit database versions 7.x through 9.x on the Solaris operating system (SPARC).
The Solutions described below are:
      A. For RDBMS version 9.x - How to Change your Attach Address
      B. For RDBMS version 8.1.x - How to Change your Attach Address
      C. For RDBMS version 8.0.x - How to Change Your Attach Address
      D. For RDBMS version 7.3.2.x - How to Change Your Attach Address
      E. For RDBMS versions 7.3.3 or 7.3.4 - How to Change Your Attach Address
      F. For RDBMS version 7.2.3 or older - How to Change Your Attach Address

If you experience difficulties during the attempt to change the attach address, simply restore the file backed up as part of the procedure, and use it to relink. You will then revert to your original attach address.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.