TNS - Revision history

Stuart: /* tnsnames.ora */

2018-10-27T23:48:37Z

‎tnsnames.ora

Stuart: /* Some simple reminders */

2018-10-27T23:36:47Z

‎Some simple reminders

Stuart at 23:36, 27 October 2018

2018-10-27T23:36:26Z

Stuart: /* Connections fail 10% of the time. How to fix? */

2015-11-24T16:04:12Z

‎Connections fail 10% of the time. How to fix?

Stuart at 16:03, 24 November 2015

2015-11-24T16:03:08Z

Stuart at 21:27, 4 September 2014

2014-09-04T21:27:17Z

Stuart at 21:26, 4 September 2014

2014-09-04T21:26:55Z

Stuart: Created page with "[http://martincarstenbach.wordpress.com/2012/06/20/little-things-worth-knowing-static-and-dynamic-listener-registration/ static and dynamic listener registration - artincarste..."

2014-09-04T20:54:36Z

Created page with "[http://martincarstenbach.wordpress.com/2012/06/20/little-things-worth-knowing-static-and-dynamic-listener-registration/ static and dynamic listener registration - artincarste..."

New page

[http://martincarstenbach.wordpress.com/2012/06/20/little-things-worth-knowing-static-and-dynamic-listener-registration/ static and dynamic listener registration - artincarstenbach.wordpress.com]

@@ Line 31: / Line 31: @@
 </pre>
 ====tnsnames.ora====
-Setting the local_listener in the database to the connection string instead of the connect identifier can help
+The clause for LISTENER_FEUK11UD is a reference for the local_listener parameter.
 <pre>
 # tnsnames.ora Network Configuration File: /oracle/product/11.2.0.4/network/admin/tnsnames.ora
@@ Line 49: / Line 49: @@
+   )
 </pre>
 <pre>
 alter system set local_listener="(ADDRESS = (PROTOCOL = TCP)(HOST = HFE2PrePrdOra)(PORT = 1521))" scope=both;

@@ Line 3: / Line 3: @@
 * [http://edstevensdba.wordpress.com/2011/02/09/sqlnet_overview/ diagnosing connection issues - edstevensdba.wordpress.com]
 * [http://edstevensdba.wordpress.com/2011/03/19/ora-12514/ tracking down solutions to tns error messages - edstevensdba.wordpress.com]
-===Some simple reminders===
+===Some basic reminders===
 Original at [https://edstevensdba.wordpress.com/2018/09/17/a-few-points-about-dynamic-registration/ edstevensdba.wordpress.com]<br />
 <br />

@@ Line 3: / Line 3: @@
 * [http://edstevensdba.wordpress.com/2011/02/09/sqlnet_overview/ diagnosing connection issues - edstevensdba.wordpress.com]
 * [http://edstevensdba.wordpress.com/2011/03/19/ora-12514/ tracking down solutions to tns error messages - edstevensdba.wordpress.com]
 ===Connections fail 10% of the time. How to fix?===

@@ Line 5: / Line 5: @@
 ===Connections fail 10% of the time. How to fix?===
 There are some settings that can help...
 ====sqlnet.ora====

← Older revision		Revision as of 16:03, 24 November 2015
Line 3:		Line 3:
	* [http://edstevensdba.wordpress.com/2011/02/09/sqlnet_overview/ diagnosing connection issues - edstevensdba.wordpress.com]		* [http://edstevensdba.wordpress.com/2011/02/09/sqlnet_overview/ diagnosing connection issues - edstevensdba.wordpress.com]
	* [http://edstevensdba.wordpress.com/2011/03/19/ora-12514/ tracking down solutions to tns error messages - edstevensdba.wordpress.com]		* [http://edstevensdba.wordpress.com/2011/03/19/ora-12514/ tracking down solutions to tns error messages - edstevensdba.wordpress.com]
		+
		+	===Connections fail 10% of the time. How to fix?===
		+	There are some settings that can help...
		+	====sqlnet.ora====
		+	Setting a value greater than 0 ensures that connections are not left open indefinitely, due to, for example, an abnormal client termination.
		+	<pre>
		+	# sqlnet.ora Network Configuration File: /oracle/product/11.2.0.4/network/admin/sqlnet.ora
		+	# Generated by Oracle configuration tools.
		+
		+	NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
		+
		+	ADR_BASE = /oracle/product
		+
		+	DIAG_ADR_ENABLED=OFF
		+
		+	sqlnet.expire_time=10
		+	DEFAULT_SDU_SIZE=11280
		+	</pre>
		+	====tnsnames.ora====
		+	Setting the local_listener in the database to the connection string instead of the connect identifier can help
		+	<pre>
		+	# tnsnames.ora Network Configuration File: /oracle/product/11.2.0.4/network/admin/tnsnames.ora
		+	# Generated by Oracle configuration tools.
		+
		+	LISTENER_FEUK11UD =
		+	(ADDRESS = (PROTOCOL = TCP)(HOST = HFE2PrePrdOra)(PORT = 1521))
		+
		+
		+	FEUK11UD =
		+	(DESCRIPTION =
		+	(ADDRESS = (PROTOCOL = TCP)(HOST = HFE2PrePrdOra)(PORT = 1521))
		+	(CONNECT_DATA =
		+	(SERVER = DEDICATED)
		+	(SERVICE_NAME = FEUK11UD)
		+	)
		+	)
		+	</pre>
		+	<pre>
		+	alter system set local_listener="(ADDRESS = (PROTOCOL = TCP)(HOST = HFE2PrePrdOra)(PORT = 1521))" scope=both;
		+	</pre>
		+
		+	====listener.ora====
		+	Setting STARTUP_WAIT_TIME_LISTENER
		+	Setting CONNECT_TIMEOUT_LISTENER
		+	<pre>
		+	# listener.ora Network Configuration File: /oracle/product/11.2.0.4/network/admin/listener.ora
		+	# Generated by Oracle configuration tools.
		+
		+	STARTUP_WAIT_TIME_LISTENER_FEUK11UD = 0
		+	CONNECT_TIMEOUT_LISTENER_FEUK11UD = 30
		+	LISTENER_FEUK11UD =
		+	(DESCRIPTION_LIST =
		+	(DESCRIPTION =
		+	(ADDRESS = (PROTOCOL = TCP)(HOST = HFE2PrePrdOra)(PORT = 1521))
		+	(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
		+	)
		+	)
		+
		+	ADR_BASE_LISTENER_FEUK11UD = /oracle/product
		+	</pre>

@@ Line 1: / Line 1: @@
-[http://martincarstenbach.wordpress.com/2012/06/20/little-things-worth-knowing-static-and-dynamic-listener-registration/ static and dynamic listener registration - artincarstenbach.wordpress.com]
+* [http://martincarstenbach.wordpress.com/2012/06/20/little-things-worth-knowing-static-and-dynamic-listener-registration/ static and dynamic listener registration - artincarstenbach.wordpress.com]
-[http://edstevensdba.wordpress.com/2011/07/30/exploring-the-local_listener-parameter/ Exploring the LOCAL_LISTENER parameter - edstevensdba.wordpress.com]
+* [http://edstevensdba.wordpress.com/2011/07/30/exploring-the-local_listener-parameter/ Exploring the LOCAL_LISTENER parameter - edstevensdba.wordpress.com]
-[http://edstevensdba.wordpress.com/2011/02/09/sqlnet_overview/ diagnosing connection issues - edstevensdba.wordpress.com]
+* [http://edstevensdba.wordpress.com/2011/02/09/sqlnet_overview/ diagnosing connection issues - edstevensdba.wordpress.com]
-[http://edstevensdba.wordpress.com/2011/03/19/ora-12514/ tracking down solutions to tns error messages - edstevensdba.wordpress.com]
+* [http://edstevensdba.wordpress.com/2011/03/19/ora-12514/ tracking down solutions to tns error messages - edstevensdba.wordpress.com]

← Older revision		Revision as of 21:26, 4 September 2014
Line 1:		Line 1:
	[http://martincarstenbach.wordpress.com/2012/06/20/little-things-worth-knowing-static-and-dynamic-listener-registration/ static and dynamic listener registration - artincarstenbach.wordpress.com]		[http://martincarstenbach.wordpress.com/2012/06/20/little-things-worth-knowing-static-and-dynamic-listener-registration/ static and dynamic listener registration - artincarstenbach.wordpress.com]
		+	[http://edstevensdba.wordpress.com/2011/07/30/exploring-the-local_listener-parameter/ Exploring the LOCAL_LISTENER parameter - edstevensdba.wordpress.com]
		+	[http://edstevensdba.wordpress.com/2011/02/09/sqlnet_overview/ diagnosing connection issues - edstevensdba.wordpress.com]
		+	[http://edstevensdba.wordpress.com/2011/03/19/ora-12514/ tracking down solutions to tns error messages - edstevensdba.wordpress.com]