13 Replies Latest reply: May 17, 2009 1:09 PM by Nicolas.Gasparotto RSS

    ./lsnrctl start effort- Message 1070 not found;

    701901
      Message 1070 not found; No message file for product=network, facility=TNSTNS-125 error when trying to start the DB listiner?

      oracle@linuxsrv:/u01/app/oracle/OraHome/bin> ./lsnrctl start

      LSNRCTL for Linux: Version 10.1.0.4.2 - Production on 16-JUN-2009 17:16:15

      Copyright (c) 1991, 2004, Oracle. All rights reserved.

      Message 1070 not found; No message file for product=network, facility=TNSTNS-125 45: Message 12545 not found; No message file for product=network, facility=TNS
      TNS-12560: Message 12560 not found; No message file for product=network, facili ty=TNS
      TNS-00515: Message 515 not found; No message file for product=network, facilit y=TNS
      Linux Error: 2: No such file or directory
      oracle@linuxsrv:/u01/app/oracle/OraHome/bin>

      OAS environment settings

      LESS=-M -I
      MACHTYPE=i686-suse-linux
      LOGNAME=oracle
      XDG_DATA_DIRS=/usr/share:/etc/opt/kde3/share:/opt/kde3/share
      LESSOPEN=lessopen.sh %s
      INFOPATH=/usr/local/info:/usr/share/info:/usr/info
      ORA_NLS33=/u01/app/oracle/as10gHome/lib:/u01/app/oracle/bin:/u01/app/oracle:/u01/app/midtier:/u01/app/midtier/bin:/u01/app/midtier/as10gHome/opmm/lib:/OraHome/lib:/OraHome/opmn/lib/nls/admin/data
      DISPLAY=192.168.2.9:0.0
      ORACLE_HOME=/u01/app/oracle/as10gHome/lib:/u01/app/oracle/bin:/u01/app/oracle:/u01/app/midtier:/u01/app/midtier/bin:/u01/app/midtier/as10gHome/opmm/lib:/OraHome/lib:/OraHome/opmn/lib
      LESSCLOSE=lessclose.sh %s %s
      G_BROKEN_FILENAMES=1
      COLORTERM=1
      _=/usr/bin/env
      OLDPWD=/u01/app/oracle/OraHome
      oracle@linuxsrv:/u01/app/oracle/OraHome/bin> vi /home/oracle/.bash_profile
      TMP=/usr/tmp
      DISPLAY=192.168.2.9:0.0
      ORACLE_BASE=/u01/app/oracle
      ORACLE_MID=/u01/app/midtier
      #ORACLE_OCA=/u01/app/OCA
      LD_LIBRARY_PATH=$ORACLE_BASE/OraHome/opmn/lib:$ORACLE_BASE/OraHome/lib:$ORACLE_MID/as10gHome/opmn/lib:$ORACLE_MID/as10gHome/lib:$PATH
      ORACLE_HOME=$ORACLE_BASE/as10gHome/lib:$ORACLE_BASE/bin:$ORACLE_BASE:$ORACLE_MID:$ORACLE_MID/bin:$ORACLE_MID/as10gHome/opmm/lib:$ORACLE_HOME/OraHome/lib:$ORACLE_HOME/OraHome/opmn/lib
      ORACLE_SID=orcl
      LISTENER=$ORACLE_HOME/bin/lsnrctl
      TNS_ADMIN=$ORACLE_HOME/network/admin
      ORA_NLS33=$ORACLE_HOME/nls/admin/data
      PATH=/usr/local/bin:/usr/bin:/usr/local2/bin:/usr:$ORACLE_HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/dcm/bin:$ORACLE_HOME/opmn/bin/$ORACLE_HOME/lib:$PATH
      LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:$ORACLE_HOME/opmn/lib:$ORACLE_HOME/dcm/bin:$ORACLE_HOME/opmn/bin:$ORACLE_HOME/lib:$PATH
      export TMP ORACLE_BASE ORACLE_HOME ORACLE_SID ORACLE_MID ORACLE_OCA LD_LIBRARY_PATH LISTENER DISPLAY PATH TNS_ADMIN ORA_NLS33

      Any suggestion in resolving?
        • 1. Re: ./lsnrctl start effort- Message 1070 not found;
          Aman....
          This error is a fairly common error arising due to the wrong setting of Oracle Home. You have done a lot of mixing of various things in your environment variables. Do one thing, in a session, set Oracle Home to the database's home, set the database sid and than try to start the listener. Show the results with a direct cut/paste from the command prompt.

          HTH
          Aman....
          • 2. Re: ./lsnrctl start effort- Message 1070 not found;
            Nicolas.Gasparotto
            To the OP,
            user10463332 wrote:
            ...
            LD_LIBRARY_PATH=$ORACLE_BASE/OraHome/opmn/lib:$ORACLE_BASE/OraHome/lib:$ORACLE_MID/as10gHome/opmn/lib:$ORACLE_MID/as10gHome/lib:$PATH
            ORACLE_HOME=$ORACLE_BASE/as10gHome/lib:$ORACLE_BASE/bin:$ORACLE_BASE:$ORACLE_MID:$ORACLE_MID/bin:$ORACLE_MID/as10gHome/opmm/lib:$ORACLE_HOME/OraHome/lib:$ORACLE_HOME/OraHome/opmn/lib
            ORACLE_SID=orcl
            LISTENER=$ORACLE_HOME/bin/lsnrctl
            TNS_ADMIN=$ORACLE_HOME/network/admin
            ORA_NLS33=$ORACLE_HOME/nls/admin/data
            PATH=/usr/local/bin:/usr/bin:/usr/local2/bin:/usr:$ORACLE_HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/dcm/bin:$ORACLE_HOME/opmn/bin/$ORACLE_HOME/lib:$PATH
            LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:$ORACLE_HOME/opmn/lib:$ORACLE_HOME/dcm/bin:$ORACLE_HOME/opmn/bin:$ORACLE_HOME/lib:$PATH
            export TMP ORACLE_BASE ORACLE_HOME ORACLE_SID ORACLE_MID ORACLE_OCA LD_LIBRARY_PATH LISTENER DISPLAY PATH TNS_ADMIN ORA_NLS33
            Something is looking wrong here. The variable $ORACLE_BASE is not translated to its value. That means none of the parameters above knows what this variable is pointing to. How did you set the ORACLE_HOME variable in your .profile or .bash_profile ?
            Lastly, it is rather strange to set a ORACLE_HOME to more than one path directory, generally, ORACLE_HOME is pointing to one and only one Oracle home directoy. Because of that, your next env variables based on $ORACLE_HOME cannot defined the string i.e. $ORACLE_HOME/bin/lsnrctl...
            Redefine properly your variable ORACLE_HOME=... to your Oracle home directory (the one you want to use now) and that should be better.

            Aman,
            set the database sid and than try to start the listener
            What the SID has to do here ?

            Nicolas.
            • 3. Re: ./lsnrctl start effort- Message 1070 not found;
              Aman....
              Aman,
              set the database sid and than try to start the listener
              What the SID has to do here ?
              Nothing, late night effect may be it is :( , apologies!

              Regards
              Aman....
              • 4. Re: ./lsnrctl start effort- Message 1070 not found;
                701901
                trying to get a status output.. get same error..

                oracle@linuxsrv:/u01/app/oracle/OraHome/bin> ./lsnrctl status

                LSNRCTL for Linux: Version 10.1.0.4.2 - Production on 16-JUN-2009 18:50:29

                Copyright (c) 1991, 2004, Oracle. All rights reserved.

                Message 1053 not found; No message file for product=network, facility=TNSTNS-12541: Message 12541 not found; No message file for product=network, facility=TNS
                TNS-12560: Message 12560 not found; No message file for product=network, facility=TNS
                TNS-00511: Message 511 not found; No message file for product=network, facility=TNS
                Linux Error: 111: Connection refused
                • 5. Re: ./lsnrctl start effort- Message 1070 not found;
                  Nicolas.Gasparotto
                  I edited my previous post, please, redefine ORACLE_HOME to one and only one path directory, the Oracle home you want to use right now in your .profile, disconnect, reconnect, check your env variables, and retry.
                  Before given an answer afterwards here, paste the env variables values and result.

                  Nicolas.
                  • 6. Re: ./lsnrctl start effort- Message 1070 not found;
                    701901
                    Hi- Aman and Nicolas,

                    can you tell how to set the Database sid? I thought I had done that?


                    Oracle_SID=orcl

                    export Oracle_sid?

                    in my oracle bash profile?


                    oracle@linuxsrv:/u01/app/oracle/OraHome/bin> vi /home/oracle/.bash_profile
                    TMP=/usr/tmp
                    DISPLAY=192.168.2.9:0.0
                    ORACLE_BASE=/u01/app/oracle
                    ORACLE_MID=/u01/app/midtier
                    #ORACLE_OCA=/u01/app/OCA
                    LD_LIBRARY_PATH=$ORACLE_BASE/OraHome/opmn/lib:$ORACLE_BASE/OraHome/lib:$ORACLE_MID/as10gHome/opmn/lib:$ORACLE_MID/as10gHome/lib:$PATH
                    ORACLE_HOME=$ORACLE_BASE/as10gHome/lib:$ORACLE_BASE/bin:$ORACLE_BASE:$ORACLE_MID:$ORACLE_MID/bin:$ORACLE_MID/as10gHome/opmm/lib:$ORACLE_HOME/OraHome/lib:$ORACLE_HOME/OraHome/opmn/lib
                    ORACLE_SID=orcl
                    LISTENER=$ORACLE_HOME/bin/lsnrctl
                    TNS_ADMIN=$ORACLE_HOME/network/admin
                    ORA_NLS33=$ORACLE_HOME/nls/admin/data
                    PATH=/usr/local/bin:/usr/bin:/usr/local2/bin:/usr:$ORACLE_HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/dcm/bin:$ORACLE_HOME/opmn/bin/$ORACLE_HOME/lib:$PATH
                    LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:$ORACLE_HOME/opmn/lib:$ORACLE_HOME/dcm/bin:$ORACLE_HOME/opmn/bin:$ORACLE_HOME/lib:$PATH
                    export TMP ORACLE_BASE ORACLE_HOME ORACLE_SID ORACLE_MID ORACLE_OCA LD_LIBRARY_PATH LISTENER DISPLAY PATH TNS_ADMIN ORA_NLS33

                    ~
                    ~
                    ~
                    ~
                    ~
                    ~
                    • 7. Re: ./lsnrctl start effort- Message 1070 not found;
                      Aman....
                      Well , once again apologies for mentioning SID in my last reply. I didn't edit it but its not needed if you are just willing to start listener. As mentioned already, set the correct Oracle home pointing towards to the correct folder where your oracle software files are located. Don't mix it with anything/any other folder. You can set the variables like,
                      export ORACLE_HOME=/u01/app/oracle/products/10.2.0/db_1
                      Do this and show us the results of the command.

                      HTH
                      Aman....
                      • 8. Re: ./lsnrctl start effort- Message 1070 not found;
                        701901
                        ok. I had rem out the other oracle instance or component install on the same machine. What I'll do is virualized another machine and install it there to avoid any conflicts; port, oracle home etc...

                        Below is my bash profile environment variables settings..
                        TMP=/usr/tmp
                        DISPLAY=192.168.2.9:0.0
                        ORACLE_BASE=/u01/app/oracle
                        ORACLE_MID=/u01/app/midtier
                        #ORACLE_OCA=/u01/app/OCA
                        LD_LIBRARY_PATH=$ORACLE_BASE/OraHome/opmn/lib:$ORACLE_BASE/OraHome/lib:$ORACLE_MID/as10gHome/opmn/lib:$ORACLE_MID/as10gHome/lib:$PATH
                        #ORACLE_HOME=$ORACLE_BASE/as10gHome/lib:$ORACLE_BASE/bin:$ORACLE_BASE:$ORACLE_MID:$ORACLE_MID/bin:$ORACLE_MID/as10gHome/opmm/lib:$ORACLE_HOME/OraHome/lib:$ORACLE_HOME/OraHome/opmn/lib
                        ORACLE_HOME=$ORACLE_BASE/as10gHome
                        ORACLE_SID=orcl
                        LISTENER=$ORACLE_HOME/bin/lsnrctl
                        TNS_ADMIN=$ORACLE_HOME/network/admin
                        ORA_NLS33=$ORACLE_HOME/nls/admin/data
                        PATH=/usr/local/bin:/usr/bin:/usr/local2/bin:/usr:$ORACLE_HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/dcm/bin:$ORACLE_HOME/opmn/bin/$ORACLE_HOME/lib:$PATH
                        LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:$ORACLE_HOME/opmn/lib:$ORACLE_HOME/dcm/bin:$ORACLE_HOME/opmn/bin:$ORACLE_HOME/lib:$PATH
                        export TMP ORACLE_BASE ORACLE_HOME ORACLE_SID ORACLE_MID ORACLE_OCA LD_LIBRARY_PATH LISTENER DISPLAY PATH TNS_ADMIN ORA_NLS33

                        ~
                        ~
                        ~
                        ~
                        ~
                        • 9. Re: ./lsnrctl start effort- Message 1070 not found;
                          701901
                          exit and log back..

                          oracle@linuxsrv:~> env
                          LESSKEY=/etc/lesskey.bin
                          NNTPSERVER=news
                          INFODIR=/usr/local/info:/usr/share/info:/usr/info
                          MANPATH=/usr/local/man:/usr/share/man:/opt/dx/man
                          HOSTNAME=linuxsrv
                          XKEYSYMDB=/usr/share/X11/XKeysymDB
                          HOST=linuxsrv
                          SHELL=/bin/bash
                          TERM=xterm
                          PROFILEREAD=true
                          HISTSIZE=1000
                          LISTENER=/u01/app/oracle/as10gHome/bin/lsnrctl
                          ORACLE_MID=/u01/app/midtier
                          GNOME_PATH=:/usr
                          MORE=-sl
                          USER=oracle
                          LD_LIBRARY_PATH=/u01/app/oracle/OraHome/opmn/lib:/u01/app/oracle/OraHome/lib:/u01/app/midtier/as10gHome/opmn/lib:/u01/app/midtier/as10gHome/lib:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/opt/kde3/bin:/usr/lib/mit/bin:/usr/lib/mit/sbin:/u01/app/oracle/as10gHome/lib:/u01/app/oracle/as10gHome/opmn/lib:/u01/app/oracle/as10gHome/dcm/bin:/u01/app/oracle/as10gHome/opmn/bin:/u01/app/oracle/as10gHome/lib:/usr/local/bin:/usr/bin:/usr/local2/bin:/usr:/u01/app/oracle/as10gHome/bin:/u01/app/oracle/as10gHome/bin:/u01/app/oracle/as10gHome/dcm/bin:/u01/app/oracle/as10gHome/opmn/bin//u01/app/oracle/as10gHome/lib:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/opt/kde3/bin:/usr/lib/mit/bin:/usr/lib/mit/sbin
                          LS_COLORS=no=00:fi=00:di=01;34:ln=00;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=41;33;01:ex=00;32:*.cmd=00;32:*.exe=01;32:*.com=01;32:*.bat=01;32:*.btm=01;32:*.dll=01;32:*.tar=00;31:*.tbz=00;31:*.tgz=00;31:*.rpm=00;31:*.deb=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.lzma=00;31:*.zip=00;31:*.zoo=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.tb2=00;31:*.tz2=00;31:*.tbz2=00;31:*.xz=00;31:*.avi=01;35:*.bmp=01;35:*.fli=01;35:*.gif=01;35:*.jpg=01;35:*.jpeg=01;35:*.mng=01;35:*.mov=01;35:*.mpg=01;35:*.pcx=01;35:*.pbm=01;35:*.pgm=01;35:*.png=01;35:*.ppm=01;35:*.tga=01;35:*.tif=01;35:*.xbm=01;35:*.xpm=01;35:*.dl=01;35:*.gl=01;35:*.wmv=01;35:*.aiff=00;32:*.au=00;32:*.mid=00;32:*.mp3=00;32:*.ogg=00;32:*.voc=00;32:*.wav=00;32:
                          ORACLE_SID=orcl
                          XNLSPATH=/usr/share/X11/nls
                          ENV=/etc/bash.bashrc
                          ORACLE_BASE=/u01/app/oracle
                          HOSTTYPE=i386
                          FROM_HEADER=
                          PAGER=less
                          CSHEDIT=emacs
                          XDG_CONFIG_DIRS=/etc/xdg
                          MINICOM=-c on
                          TNS_ADMIN=/u01/app/oracle/as10gHome/network/admin
                          GNOMEDIR=/usr
                          MAIL=/var/spool/mail/oracle
                          PATH=/usr/local/bin:/usr/bin:/usr/local2/bin:/usr:/u01/app/oracle/as10gHome/bin:/u01/app/oracle/as10gHome/bin:/u01/app/oracle/as10gHome/dcm/bin:/u01/app/oracle/as10gHome/opmn/bin//u01/app/oracle/as10gHome/lib:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/opt/kde3/bin:/usr/lib/mit/bin:/usr/lib/mit/sbin
                          CPU=i686
                          INPUTRC=/etc/inputrc
                          PWD=/home/oracle
                          LANG=en_US.UTF-8
                          PYTHONSTARTUP=/etc/pythonstart
                          QT_SYSTEM_DIR=/usr/share/desktop-data
                          SHLVL=1
                          HOME=/home/oracle
                          LESS_ADVANCED_PREPROCESSOR=no
                          OSTYPE=linux
                          LS_OPTIONS=-N --color=tty -T 0
                          XCURSOR_THEME=DMZ
                          WINDOWMANAGER=/usr/bin/startkde
                          TMP=/usr/tmp
                          G_FILENAME_ENCODING=@locale,UTF-8,ISO-8859-15,CP1252
                          LESS=-M -I
                          MACHTYPE=i686-suse-linux
                          LOGNAME=oracle
                          XDG_DATA_DIRS=/usr/share:/etc/opt/kde3/share:/opt/kde3/share
                          LESSOPEN=lessopen.sh %s
                          INFOPATH=/usr/local/info:/usr/share/info:/usr/info
                          ORA_NLS33=/u01/app/oracle/as10gHome/nls/admin/data
                          DISPLAY=192.168.2.9:0.0
                          ORACLE_HOME=/u01/app/oracle/as10gHome
                          LESSCLOSE=lessclose.sh %s %s
                          G_BROKEN_FILENAMES=1
                          COLORTERM=1
                          _=/usr/bin/env
                          oracle@linuxsrv:~>
                          • 10. Re: ./lsnrctl start effort- Message 1070 not found;
                            Nicolas.Gasparotto
                            Well,
                            1. You have "LD_LIBRARY_PATH=$ORACLE_BASE..."
                            You cannot set the LD_LIBRARY_PATH containing $ORACLE_HOME because at this very moment $ORACLE_HOME is not defined

                            2. You have "ORACLE_HOME=$ORACLE_BASE..."
                            But at this moment $ORACLE_HOME is not defined ! What do you expect ?

                            3. You have "ORACLE_HOME=$ORACLE_BASE/as10gHome/lib:$ORACLE_BASE/bin:..." then "LISTENER=$ORACLE_HOME/bin/lsnrctl"
                            You have more than one path directory in ORACLE_HOME, what the LISTENER value are you expecting to get ?

                            You seriously need to revisit your .bash_profile to a proper way.
                            Please, find out more :
                            http://download.oracle.com/docs/cd/B19306_01/install.102/b15662/pre_install.htm#sthref219

                            Nicolas.
                            • 11. Re: ./lsnrctl start effort- Message 1070 not found;
                              701901
                              still get the same error..

                              oracle@linuxsrv:/u01/app/oracle/OraHome/bin> ./lsnrctl start

                              LSNRCTL for Linux: Version 10.1.0.4.2 - Production on 16-JUN-2009 19:05:00

                              Copyright (c) 1991, 2004, Oracle. All rights reserved.

                              Message 1070 not found; No message file for product=network, facility=TNSTNS-12545: Message 12545 not found; No message file for product=network, facility=TNS
                              TNS-12560: Message 12560 not found; No message file for product=network, facility=TNS
                              TNS-00515: Message 515 not found; No message file for product=network, facility=TNS
                              Linux Error: 2: No such file or directory
                              oracle@linuxsrv:/u01/app/oracle/OraHome/bin> ./lsnrctl status

                              LSNRCTL for Linux: Version 10.1.0.4.2 - Production on 16-JUN-2009 19:05:08

                              Copyright (c) 1991, 2004, Oracle. All rights reserved.

                              Message 1053 not found; No message file for product=network, facility=TNSTNS-12541: Message 12541 not found; No message file for product=network, facility=TNS
                              TNS-12560: Message 12560 not found; No message file for product=network, facility=TNS
                              TNS-00511: Message 511 not found; No message file for product=network, facility=TNS
                              Linux Error: 111: Connection refused
                              • 12. Re: ./lsnrctl start effort- Message 1070 not found;
                                Nicolas.Gasparotto
                                user10463332 wrote:
                                exit and log back..
                                I'm not sure how to understand it... and what ORACLE_HOME path directory you actually want to use...

                                Nicolas.
                                • 13. Re: ./lsnrctl start effort- Message 1070 not found;
                                  Nicolas.Gasparotto
                                  Userxxxx,
                                  oracle@linuxsrv:/u01/app/oracle/OraHome/bin> ./lsnrctl start
                                  You must be serious ! You are previsouly setting ORACLE_HOME and all the others env variables to a different path directory.
                                  Be consistent !

                                  Nicolas.