Help - Search - Members - Calendar
Full Version: ORA-12500, TNS:listener failed to start a dedicated server process
Oracle DBA Forums > Oracle > Oracle Forum
tulsidask@dcbl.com
We are getting the below error in between from database.

The database throws the below error some times only not continuous.

ORA-12500, TNS:listener failed to start a dedicated server process

Please guide us
We are waiting for your reply.

Saurabh Sharma
Hi ,

Error is intermittent , looks like database server dont have enough RAM to allocate for PGA when you are trying to execute any resource intensive program.


Thanks,
Saurabh
aussie_dba
Yes, you are out of PGA RAM.

Implement dhared server until you can buy more RAM

http://www.dba-oracle.com/t_mts_multithrea...vers_shared.htm

READ THIS ON ORA-12500

http://www.dba-oracle.com/t_ora_12500_listener_process.htm
tulsidask@dcbl.com
QUOTE (aussie_dba @ Dec 12 2011, 02:52 AM) *
Yes, you are out of PGA RAM.

Implement dhared server until you can buy more RAM

http://www.dba-oracle.com/t_mts_multithrea...vers_shared.htm

READ THIS ON ORA-12500

http://www.dba-oracle.com/t_ora_12500_listener_process.htm


Thanks my problem has resolved after reducing the size for below parameters

sort_area_size = 1048576
hash_area_size = 2097152

what to do for the perment solution .
tulsidask@dcbl.com
QUOTE (aussie_dba @ Dec 12 2011, 02:52 AM) *
Yes, you are out of PGA RAM.

Implement dhared server until you can buy more RAM

http://www.dba-oracle.com/t_mts_multithrea...vers_shared.htm

READ THIS ON ORA-12500

http://www.dba-oracle.com/t_ora_12500_listener_process.htm

In our databace there are around 300 sessions were in inactive state.
The database is not relies the session how to fix it
tulsidask@dcbl.com
QUOTE (aussie_dba @ Dec 12 2011, 02:52 AM) *
Yes, you are out of PGA RAM.

Implement dhared server until you can buy more RAM

http://www.dba-oracle.com/t_mts_multithrea...vers_shared.htm

READ THIS ON ORA-12500

http://www.dba-oracle.com/t_ora_12500_listener_process.htm

In our databace there are around 300 sessions were in inactive state.
The database is not relies the session how to fix it
burleson
Hi,


hash_area_size = 2097152

>> what to do for the perment solution .

Add RAM. One meg for sorting is stingy! RAM is cheap AT $1,000 PER GIG.

******************************
sort_area_size = 1048576

Check to see if you are doing disk sorts with a STATSPACK or AWR report

******************************
>> hash_area_size = 2097152

See here how to size hash_area_size:

http://www.dba-oracle.com/tips_oracle_hash_area_size.htm

Good Luck!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.