![]() I have dedicated the web users to connect only through the new listener while the local users connect through the default listener. I felt it is a listener and RAM problemġ) For the listener, I have added a new listener The CPU usage is just around 50% and IO seems to be acceptable. I have monitored Oracle from Oracle Enterprise Manager and Statspack reports in peak working hours. This is in addition when we start to go more than 850 or little more, the users who connect to the database take longer time to connect than before. However, now we have reached more than 980 concurrent sessions and the Oracle Database started to display the same error "ORA-12500: TNS:listener failed to start a dedicated server process" The sessions go beyond the 700 even 800 concurrent sessions. I have added the switch /3GB to the boot.ini in Windows and things have improved ![]() I have read about the 4GB Tunning and how to allow Oracle Process in Windows to grow more than the 2 GB limit. ORA-12500: TNS:listener failed to start a dedicated server process However, once the sessions connected to the server started to reach 600 or little more we start to have the error: This server is dedicated to the Oracle Database which the users are accessing it locally and from the Internet. Oracle Database 9i R2 installed on Windows 2000 AS which is running on HP Server with the following specification: I hope you help me in this as you usually do. What is the meaning of "Note, however, that re-linking must occur on the O/S version that the application was compiled, as this affects patch sets."?ĭoes it simply mean executing $ORACLE_HOME/bin/relink? What does relink do and how is it related to 32/64 bit problem? Note, however, that re-linking must occur on the O/S version that the application was compiled, as this affects patch sets. A 32-bit application will work on both a 32-bit and 64-bit O/S, whereas a 64-bit application will only work on a 64-bit O/S. The 32-bit O/S runs only programs that were compiled on a 32-bit O/S. The 64-bit O/S is capable of running programs that were compiled on a 32-bit O/S and 64-bit O/S. ![]() All Server and O/S versions without 64-bit notations indicate 32-bit versions. I wanted to know if Oracle 9i release 2 (32 bit) supported on 64 bit Sun 5.8 (solaris 8). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |