>  Operating System
>  VMWARE
>  Installations - Apps11i
>  R12 Topics
>  Installations - Apps R12
>  Patching
>  Cloning
>  Oracle Apps Upgrades
>  System Administration - R11/R12
>  Advance Features - Oracle Apps R12
>  Want to Become an Apps DBA ?
>  Certification - Apps DBA
>  Apps Performance
>  Oracle Apps DBA Interview Questions
>  Apps Day to Day Queries

Home

Username

Password

Remember Me







Installation
RMAN - Backup & Recovery
Replication
Convert DB Character Set
DATAPUMP
Recoveries
Oracle 11g Topics
Oracle 11g DBA course

   Installation

Upgrades

Upgrade Oracle Application from R11.5.10.2 to R12.1.1

Upgrade Oracle Database from 9.2.0.6 to 10g

Upgrade Oracle Applications from R11.5.10.2 to R12.1.1

Upgrade Oracle Application from R12.1.1 to R12.1.2

Upgrade Oracle Applications from R12.1.1 to R12.1.2

Upgrade Oracle Application from R12.1.2 to R12.1.3

Upgrade Oracle Applications from R12.1.2 to R12.1.3



Upgrade Oracle Application from R12.1.1 to R12.1.3

Upgrade Oracle Applications from R12.1.1 to R12.1.3


Created on 07/11/2008 01:05 AM by akr14feb
Updated on 02/23/2012 04:47 PM by akr14feb
 Printable Version

The comments are owned by the poster. We are not responsible for its content.
No Subject
Posted on: 2008-07-12 04:47:21   By: Anonymous
 
That's cool, let me try




Good explanation
Posted on: 2008-07-12 05:37:16   By: Anonymous
 
Thanks for the step by step detailed steps.Appreciate ur efforts.

Regards,
Varma.


    Re: Good explanation
    Posted on: 2008-07-17 16:55:35   By: Anonymous
     
    Hai Kishore,

    Thanks for that handy Document.. Gotta doubt.. In note..362203.1, Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0), it is mentioned that

    "Shut down Applications server processes and database listener " before upgrade..

    In the document, you've mentioned to create a listener before upgrading.. Can you shed some lite on this ?


    Thanks
    Yusuf


      Re: Good explanation
      Posted on: 2008-07-18 01:20:16   By: akr14feb
       
      Hi Yosuf,

      Thanks for your response, creation of 10g Listener is mandatory but before upgrade you can either start or stop. During upgrade, I must have started, but before running adbldxml.pl, 10g listener should be up else we will get errors.

      perl adbldxml.pl tier=db appsuser=apps appspasswd=apps

      But before upgrade you need to shutdown 9i listener and application tier components. This is very important.

      Its better you upgrade and let me know, so that I can update my document accordingly.

      Thanks
      Kishore


        Re: Good explanation
        Posted on: 2008-07-31 01:51:22   By: Anonymous
         
        Hai Kishore,
        Yes..I think it is mandatory to create the listener before upgrade,else, DBUA will fail upgrading Enterprise manager with the error NETWORK ADAPTER CANNOT ABLE TO ESTABLISH THE CONNECTION...

        Comment Please

        Yusuf


No Subject
Posted on: 2008-07-22 03:33:38   By: Anonymous
 
A.Kishore,

Great document, it is really appreciated.

Thanks!
hsawwan




No Subject
Posted on: 2008-07-22 03:34:02   By: Anonymous
 
Yeah!!!...I agree. It's very clear, actual implementation.
Thanks to all :)





    Re:
    Posted on: 2008-07-30 22:52:28   By: Anonymous
     
    thanks for this helpfull documant

    fadi



Upgrade DB to 10g from 9i for Oracle Apps 11.5.10.2 in win2003 server
Posted on: 2009-01-07 15:11:28   By: Anonymous
 
Hi Kishore,

First of all thank u very much for providing us with valuable information..
Can u tell me how to upgrade the database from 9i to 10g in Apps 11i in win 2003 server environment..
Thanks again for your valuable contributions.


    Re: Upgrade DB to 10g from 9i for Oracle Apps 11.5.10.2 in win2003 server
    Posted on: 2009-03-17 06:59:02   By: Anonymous
     
    Nope, but it should be same

    Thanks
    A.Kishore


Upgrade from 11.5.9 to 11.5.10 and 10g db from 9i
Posted on: 2009-05-08 00:28:20   By: bruced
 
