Hi all. Was wondering if anyone could guide me gently through this snippet of a listener.log file. I am experiencing ORA-12500 errors eventually from db server and have begun to investigate the possibility of too many connections hanging around - no doubt a result of poor programming in the DLL's, but that is another story - and want to get a grip on what the listener.log is telling me.
This snippet is what the listener.log generates when I log into my ASP web-based application from IE5.5 on Windows NT, Microsoft Transaction Server-enabled, with Visual Basic Middle tier COM+ DLL's within MTS.
Is this telling me that no less than 8(!) separate connections are being created based on the PORT being different for each CONNECT_DATA element?
I eventually receive these errors from the listener.log file:
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNSrotocol adapter error
TNS-00510: Internal limit restriction exceeded
32-bit Windows Error: 8: Exec format error
By this time you might have answer. If not, here is.
Each field is delimited by *
A successful connection returns 0. Failure connection returns oracle error code.
This is the format
timestamp*connect info* protocol tcp/ip , spx, port * sid * return value