ORA-12500 TNS: listener...

Printable View

08-12-2002, 05:18 AM
sandycrab

Hi friends,
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
Sandy
08-12-2002, 06:04 AM
shailendra

what is the setting of MTS in your init.ora?
08-12-2002, 06:08 AM
sandycrab

mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
This is the one are you looking for??
sandy
08-12-2002, 06:21 AM
pando

nothing to do with MTS, most probably is your server resources are too low
08-12-2002, 06:42 AM
sandycrab

Thanks Pando,
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??
Sandy
08-12-2002, 06:46 AM
Tarry

You have enough memory.
Check:SID_LIST section of the LISTENER.ORA file
or
SERVICE_NAME in the CONNECT DATA section of the TNSNAMES.ORA file is incorrect.
Check'em both!!
It could also have to do with the access/if you have adequate privs to access the db.
08-12-2002, 06:54 AM
pando

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, 07:02 AM
shailendra

SANDYCRAB

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.

SHAILENDRA
08-12-2002, 07:06 AM
shailendra

PANDO

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?

SHAILENDRA
08-12-2002, 07:10 AM
Tarry

pando i know that, since it being an error in the networking layer, i'd double check the mentioned parameters as well.
08-12-2002, 07:41 AM
sandycrab

Pando, Sorry for the wrong info. My machine is running on 512 RAM. System resources also seems to look farely perfect. One more thing, when I tried to create a new service name using net8 assitent, it gave me Dr. Watson error on ORADIM.exe. is this anyway related with our problem??
Though later on I copied the oradim.exe from some other server and replaces in my server, and the problem was solved.
But still main problem (ORA-12500) persists.
Shailendra, till saturday night I was working fine on that server, then sysadmin moved that server from one server room to the other, and from that point of time this problem is coming.
08-12-2002, 08:04 AM
sandycrab

One more thing friends, I'm have this Oracle 8.1.6. Hope no problem with version. This is not any Oracle Bug??
Plz clerify on this
Thanks
08-12-2002, 08:15 AM
ggnanaraj

Quote:

Originally posted by sandycrab
till saturday night I was working fine on that server, then sysadmin moved that server from one server room to the other, and from that point of time this problem is coming.

You could check whether this is caused by some network routing problem also ? Are you are on the same network as the server ?? If so, one way to sort this out would be to use ip address in your network config files (tnsnames.ora, listener.ora). Ofcouse, you should be able to do a ping to your server and also tnsping.

HTH.

P.S.: You could post the full text of your errors.

[Edited by ggnanaraj on 08-12-2002 at 08:20 AM]
08-12-2002, 08:25 AM
ggnanaraj

Check this out also ...

[quote]

Intermittent TNS-12500 Errors on Microsoft Windows NT
====================================
1. Increase the amount of memory available to the system either by removing unnecessary processes or increasing the amount of physical memory.

2. Increasing the amount of swap space will also temporarily help relieve the symptoms.

3. Disable OTRACE. OTRACE is a tracing feature that can cause many problems. OTRACE is enabled by default.
To disable OTRACE:

a. Stop the Oracle database.
b. Go to the orant/otrace/admin directory.
c. Delete all files with a ‘.dat’ extension.
d. Restart the Oracle database.

4. The TNS-12500 can be a result of the 'processes' parameter in the init.ora file being too low.

[quote]

HTH
08-12-2002, 08:36 AM
dba_essex

Check this link, might help

http://www.dbasupport.com/oracle/faq/Detailed/507.shtml
08-12-2002, 08:57 AM
sandycrab

HI ggnanaraj,
I'm working on the same server and able to connect internal and able to do all my normal activities. Only when I try to connect to some other user like sys, system or anyother, i face ...
ORA-12500 TNS: listener failed to start a dedicated shared server proces.
I have tried everything you told like processes parameter, deleteing .dat file for disabling OTRACE etc. Still same problem buddy...
Any idea??
08-12-2002, 09:27 AM
shailendra

CAN YOU PLEASE EXPLAIN WHAT SYSADMIN HAS DONE EXACTLY

SHAILENDRA
08-12-2002, 09:55 AM
sandycrab

sysadmin shutdown the machine and moved from one place to another without my knowledge. I don't know whether he shut down the oracle database properly or not. Does this make any differenc??
08-12-2002, 10:35 AM
Tarry

Quote:

Originally posted by sandycrab
sysadmin shutdown the machine and moved from one place to another without my knowledge. I don't know whether he shut down the oracle database properly or not. Does this make any differenc??

A lot of spooky things are going down there!!!