Hi Kishore,
Do you remember any special performance tuning that we have to do for these upgrades?
Thanks,


Thanks
Posted on: 2010-03-09 15:36:27   By: fkhalid
 
Thanks kishore, Your site is very very usefull for new apps dba's and also equally helpful for experienced dba's


upgradation-from-10203-to-11107-in-oracle-e-business-suite-115102
Posted on: 2010-07-06 06:00:41   By: akr14feb
 
http://onlineappsdba.com/index.php/2009/05/05/database-upgradation-from-10203-to-11107-in-oracle-e-business-suite-115102/


Oracle application Upgradation from 12.0.4 to 12.1.1
Posted on: 2010-07-15 18:58:08   By: AbdulRehman
 
Dear all if some already done Oracle EBS upgradation from 12.0.4 to 12.1.1 please share the document.
I will very much thank full.

Regards,
Abdul Rehman
abdul.rehman1971@hotmail.com


    Re: Oracle application Upgradation from 12.0.4 to 12.1.1
    Posted on: 2010-09-03 13:04:18   By: akr14feb
     
    Is this upgrde done, I have posted couple of upgrades which this knowledge and if you follow metalink notes, u can do the upgrade

    Thanks
    Kishore


    Re: Oracle application Upgradation from 12.0.4 to 12.1.1
    Posted on: 2011-05-30 09:59:21   By: akr14feb
     

    Follow the below notes -

    752619.1 - Oracle E-Business Suite Release 12.1.1 Maintenance Pack Installation Instructions

    Interoperability Notes EBS R12 with Database 11gR2 (Doc ID 1058763.1)


    For instructions on applying Oracle E-Business Suite 12.1.3 Release Update Pack
    (12.1.3), features and other information, please refer to My Oracle Support
    Knowledge Document - 1080973.1


    You need to upgrade to 12.1.1 then apply 12.1.3 Release Update Pack (Patch 9239090) -- No fresh installation software is available for 12.1.2/12.1.3


Upgrade R12.1.1 to R12.1.3
Posted on: 2010-09-01 17:45:55   By: akr14feb
 
Oracle E-Business Suite Release 12.1.3 Readme (Doc ID 1080973.1)

R12.1.1 to R12.1.3

9239089
9239090
9239095

9817770
9966055


Run AutoConfig on the APPL_TOP

perl /bin/admkappsutil.pl

Copy or FTP the appsutil.zip file to the .
Uncompress appsutil.zip under the .


Run AutoConfig on the .

perl adpreclone.pl dbTier
perl adpreclone.pl appsTier



    Re: Upgrade R12.1.1 to R12.1.3
    Posted on: 2011-05-31 15:31:51   By: Farhan
     
    i want to upgrade oracle database from 11.1.0.7 to 11.2 along with R 12.1.1 to R 12.1.13,
    Kindly share the database upgrade information document


Upgrading 11.5.10.2 to 12.1.3
Posted on: 2010-09-29 19:02:06   By: mehboob_cse
 
Hi Kishore-

I am a great admirer of you and Atul, you people have given lot to Oracle World and hope you will continue with your contributions, I am also working as Sr. Oracle Apps. DBA with Teradata Corporation.

I am in a Process of Upgrading our Production ERP env 11.5.10.2 to 12.1.3 , here are the Details of the same:

OS: Red Hat Enterprise Linux AS release 4 (Nahant Update 7).
Oracle RDMS: 10.2.0.4 (With RAC)
ERP Version : 11.5.10.2 with RUP6 (PCP enabled, 4 Nodes MT).

I need the detailed steps to Upgrade it, please provide me if any, i have already gone through your previous posts in which you have posted the Document to Upgrade 11.5.10.2 to 12.1.1 with oracle 10.2.0.3.

Please help me out on this.

Thanks
Mack



R12 DB(10.2.04.4) Migration from Linux Itanium to hpux Itanium
Posted on: 2011-05-18 15:17:57   By: salimka
 
Hi Kishore,

You are doing excellent job to help to us (All Apps DBAs) and I wish you a long healthy life.

By the way ,I am on old student of Ikon Infotech , currently working as a Sr.Apps DBA in Abu Dhabi.


I found a document for "Migrating Oracle E-Business Suite to Oracle Exadata Database Machine Using Oracle Data Pump".

