Rel 11i: How to change the hostname and/or port of the Database Tier using AutoConfig
Last updated on NOVEMBER 09, 2017
Applies to:Oracle Applications Manager - Version 18.104.22.168 to 22.214.171.124 [Release 11.5.10]
Oracle E-Business Suite Technology Stack - Version 126.96.36.199 to 188.8.131.52 [Release 11.5.10]
Information in this document applies to any platform.
Checked for relevance on 12-Jan-2017
Many customers are aware of how to reconfigure an E-Business 11i system using AutoConfig, however certain configuration changes are not reflected in the configuration files.
This is caused by new functionality delivered in ADX.E called the "Net Services Topology Model".
The Net Services Topology Data Model stores the entire topological information about a single Oracle Application instance. The data model stores information about each node in the Oracle Applications instance which is then used to generate the Net Service configuration files (for example tnsnames.ora). AutoConfig seeds the data model with relevant data.
The Net Services Topology Data Model stores the following information:
- On the database tier: Hostname, Database SID, Database Name, Instance Name, TNS Descriptors.....
- On the application tier: Hostname, FNDFS and FNDSM alias descriptors.........
This functionality is causing confusion with customers who are trying to reconfigure their existing systems using AutoConfig. Changes such as hostname or Database port are not reflected in the configuration files after AutoConfig is run.
Examples such as : tnsnames.ora, listener.ora, or APPS_JDBC_URL still contain references to the old configuration or now contain both old and new configuration.
These problems occur because the "Tier" information needs to be removed and re-inserted in the Net Services Model.
Refer to <Note:218089.1> (Questions/Answers 28-41) for more information
The purpose of this document is to assist customers who have a requirement to make one or more of the following changes to their existing Oracle Applications instance:-
- Database Host
- Database Port
To change the Appllications Host, please refer to <NOTE:341322.1> How to change the hostname of an Applications Tier using AutoConfig.
Any other changes to the data stored in the Net Services Topology Data Model you should follow <Note:230672.1> - 'Cloning Oracle Applications 11i with RapidClone'.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms