<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
