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 next 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

Re: Listner stops immediately after starting, [message #606480 is a reply to message #606479] Fri, 24 January 2014 09:36 Go to previous messageGo to next message
ThomasG
Messages: 3211
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 #606481 is a reply to message #606479] Fri, 24 January 2014 09:37 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
when was last time listener worked without error?
what changed since then?

>please suggest the change in configuration required to prevent listner from stopping immediately after starting.
why do you expect us to suggest change when you did NOT post any configuration details so we know what exists today?

>System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

post content of file above

>Log messages written to /u01/app/oracle/diag/tnslsnr/linux-0nrm/listener/alert/log.xml

post last 100 or so lines from file above
Re: Listner stops immediately after starting, [message #606516 is a reply to message #606479] Sat, 25 January 2014 08:32 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
https://community.oracle.com/thread/2622769
Re: Listner stops immediately after starting, [message #606526 is a reply to message #606516] Sat, 25 January 2014 12:00 Go to previous messageGo to next message
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 #606534 is a reply to message #606526] Sat, 25 January 2014 21:17 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
neither sqlnet.ora nor listener.ora files are required to start or use Oracle listener.

so rename these files out of the way to different names; like sqlnet.ora.sav & listener.ora.sav
then do as below

lsnrctl start
lsnrctl status

COPY the results from above then PASTE all back here
Re: Listner stops immediately after starting, [message #606536 is a reply to message #606534] Sat, 25 January 2014 23:25 Go to previous messageGo to next message
optimus2k88
Messages: 11
Registered: January 2014
Location: bangalore
Junior Member
Renamed listner.ora to listner.sav and sqlnet.ora file doesn't exist/

oracle@linux-0nrm:/u01/app/oracle/product/11.2.0/dbhome_1/network/admin> lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 26-JAN-2014 16:19:00

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
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)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 26-JAN-2014 16:19:00
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
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)))
The listener supports no services
The command completed successfully
oracle@linux-0nrm:/u01/app/oracle/product/11.2.0/dbhome_1/network/admin> lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 26-JAN-2014 16:19:06

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
oracle@linux-0nrm:/u01/app/oracle/product/11.2.0/dbhome_1/network/admin>

###########################output of listner.log file##########################################

Started with pid=5113
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux-0nrm.site)(PORT=1521)))
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 16:17:56 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=linux-0nrm.site)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0
Sun Jan 26 16:19:00 2014
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_5127_3042592448.trc
Trace level is currently 0

Started with pid=5127
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux-0nrm.site)(PORT=1521)))
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 16:19:00 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=linux-0nrm.site)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0
1592,1 Bot

