Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

TNS:12500 Failed to start dedicated Server process

karthik_4
Occasional Contributor

TNS:12500 Failed to start dedicated Server process

I am Currently running Oracle 7.1.3 on HP UNIX Realease B.10.20 Version E 9000/803

When I try connecting from PL/SQL 8.0 (windows client) .it gives me the following messages.

TNS-12500: TNS:listener failed to start a dedicated server process
2 REPLIES
Alexander M. Ermes
Honored Contributor

Re: TNS:12500 Failed to start dedicated Server process

Hi there.
Here the official Oracle explanation :

ORA-12500: "TNS:listener failed to start a dedicated server process"
Cause: The listener was unable to start a process connecting the user to the database server.

Actions:

Verify that the SID_LIST section of the LISTENER.ORA file and the system identifier (SID) in the CONNECT DATA section of the TNSNAMES.ORA file are correct.
Verify that the user has adequate privileges to access the database.


Rgds
Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
Ravi_8
Honored Contributor

Re: TNS:12500 Failed to start dedicated Server process

Hi,
in/etc/oratab the instance is enabled or not(y/n at the end of that line). and listener should be started by lsnrctl.

never give up