Home » RDBMS Server » Server Administration » pga_aggregate_target
pga_aggregate_target [message #582791] Mon, 22 April 2013 10:47 Go to next message
compuscience
Messages: 30
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 #582793 is a reply to message #582791] Mon, 22 April 2013 11:10 Go to previous messageGo to next message
BlackSwan
Messages: 22792
Registered: January 2009
Senior Member
>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
Re: pga_aggregate_target [message #582795 is a reply to message #582791] Mon, 22 April 2013 11:37 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The problem is Windows memory.

Regards
Michel
Re: pga_aggregate_target [message #582798 is a reply to message #582795] Mon, 22 April 2013 12:33 Go to previous messageGo to next message
compuscience
Messages: 30
Registered: September 2012
Member
Michel Cadot wrote on Mon, 22 April 2013 14:37

The problem is Windows memory.

Regards
Michel

how come
server run okay with 10 giga ram
Re: pga_aggregate_target [message #582801 is a reply to message #582793] Mon, 22 April 2013 12:50 Go to previous messageGo to next message
compuscience
Messages: 30
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 #582806 is a reply to message #582798] Mon, 22 April 2013 13:43 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
compuscience wrote on Mon, 22 April 2013 19:33
Michel Cadot wrote on Mon, 22 April 2013 14:37

The problem is Windows memory.

Regards
Michel

how come
server run okay with 10 giga ram


Don't you ever hear about Windows memory leaks?
Only one solution: a) upgrade to a supported version b) throw away Windows.

Regards
Michel

Re: pga_aggregate_target [message #582852 is a reply to message #582806] Tue, 23 April 2013 02:18 Go to previous messageGo to next message
nlnkapardi
Messages: 26
Registered: April 2013
Location: India
Junior Member

Hello Compuscience

Hope you are doing good!

Whenever there is a TNS issue in the Windows Environment. Please Check weather the TNS services are Manually or Automatically in services.msc file. The Navigation to the File can be done like this.

Go to Start>> click on Run >>> Then type services.msc

Then there will be a configuration window Will open then select the listener name service. then selectr it to MANUAL.

@ Seniors please Correct me. Your feedback is highly appreciatable

Please feel to Get back to me

Cheers
Kapardi
Re: pga_aggregate_target [message #582870 is a reply to message #582852] Tue, 23 April 2013 03:11 Go to previous message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Unable to drop user
Next Topic: ORA-01000: maximum open cursors exceeded
Goto Forum:
  


Current Time: Sat Sep 20 21:21:54 CDT 2014

Total time taken to generate the page: 0.08536 seconds