ORA-25138: XXX initialization parameter has been made obsolete
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-25138: XXX initialization parameter has been made obsolete

  1. #1
    Join Date
    Nov 2000
    Posts
    42

    Question

    Hello.

    Working on Windows NT 4.0 + Oracle 8i

    When starting my database I get these warning messages:

    ORA-25138: SEQUENCE_CACHE_ENTRIES initialization parameter has been made obsolete
    ORA-25138: SEQUENCE_CACHE_HASH_BUCKETS initialization parameter has been made obsolete
    ORA-25138: SNAPSHOT_REFRESH_PROCESSES initialization parameter has been made obsolete

    I performed:
    select name, isspecified from v$obsolete_parameter;

    In order to confirm this. And, in effect, I have these three parameters into my init.ora:
    sequence_cache_entries = 10
    snapshot_refresh_processes = 1
    sequence_cache_hash_buckets = 10

    I would be extremely obliged if anybody could help me about the steps I must follow or if it's not important.

    Regards.
    ========
    LARRY ELLISON

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Comment out those entries in init.ora and bounce your db.

    Sanjay

  3. #3
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    Thumbs up

    As these params are made obsolete from 8.1.5, you can ignore these errors (in the alert log also) as the db starts 'ok'; or better still remove them from your init.ora.

    The ISSPECIFIED Column is set to TRUE if any of these parameters has been set in v$OBSOLETE_PARAMETER.

    HTH

Posting Permissions

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


Click Here to Expand Forum to Full Width