Re: Listner stops immediately after starting, [message #606547 is a reply to message #606536] Sun, 26 January 2014 03:46 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
This line in your log
Listener completed notification to CRS on start
suggests that you have Grid Infrastructure installed, which complicates the situation. Are you certain that you are attempting to run this listener from the correct home? Better check what is registered in he OLR, and how:
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 #606548 is a reply to message #606547] Sun, 26 January 2014 09:06 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
complicating reality is shown below

>ORA_CRS_HOME=/opt/oracle/product/10gR2/crs
>TNS_ADMIN=/opt/oracle/product/10gR2/db/network/admin
>XAUTHLOCALHOSTNAME=localhost
Re: Listner stops immediately after starting, [message #606551 is a reply to message #606547] Sun, 26 January 2014 13:23 Go to previous messageGo to next message
optimus2k88
Messages: 11
Registered: January 2014
Location: bangalore
Junior Member
Output of the below mentioned commands:
crsctl status resource -t
crsctl status resource -p

oracle@linux-0nrm:/u01/app/oracle/product/11.2.0/dbhome_1> crsctl status resource -t
If 'crsctl' is not a typo you can use command-not-found to lookup the package that contains it, like this:
cnf crsctl
oracle@linux-0nrm:/u01/app/oracle/product/11.2.0/dbhome_1> cnf crsctl
crsctl: command not found

srvctl status listener
srvctl config listener

oracle@linux-0nrm:/u01/app/oracle/product/11.2.0/dbhome_1> srvctl status listener
PRCR-1035 : Failed to look up CRS resource for ora.listener.type
PRCR-1068 : Failed to query resources
Cannot communicate with crsd Sad

Please suggest..



Re: Listner stops immediately after starting, [message #606552 is a reply to message #606548] Sun, 26 January 2014 13:24 Go to previous messageGo to next message
optimus2k88
Messages: 11
Registered: January 2014
Location: bangalore
Junior Member
>ORA_CRS_HOME=/opt/oracle/product/10gR2/crs
>TNS_ADMIN=/opt/oracle/product/10gR2/db/network/admin
>XAUTHLOCALHOSTNAME=localhost

how can i fix this? Sad
Re: Listner stops immediately after starting, [message #606553 is a reply to message #606552] Sun, 26 January 2014 13:35 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post results from following OS command

find /opt/oracle/product -name crsctl -ls
Re: Listner stops immediately after starting, [message #606554 is a reply to message #606553] Sun, 26 January 2014 13:45 Go to previous messageGo to next message
optimus2k88
Messages: 11
Registered: January 2014
Location: bangalore
Junior Member
oracle@linux-0nrm:/u01/app/oracle/product/11.2.0/dbhome_1> find /opt/oracle/product -name crsctl -ls
find: `/opt/oracle/product': No such file or directory
Re: Listner stops immediately after starting, [message #606587 is a reply to message #606554] Mon, 27 January 2014 03:41 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Try:

find /u01/app/oracle/product -name crsctl -ls
Re: Listner stops immediately after starting, [message #606633 is a reply to message #606587] Mon, 27 January 2014 11:26 Go to previous messageGo to next message
optimus2k88
Messages: 11
Registered: January 2014
Location: bangalore
Junior Member
The find command didn't return anything:-
oracle@linux-0nrm:/u01/app/oracle/product/11.2.0/dbhome_1> find /u01/app/oracle/product -name crsctl -ls
oracle@linux-0nrm:/u01/app/oracle/product/11.2.0/dbhome_1>
Re: Listner stops immediately after starting, [message #606641 is a reply to message #606633] Mon, 27 January 2014 13:36 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
You're going to have to find where Oracle was installed and use that directory structure for your search.
Re: Listner stops immediately after starting, [message #606823 is a reply to message #606641] Wed, 29 January 2014 11:57 Go to previous messageGo to next message
optimus2k88
Messages: 11
Registered: January 2014
Location: bangalore
Junior Member
I checked the oratab file and found following entry for oracle home
newdb:/u01/app/oracle/product/11.2.0/dbhome_1:N

Just wanted to clarify whether the entry of portlist.ini is fine
PATH : /u01/app/oracle/product/11.2.0/dbhome_1/install/portlist.ini

Enterprise Manager Console HTTP Port (newdb) = 1158
Enterprise Manager Agent Port (newdb) = 3938

Following is the section of oracle installation log file
INFO: End output from spawned process.
INFO: ----------------------------------
INFO: Calling Action unixActions10.2.0.3.0 make
registerOnly = false
installMakePath = /usr/bin/make
installMakeFileName = /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk
installTarget = irman ioracle
undoMakeFileName =
installArguments = ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
logFile = /u01/app/oracle/product/11.2.0/dbhome_1/install/make.log
undoTarget =
progMsg = Linking RMAN Utility
So according to this oracle home directory is /u01/app/oracle/product/11.2.0/dbhome_1 however crsctl file doesn't exist in any folder,please let me know if i can download/install the file seperately?


Re: Listner stops immediately after starting, [message #606824 is a reply to message #606823] Wed, 29 January 2014 12:13 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>INFO: Calling Action unixActions10.2.0.3.0 make
Interesting observation

how & why is V11 software trying to use V10 utility?

was any V10 Oracle software ever installed on this system?
Re: Listner stops immediately after starting, [message #606960 is a reply to message #606824] Fri, 31 January 2014 06:50 Go to previous messageGo to next message
optimus2k88
Messages: 11
Registered: January 2014
Location: bangalore
Junior Member
Currently I am using dual boot with windows xp and opensuse installed on my PC, I had installed oracle 10g on windows, later with oracle 11g available, i considered installing oracle 11g on open suse on which i am facing this issue.
Will uninstalling Oracle 10g from windows work? and If so how would that work?
Please suggest.
Re: Listner stops immediately after starting, [message #606975 is a reply to message #606960] Fri, 31 January 2014 09:35 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Other than reformatting the disk & starting from scratch with a clean disk, I am out of ideas on how you should proceed.
Re: Listner stops immediately after starting, [message #607140 is a reply to message #606975] Mon, 03 February 2014 04:50 Go to previous messageGo to next message
optimus2k88
Messages: 11
Registered: January 2014
Location: bangalore
Junior Member
I uninstalled oracle 10g from windows still, I am facing the same issue, formatting the hard disk is my last option. I am looking forward for any other suggestions(if any) before formatting my hard disk.
Re: Listner stops immediately after starting, [message #607143 is a reply to message #607140] Mon, 03 February 2014 05:19 Go to previous messageGo to next message
John Watson
Messages: 8922
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: Listner stops immediately after starting, [message #607225 is a reply to message #607143] Tue, 04 February 2014 01:54 Go to previous messageGo to next message
mrkamranumer
Messages: 11
Registered: January 2014
Junior Member
stop Listener by lsnrctl stop
open Netmgr and re-create a Listener and Make sure you register this with your database
save this configuration and then check the issue,

Hopefully it will be resolved
Re: Listner stops immediately after starting, [message #607226 is a reply to message #607225] Tue, 04 February 2014 01:54 Go to previous messageGo to next message
mrkamranumer
Messages: 11
Registered: January 2014
Junior Member
and one thing more if you find a listner there , first you delete this and add new

Thank you
Kamran Saeed
Re: Listener stops immediately after starting [message #607494 is a reply to message #606479] Fri, 07 February 2014 05:17 Go to previous messageGo to next message
optimus2k88
Messages: 11
Registered: January 2014
Location: bangalore
Junior Member
John, Please post a link if you have one for installing oracle 11g in oel (32 bit machine), i don't want to mess up this time and try correcting it for weeks. Sad

[Updated on: Fri, 07 February 2014 05:21]

Report message to a moderator

Re: Listener stops immediately after starting [message #607502 is a reply to message #607494] Fri, 07 February 2014 09:12 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
optimus2k88 wrote on Fri, 07 February 2014 12:17
John, Please post a link if you have one for installing oracle 11g in oel (32 bit machine), i don't want to mess up this time and try correcting it for weeks. Sad


All the installation guides are linked from the readme.html in the download:

Installing and Upgrading

You should at least read and follow the Oracle® Database Quick Installation Guide 11g Release 2 (11.2) for Linux x86. (If you don't want to use anything that is mentioned in the "Tasks Not Described in This Guide" paragraph, in which case you have to read the full install guide)
Re: Listener stops immediately after starting [message #607503 is a reply to message #607502] Fri, 07 February 2014 09:19 Go to previous message
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
Previous Topic: Temporary tablespace space monitoring
Next Topic: After installation Oracle not started
Goto Forum:
  


Current Time: Thu Mar 28 08:18:50 CDT 2024