Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE : concurrent connection limit
Kevin,
Strange indeed but definitely unrelated to the listener itself.
ORA-12154 is definitely a client-side error - you need to find the
service name before hitting any listener. It probably is a names
server-related problem.
Concurrent connections are limited by the 'processes' init.ora parameter
and the (Unix) maximum number of processes per login, whichever is
smaller.
-- Regards, Stephane Faroult email: sfaroult_at_oriolecorp.com Oriole Corporation Voice: +44 (0) 7050-696-269 Fax: +44 (0) 7050-696-449 Performance Tools & Free Scripts ------------------------------------------------------------------ http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs ------------------------------------------------------------------ >>Received on Fri May 05 2000 - 11:32:31 CDT
>
> hi listers:
>
> Does anyone know if there is any limit for concurrent connection a listener can
> handle by using (protocol=ipc) ?
>
> platform HP-UX 10.20
> Oracle 7.3.4.3
> Oracle networking using names server (i.e. we have listener.ora, names.ora,
> sqlnet.ora)
>
> The problem is we've experienced sporadically ORA-12154 :TNS could not resolve
> service name and this was happened when there were some background jobs in UNIX
> did a "sqlplus -s user/passwd_at_sid"
> and the job received this error. The weird thing is a minute before the other
> job went thru but the next minute later this job failed. So I suspect is there
> any concurrent connection limit that a listener can handle ?
>
> Any ideas ?
>
> TIA
>
> Kevin Tsay
> --
> Author: Kevin Tsay