simple listener problem

[pwoneill]

I'm having some small problem with adding a new listner. Originally I had just FUNK, and today I wanted to add TEST. I've done this before on an 8.0.5 and an 8.1.6 installation (right now I'm using 8.1.6) and didn't have a problem, maybe I'm just missing something trivial.

If no listeners are running, I can start the listener for funk, but then when I try to start test, it says "Listener using name funk has already been started".

Or, if no listeners are running, I can start the listener for test, but when I try to start funk, it says "Listener using name test has already been started".

For some reason it's not recognizing that I want to start the other listner. I'm using just "lsnrctl start test", or "lsnrctl start funk". Either one will start individually, but if I try to start the second one, it thinks I'm trying to start the first one again.

Any ideas? Figure I just need another pair of eyes. My listener.ora is below.

<font face="courier">
# LISTENER.ORA Configuration File:
# Generated by Oracle configuration tools.

FUNK =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = irad-rms)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = irad-rms)(PORT = 2481))
)
)

SID_LIST_FUNK =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /app/oralmc/product/8.1.6)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = funk)
(ORACLE_HOME = /app/oralmc/product/8.1.6)
(SID_NAME = funk)
)
)

STARTUP_WAIT_TIME_funk = 0
CONNECT_TIMEOUT_funk = 10
TRACE_LEVEL_funk = OFF

LOG_DIRECTORY_funk = /app/oralmc/product/8.1.6/network/admin
LOG_FILE_funk = funk
TRACE_DIRECTORY_funk = /app/oralmc/product/8.1.6/network/admin
TRACE_FILE_funk = funk

TEST =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = irad-rms)(PORT = 1551))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = irad-rms)(PORT = 2491))
)
)

SID_LIST_TEST =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /app/oralmc/product/8.1.6)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = /app/oralmc/product/8.1.6)
(SID_NAME = test)
)
)
STARTUP_WAIT_TIME_test = 0
CONNECT_TIMEOUT_test = 10
TRACE_LEVEL_test = OFF

LOG_DIRECTORY_test = /app/oralmc/product/8.1.6/network/admin
LOG_FILE_test = test
TRACE_DIRECTORY_test = /app/oralmc/product/8.1.6/network/admin
TRACE_FILE_test = test
</font>

[JDoyle]

What is the output from :
lsnrctl service
?

[pwoneill]

Actually both lsnrctl service and lsnrctl status give me

<font face="courier">
oralmc@irad-rms:/d01/app/oralmc> lsnrctl service

LSNRCTL for Solaris: Version 8.1.6.0.0 - Production on 02-FEB-2001 15:11:39

(c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
TNS-01103: Protocol specific component of the address is incorrectly specified
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Solaris Error: 2: No such file or directory
oralmc@irad-rms:/d01/app/oralmc>
</font>

Which has happened even with the old version of the database that was set up by Oracle clients before I got on the job. If you knew how to fix that it would be great too.

lsnrctl status funk yeilds

<font face="courier">
.....variables....
Services Summary...
PLSExtProc has 1 service handler(s)
funk has 1 service handler(s)
The command completed successfully
</font>

however if I try to start test by "lsnrctl start test", it fails with the error I mentioned, but when I do "lsnrctl status funk" again I get

<font face="courier">
.... variables ....
Services Summary...
PLSExtProc has 1 service handler(s)
funk has 1 service handler(s)
funk has 2 service handler(s)
test has 2 service handler(s)
The command completed successfully
</font>

[JDoyle]

It's not clear why this is happening, except for a possible bug.
I duplicated your situation on my NT network and it (8.1.5) gave me no problems. I could start either one or both listeners from the command line.
What seems to occur is that when you specify a particular listener it runs the whole file, so that both listeners are always started. This would be the same as if you ran "LSNRCTL START" without specifying the name of the individual listener.
This amounts to your having no problem, doesn't it? Both listeners are up. Is that a bad thing?
I can't figure out the "service" listing problem you showed.

[gsprince]

Could it be anything to do with the GLOBAL_DBNAME. Did you try removing that line and try starting the listener?

[pwoneill]

If I run just "lsnrctl start", the listener for FUNK starts, but I still get

ORA-12203: TNS:unable to connect to destination

when I try to connect to TEST. I switched the order in the file just to see if it was starting the first one, but it still starts up FUNK and not TEST.

But as I said, TEST starts and runs fine if I start it individually when no other listeners are running.

Everything seems to be configured properly, it's identical to lots of listeners that have worked before, the tnsnames.ora on the client side is correct. I'm not sure what the deal is.

Removing GLOBAL_DBNAME didn't make a difference, thanks for the suggestion though.

[Edited by pwoneill on 02-02-2001 at 05:47 PM]

[JDoyle]

You modified your listener.ora file using Net 8 assistant I presume.
Maybe turdcan the whole thing and start from scratch with Net8 and make a new listener.ora file.
Maybe reinstall the listener program. I dunno.

[pwoneill]

Problem solved, for anybody wondering you can't have two IPC entries in the listener.ora file. I removed the one for TEST and everything started up as expected.

[soren]

neil,
pls. can u put in the modified listener.ora? i am also in this fix for quite sometime now, just dismissed as some bug in oracle
soren

[pwoneill]

Sure, here was the section for TEST originally with the bad part highlighted

<font face="courier">
TEST =
(DESCRIPTION_LIST =
(DESCRIPTION =<font color="#FF0000">
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)</font>
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = irad-rms)(PORT = 1551))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = irad-rms)(PORT = 2491))
)
)
</font>

I removed the highlighted section and everything was fine.