TNS-12500: TNS:listener failed to start a dedicated server process

TNS-12500: TNS:listener failed to start a dedicated server
process

Question Posted / guest

2 Answers
6532 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

TNS-12500: TNS:listener failed to start a dedicated server process..

Answer / st holy

Hi,

I was facing the same kind of dreaded error , for a few
days., until now..
There could be only three reasons for which this error is
splashed across your screen, :

1. Your db is down, so in this case u need to pester
ur dba to do the performance tuning so that the instance
running can serve as a dedicated server for the incoming
requests.

It can be done , with a small tweak on ur tnsnames.ora file,
Just add SERVER = DEDICATED to the line after the
CONNECT_DATA PARAMETER.

The worst case is that the dba would have to figure out the
prob by him self.

2. The parameters representing your tnsnames.ora and
the listener.ora files are not assigned properly
3. This is the most exceptional and possible cause of
this error,
Well, its your darn antyi-virus, which can’t keep its hands
of the innocent oracle processes which are : the RDBM
executable and the intelligent agent module.

If they are held at point blank range by your crappy anti –
virus, then, its time you spring into action. These two
process are must for the connectivity for DB tools such as
Toad.,as it references many of these agents and oracle
specific files to estb. A connection.

So, just make sure its not blocked or something.

In case, you find the anti virus to be the culprit, then
simply run this line at your prompt. :

Oradim –shutdown –sid -<your instance name>

U might get an error if the RDBMS module is fortunatly not
blocked.

Next, find yourself into c:/oracle/ora09/bin/ and execute
agntsrvc executabe.
It should not throw any error. If not, then its your lucky
day, after all.

Now check the status of your listener.
Type, lsnrctl, then u get an intro by the listener,
Lsnrctl>
Type, status…
You will find the name of your instance, with the status
as “READY” ,,,

That’s its your done,,, Now fire up the tool your using,,,,
Voila…,ITS CONNECTED.

Is This Answer Correct ?

3 Yes

1 No

TNS-12500: TNS:listener failed to start a dedicated server process..

Answer / guest

Cause: The process of starting up a dedicated server process
failed. The executable could not be found or the environment
may be set up incorrectly.

Action: Turn on tracing at the ADMIN level and reexecute the
operation. Verify that the ORACLE Server executable is
present and has execute permissions enabled. Ensure that the
ORACLE environment is specified correctly in LISTENER.ORA.
The Oracle Protocol Adapter that is being called may not be
installed on the local hard drive. Please check that the
correct Protocol Adapter are successfully linked. If error
persists, contact Oracle Customer Support.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

2 No

Post New Answer