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 MAY 28, 2010

Applies to:

Oracle Thesaurus Management System - Version: 4.5.0.6 and later   [Release: 4.5 and later ]
Information in this document applies to any platform.
***Checked for relevance on 28-May-2010***

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

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 hundreds of Community platforms