ERROR:-
ORA-01804: failure to initialize timezone information
SP2-0152: ORACLE may not be functioning properly
Cause: -
The timezone information file was not properly read.
Solution:-
1. Set the ORA_TZFILE environment variable:
a. Set environment variable ORA_TZFILE:
$ export ORA_TZFILE=/home/oracle/app/oracle/product/12.1.0/oracore/zoneinfo/timezlrg_18.dat
[ora@sujeet ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Mar 6 10:27:42 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL>
ORA-01804: failure to initialize timezone information
SP2-0152: ORACLE may not be functioning properly
Cause: -
The timezone information file was not properly read.
Solution:-
1. Set the ORA_TZFILE environment variable:
a. Set environment variable ORA_TZFILE:
$ export ORA_TZFILE=/home/oracle/app/oracle/product/12.1.0/oracore/zoneinfo/timezlrg_18.dat
[ora@sujeet ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Mar 6 10:27:42 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL>
No comments:
Post a Comment