| TNS-00510 limit restrictions exceeded [message #115462] |
Mon, 11 April 2005 15:33  |
TLegend33
Messages: 203
Registered: March 2005
|
Senior Member |
|
|
My client has Oracle 8.1.7.4.1 running on Win2003 Enterprise Edition with 8GB of RAM. We can't seem to set the SGA above 2GB or else the Oracle instance will not start. If the SGA is below 2GB, the database starts, however only a limited number of users can log on before the database hangs. There is some resource that is being depleated. Here are the errors:
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
32-bit Windows Error: 8: Exec format error
We have more than enough memory, how come we're getting Windows memory errors? We have the process parameter set high and also set USE_INDIRECT_DATA_BUFFERS=TRUE.
|
|
|
|
|
|
| Re: TNS-00510 limit restrictions exceeded [message #119194 is a reply to message #116249] |
Wed, 11 May 2005 02:29  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
32-bit Windows Error: 8: Exec format error
The last line is helpful because it tells you the OSD layer reason. Oracle
needs to fix this port-specific "bug". (Even Note:171636.1 doesn't get it
right, but Note:46001.1 does.) On Solaris and other UNIXes/Linux, error 8 is
indeed "Exec format error". But on Windows, it's actually:
C:\>net helpmsg 8
Not enough storage is available to process this command.
Like in several other OSes, "not enough storage" doesn't mean lack of disk
space. It means lack of virtual memory instead (including swap space).
Source: http://rootshell.be/~yong321/oranotes/12500.txt
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
