Home : ORA-12500: TNS:listener failed to start a dedicated server process
Q11267 - ERRMSG: ORA-12500: TNS:listener failed to start a dedicated server process

The following error can occur when the Oracle changes machines but the tnsnames.ora file is not configured to point to the new machine name. It can also occur if this file is not configured correctly to begin with. You will get a prompt while running the interface in interactive mode or you will see the following error in the interface log file.

 

 

The following is a sample tnsnames.ora file from a working oracle database. The bolded items are some of the items to match up correctly.

 

# TNSNAMES.ORA Network Configuration File: c:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORA92 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = vmt10566)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ora92)
    )
  )

INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = vmt10566)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = http://HRService)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 5/21/2008 12:09 PM.
Last Modified on 8/5/2008 3:17 PM.
Last Modified by No Author Name Available!.
Article has been viewed 6781 times.
Rated 3 out of 10 based on 5 votes.
Print Article
Email Article