5 Replies Latest reply: Jul 12, 2013 4:32 PM by Hussein Sawwan-Oracle RSS

    unable to start listenr

    user12187801

      [orauat@FAKORADB bin]$ export TNS_ADMIN=$ORACLE_HOME/network/admin

      [orauat@FAKORADB bin]$ ./lsnrctl

       

       

      LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 12-JUL-2013 22:39:37

       

       

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

       

       

      Message 850 not found; No message file for product=network, facility=NL

      LSNRCTL>

        • 1. Re: unable to start listenr
          Hussein Sawwan-Oracle
          Message 850 not found; No message file for product=network, facility=NL


          Please make sure you source the database env file first.


          Thanks,

          Hussein

          • 2. Re: unable to start listenr
            user12187801

            Hi,

            Yes i did that . but still gettig same error message.

            • 3. Re: unable to start listenr
              Hussein Sawwan-Oracle

              Please post the output of "env | sort" command after sourcing the database env file.

               

              Thanks,

              Hussein

              • 4. Re: unable to start listenr
                user12187801

                [orauat@FAKORADB bin]$ id

                uid=505(orauat) gid=500(dba) groups=0(root),500(dba) context=user_u:system_r:unconfined_t

                [orauat@FAKORADB bin]$ env | sort

                ADJREOPTS=-Xms128M -Xmx512M

                ADJVAPRG=/data1/DEV/db/tech_st/11.2.0/jdk/jre/bin/java

                ADPERLPRG=/usr/bin/perl

                CALIB=/opt/CA/SharedComponents/lib

                CASHCOMP=/opt/CA/SharedComponents

                CONTEXT_FILE=/data1/DEV/db/tech_st/11.2.0/appsutil/DEV_fakoradb.xml

                CONTEXT_NAME=DEV_fakoradb

                CVS_RSH=ssh

                G_BROKEN_FILENAMES=1

                HISTSIZE=1000

                HOME=/home/orauat

                HOSTNAME=FAKORADB.fakhruddin.local

                INPUTRC=/etc/inputrc

                KDEDIR=/usr

                KDE_IS_PRELINKED=1

                KDE_NO_IPV6=1

                LANG=en_US.UTF-8

                LD_LIBRARY_PATH=/data1/DEV/db/tech_st/11.2.0//lib

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

                LIBPATH=/data1/DEV/db/tech_st/11.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/data1/DEV/db/tech_st/11.2.0/lib:/usr/dt/lib:/data1/DEV/db/tech_st/11.2.0/ctx/lib

                LIC_ECHO=echo -e

                LINK_CNTRL=

                LOGNAME=orauat

                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/orauat

                NLS_DATE_FORMAT=DD-MON-RR

                NLS_LANG=American_America.UTF8

                NLS_NUMERIC_CHARACTERS=.,

                NLS_SORT=binary

                OLDPWD=/data1/DEV/db/tech_st/11.2.0

                ORACLE_HOME=/data1/DEV/db/tech_st/11.2.0/

                ORACLE_SID=DEV

                ORA_NLS10=/data1/DEV/db/tech_st/11.2.0/nls/data/9idata/

                ORA_TZFILE=

                PATH=/data1/DEV/db/tech_st/11.2.0//bin:/usr/bin:/data1/DEV/db/tech_st/11.2.0/bin:/db/tech_st/11.2.0/bin:/usr/lib/qt-3.3/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/orauat/bin:.

                PERL5LIB=/usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi:/usr/lib/perl5/site_perl/5.8.7/i386-linux-thread-multi:/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi:/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi:/usr/lib/perl5/site_perl/5.8.8:/usr/lib/perl5/site_perl/5.8.7:/usr/lib/perl5/site_perl/5.8.6:/usr/lib/perl5/site_perl/5.8.5:/usr/lib/perl5/site_perl:/usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi:/usr/lib/perl5/vendor_perl/5.8.7/i386-linux-thread-multi:/usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi:/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi:/usr/lib/perl5/vendor_perl/5.8.8:/usr/lib/perl5/vendor_perl/5.8.7:/usr/lib/perl5/vendor_perl/5.8.6:/usr/lib/perl5/vendor_perl/5.8.5:/usr/lib/perl5/vendor_perl:/usr/lib/perl5/5.8.8/i386-linux-thread-multi:/usr/lib/perl5/5.8.8:.:/data1/DEV/db/tech_st/11.2.0/appsutil/perl:/data1/DEV/db/tech_st/11.2.0/appsutil/perl

                PWD=/data1/DEV/db/tech_st/11.2.0/appsutil/bin

                QTDIR=/usr/lib/qt-3.3

                QTINC=/usr/lib/qt-3.3/include

                QTLIB=/usr/lib/qt-3.3/lib

                SHELL=/bin/bash

                SHLIB_PATH=/data1/DEV/db/tech_st/11.2.0/lib:/usr/lib:/data1/DEV/db/tech_st/11.2.0/ctx/lib

                SHLVL=1

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

                SSH_CLIENT=192.168.108.76 1185 22

                SSH_CONNECTION=192.168.108.76 1185 192.168.108.5 22

                SSH_TTY=/dev/pts/2

                TERM=xterm

                TNS_ADMIN=/data1/DEV/db/tech_st/11.2.0/network/admin

                USER=orauat

                _=/usr/bin/env

                [orauat@FAKORADB bin]$

                • 5. Re: unable to start listenr
                  Hussein Sawwan-Oracle

                  Change this line:

                   

                   

                  export TNS_ADMIN=$ORACLE_HOME/network/admin

                   

                   

                  To:

                   

                   

                  export TNS_ADMIN=$ORACLE_HOME/network/admin/<CONTEXT_NAME>

                   

                   

                  i.e.

                   

                   

                  export TNS_ADMIN=$ORACLE_HOME/network/admin/DEV_fakoradb

                   

                  Thanks,

                  Hussein