Home » RDBMS Server » Server Administration » Listener stops immediately after starting (Oracle 11g , linux open suse)
Listener stops immediately after starting [message #606479] Fri, 24 January 2014 09:26 Go to previous message
optimus2k88
Messages: 11
Registered: January 2014
Location: bangalore
Junior Member
oracle@linux-0nrm:/u01/app/oracle/product/11.2.0/dbhome_1> lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 25-JAN-2014 01:10:30

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

Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/linux-0nrm/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux-0nrm.site)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=linux-0nrm.site)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 25-JAN-2014 01:10:32
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/linux-0nrm/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux-0nrm.site)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "newdb" has 1 instance(s).
Instance "newdb", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
oracle@linux-0nrm:/u01/app/oracle/product/11.2.0/dbhome_1> lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 25-JAN-2014 01:10:44

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=linux-0nrm.site)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)(queuesize=50)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
###############listner.ora##############################
LISTENER=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=linux-0nrm.site)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=extproc) (queuesize=50))))
#ADR_BASE_LISTENER = /u01/app/oracle


SID_LIST_listener=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=newdb)
(SID_NAME=newdb)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)))

output of gen|env

LESSKEY=/etc/lesskey.bin
XDG_VTNR=7
NNTPSERVER=news
MANPATH=/usr/lib/mpi/gcc/openmpi/share/man:/usr/local/man:/usr/share/man
XDG_SESSION_ID=2
HOSTNAME=linux-0nrm.site
ORA_CRS_HOME=/opt/oracle/product/10gR2/crs
XKEYSYMDB=/usr/X11R6/lib/X11/XKeysymDB
GPG_AGENT_INFO=/run/user/oracle/keyring-rKwoSL/gpg:0:1
SHELL=/bin/bash
XDG_MENU_PREFIX=gnome-
HOST=linux-0nrm.site
TERM=xterm
HISTSIZE=1000
XDG_SESSION_COOKIE=aaf45848b77796875f161bed0000071b-1390590701.757075-721617866
PROFILEREAD=true
TMPDIR=/tmp
ORACLE_UNQNAME=DB11G
GJS_DEBUG_OUTPUT=stderr
MORE=-sl
WINDOWID=44040197
OLDPWD=/u01/app/oracle/product/11.2.0/dbhome_1/network/admin
GNOME_KEYRING_CONTROL=/run/user/oracle/keyring-rKwoSL
XSESSION_IS_UP=yes
GJS_DEBUG_TOPICS=JS ERROR;JS LOG
ORA_ASM_HOME=/opt/oracle/product/10gR2/asm
GTK_MODULES=canberra-gtk-module
JRE_HOME=/usr/lib/jvm/jre
USER=oracle
LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/dbhome_1/lib:/lib:/usr/lib
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;3 1:*.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:*.p bm=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=newdb
XNLSPATH=/usr/share/X11/nls
HOSTTYPE=i386
ORACLE_HOSTNAME=127.0.0.1
SSH_AUTH_SOCK=/run/user/oracle/keyring-rKwoSL/ssh
ORACLE_BASE=/u01/app/oracle
CONFIG_SITE=/usr/share/site/i686-pc-linux-gnu
SESSION_MANAGER=local/linux-0nrm.site:@/tmp/.ICE-unix/1105,unix/linux-0nrm.site:/tmp/.ICE-unix/1105
USERNAME=oracle
FROM_HEADER=
PAGER=less
COLUMNS=140
CSHEDIT=emacs
XDG_CONFIG_DIRS=/etc/xdg
MINICOM=-c on
PATH=/u01/app/oracle/product/11.2.0/dbhome_1/bin:/usr/sbin:/u01/app/oracle/product/11.2.0/dbhome_1/bin:/u01/app/oracle/product/11.2.0 /dbhome_1/bin:/usr/lib/mpi/gcc/openmpi/bin:/home/oracle/bin:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/usr/ lib/mit/bin:/opt/oracle/product/10gR2/db/bin
TNS_ADMIN=/opt/oracle/product/10gR2/db/network/admin
MAIL=/var/spool/mail/oracle
DESKTOP_SESSION=gnome
CPU=i686
QT_IM_MODULE=xim
PWD=/u01/app/oracle/product/11.2.0/dbhome_1
INPUTRC=/home/oracle/.inputrc
XMODIFIERS=@im=local
LANG=en_US.utf8
GNOME_KEYRING_PID=1086
PYTHONSTARTUP=/etc/pythonstart
GDM_LANG=en_US.utf8
AGENT_HOME=/opt/oracle/product/10.2/agent
LINES=39
GDMSESSION=gnome
GPG_TTY=/dev/pts/0
ICEAUTHORITY=/home/oracle/.ICEauthority
XDG_SEAT=seat0
QT_SYSTEM_DIR=/usr/share/desktop-data
HOME=/home/oracle
SHLVL=2
OSTYPE=linux
SDL_AUDIODRIVER=pulse
ALSA_CONFIG_PATH=/etc/alsa-pulse.conf
LESS_ADVANCED_PREPROCESSOR=no
GNOME_DESKTOP_SESSION_ID=this-is-deprecated
XCURSOR_THEME=DMZ
LS_OPTIONS=-N --color=tty -T 0
WINDOWMANAGER=/usr/bin/gnome
LOGNAME=oracle
MACHTYPE=i686-suse-linux
TMP=/tmp
LESS=-M -I -R
G_FILENAME_ENCODING=@locale,UTF-8,ISO-8859-15,CP1252
CVS_RSH=ssh
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-z2EOIPsCwM,guid=31f2ca8d8a705468a53cc1340000004a
CLASSPATH=/u01/app/oracle/product/11.2.0/dbhome_1/jlib:/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/jlib
XDG_DATA_DIRS=/usr/share
LESSOPEN=lessopen.sh %s
WINDOWPATH=7
DISPLAY=:0
XDG_RUNTIME_DIR=/run/user/oracle
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
GTK_IM_MODULE=cedilla
XAUTHLOCALHOSTNAME=localhost
LESSCLOSE=lessclose.sh %s %s
QT_IM_SWITCHER=imsw-multi
G_BROKEN_FILENAMES=1
COLORTERM=gnome-terminal
XAUTHORITY=/home/oracle/.xauth3QPCtf
JAVA_ROOT=/usr/lib/jvm/jre
_=/usr/bin/env


please suggest the change in configuration required to prevent listner from stopping immediately after starting.

[EDITED by LF: fixed topic title typo; was "Listner"]

[Updated on: Sat, 25 January 2014 13:59] by Moderator

Report message to a moderator

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Temporary tablespace space monitoring
Next Topic: After installation Oracle not started
Goto Forum:
  


Current Time: Fri Apr 26 10:05:15 CDT 2024