fact: Oracle Net Services 9.2
fact: TNS Listener 9.2
symptom: Client hangs when connecting to the instance.
symptom: Error is reported to the listener.log file.
symptom: TNS-01181: Internal registration connection limit reached
cause: Caused by (internal) <Bug:2755063> TNS-1181: INTERNAL REGISTRATION
CONNECTION LIMIT REACHED
a) upgrade to Oracle Server 10
b) Apply patchset 18.104.22.168
c) Apply patch number 2755063 on the top of the patchset 22.214.171.124
a) restart listener
b) set following parameter in listener.ora
MAX_REG_CONNECTIONS_<listener> = 1000
(default value is 512)
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.