resources like RAM (swapping?)
100% CPU usage?

Listener cannot spawn more processes when there are no resources for him to do it.
256mb RAM sounds silly for a database server anyways... even my PC has more than that

Tarry what you said has nothing to do with this error really, processes is related to server resources not sid list, connect data etc