ERROR:-
ORA-01804: failure to initializetimezone information
SP2-0152: ORACLE may not be functioning properly
Cause: -
Thetimezone information file was not properly read.
Solution:-
1. Set the ORA_TZFILE environment variable:
a. Set environment variable ORA_TZFILE:
export ORA_TZFILE=/u01/app/oracle/PROD/db /tech_st/11.2.0.4 /oracore /zoneinfo/timezlrg_14.dat
[oracle@ebsdbs ] $ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Mar 31 03:42:51 2020
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
ORA-01804: failure to initialize
SP2-0152: ORACLE may not be functioning properly
Cause: -
The
Solution:-
1. Set the ORA_TZFILE environment variable:
a. Set environment variable ORA_TZFILE:
[oracle@ebs
SQL*Plus: Release 11.2.0.4.0 Production on Tue Mar 31 03:42:51 2020
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
No comments:
Post a Comment