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

AKS_Cover

Restrict Applications Users To Be Signed In

How Can I Restrict Applications Users To Be Signed In Only Once At Any Time …

Leave a Reply