10.2 listener won 't start on same port as 9.2 listener 2005-09-20 - By William B Ferguson
<FONT face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size=2><DIV
>Jay,</DIV><DIV> </DIV><DIV>Because of the error message you are receiving,
"<FONT face="Courier New">ORA-12500 (See ORA-12500.ora-code.com): TNS:listener failed to start a dedicated
server process", instead of a listener problem, check for the following line in
your tnsnames.ora file(s):</FONT></DIV><DIV><FONT face="Courier New"></FONT>
(SERVER = DEDICATED)</DIV><DIV>If you find the
line, delete it or sometimes setting it to SHARED will work. I've encountered
that same error message numerous times, a real headache.<BR></DIV><DIV><BR>----
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -----<BR><BR
> Bill Ferguson<BR> U.S. Geological
Survey - Minerals Information Team<BR> PO Box 25046,
MS-750<BR> Denver Federal Center<BR>
Denver, Colorado 80225<BR> V
oice (303)236-8747 ext. 321 Fax (303)236-4208<BR> ~ Think on a
grand scale, start to implement on a small scale ~<BR><DIV><BR></DIV><FONT
color=#990099>-- --oracle-l-bounce@(protected) wrote: -- --<BR><BR></FONT>
<blockquote style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px;
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">To: makbo@(protected)<BR
>From: JayMiller@(protected)<BR>Sent by: oracle-l-bounce@(protected)<BR
>Date: 09/20/2005 09:40AM<BR>cc: oracle-l@(protected)<BR>Subject: RE: 10.2
listener won't start on same port as 9.2 listener<BR><BR><FONT face=monospace
size=2>No, the key is different. I'm using the exact same listener.ora
that I<BR>did<BR>for the 10.1 instance with the exception of the different
ORACLE_HOME. I<BR>differentiate the keys by adding the instance name (e.g
., KEY =<BR>EXTPROCAAA,<BR>KEY = EXTPROCBBB, KEY = EXTPROCCCC).<BR><BR>I'll
speak with the SAs about running netstat --listening tonight.<BR><BR>I di
dn't try turning off both other listeners and then restarting all<BR>three<BR
>but when I refreshed from my 10.1 backup the listener started up with no<BR
>problems.<BR><BR>Regarding the last question, see my response to Mladen.<BR><BR
>One additional note on something I tried after sending the email to the<BR>list
. I tried adding the 10.2 instance to one of the 9.2 listeners<BR>
(figuring I could run that way on a temporary basis) and while the<BR>listener
<BR>came up I was unable to connect.<BR><BR>This was the entry:<BR><BR>listener
_rtb =<BR> (DESCRIPTION_LIST =<BR> (DESCRIPTION =<BR>
(ADDRESS_LIST =<BR> (ADDRESS =
(PROTOCOL = TCP)(HOST = usnjc01urp004)(PORT = 1526))<BR> )
<BR> (ADDRESS_LIST =<BR> (ADDRESS =
(PROTOCOL = IPC)(KEY = EXTPROCRTB))<BR> )<BR>
)<BR> )<BR><BR>SID_LIST_listener_rtb =<BR> (SID
_LIST =<BR> (SID_DESC =<BR> (ORACLE_HOME=
/oracle/rtbp/product/9.2.0)<BR> (SID_NAME = rtbp)<BR>
)<BR> (SID_DESC =<BR> (ORACLE_HOME= /oracle
/mds/product/10.2.0)<BR> (SID_NAME = mdsdb)<BR> )
<BR> (SID_DESC =<BR> (SID_NAME = PLSExtProc)
<BR> (ORACLE_HOME = /oracle/rtbp/product/9.2.0)<BR>
(PROGRAM = extproc)<BR> )<BR> )<BR><BR>This was
the error I got when I tried to connect through the listener:<BR>ORA-12500 (See ORA-12500.ora-code.com): TNS
:listener failed to start a dedicated server process<BR><BR>I'm wondering now if
the fact that I have PROGRAM = extproc but KEY =<BR>EXTPROCRTB could
possibly be an issue? Something else to try once the<BR>developers
release the box to me tonight.<BR><BR><BR><BR>Thanks,<BR>Jay Miller<BR><BR><BR>
<BR><BR>-- --Original Message-- --<BR>From: Mark
Bole [<A href="mailto:makbo@(protected)" target=blank >mailto:makbo@(protected)
.net</A>] <BR>Sent: Tuesday, September 20, 2005 10:24 AM<BR>Cc: oracle-l
@(protected)<BR>Subject: Re: 10.2 listener won't start on same port as 9.2
listener<BR><BR><BR><BR>Have you tried the above step first? Note that
ADDRESSes are not <BR>limited to TCP protocol. Perhaps you have a
conflicting IPC key? What <BR>are the results of the "netstat --listening
" command run as root?<BR><BR>Break the problem down through process of
elimination. Double-check <BR>your ORACLE_HOME settings when starting
each listener. Eliminate all <BR>but one ADDRESS for each listener, and
then add them back in one at a<BR>time.<BR><BR>But, as Mladen stated, there is
rarely a reason to run more than one <BR>listener per machine. Why do you
need to do this?<BR><BR>-- <BR>Mark Bole<BR><A href="http://www.bincomputing
.com/" target=blank >http://www.bincomputing.com</A><BR><BR><BR><BR>--<BR>
<A href="http://www.freelists.org/webpage/oracle-l" target=blank >http://www
.freelists.org/webpage/oracle-l</A><BR><BR>-- ---- ---- ---- ---- ---- ---- ----
----<BR>This message is confidential and sent by TD Waterhouse solely for use<BR
>by the intended recipient. If you are not the intended recipient, you<BR
>are hereby notified that any use, distribution or copying of this<BR
>communication is strictly prohibited. This should not be deemed as an<BR
>offer or solicitation, to buy or sell any product. Any 3rd party<BR>information
contained herein was prepared by sources deemed reliable,<BR>but is not
guaranteed. TD Waterhouse does not accept electronic<BR>instructions that
would require an original signature. Information<BR>received by or sent from TD
Waterhouse is stored, subject to review,<BR>and may be produced to regulatory
authorities or others with a legal<BR>right to such.<BR><BR>--<BR><A href="http
://www.freelists.org/webpage/oracle-l" target=blank
>http://www.freelists.org/webpage/oracle-l</A><BR></FONT></blockquote><br><
/DIV></FONT>--
http://www.freelists.org/webpage/oracle-l
|
|
