DST V25 Timezone

DST  V14 to V25 Upgrading:


If your E-Business Suite Release environment is configured to support Daylight Saving Time (DST) or international time zones, it’s important to keep your timezone definition files up-to-date. They were last changed in November 2015 and released as DSTv25.

1. Check the invalid count before upgrade
SQL>select count(1) from dba_objects where status=’INVALID’;


2. Check the TZ version before upgrade.
SQL> SELECT version FROM v$timezone_file;


   VERSION
—————
14


3. Bringdown Apps services and Database and Listener
$ADMIN_SCRIPTS_HOME/adstpall.sh apps/apps


sqlplus ‘/ as sysdba’
shut immediate
lsnrctl stop TEST


4. Set the inventory


cat /etc/oraInst.loc
inventory_loc=/etc/oracle/oraInventory
inst_group=dba


5. Verify the inventory


$ORACLE_HOME/OPatch/opatch lsinventory


6.Apply DST25 Patch


cd /stageall/patches/DST/22037014
$ORACLE_HOME/OPatch/opatch apply


7.Verify patch applied or not?


$ORACLE_HOME/OPatch/opatch lsinventory | grep 22037014


8.Post steps of DST  patch


Download scripts from Note: 1585343.1


cd /stagall/patches/DST/DBMS_DST_scriptsV1.9


Conn / as sysdba
spool countstatsTSTZ.log
@countstatsTSTZ.sql
spool off


Conn / as sysdba
spool upg_tzv_check.log
@upg_tzv_check.sql
spool off


Conn / as sysdba
spool upg_tzv_apply.log
@upg_tzv_apply.sql
spool off


9.Verify DST version post upgrade


SQL> SELECT version FROM v$timezone_file;


VERSION
————–
25


10.Verify invalid objects


select count(1) from dba_objects where status=’INVALID’;


11. Bring up services, validate the environment and release
————————————————————
sqlplus ‘ /as sysdba’
startup
exit
lsnrctl start TEST




$ADMIN_SCRIPTS_HOME/adstrtal.sh apps/appspwd




Reference


Scripts to automatically update the RDBMS DST (timezone) version in an 11gR2 or 12cR1 database . (Doc ID 1585343.1)

Complying with Daylight Saving Time (DST) and Time Zone Rule Changes in E-Business Suite 12 (Note 563019.1)


Thank you ! 

  • March 27, 2017 | 18 views
  • Comments