| ora-12500 [message #268112] |
Mon, 17 September 2007 10:07  |
samit_gandhi
Messages: 226
Registered: July 2005
Location: Hong Kong
|
Senior Member |
|
|
Hi
My oracle was working fine before 2 hrs but now it showing me error when i m trying to connect it gives ORA-12500 : TNS-listener failed to start a dedicated server. pls help me its urgent
waiting for ur reply.
thank you in advance
samit
|
|
|
|
| Re: ora-12500 [message #268113 is a reply to message #268112] |
Mon, 17 September 2007 10:18  |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
Whats your oracle version.???
| Quote: | Common syntax issues in the listener.ora file can cause numerous listener connection problems, most notably this:
ORA-12500: TNS: listener failed to start a dedicated server process
Sometimes this ORA-12500 is because of a PGA RAM shortage on the target database, based on the settings for pga_aggregate_target, sort_area_size and hash_area_size.
You can have a single listener, pointing to multiple Oracle instances, each on a different version.
In Windows, especially Oracle8 and Oracle8i, you may need to re-start the listener service using the Windows task manager.
|
http://www.dba-oracle.com/t_ora_12500_listener_process.htm
[Updated on: Mon, 17 September 2007 10:18] Report message to a moderator |
|
|
|
|
|
|
|
| Re: ora-12500 [message #268891 is a reply to message #268114] |
Thu, 20 September 2007 00:56 |
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
|
Senior Member |
|
|
Hi,
ORA-12500: TNS:listener failed to start a dedicated server process
For Above error there is couple of reason check below point.
1.Oracle Services is start.
Windows > c:\>net start OracleService
Unix > $ps -ef | grep ora_smon
2.Listener Services is start.
3.Take a look on LISTENER.LOG file {%ORACLE_HOME%/network/log}
4.if you received WINEXEC FORMAT ERROR 8
C:\>net helpmsg 8
Not enough storage is available to process this command.
Contact OS vendor for more information.
5.Sometimes it is happen due to PGA RAM shortage on database.
You have to set below parameters.
pga_aggregate_target, sort_area_size and hash_area_size.
6.TNS-00517: Lost contact
32-bit Windows Error: 54: Unknown error
If your received above error
C:\>net helpmsg 54
The network is busy.
7.TNS-00507: Connection closed
32-bit Windows Error: 109: Unknown error
C:\>net helpmsg 109
The pipe has been ended.
8.Recreate OracleService service through ORADIM utility
ORADIM -DELETE -SID
ORADIM -NEW -SID
http://dbataj.blogspot.com/2007/03/ora-12500.html
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