We've a migration project to move EBS(12.1.1)database(10.2.0.4) running on RAC from linux itanium to hpux itanium. Could you please send me a document which explain the steps to proceed.


Regards,

Salim




Certification Matrix
Posted on: 2011-05-31 17:01:30   By: akr14feb
  Edited By: akr14feb
On: 2011-05-31 17:02:09
Complete Checklist for Manual Upgrades to 11gR2 (Doc ID 837570.1)

Source Database Target Database

9.2.0.8 or higher 11.2.x

10.1.0.5 or higher 11.2.x

10.2.0.2 or higher 11.2.x

11.1.0.6 or higher 11.2.x







need detailed document for upgrading to R12
Posted on: 2011-09-19 14:05:07   By: atulsun
 
Hi,

I am planning to upgrade our system to R12 .I did it in testing but that is not rac enviornment
Now i am planning to upgrade the PROD in RAC .Please provide me the doc so that i can plan accordingly.

system detail

oracle database --11.2.0.1 (RAC)

and application is two node and shared appl_top
11.5.10.2 (forms,http,cm and report server)

thanks
Atul Gupta
atul.sun@gmail.com


upgrade status
Posted on: 2012-04-06 19:06:01   By: akr14feb
 
SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;
http://www.jobacle.nl/?p=99
https://forums.oracle.com/forums/thread.jspa?threadID=669838


Migrate11.0 - R12
Posted on: 2012-04-25 16:49:11   By: em_zed
 
Hi,
i need your help. i want to migrate oracle Financial 11.0 to oracle R 12 version. please guide me how it can be done. waiting for your positive reply.

Regard,
Mirza Zeeshan Baig


    Re: Migrate11.0 - R12
    Posted on: 2012-04-25 17:53:31   By: em_zed
     
    i am using Microsoft platform.


Error - ORA-54015 : biv_b_age_h_sum_mv.xdf Failes with Duplicate Column Expression was Specified
Posted on: 2012-07-08 13:10:49   By: akr14feb
 
http://oracleupgrade.blogspot.com/2011/09/error-ora-54015-bivbagehsummvxdf-failes.html


pre-install patch
Posted on: 2012-07-16 21:06:44   By: akr14feb
 
http://www.unitask.com/oracledaily/2012/07/07/r12-1-1-preinstally-patches-to-update-the-1211-filesystem-before-the-upgrade/

R12.1.1 preinstall=y Patches to Update the 1211 filesystem before the Upgrade

Posted by: mswing on Jul 7, 2012 | No Comments

Apply only the patches for modules that are installed and in use. You may not need some of these patches.







7303029

Oracle E-Business Suite Consolidated Upgrade Patch 1 (CUP1) for R12.1.1





7648869

RCA: SUPPLIER CONTACT DETAILS MISSING SOME TITLE IN R12 FORM AFTER UPGRADE.

Payables



8230656

RCA BUG FOR BUG 7705629

Payments



8495719

EVENT CLASS OPTIONS ARE NOT MIGRATED FOR PAYABLES

E-Business Tax



8764069

POST USERMIGRATE TO HASH PASSWORDS, AFTER 12.1 UPG, FNDCPASS FAILS DECRYPT

Application Object Library



8781600

CFIX : CHANGE TRANSACTION_DATE IN XLA_EVENTS DURING AX UPGRADE

Subledger Accounting



8781600

CFIX : CHANGE TRANSACTION_DATE IN XLA_EVENTS DURING AX UPGRADE

Subledger Accounting



8850587

R12 UPGRAGE DEFAULT_PAYMENT_METHOD_CODE SETS TO WRONG VALUE

Payments



8850587

R12 UPGRAGE DEFAULT_PAYMENT_METHOD_CODE SETS TO WRONG VALUE

Payments



9082021

WRONG TAX CALCULATION FOR MIGRATED COMPOUNDED TAXES-CANADA

E-Business Tax



9202645

UPGRADE SCRIPT ZXEXEMPTMIG1.SQL LONG RUNNING

E-Business Tax



9290222

Some rules created from tax group migration are incorrectly enabled

E-Business Tax



9560244

DURING UPGRADE TO R12, SCRIPT 5408422.SQL IS TAKING 1,5 HOURS

Item Master



9726737

RCA: REVERSED TIPV AND NREC AMOUNTS ARE GOING WRONG WHILE UPGRADING

Payables



9903933

ZXGEOTORATESMIG8.SQL FAILS IN 12.1.1 UPGRADE

