Autoconfig is not generating scan alias in tnsnames.ora

When we run the autoconfig on application nodes TNSNAME.ORA IS ALSO CREATED BUT WITH VIRTUAL IP ENTRY IN HOST FIELD IT SHOULD BE WITH SCAN LISTENER ENTRY.

FND_DATABASES is a table which is part of the Net Services Topology Model. It gets updated or data gets extracted from it when adconfig runs. So according to the bug if s_update_scan is set to FALSE in the context file, then adconfig will extract the entries from FND_DATABASES.

Customer will need to keep in mind that if they clear the topology data (FND_CONC_CLONE.SETUP_CLEAN) the data in FND_DATABASES will be lost. In that case if they clear the topology data they would have to set s_update_scan to TRUE before running adconfig to reseed the topology tables.

This is expected behaviour in a RAC installation and the process works as following (this method is designed to synchronize scan parameters between the Context File and the FND_DATABASES table):

1. If s_update_scan is set to TRUE, The scan params from the context file are copied to FND_DATABASES and s_update_scan is reset to FALSE.

2. If s_update_scan is set to FALSE, The scan params are copied from FND_DATABASES to the context file.

Workaround:

1. Check the scan name and port from fnd_database table

select DB_NAME,DB_DOMAIN,SCAN_NAME,SCAN_PORT from apps.fnd_databases;

DB_NAME  DB_DOMAIN            SCAN_NAME             SCAN_PORT

-------- -------------------- -------------------- ----------

DEV    abc.com

2. If you find the scan name and port number are null, then update them manually.

update apps.fnd_databases set SCAN_NAME='hostname-scan',SCAN_PORT=1525 where DB_NAME='DEV';

Then commit;

3. Check the values again 

select DB_NAME,DB_DOMAIN,SCAN_NAME,SCAN_PORT from apps.fnd_databases;

DB_NAME  DB_DOMAIN            SCAN_NAME             SCAN_PORT

-------- -------------------- -------------------- ----------

DEV    abc.com                hostname-scan           1525 

4. Now run the autoconfig on application nodes. It should create tnsnames.ora with scan entry.