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

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 ONE Support launchpad (Login required).

Search for additional results

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