patch information
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: patch information

  1. #1
    Join Date
    Jan 2008
    Posts
    45

    patch information

    Hi

    i have had an issue with the database and contacted oracle...
    they told me to install patch 5583446...
    and test it in a test environment....

    my question here is :

    what is this patch 5583446? and how can i know more information about this patch?

    i also checked with oracle about the workaround mentioned in other note on this issue on other site...

    Set SGA_target =0 ie disable automatic shared memory management....

    what does this mean?

    Any comments or suggesstuons will be appreciated ..

    Thanks

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    what does metalink say about it

  3. #3
    Join Date
    Jan 2008
    Posts
    45

    hey Davey

    Unfortunately i don't have access to the metalink.

    but these are the errors i get...

    Errors in file /u01/app/oracle/admin/umdp/bdump/umdp_cjq0_29869.trc:
    ORA-01882: timezone region ORA-018 not found
    ORA-01882: timezone region ORA-01882: timezone region not found
    ORA-01882: timezone region ORA-01882: timezone region not found
    ORA-01882: timezone region ORA-01882: timezone region not found
    ORA-01882: timezone region ORA-01882: timezone region not found
    ORA-01882: timezone region ORA-01882: timezone region not found

    can u shed some light on it?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    raise an SR with metalink - if you dont have access - get it

  5. #5
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,476

    Cool Strange....

    Patch#5583446 does not seem to be related to the errors you are getting, check out Note#414590.1: This note explains that the internal region IDs that Oracle uses for 7 time zones were updated in the "version-3" time zone files (patch 4689959, and also in the "version-4" files, patch 5632264). After these patches have been installed any "old" data which uses these 7 time zones will not be recognized by Oracle and result in a ORA-1882 error.


    You NEED Metalink!
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  6. #6
    Join Date
    Jan 2008
    Posts
    45

    hey

    thanks for the replys guys...

    i will have to get the metalink i guess..

    Thanks anyways.

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