Home » RDBMS Server » Server Administration » ERROR: ORA-12500
ERROR: ORA-12500 [message #584444] Tue, 14 May 2013 06:56 Go to next message
compuscience
Messages: 97
Registered: September 2012
Member
i have a problem with oracle database 9i in windows server 2003 R1 X86
why this message appear
ERROR: ORA-12500: TNS:listener failed to start a dedicated server process
while listener is worked at this time
and no. of process at this time is 350 while it is initialized as 1000
and session is 340 ath this time while it is initialized as 2000
pga aggregate target is 600M
at this time any user try to connect to database can't do that
and the above message appear
and after some time a user can be connected to database

what can i do to remove this problem
Re: ERROR: ORA-12500 [message #584448 is a reply to message #584444] Tue, 14 May 2013 07:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Windows memory usual problem.
Solution: reboot (as usual with Windows).

Regards
Michel
Re: ERROR: ORA-12500 [message #584449 is a reply to message #584448] Tue, 14 May 2013 07:10 Go to previous messageGo to next message
compuscience
Messages: 97
Registered: September 2012
Member
then the problem in windows memory
Re: ERROR: ORA-12500 [message #584450 is a reply to message #584449] Tue, 14 May 2013 07:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, most likely (at 95%).

Regards
Michel

[Updated on: Tue, 14 May 2013 07:25]

Report message to a moderator

Re: ERROR: ORA-12500 [message #584488 is a reply to message #584450] Tue, 14 May 2013 15:17 Go to previous message
compuscience
Messages: 97
Registered: September 2012
Member
thank you very much for your effort
Previous Topic: Partitioned Tables for 30+ GB table which load very slow in front end GUI
Next Topic: 9i in Windows 2012
Goto Forum:
  


Current Time: Fri Mar 29 03:39:57 CDT 2024