My Oracle Support Banner

Using the TNS_ADMIN variable and changing the default port number of all Listeners in an 11.2 RAC for an 11.2, 11.1, and 10.2 Database (Doc ID 1306927.1)

Last updated on FEBRUARY 13, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.2 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Using the TNS_ADMIN variable and changing the default port number of all Listeners in an 11.2 RAC for an 11.2, 11.1, and 10.2 Database

***Checked for relevance on 11-Mar-2013***


Goal

The purpose of this note is to describe the necessary steps to use the TNS_ADMIN variable in an 11.2 Grid infrastructure for the 11.2, 11.1, and 10.2 Oracle Databases. In this note, each database version can be treated as a separate install into an 11.2 Grid infrastructure.

The general technique used is to first start from the Grid and Database installations using all default settings. Once the various databases have been installed and validated to be working, then make the changes necessary to use the TNS_ADMIN variable and the files in that directory. Once the change to use the TNS_ADMIN has been validated to work, then make change the default port numbers of the Listeners and the modifications to the corresponding entries in the tnsnames.ora file.

There are many steps and phases in this document which make changes to the Cluster and Instances running in it. This paper was written with the assumption that a fresh installation of all the software is occurring, in which case the system is not in production. It might be possible to perform these steps without taking a Cluster-wide outage, but such a procedure would be much lengthier. This paper is intended to show what needs to be changed and why.

It is possible that not everything will work as outlined in this paper, so look at note 948456.1 for various errors that can occur in this environment.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Install 11.2.0.2 Grid
 Database Installations
 Install The 11.2.0.2 Database
 Install The 11.1.0.7 Database
 Install The 10.2.0.5 Database
 Change The TNS_ADMIN Variable For Each Database.
 Test the TNS_ADMIN Is Properly Set
 Change The LOCAL_LISTENER And REMOTE_LISTENER Parameters
 Changing The Default Port Numbers Of The Listeners
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.