How to update timezone from 32 to 42

Learn how to update timezone from 32 to 42 on Oracle Cloud RAC 2 Node in DbaaS model in some easy steps.

STEPS:

  1. show parameter cluster_database
  2. alter system set cluster_database=FALSE scope=spfile;
  3. show parameter cluster_database
  4. alter system set cluster_database=TRUE scope=spfile;
  5. show parameter cluster_database
  6. SELECT * FROM v$timezone_file;
  7. @ upg_tzv_apply.sql

About Syed Raheel

I have total of 17 years and more than 15 years experience in Oracle ERP E-Business Suite R11i , R12.1.3 , 12.2.4 to 12.2.11 with Oracle 10g/11g/12c and 19c with Red Hat / Oracle Enterprise Linux Environments. I am Working as Oracle EBS APPS Database Consultant in Advanced Operations Technology, A Saudi Arabian IT/ERP Consulting firm, I am responsible for New Technical Implementations, Upgradation, Migrations and Providing 24x7 support for critical ERP Production Application & Databases. Specialties: Oracle Application Oracle E-Business Suite R12 Oracle Applications System Administration Oracle Applications Database Administration

Check Also

HTTP Service Issue After Sudden Power Shutdow

Fixing HTTP Service Issue After Sudden Power Shutdown of Oracle EBS 12.2 Application Server   …

Leave a Reply