| Listener stops immediately after starting [message #606479] |
Fri, 24 January 2014 09:26  |
 |
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 |
|
|
|
| Re: Listner stops immediately after starting, [message #606480 is a reply to message #606479] |
Fri, 24 January 2014 09:36  |
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
You could check if the listener process is running.
~ $ ps -eaf |grep lsnr
oracle 27694 1 0 16:33 ? 00:00:00 /u01/app/oracle/product/11.2.0//bin/tnslsnr LISTENER -inherit
oracle 27710 27639 0 16:34 pts/0 00:00:00 grep lsnr
~ $
If yes, is there some sort of firewall active?
The second thing to check:
Ist there anything in /u01/app/oracle/diag/tnslsnr/linux-0nrm/listener/alert/log.xml that points to an error?
|
|
|
|
|
|
|
|
| Re: Listner stops immediately after starting, [message #606526 is a reply to message #606516] |
Sat, 25 January 2014 12:00 |
|
optimus2k88
Messages: 11
Registered: January 2014
Location: bangalore
|
Junior Member |
|
|
OUTPUT OF oracle@linux-0nrm:/u01/app/oracle/diag/tnslsnr/linux-0nrm/listener/trace/listner.log
Sun Jan 26 04:26:39 2014
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
Trace information written to /u01/app/oracle/diag/tnslsnr/linux-0nrm/listener/trace/ora_2952_3042879168.trc
Trace level is currently 0
Started with pid=2952
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux-0nrm.site)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Listener completed notification to CRS on start
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
WARNING: Subscription for node down event still pending
26-JAN-2014 04:26:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=linux-0nrm.site)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
#LISTENER1 =
# (DESCRIPTION_LIST =
# (DESCRIPTION =
# (ADDRESS = (PROTOCOL = TCP)(HOST = linux-0nrm.site)(PORT = 1521))
# )
# )
#ADR_BASE_LISTENER1 = /u01/app/oracle/
#LISTENER =
# (DESCRIPTION_LIST =
# (DESCRIPTION =
# (ADDRESS = (PROTOCOL = TCP)(HOST = linux-0nrm.site)(PORT = 1521))
# )
# )
#ADR_BASE_LISTENER = /u01/app/oracle
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 on ps -ef|grep lsnr
oracle 4238 2574 0 04:52 pts/0 00:00:00 grep --color=auto lsnr
I have added the content of log file and also listner.ora..content of gen|env is already posted in my query, please let me know if any other information is required.
[Updated on: Sat, 25 January 2014 12:03] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Listner stops immediately after starting, [message #606547 is a reply to message #606536] |
Sun, 26 January 2014 03:46 |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
This line in your logListener completed notification to CRS on start crsctl status resource -t
crsctl status resource -p
--update
also,srvctl status listener
srvctl config listener [Updated on: Sun, 26 January 2014 03:49] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Listner stops immediately after starting, [message #607143 is a reply to message #607140] |
Mon, 03 February 2014 05:19 |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
|
I (and others) are deeply suspicious about what may have been installed on and improperly removed from your Linux machine. To re-install Linux will take you less than an hour. Just do it. You might want to download and install OEL rather than SUSE, OEL comes configured suitably for a database installation by default. If you want to use database release 11.2.x, better install OEL 5.8. If you want database 12.1, try OEL 6.4.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Listener stops immediately after starting [message #607503 is a reply to message #607502] |
Fri, 07 February 2014 09:19 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
> i don't want to mess up this time and try correcting it for weeks.
listener can start & run WITHOUT listener.ora file existing.
listener can start & run WITHOUT any database existing.
what results when you do as below?
lsnrctl start
lsnrctl status
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
