Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Location
    IL
    Posts
    73

    Unanswered: oradism not set up correctly error in the alert log in 9.2.0.4

    Hello,

    I have installed 9.2.0.4 patch on top of 9.2.0.1 database.
    The O/S is Solaris 5.9

    The database is set to work with:
    workarea_size_policy=AUTO.

    The database is not working properly – compared to other machines we have.

    After looking in the alert log I found the following error popping after restart:
    WARNING: -------------------------------
    WARNING: oradism not set up correctly.
    Dynamic ISM can not be locked. Please
    setup oradism, or unset sga_max_size.
    [diagnostic 0, 16, 5001]

    I found the following two notes on the subject, contradicting each other and also contradicting the status of the machine:

    Note:151222.1
    http://metalink.oracle.com/metalink/...&p_id=151222.1
    Telling me not to do the below procedure on 9.2.0.4, though I get the same error and miss the required etc entries specified.

    Note:262886.1
    http://metalink.oracle.com/metalink/...&p_id=262886.1
    Telling me to copy oradism.sav to oradism and I already have those.


    Can you please supply a full and DETAILED procedure regarding what should I do, in case it is not a procedure, please specify how I should solve the ‘oradism not set up correctly’ error.



    Tal Olier
    otal@mercury.co.il

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    if you have workarea_size_policy set to AUTO
    then you must set PGA_AGGREGATE_TARGET to something.

    If not then set workarea_size_policy to MANUAL

    from Oracle:

    WORKAREA_SIZE_POLICY
    Parameter type
    String

    Syntax
    WORKAREA_SIZE_POLICY = {AUTO | MANUAL}

    Default value
    If PGA_AGGREGATE_TARGET is set, then AUTO

    If PGA_AGGREGATE_TARGET is not set, then MANUAL

    Parameter class
    Dynamic: ALTER SESSION, ALTER SYSTEM


    WORKAREA_SIZE_POLICY specifies the policy for sizing work areas. This parameter controls the mode in which working areas are tuned.

    Values:

    AUTO

    Work areas used by memory-intensive operators are sized automatically, based on the PGA memory used by the system, the target PGA memory set in PGA_AGGREGATE_TARGET, and the requirement of each individual operator. You can specify AUTO only when PGA_AGGREGATE_TARGET is defined.

    MANUAL

    The sizing of work areas is manual and based on the values of the *_AREA_SIZE parameter corresponding to the operation (for example, a sort uses SORT_AREA_SIZE). Specifying MANUAL may result in sub-optimal performance and poor PGA memory utilization.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •