Home » RDBMS Server » Networking and Gateways » listener connection_timeout (oracle 10.1.2 Redhat AS 4)
listener connection_timeout [message #308303] Mon, 24 March 2008 00:23 Go to next message
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
Re: listener connection_timeout [message #308304 is a reply to message #308303] Mon, 24 March 2008 00:34 Go to previous messageGo to next message
BlackSwan
Messages: 22725
Registered: January 2009
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?
Re: listener connection_timeout [message #308307 is a reply to message #308303] Mon, 24 March 2008 00:39 Go to previous messageGo to next message
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


Re: listener connection_timeout [message #308309 is a reply to message #308303] Mon, 24 March 2008 00:46 Go to previous messageGo to next message
BlackSwan
Messages: 22725
Registered: January 2009
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?
Re: listener connection_timeout [message #308323 is a reply to message #308303] Mon, 24 March 2008 01:05 Go to previous messageGo to next message
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
Re: listener connection_timeout [message #308327 is a reply to message #308303] Mon, 24 March 2008 01:07 Go to previous messageGo to next message
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
Re: listener connection_timeout [message #308329 is a reply to message #308303] Mon, 24 March 2008 01:09 Go to previous messageGo to next message
BlackSwan
Messages: 22725
Registered: January 2009
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.
Re: listener connection_timeout [message #308333 is a reply to message #308323] Mon, 24 March 2008 01:13 Go to previous messageGo to next message
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 Go to previous messageGo to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
should i use sqlplus or lsnrctl to
show inbound_connect_timeout ?
Re: listener connection_timeout [message #308370 is a reply to message #308303] Mon, 24 March 2008 02:49 Go to previous message
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>   
Previous Topic: Static Service registration for Listener
Next Topic: Client Tracking in Database
Goto Forum:
  


Current Time: Mon Sep 01 19:57:03 CDT 2014

Total time taken to generate the page: 0.10635 seconds