| TNS:listener failed to start [message #118857] |
Mon, 09 May 2005 06:50  |
gvsenthil
Messages: 4
Registered: May 2005
Location: india
|
Junior Member |
|
|
Problem?
======
1. When we connect the Database Server we get this Error.
2. We chcked all the memory and performance statistical reports is ok.
Listener Error
=========
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
32-bit Windows Error: 109: Unknown error
Current Solutions
=============
1. Currently we have restarting the server
if any body know plz help me.. Any way advance thanks,
Senthilkumar
|
|
|
|
|
|
|
|
|
|
| Re: TNS:listener failed to start [message #119513 is a reply to message #118857] |
Fri, 13 May 2005 00:47  |
gvsenthil
Messages: 4
Registered: May 2005
Location: india
|
Junior Member |
|
|
hi girish.rohini,
I checked the url.. All are fine as per document.
My Server having 2GB Memory and SGA_sort_size is 64K.....
But Still the problem occurs...
Thanks & Regards,
Senthilkumar
|
|
|
|
| Re: TNS:listener failed to start [message #119558 is a reply to message #119513] |
Fri, 13 May 2005 06:29 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
HI
Hv u followed this step:
If nothing helps, then give up and reduce SGA, or configure shared server (when
would this technology mature to be as robust as regular dedicated connection
server?) If on UNIX/Linux, also consider DCD, dead connection detection. It
doesn't directly solve the problem of TNS-12500 but helps clean up useless
sessions. (DCD in 8i to 10gR1 on Windows has problems; see Note:285026.1.) If
this is considered, also consider idle_time profile for database users.
Regds
Girish
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
