patch information

[chaitanyagoa]

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

[davey23uk]

what does metalink say about it

[chaitanyagoa]

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?

[davey23uk]

raise an SR with metalink - if you dont have access - get it

[LKBrwn_DBA]

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!

[chaitanyagoa]

thanks for the replys guys...

i will have to get the metalink i guess..

Thanks anyways.