SAP Knowledge Base Article - Preview

2457531 - Error “ORA-01804: failure to initialize timezone information” while restore from backup after homogeneous system copy


SWPM shows below error in Phase 16 ("Adapt database schema") of a homogeneous System Copy with Backup/Restore method:


ora_sql_results.log shows below error:

     37    dbms_output.put_line('using following Parameters: ');
     38    dbms_output.put_line('.');
     39    dbms_output.put_line('.  Oracle Version:                     '||:sVersion);
     40    dbms_output.put_line('.  Parametervalue os_authent_prefix:   '||:sPrefix);
     41    dbms_output.put_line('.  Schema Id:                          '||:sSchemaId);
     42    dbms_output.put_line('.  Database User (Schema):             '||:sSchema);
     43    dbms_output.put_line('.  SAP R/3 Administrator:              '||:sR3user);
     44    dbms_output.put_line('.  SAP R/3 Serviceuser:                '||:sSvcuser);
     45    dbms_output.put_line('.  ASM Parameter:                      '||:sIsASM);
     46    dbms_output.put_line('.  Create SAPUSER env:                 '||:sIsSapuser);
     47    if :bONNT = 1 then
     48    dbms_output.put_line('.  Domain/Host:                        '||:sDomain);
     49  end if;
     50     dbms_output.put_line('.');
     51  end;
     52  end;
     53  /
    ERROR at line 1:
    ORA-01804: failure to initialize timezone information



  • Oracle RDBMS Release and above
  • SAP Release independent


SAP NetWeaver all versions


ORA-01804, Timezone problem, Restore backup. , KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.