also i have 2 nodes i must be apply this command in both nodes that i have ??? if there is any downtime in this operation
alter system set processes=200 scope=spfile; shutdown immediate; startup;
861100 wrote:The larger the value of PROCESSES parameter, the more SGA space must be reserved for those sessions.
Hi , also my manger ask me why this value is set to 150
i told him this value is set vie oracle by default
but why oracle set this value to this number not to unlimited ? unfortunatily i can't say any thing
can you please share with me???
861100 wrote:Because the client process/app contacted the Oracle listener process via TCP. As part of its TNS connection string, it requested the listener to hand it (the client) off to a specific database service. That service is not registered (by any database instances) with the listener. As the listener has no idea what to do with the client request, it returns the ORA-12516 error.
there is one user that use my oracle database say i found this error in my application
ORA-12516: TNS:listener could not find available handler with matching protocol stack
- why this error not appear in alert log files ???