This discussion is archived
5 Replies Latest reply: Jul 12, 2013 2:32 PM by Hussein Sawwan-Oracle RSS

unable to start listenr

user12187801 Expert
Currently Being Moderated

[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 Employee ACE
    Currently Being Moderated
    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 Expert
    Currently Being Moderated

    Hi,

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

  • 3. Re: unable to start listenr
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated

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

     

    Thanks,

    Hussein

  • 4. Re: unable to start listenr
    user12187801 Expert
    Currently Being Moderated

    [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 Employee ACE
    Currently Being Moderated

    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points