OraFAQ Forum: Networking and Gateways » listener connection

Home » RDBMS Server » Networking and Gateways » listener connection_timeout (oracle 10.1.2 Redhat AS 4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

listener connection_timeout [message #308303]

Mon, 24 March 2008 00:23

M.Shakeel Azeem
Messages: 226
Registered: September 2006

Senior Member

Dear All,

We can set the connection_timeout by

lsnrctl>set connection_timeout

but how to know the settings of connection_timeout already defined .

I also want to have an expert's opinion about the following errors

ORA-12560: TNS: protocol adapter error cause.

ORA-12571: TNS:packet writer failure error cause.

ORA-03135: connection lost contact error cause.

ORA-12547: TNS:lost contact error cause

Report message to a moderator

Re: listener connection_timeout [message #308304 is a reply to message #308303]

Mon, 24 March 2008 00:34

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I also want to have an expert's opinion about the following errors
Yes, they are Oracle errors.

So what is your real question?

Report message to a moderator

Re: listener connection_timeout [message #308307 is a reply to message #308303]

Mon, 24 March 2008 00:39

M.Shakeel Azeem
Messages: 226
Registered: September 2006

Senior Member

my first question was about how to determine the settings of
connection_timeout already defined ?

e.g. we can set the connection_timeout by using the following
lsnrctl>set connection_timeout=22

Report message to a moderator

Re: listener connection_timeout [message #308309 is a reply to message #308303]

Mon, 24 March 2008 00:46

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>e.g. we can set the connection_timeout by using the following
>lsnrctl>set connection_timeout=22

Yes, but what will be gained or lost?

Report message to a moderator

Re: listener connection_timeout [message #308323 is a reply to message #308303]

Mon, 24 March 2008 01:05

M.Shakeel Azeem
Messages: 226
Registered: September 2006

Senior Member

The question is not about gaining or loosing something
but someone ask me to know connection_timeout

So please suggest me if you can

Thanx a Lot

Report message to a moderator

Re: listener connection_timeout [message #308327 is a reply to message #308303]

Mon, 24 March 2008 01:07

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

http://download.oracle.com/docs/cd/B19306_01/network.102/b14213/sqlnet.htm#sthref481

Report message to a moderator

Re: listener connection_timeout [message #308329 is a reply to message #308303]

Mon, 24 March 2008 01:09

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>but someone ask me to know connection_timeout
It either solves your problem or it doesn't.
It is for you to decide.

Report message to a moderator

Re: listener connection_timeout [message #308333 is a reply to message #308323]

Mon, 24 March 2008 01:13

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Quote:

to know connection_timeout

show inbound_connect_timeout;
set inbound_connect_timeout 22

[Edit: Code Tags.]

[Updated on: Mon, 24 March 2008 01:15]

Report message to a moderator

Re: listener connection_timeout [message #308354 is a reply to message #308303]

Mon, 24 March 2008 02:09

M.Shakeel Azeem
Messages: 226
Registered: September 2006

Senior Member

should i use sqlplus or lsnrctl to
show inbound_connect_timeout ?

Report message to a moderator

Re: listener connection_timeout [message #308370 is a reply to message #308303]

Mon, 24 March 2008 02:49

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

your wish..

-bash-3.00$ lsnrctl show inbound_connect_timeout;

LSNRCTL for Solaris: Version 10.2.0.2.0 - Production on 24-MAR-2008 14:50:04

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
LISTENER parameter "inbound_connect_timeout" set to 0
The command completed successfully
-bash-3.00$ lsnrctl

LSNRCTL for Solaris: Version 10.2.0.2.0 - Production on 24-MAR-2008 14:50:19

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.
LSNRCTL> show inbound_connect_timeout
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
LISTENER parameter "inbound_connect_timeout" set to 0
The command completed successfully
LSNRCTL>

Report message to a moderator

Previous Topic:	Static Service registration for Listener
Next Topic:	Client Tracking in Database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 31 23:40:05 CST 2025