Tuesday, March 9, 2010

ORA-00005

Usually this error comes from Application side in the form :

ORA-00005:
Message 5 not found; product=RDBMS; facility=ORA
ORA-06512: at "SYS.DBMS_UTILITY", line 70
ORA-06512: at line 1

and its related with the timezones that are supported on the database.
Oracle has 2 Timezone files on the $ORACLE_HOME/oracore/zoneinfo/ directory.

timezone.dat -- small file
timezlrg.dat -- large file

From 9.2.0.5 onwards, $ORACLE_HOME/oracore/zoneinfo/timezlrg.dat is the default timezone file and will be used if ORA_TZFILE parameter is not set.

if you use on the application side a timezone that is not in the timezlrg.dat then this error is raised.

You can query this view by to see the timezones with:

select *
from v$timezone_names;

No comments:

Post a Comment