| hi [message #60721] |
Sun, 29 February 2004 13:53  |
vadlamani
Messages: 39
Registered: November 2003
|
Member |
|
|
I posted this message earlier also,but no one replied, i restared my system & i successfully installed oracle software,but i am curious why did this error come.
hi,
when i was trying to create DB using DCA i got the
TNS-12540 -- too many onnections error
what is this error & what should i do to resiolve it.
Any help greatly appreciated.
thank you
satish
|
|
|
|
| Re: hi [message #60722 is a reply to message #60721] |
Sun, 29 February 2004 14:22  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
it basically indicates some internal limit restriction related to connections exceeded. The last time I got this error was when the number of file handles exceeded the kernel limit , preventing the listener process from spawning more dedicated server process.
Check the number of processes,number of open files and also check your free memory(ie it should have sufficient virtual memory to create a new process)... If its related to memory,try reducing the SGA size to increase free memory from which PGA is allocated.
-Thiru
|
|
|
|
| Re: hi [message #60724 is a reply to message #60722] |
Sun, 29 February 2004 19:36 |
vadlamani
Messages: 39
Registered: November 2003
|
Member |
|
|
Is this some thing because my SGA_MAX_SIZE value is less than the total allocated to shared pool, database buffer cache, redo buffer cache & large pool in the intialisation parameter
regards
satish
|
|
|
|
| Re: hi [message #60728 is a reply to message #60724] |
Mon, 01 March 2004 04:45 |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
If the SGA_MAX_SIZE specified is less than the sum of db_cache_size,shared_pool_size,log_buffer etc, it defaults to the sum of those memory areas.
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
