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

Oracle : Database Startup Time

 Oracle Instance Startup Time SET LINES 2000 SET PAGES 9999 COLUMN INSTANCE_NAME FOR A20 SELECT     instance_name,     to_char(startup_time,...