| ORA-12571 and ORA-12500 [message #67348] |
Thu, 27 May 2004 22:01  |
Arindam Saha
Messages: 15
Registered: May 2004
|
Junior Member |
|
|
|
I am managing an Oracle db 9i release 1 (9.0.1) on Windows Nt 4.0 server. The db encounters the ORA-12571 and ORA-12500 messages quite frequently at the pick business hour. The concurent number of sessions are between 50 and 60 at that time.What might be the possible reasons and remedies?
|
|
|
|
| Re: ORA-12571 and ORA-12500 [message #67352 is a reply to message #67348] |
Sat, 29 May 2004 00:33  |
Tak Tang
Messages: 142
Registered: May 2004
|
Senior Member |
|
|
According to the manual, 12500 means that the listener failed to start a dedicated server process; and 12571 means 'TNS packet writer failure'. This kinda makes sense with it occuring at peak activity. Try monitoring the os - stuff like available memory. If you are running Multi-Threaded-Server, then you have reached the configured maximum number of connections - if you dont know whether you are running MTS, then you probably are not - it is an advanced configuration for specific conditions.
Pull out your PROCESSES; SESSIONS and TRANSACTIONS setting from v$parameter - you could be hitting those.
Takmeister
|
|
|
|
| Re: ORA-12571 and ORA-12500 [message #67405 is a reply to message #67352] |
Sun, 27 June 2004 23:23 |
charles
Messages: 16
Registered: September 2000
|
Junior Member |
|
|
I have received "TNS packet writer failure" problem during the installation of oracle 8.0 for NT os.(Server version 4.0)
After installing BOOT MANAGER the above problem arises.
I could not understand why this happens.I need explanation about it.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
