Re: tns-12500 unable to start dedicated server process.
[EMAIL PROTECTED] wrote: > > I have 3 instances on Oracle 8.1.6,Nt 4. They are all started but on one > instance I connect via the listener. The only connection is at > the server not using service name. I have the usual plenty of > memory,swap,etc. It has been working fine until today. I even stopped the > other 2 instances just to give more memory but still fails. The > listener.ora has not changed. I have rebooted the server multiple times. > Oracle gives me the same old answer increase processes parameter,add more > memory,add more swap file,etc. > > Anyone have any fresh ideas on how to resolve. > > Thanks > Rick > Rick, Put your listener in trace mode.This is the process which creates the dedicated server. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
tns-12500 unable to start dedicated server process.
I have 3 instances on Oracle 8.1.6,Nt 4. They are all started but on one instance I connect via the listener. The only connection is at the server not using service name. I have the usual plenty of memory,swap,etc. It has been working fine until today. I even stopped the other 2 instances just to give more memory but still fails. The listener.ora has not changed. I have rebooted the server multiple times. Oracle gives me the same old answer increase processes parameter,add more memory,add more swap file,etc. Anyone have any fresh ideas on how to resolve. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: TNS-12500 intermittent errors
> Environment NT4 > 4Gb RAM > Page Filesize 4.5Gb > Oracle Version 8.0.5.1.1 > > We have recently been experiencing intermittent TNS-12500 Listener > unable to create a dedicated server process > messages. It does occur when we have around 300 + processes, but even > then it appears hit and miss. > It has all the hallmarks of being a resource problem, but none of the > measurements at time of error(s) seem to > bear this out. Once the processes count is reduced ever so slightly, > the problem goes away ! > > Peak memory usage : - Just over 2Gb > Oracle Process memory usage max - approx 1.7 Gb > Max Oracle Processes - 318 > Initialization Parm - Processes = 500 > > Before I start tracing the listener, I thought I'd ask this list for > any ideas. > > regards/Bob Bob, Seems to me clear enough. When you are at the limit, it's just a question of one process disappearing to allow another one to take its place. The place to search is the NT system error log. The easy answer would be 'migrate to Unix and use MTS', but perhaps that some NT tuning may help in taking you past the limit you are hitting. But I am totally incompetent on NT and cultivating my incompetence. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
TNS-12500 intermittent errors
Environment NT4 4Gb RAMPage Filesize 4.5GbOracle Version 8.0.5.1.1 We have recently been experiencing intermittent TNS-12500 Listener unable to create a dedicated server process messages. It does occur when we have around 300 + processes, but even then it appears hit and miss. It has all the hallmarks of being a resource problem, but none of the measurements at time of error(s) seem to bear this out. Once the processes count is reduced ever so slightly, the problem goes away ! Peak memory usage : - Just over 2GbOracle Process memory usage max - approx 1.7 GbMax Oracle Processes - 318Initialization Parm - Processes = 500 Before I start tracing the listener, I thought I'd ask this list for any ideas. regards/Bob
fyi - solving TNS-12500 on solaris server
Title: fyi - solving TNS-12500 on solaris server A while ago I had posted a question vis-à-vis the following error in our listener log for a Sun Solaris server that was used for development and running several Oracle versions (7.3.4 to 8.1.7, 32-bit and 64-bit) TNS-12500: TNS:listener failed to start a dedicated server process TNS-12540: TNS:internal limit restriction exceeded TNS-12560: TNS:protocol adapter error TNS-00510: Internal limit restriction exceeded The error re-appeared recently so I posted a question in a Metalink forum, and the support person dug up this document for me (I don't know why I didn't find it when I searched for "TNS-12500" and "listener") Metalink note:121091.1 The error was caused by our 8.1 databases automatically registering with all the listeners running on the machine. So the 64-bit listener was being used for 32-bit databases and vice-versa. Adding a LOCAL_LISTENER parameter in the init.ora for each 8.0 and 8.1 database to make sure that 32-bit databases were handled by the 32-bit listener, and 64-bit databases by the 64-bit listener, eliminated the problem. Of course, there are other factors that can cause the TNS-12500, but in our case, it was the listener/database mismatch. -- Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com
RE: RE: TNS-12500
On windows NT, we had tns-12500 because the Oracle executable was trying to grow beyound 2gb... Chaim "Deshpande, Kirti" <[EMAIL PROTECTED]> on 04/15/2001 08:30:20 PM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc:(bcc: Chaim Katz/Completions/Bombardier) Relinking all the networking components. As the Note suggested. If it still does not work for you, you will need to contact Oracle support. HTH.. - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Cyril Thankappan [SMTP:[EMAIL PROTECTED]] > Sent: Sunday, April 15, 2001 2:36 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: RE: TNS-12500 > > > Hi! > > True, but finally how was it solved at ur end? > > cos at my end , I have tried everything > including adding RAM.. > still it won't go.. > > > - Original Message -- > "Deshpande, Kirti" <[EMAIL PROTECTED]> wrote: > To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > From:"Deshpande, Kirti" <[EMAIL PROTECTED]> > Date:Sat, 14 Apr 2001 12:50:18 -0800 > Subject:RE: TNS-12500 > > I think Note:2064862.102 on Metalink has 'enough' light on this topic. > > I had to deal with it a few months ago. > > HTH > > - Kirti Deshpande > Verizon Information Services >http://www.superpages.com > > > -Original Message- > > From: Cyril Thankappan [SMTP:[EMAIL PROTECTED]] > > Sent: Saturday, April 14, 2001 2:25 PM > > To: Multiple recipients of list ORACLE-L > > Subject: TNS-12500 > > > > > > Hi.. > > > > can someone throw some 'more' light on > > TNS-12500 (apart from RAM,resources problem) > > > > Thanks > > > > _ > > Chat with your friends as soon as they come online. Get Rediff Bol at > > http://bol.rediff.com > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Cyril Thankappan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Deshpande, Kirti > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > _ > Chat with your friends as soon as they come online. Get Rediff Bol at > http://bol.rediff.com > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: TNS-12500
Relinking all the networking components. As the Note suggested. If it still does not work for you, you will need to contact Oracle support. HTH.. - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Cyril Thankappan [SMTP:[EMAIL PROTECTED]] > Sent: Sunday, April 15, 2001 2:36 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: RE: TNS-12500 > > > Hi! > > True, but finally how was it solved at ur end? > > cos at my end , I have tried everything > including adding RAM.. > still it won't go.. > > > - Original Message -- > "Deshpande, Kirti" <[EMAIL PROTECTED]> wrote: > To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > From:"Deshpande, Kirti" <[EMAIL PROTECTED]> > Date:Sat, 14 Apr 2001 12:50:18 -0800 > Subject:RE: TNS-12500 > > I think Note:2064862.102 on Metalink has 'enough' light on this topic. > > I had to deal with it a few months ago. > > HTH > > - Kirti Deshpande > Verizon Information Services >http://www.superpages.com > > > -Original Message- > > From: Cyril Thankappan [SMTP:[EMAIL PROTECTED]] > > Sent: Saturday, April 14, 2001 2:25 PM > > To: Multiple recipients of list ORACLE-L > > Subject:TNS-12500 > > > > > > Hi.. > > > > can someone throw some 'more' light on > > TNS-12500 (apart from RAM,resources problem) > > > > Thanks > > > > _ > > Chat with your friends as soon as they come online. Get Rediff Bol at > > http://bol.rediff.com > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Cyril Thankappan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Deshpande, Kirti > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > _ > Chat with your friends as soon as they come online. Get Rediff Bol at > http://bol.rediff.com > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: TNS-12500
Hi! True, but finally how was it solved at ur end? cos at my end , I have tried everything including adding RAM.. still it won't go.. - Original Message -- "Deshpande, Kirti" <[EMAIL PROTECTED]> wrote: To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> From:"Deshpande, Kirti" <[EMAIL PROTECTED]> Date:Sat, 14 Apr 2001 12:50:18 -0800 Subject:RE: TNS-12500 I think Note:2064862.102 on Metalink has 'enough' light on this topic. I had to deal with it a few months ago. HTH - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Cyril Thankappan [SMTP:[EMAIL PROTECTED]] > Sent: Saturday, April 14, 2001 2:25 PM > To: Multiple recipients of list ORACLE-L > Subject: TNS-12500 > > > Hi.. > > can someone throw some 'more' light on > TNS-12500 (apart from RAM,resources problem) > > Thanks > > _ > Chat with your friends as soon as they come online. Get Rediff Bol at > http://bol.rediff.com > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Cyril Thankappan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TNS-12500
I think Note:2064862.102 on Metalink has 'enough' light on this topic. I had to deal with it a few months ago. HTH - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Cyril Thankappan [SMTP:[EMAIL PROTECTED]] > Sent: Saturday, April 14, 2001 2:25 PM > To: Multiple recipients of list ORACLE-L > Subject: TNS-12500 > > > Hi.. > > can someone throw some 'more' light on > TNS-12500 (apart from RAM,resources problem) > > Thanks > > _ > Chat with your friends as soon as they come online. Get Rediff Bol at > http://bol.rediff.com > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Cyril Thankappan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
TNS-12500
Hi.. can someone throw some 'more' light on TNS-12500 (apart from RAM,resources problem) Thanks _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).