Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Listener Problem?

Re: Listener Problem?

From: Christophe Galerne <christophe_at_tumbleweed.com>
Date: Tue, 08 Feb 2000 17:36:58 -0800
Message-ID: <38A0C4BA.7500AAEF@tumbleweed.com>


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 Mencken
Received on Tue Feb 08 2000 - 19:36:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US