Welcome Guest ( Log In | Register )



Performance Tuning Reference poster
Oracle training in Linux 

Oracle training Weblogic Book
Easy Oracle Jumpstart
Oracle training & performance tuning books
Burleson Consulting Remote DB Administration
Reply to this topicStart new topic
> Create Oracle 10g database, Error while creating Oracle 10g database
post Mar 16 2017, 09:25 AM
Post #1

Advanced Member

Group: Members
Posts: 244
Joined: 8-September 14
Member No.: 49,938

Hi Burleson,

When I try to create Oracle 10g database, I get below error.
$ sqlplus /nolog
ORA-01804: failure to initialize timezone information

SP2-0152: ORACLE may not be functioning properly

Oracle note has suggested the following

The first thing to do is to check if ORA_TZFILE is set and if it is, remove it and restart the database and listener. Oracle will then try to load $ORACLE_HOME/oracore/zoneinfo/timezlrg.dat
If for some reason the file that Oracle wants to use is not available then this is the cause of the problem.
If the file is present then an alternative reason for the error could be that Oracle cannot load the file because of permission problems.

If all above is correct then it might be a .dat file that is corrupt.

$ pwd
$ ls -alrt
total 1050
-rw-r-----   1 oracle     oinstall      2299 Nov 14  2003 readme.txt
-rw-r-----   1 oracle     oinstall    384987 Feb  4  2006 timezlrg.dat
-rw-r-----   1 oracle     oinstall    149260 Feb  4  2006 timezone.dat
drwxr-x---   4 oracle     oinstall        96 Mar  9 04:04 ..
drwxr-x---   2 oracle     oinstall        96 Mar  9 04:06 .

Can we remove this .dat file (timezlrg.dat) to continue creating database? Could you please clarify?

Please note that this is testing environment. There is already 11g database is created.

Go to the top of the page
+Quote Post
post Mar 20 2017, 11:35 AM
Post #2

Advanced Member

Group: Members
Posts: 13,573
Joined: 26-January 04
Member No.: 13

Hi Harish,

>> ORA-01804 failure

See my notes here on the ORA-01804 error:


Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:


Lo-Fi Version Time is now: 20th October 2017 - 04:30 PM