Sunday, July 11, 2021

DB Upgrade to 19c | preupgrade_fixups.sql fails with error

 Issue : 

SQL> @/u02/app/oracle/cfgtoollogs/XXXX/preupgrade/2021-07-07205429/naerppch_stby/preupgrade_fixups.sql

DECLARE

*

ERROR at line 1:

ORA-29284: file read error

ORA-06512: at "SYS.UTL_FILE", line 106

ORA-06512: at "SYS.UTL_FILE", line 746

ORA-06512: at "SYS.DBMS_PREUP", line 3352

ORA-06512: at "SYS.DBMS_PREUP", line 10503

ORA-06512: at line 13



Fix :

$echo $ORA_NLS10 

$  unset ORA_NLS10 and run the script again.

$ echo $ORA_NLS10 

No comments:

Post a Comment

Database Options/Management Packs Usage Reporting for Oracle Databases 11.2 and later (Doc ID 1317265.1)

  Database Options/Management Packs Usage Report You can determine whether an option is currently in use in a database by running options_pa...