| pga_aggregate_target [message #582791] |
Mon, 22 April 2013 10:47  |
 |
compuscience
Messages: 97
Registered: September 2012
|
Member |
|
|
i have a question about oracle database 9i in windows server 2003 R1 X86
i set the parameter of pga_aggregate_target=1000M and 500M sometimes
i found after few days that error message appear to client
ORA-12500 TNS:listener failed to start a dedicated server process
when i try to connect from the server sometimes logon and sometimes another message appear
ORA-12560: TNS:protocol adapter error
i think the problem in pga_aggregate_target value
can you help me?
|
|
|
|
|
|
|
|
|
|
| Re: pga_aggregate_target [message #582801 is a reply to message #582793] |
Mon, 22 April 2013 12:50  |
|
compuscience
Messages: 97
Registered: September 2012
|
Member |
|
|
BlackSwan wrote on Mon, 22 April 2013 14:10>i have a question about oracle database 9i
V9 is obsoleted & unsupported
>in windows server 2003 R1 X86
V9 never certified on this OS
>ORA-12500 TNS:listener failed to start a dedicated server process
increase number of PROCESSES
i do what you ask me to do
but after few hours the same thing happen
[Updated on: Mon, 22 April 2013 12:51] Report message to a moderator |
|
|
|
|
|
|
|
| Re: pga_aggregate_target [message #582870 is a reply to message #582852] |
Tue, 23 April 2013 03:11 |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:@ Seniors please Correct me. Your feedback is highly appreciatable
We already answer to the question.
Note that if the listener was not started then the message would be "there is no listener" and not "the listener cannot start a process", don't you think?
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
