Nach einem Datenbank-Upgrade sollte ebenfalls die Zeitzonendatei auf den entsprechenden Stand gebracht werden. Bei einem Upgrade auf Oracle 11g R2 kann dieses mit dem folgendem Skript erreicht werden.


conn / as sysdba

set linesize 400
set echo on
startup

select property_name, substr(property_value, 1, 30) value from database_properties where property_name like 'DST_%' order by property_name;
pause

shutdown immediate
startup upgrade
exec dbms_dst.begin_upgrade(11);
pause
shutdown immediate
startup
select property_name, substr(property_value, 1, 30) value from database_properties where property_name like 'DST_%' order by property_name;
pause

select owner, table_name, upgrade_in_progress from all_tstz_tables where owner='SYSMAN';
pause
set serveroutput on
declare
 num_of_failures number; 
begin
 dbms_dst.upgrade_database(num_of_failures); 
 dbms_output.put_line(num_of_failures); 
 dbms_output.put_line(num_of_failures); 
end

/
pause

declare
 num_of_failures number; 
begin
 dbms_dst.end_upgrade(num_of_failures); 
end

/