Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Listener Problem?
Sybrand Bakker wrote:
>
> Here you are
> sqlnet.ora
>
> # SQLNET.ORA Configuration
> File:/u01/app/oracle/product/8.1.5/network/admin/sqlnet.ora
> # Generated by Oracle Net8 Assistant
>
> SQLNET.EXPIRE_TIME = 1
>
> -> NAMES.MAX_OPEN_CONNECTIONS = 5
>
> And I would also increase expire_time to 10, provided this is the server's
> sqlnet.ora (otherwise it doesn't do anything anyway). This is the dead
> connection detection mechanism and it means sqlnet polls every minute.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> Fender <efender_at_ix.netcom.com> wrote in message
> news:87puf4$hu3$1_at_nntp4.atl.mindspring.net...
> > After making a couple successful connections with the Enterprise
> Management
> > Tools, or anything else for that matter, all subsequent connections fail
> > with an "ORA-12545: Connect failed because target host or object does not
> > exist." If I restart listener with a "lsnrctl stop" "lsnrctl start" then
> I
> > can make more connections, up to 4, then I have stop restart the listener
> > again. Oracle 8i 8.1.5, HP-UX 11.0. Right now, this is just an
> > inconvenience, but once we get closer to production, this could cause
> > significant headaches. Here are my relevant .ora files. I used the db
> > create assistant instead of creating this manually, for once. If anyone has
> > any suggestions, they'd be appreciated.
We have a similar problem when under load (several hundred connections) our application server tries to connect to the db, we get a surprising: ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor;
The problem appears with NT and Solaris for the Db server.
However we don't have the settings that you incriminate:
SQLNET.EXPIRE_TIME = 1
NAMES.MAX_OPEN_CONNECTIONS = 5
So our guess is that at least: NAMES.MAX_OPEN_CONNECTIONS would default to the value
of 'processes' in init.ora.
Thanks for any ideas about what could cause this problem. Christophe
Christophe L. Galerne cgalerne_at_tumbleweed.com Software Engineer Tel: (650) 216 2029 "For every complex problem there is an answer that is clear, simple, and wrong." -- H L MenckenReceived on Tue Feb 08 2000 - 19:36:58 CST