Looking for one solution...hope you can help me out...
I have a Oracle 8i database in my Win-2000 machine. Now I'm trying to connect using internal account. Not a problem, it is connecting fine. But when I try to connect as sys or system on same machine(server) or from some client it throws following error...
ORA-12500 TNS: listener failed to start a dedicated shared server proces.
I have checked my listener.ora and tnsnames.ora also. Everything seems to look fine there.
Any idea about this...Tgis is really urgent friends
Thanks in advance
08-12-2002, 07:04 AM
what is the setting of MTS in your init.ora?
08-12-2002, 07:08 AM
mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
This is the one are you looking for??
08-12-2002, 07:21 AM
nothing to do with MTS, most probably is your server resources are too low
08-12-2002, 07:42 AM
Please tell me what can be the problem. System resources like what?? Can you give me some precise solution? My manager is sitting on top of my head yaar. This is a Windows machine with 256 RAM.
One more thing I'm able to start the database. Internal can do all the operations finely. But other users on same machine or clients are not able to connect. Any solution sir??
08-12-2002, 07:46 AM
You have enough memory.
Check:SID_LIST section of the LISTENER.ORA file
SERVICE_NAME in the CONNECT DATA section of the TNSNAMES.ORA file is incorrect.
It could also have to do with the access/if you have adequate privs to access the db.
08-12-2002, 07:54 AM
resources like RAM (swapping?)
100% CPU usage?
Listener cannot spawn more processes when there are no resources for him to do it.
256mb RAM sounds silly for a database server anyways... even my PC has more than that
Tarry what you said has nothing to do with this error really, processes is related to server resources not sid list, connect data etc
08-12-2002, 08:02 AM
ARE YOU GETTING THIS PROBELM FIRST TIME YOU ALREADY FACED THIS PROBLEM BEFORE?
I MEAN ARE YOU TRYING TO CONNECT WITH SYS AND SYSTEM FIRST TIME OR YOU HAD TRIED BEFORE.
08-12-2002, 08:06 AM
IS THERE ANY WAY TO FIND OUT THAT THE AVAILIABLE MEMORY IS NOT SUFFICIENT BECAUSE IF I ORDERED FOR EXTRA RAM THEN I SHOULD KNOW HOW MUCH MORE RAM IS REQUIRED?
08-12-2002, 08:10 AM
pando i know that, since it being an error in the networking layer, i'd double check the mentioned parameters as well.