Thursday 28 September 2017

DB : ORA-01804: failure to initialize timezone information

Error:

[oracle@localhost ~]$ sqlplus / as sysdba
ERROR:
ORA-01804: failure to initialize timezone information


SP2-0152: ORACLE may not be functioning properly


Solution:

[oracle@localhost ~]$ unset ORA_TZFILE

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Sep 28 15:46:48 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL>

No comments:

Post a Comment

SQL Developer displaying Junk characters (??????)

Change the Encoding in SQL Developer Preferences as below Tools --> Preferences --> Environment --> Encoding --> UTF...