E-Business Tax



9918101

RCA:RECURRING INV TEMPLATE UPGRADE FROM 11I DOESN’T UPDATE EXT_BANK_ACCOUNT

Payables



10011700

RCA:NEGATIVE CCIDS FOR INTRACOMPANY RULES UPGRADE FROM 11I TO R12

Financials Common Modules



10029457

TAX CODES WHICH ARE USED IN TAX GROUPS UPGRADED FROM 11I TO R12 UNDER DIFFERENT REGIME

E-Business Tax



10041471

SKIP R12 UPGRADE CASH ACCOUNTING METHOD MIGRATION SCRIPTS ON ACCRUAL

Receivables



10041471

SKIP R12 UPGRADE CASH ACCOUNTING METHOD MIGRATION SCRIPTS ON ACCRUAL

Receivables



10163624

EMEA VAT UPG: JGZZVATUPGTRXDET.SQL TOOK 8+ HRS (PRE INSTALL)

Regional Localizations



10163753

APPSST11202: BIV_B_AGE_H_SUM_MV FAILS DURING INDEX CREATION

Service Intelligence



10163753

APPSST11202: BIV_B_AGE_H_SUM_MV FAILS DURING INDEX CREATION

Service Intelligence



10198811

R12 UPGRADE DRIVER FAILES WITH ORA-01400: CANNOT INSERT NULL INTO(

Subledger Accounting



10275581

QRE :R12.1.1 UPGRADE DRIVER (U6678700.DRV) FAILING FOR CSLKU.ODF

Service



10420245

Pre-Install: Upgrade script jaircvrtvdff.sql hangs during 12.1.1 upgrade

Financials For India



11653739

RCA : RCA FOR DUPLICATE PARTY SITES AFTER UPGRADE

Payables



11653739

RCA : RCA FOR DUPLICATE PARTY SITES AFTER UPGRADE

Payables



11767692

BUG TO STUB OUT GMDQCMI2.SQL AND GMDQCMIJ.sql

OPM Product Development



11847569

PRE INSTALL PATCH FOR 10077152, INDEXES ON AP_LIABILITY_BALANCE

Payables



12332819

In Oracle Purchasing, User was not able to approve a Complex PO with Advance Shipment.

Purchasing



12344218

Invoice lines upgrade (APLNUPGB.PLS) taking longer time to complete

Payables



12360278

In Oracle Purchasing, After patch 9593873, Note entered in Response section of notification was not getting updated in action history when document was rejected.

Purchasing



12372035

AP > ZXPOTRXMIGUPD.SQL FAILS WITH ERROR ORA-00001: UNIQUE CONSTRAINT VIOLATED

E-Business Tax



12382774

TAX GROUPS NOT CORRECTLY MIGRATED FROM R11I TO R12

E-Business Tax



12387835

MASTER ITEM MIGRATION FROM R11.5.7 TO R12 – SHELF LIFE NOTE MIGRATED TO ALL ORGS

Inventory Management



12422840

GMDMIG.SQL SHOULD NOT BE A PART OF 12.1

OPM Product Development



12553436

SLA HOT PATCH FAILS WITH ORA-00001 UNIQUE CONSTRAINT (PA.PA_PRIM_REP_LEGER_TMP_U

Project Costing



12578648

UPGRADE:APXLAPAY.SQL:PERFORMANCE PROBLEM WAS NOT FIXED

Payables



12648752

RCA : POPULATE CORRECT VALUE OF FRZ_FLG AND ASSOC_CHILD_FRZN_FLG DURING UPGRADE

E-Business Tax



12682665

Migrated tax groups were not working properly incase the tax group length is more than 40

E-Business Tax



12837833

RECOVERY RATE RULES ARE NOT GETTING HONORED

E-Business Tax



12837833

RECOVERY RATE RULES ARE NOT GETTING HONORED

E-Business Tax



12877002

INCORRECT TAXABLE BASE AMOUNT ON TAX DISTRIBUTIONS

Payables



12877002

INCORRECT TAXABLE BASE AMOUNT ON TAX DISTRIBUTIONS

Payables



12877611

RCA – CONTACT POINTS INACTIVATED WHEN CONTACTS ARE ENDDATED DURING UPGRADE

Payables



12912302

ECE PAYABLES VAT REGISTER DISPLAY NO DATA

Regional Localizations



12930626

1OFF:7216659:12.1.3:PA/GMS: R12 SLA UPGRADE ISSUE IF ENHANCED PERIOD PROC

Project Costing



12944782

COMPOUNDED TAX RATE IS NOT CALCULATED CORRECTLY IN R12

E-Business Tax



12944782

COMPOUNDED TAX RATE IS NOT CALCULATED CORRECTLY IN R12

E-Business Tax



12990345

GROUP BY ERROR HAPPENING IN APSTCA01.SQL

Payables



12990345

GROUP BY ERROR HAPPENING IN APSTCA01.SQL

Payables



12992125

RCA BUG: BANK ACCOUNT NAME IS APPENDED WITH OU NAME DURING UPGRADE.

Payments



13016846

RCA Upgraded untranferred accounting headers have incorrect GL transfer flag

Payables



13016846

RCA Upgraded untranferred accounting headers have incorrect GL transfer flag

Payables



13019385

AFTER R12 UPGRADE USER CANNOT OVERRIDE THE CALCULATED TAX LINES

E-Business Tax



13040251

Performance issue in upgrade accounting

Payables



13040251

Performance issue in upgrade accounting

Payables



13243594

AFTER MIGRATION ORDERS WITH STATUS OF RTW CANNOT BE TRANSACTED

OPM Logistics



13248921

EMEA VAT UPG: JGZZVATUPGTRXDET.SQL FAILS DURING UPGRADE TO R12.1.1 (PRE INSTALL)

Regional Localizations



13335019

UPGRADE: GMIG3MIB.SQL TAKING 8 HRS

OPM Inventory



13356426

MODIFY AX UPGRADE SCRIPT XLAAXUAR.SQL TO MAP INTRA ACCOUNTING_CLASS_CODE

Subledger Accounting



13356426

MODIFY AX UPGRADE SCRIPT XLAAXUAR.SQL TO MAP INTRA ACCOUNTING_CLASS_CODE

Subledger Accounting



13390676

APINTBAL.SQL SCRIPT RUNS FOR MORE THAN 48 HOURS DURING TEST UPGRADE

Subledger Accounting



13397299

UPGRADE: GMIG3MIB.SQL TAKING 8 HRS

Inventory Management



13403786

R12.1.1 UPGRADE DRIVER U6678700.DRV HANGS AT OZFUPFUT.SQL SINCE MORE THAN 24 HRS

Trade Management



13451293

RECOVERY RATE RULES ARE NOT GETTING HONORED

E-Business Tax



13451293

RECOVERY RATE RULES ARE NOT GETTING HONORED

E-Business Tax



13509912

CONSOLIDATED ROOT CAUSE CODEFIX: ACCOUNTING & UPGRADE RELATED ISSUES

Project Costing



13509912

CONSOLIDATED ROOT CAUSE CODEFIX: ACCOUNTING & UPGRADE RELATED ISSUES

Project Costing



13544907

RCA BUG:PAYEE UPG SCRIPT CREATES INACTIVE PAYEES FOR INACTIVE SUPPLIERS/SITES

Payments



13545598

In Oracle Purchasing,approval screen shows up only with buttons with no text on them

Purchasing



13557244

NEED TO UPGRADE ICMS,IPI DISTRIBUTIONS CREATED BY JL LOCALIZATION AS ITEM IN R12

Payables



13557244

NEED TO UPGRADE ICMS,IPI DISTRIBUTIONS CREATED BY JL LOCALIZATION AS ITEM IN R12

Payables



13577549

ATT MOBILITY UPGRADE: SCRIPT APSTCA01.SQL

Payables



13577549

ATT MOBILITY UPGRADE: SCRIPT APSTCA01.SQL

Payables



13598940

UPG:AR120CASHLNPU.SQL FAILED DURING ADPATCH ON XLA5584908.DRV

Receivables



13598940

UPG:AR120CASHLNPU.SQL FAILED DURING ADPATCH ON XLA5584908.DRV

Receivables



13684949

UNABLE TO SEE VOLUME TIERS AFTER 12.1 UPGRADE

Trade Management



13695167

Consolidated pre-upgrade fixes

Cash Management



13774403

RCA:INVOICE INCLUDES PREPAY FLAG IS NOT POPULATING FOR INV DISTS WHILE UPGRADE

Payables



13774403

RCA:INVOICE INCLUDES PREPAY FLAG IS NOT POPULATING FOR INV DISTS WHILE UPGRADE

Payables



13793279

Automatic Receipts gives ‘Instrument Assignment not Valid Payer’

Receivables



13793279

Automatic Receipts gives ‘Instrument Assignment not Valid Payer’

Receivables



13799611

In Oracle Purchasing, release form closed abruptly when distribution window was closed

Purchasing



13820304

PERFORMANCE HIT DURING UPGRADE TO 12.1.1 IN ZXTAXDEFMIGB.PLS

E-Business Tax



13833174

In Oracle Purchasing, BWC, Submission check fails for Complex Work Order with Fixed Price Services due to in consistant amount calculation at Line level and Distributions

Purchasing



13837821

PERFORMANCE ISSUE WITH APILNUPG.SQL SCRIPT DURING R12.1.1 UPGRADE-PART-2

Payables



13837821

PERFORMANCE ISSUE WITH APILNUPG.SQL SCRIPT DURING R12.1.1 UPGRADE-PART-2

Payables



13856969

This is the pre-req patch (to be applied Before Inline Migration) for GMF customers upgrading to R12.1

OPM Financials



13864126

APINTBAL.SQL NOT RE-RUNNABLE AND FAILS WITH U1 ERROR

Subledger Accounting



13917170

LOCATION Tax not migrated to R12 setup because of multiple Location Tax-Type Tax Codes in 11i setup

E-Business Tax



13917170

LOCATION Tax not migrated to R12 setup because of multiple Location Tax-Type Tax Codes in 11i setup

E-Business Tax



13931180

In Oracle Purchasing, get FRM-41056 error when enter item information on Quotations form

Purchasing



13978746

ACCRUAL LINES MISSING IN XDL AFTER PATCH 13444893:R12.AP.B

Payables



13978746

ACCRUAL LINES MISSING IN XDL AFTER PATCH 13444893:R12.AP.B

Payables



14026963

COUNTERS MIGRATION FROM 1159 TO R12 – “CSI_MIGRATE_CS_COUNTERS”(CSIMCTRB) ERRORS



Troubleshooting upgrade link -nice site
Posted on: 2012-07-28 06:08:03   By: akr14feb
 
http://oracleupgrade.blogspot.com/2011/09/ora-06512-at-appsadmv-while-running.html


upgrade link
Posted on: 2012-08-05 11:34:29   By: akr14feb
 
http://trutek.com/wordpress/page/2


Query to check upgrade version
Posted on: 2012-11-21 07:10:20   By: akr14feb
 
col VERSION format a10
col COMP_ID format a10
col COMP_NAME format a30
select COMP_ID,COMP_NAME,VERSION from dba_registry



Upgrade from 10.2.0.4 to 11.2.0.3.2 including Time Zone files
Posted on: 2012-12-22 15:49:18   By: akr14feb
 
http://www.dbspecialists.com/blog/uncategorized/upgrade-from-10204-to-112032-including-time-zone-files/


ORA-01722: invalid number
Posted on: 2012-12-22 16:15:11   By: akr14feb
 
Special Note for 11gR2
Starting with 11gR2, running pre-upgrade utility is mandatory and it will create or update registry$database.

Failure to run the pre-upgrade tool (utlu112i.sql) will result in the following error while running the catupgrd.sql script :
SQL> SELECT TO_NUMBER('MUST_BE_SAME_TIMEZONE_FILE_VERSION')
2 FROM registry$database
3 WHERE tz_version != (SELECT version from v$timezone_file);
SELECT TO_NUMBER('MUST_BE_SAME_TIMEZONE_FILE_VERSION')
*
ERROR at line 1:
ORA-01722: invalid number


After opening the database for upgrade, you need to check whether registry$database table exists or not.
SQL> describe registry$database

If registry$database exists, it should have TZ_VERSION column and an appropriate timezone value should be updated in the table. ( The value should be from V$TIMEZONE_FILE)

If table does not exist, has to be created as -
CREATE TABLE registry$database (
platform_id NUMBER,
platform_name VARCHAR2(101),
edition VARCHAR2(30),
tz_version NUMBER )

The table then needs to be inserted with values -
INSERT into registry$database
(platform_id, platform_name, edition, tz_version)
VALUES ((select platform_id from v$database),
(select platform_name from v$database),
NULL,
(select version from v$timezone_file));
*** Note, If table exists and there are some values in it, the entries are to be deleted and re-inserted. ( Because the table should only contain one row)