My Oracle Support Banner

TMS 4.6 Upgrade : Get the 'The sga_target initialization parameter needs to be set to 600MB or a greater value. Please correct it and try again' Message In The Log File. (Doc ID 413021.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Thesaurus Management System - Version 4.5.0.6 and later
Information in this document applies to any platform.

Symptoms

TMS 4.5.2 to 4.6 Upgrade :

  1. Running OracleAS Metadata Repository Creation Assistant using OUI (setup.exe) ie Disk B27305-01 and connecting to RDBMS 9.2.0.7 machine. Host, port and sid are entered but shortly thereafter aborts with the following message:
    'The sga_target initialization parameter needs to be set to 600MB or a greater value. Please correct it and try again'.
  2. Tried to set the sga_target variable, but this appears not to work for 9i, so cannot be set. (sga_target was not introduced until RDBMS Release 10 ).

Cause

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

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

In this Document
Symptoms
Cause
Solution

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