9 Replies Latest reply on Jul 7, 2014 5:35 PM by Srini Chavali-Oracle

    ORA-01804: failure to initialize timezone information in DB11.2.0.4

    Ahmad-Hamdan

      Dear Experts,

       

      I have installed Oracle DB 11..2.0.4 in order to upgrade my current DB 11.1.0.7 to 11.2.0.4.

       

      when I try to connect to DB I get the following errors

       

      [oraerp@ebsvm admin]$ sqlplus / as sysdba

      ERROR:

      ORA-01804: failure to initialize timezone information

       

       

       

       

      SP2-0152: ORACLE may not be functioning properly

      [oraerp@ebsvm admin]$ sqlplus / as sysdba

      ERROR:

      ORA-01804: failure to initialize timezone information


      SP2-0152: ORACLE may not be functioning properly


      I am using Oracle linux 86 and I have installed R12.1.1 application.


      Regards,


      Ahmad,




        • 1. Re: ORA-01804: failure to initialize timezone information in DB11.2.0.4
          Srini Chavali-Oracle

          Please identify the MOS Doc you are following for this upgrade process. Pl see troubleshooting steps in MOS Doc 365558.1

          • 3. Re: ORA-01804: failure to initialize timezone information in DB11.2.0.4
            Ahmad-Hamdan

            I couldnt connect to DB to execute the scripts mentioned in the Doc

            • 4. Re: ORA-01804: failure to initialize timezone information in DB11.2.0.4
              Srini Chavali-Oracle

              This is the correct document to follow. Which step in this document are you ? Pl post the output of command "env | sort" just before the "sqlplus / as sysdba" command is issued above

              1 person found this helpful
              • 5. Re: ORA-01804: failure to initialize timezone information in DB11.2.0.4
                Ahmad-Hamdan

                I read the Doc, I reached to step 3, as my DB is 11.2.0.4. 

                When I apply the env | sort command, I see that ORA_TZFILE variable is set as below.

                 

                ORA_TZFILE=/u01/orar12/db/tech_st/11.2.0/oracore/zoneinfo/timezlrg.dat

                Then the document in form me to go to Doc NOTE:977512.1.

                 

                I stopped here.

                 

                Regards,

                1 person found this helpful
                • 6. Re: ORA-01804: failure to initialize timezone information in DB11.2.0.4
                  Srini Chavali-Oracle

                  I read the Doc, I reached to step 3, as my DB is 11.2.0.4.

                  Step 3 in the doc is changing database context file values - the 11.2.0.4 software install are Steps 5 and 6. Have you completed the install of the 11.2.0.4 software ?

                   

                  When I apply the env | sort command, I see that ORA_TZFILE variable is set as below.

                  Pl post the entire contents of the output of "env | sort" as requested.

                   

                  Then the document in form me to go to Doc NOTE:977512.1.

                   

                  I stopped here.

                  Pl identify which is "here" in this doc.

                   

                  HTH
                  Srini

                  • 7. Re: ORA-01804: failure to initialize timezone information in DB11.2.0.4
                    Ahmad-Hamdan

                    Step 3 in the doc is changing database context file values - the 11.2.0.4 software install are Steps 5 and 6. Have you completed the install of the 11.2.0.4 software ?

                    Yes I have completed installation of the software.


                    Pl post the entire contents of the output of "env | sort" as requested.


                    here is the output


                    ADJREOPTS=-Xms128M -Xmx512M

                    ADJVAPRG=/u01/orar12/db/tech_st/11.2.0/appsutil/jre/bin/java

                    ADPERLPRG=/u01/orar12/db/tech_st/11.2.0/perl/bin/perl

                    COLORTERM=gnome-terminal

                    CONTEXT_FILE=/u01/orar12/db/tech_st/11.2.0/appsutil/VIS_ebsvm.xml

                    CONTEXT_NAME=VIS_ebsvm

                    CVS_RSH=ssh

                    DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-OAgXpPFr9q,guid=66695e1a5af0f722f57b450053b8a0e6

                    DESKTOP_SESSION=default

                    DESKTOP_STARTUP_ID=

                    DISPLAY=:0.0

                    G_BROKEN_FILENAMES=1

                    GDMSESSION=default

                    GDM_XSERVER_LOCATION=local

                    GNOME_DESKTOP_SESSION_ID=Default

                    GNOME_KEYRING_SOCKET=/tmp/keyring-rXi2Ux/socket

                    GTK_RC_FILES=/etc/gtk/gtkrc:/root/.gtkrc-1.2-gnome2

                    HISTSIZE=1000

                    HOME=/home/oraerp

                    HOSTNAME=ebsvm.oracleerp.com

                    INPUTRC=/etc/inputrc

                    LANG=en_US.UTF-8

                    LD_LIBRARY_PATH=/u01/orar12/db/tech_st/11.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/orar12/db/tech_st/11.2.0/lib:/usr/dt/lib:/u01/orar12/db/tech_st/11.2.0/ctx/lib

                    LESSOPEN=|/usr/bin/lesspipe.sh %s

                    LIBPATH=/u01/orar12/db/tech_st/11.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/orar12/db/tech_st/11.2.0/lib:/usr/dt/lib:/u01/orar12/db/tech_st/11.2.0/ctx/lib

                    LINK_CNTRL=

                    LOGNAME=oraerp

                    LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:

                    MAIL=/var/spool/mail/root

                    NLS_DATE_FORMAT=DD-MON-RR

                    NLS_LANG=American_America.AL32UTF8

                    NLS_NUMERIC_CHARACTERS=.,

                    NLS_SORT=binary

                    OLDPWD=/u01/orar12/db/tech_st/11.2.0/appsutil/bin

                    ORACLE_HOME=/u01/orar12/db/tech_st/11.2.0

                    ORACLE_SID=VIS

                    ORA_NLS10=/u01/orar12/db/tech_st/11.2.0/nls/data/9idata

                    ORA_TZFILE=/u01/orar12/db/tech_st/11.2.0/oracore/zoneinfo/timezlrg.dat

                    PATH=/u01/orar12/db/tech_st/11.2.0/perl/bin:/u01/orar12/db/tech_st/11.2.0/bin:/usr/bin:/usr/sbin:/u01/orar12/db/tech_st/11.2.0/appsutil/jre/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/u01/orar12/db/tech_st/11.2.0/OPatch:/u01/orar12/db/tech_st/11.2.0/perl/bin:/u01/orar12/db/tech_st/11.2.0/bin:/usr/bin:/usr/sbin:/u01/orar12/db/tech_st/11.2.0/appsutil/jre/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/u01/orar12/db/tech_st/11.2.0/OPatch:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin:.:.

                    PERL5LIB=/u01/orar12/db/tech_st/11.2.0/perl/lib/5.8.3:/u01/orar12/db/tech_st/11.2.0/perl/lib/site_perl/5.8.3:/u01/orar12/db/tech_st/11.2.0/appsutil/perl

                    PWD=/u01/orar12/db/tech_st/11.2.0/rdbms/admin

                    SESSION_MANAGER=local/ebsvm.oracleerp.com:/tmp/.ICE-unix/4246

                    SHELL=/bin/bash

                    SHLIB_PATH=/u01/orar12/db/tech_st/11.2.0/lib:/usr/lib:/u01/orar12/db/tech_st/11.2.0/ctx/lib

                    SHLVL=3

                    SSH_AGENT_PID=4282

                    SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass

                    SSH_AUTH_SOCK=/tmp/ssh-kzJTPH4246/agent.4246

                    TERM=xterm

                    TNS_ADMIN=/u01/orar12/db/tech_st/11.2.0/network/admin/VIS_ebsvm

                    USER=oraerp

                    _=/usr/bin/env

                    WINDOWID=20999133

                    XMODIFIERS=@im=none

                    1 person found this helpful