Operating System - HP-UX
1748202 Members
3037 Online
108759 Solutions
New Discussion юеВ

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 2
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