SAP Knowledge Base Article - Preview

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

Symptom

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

 dd.jpg

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  /
    begin
    *
    ERROR at line 1:
    ORA-01804: failure to initialize timezone information


Read more...

Environment

  • Oracle RDBMS Release 9.2.0.5 and above
  • SAP Release independent

Product

SAP NetWeaver all versions

Keywords

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 for Me (Login required).

Search for additional results

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