rcc50886 wrote:We use the FQDN of the VIP address on the client side as well, the problem is the answer from the server side.
We generally use VIP's (vip_name.domain) to connect to database from the client side, as long as vip_name.domain is resolved on client side you don't find any problem.
To avoid domain issues, you can add the domain name to /etc/resolv.conf on client server, with this entry you don't even specify the domain name.Unfortunately, I can not control all the clients which connect to this database.
local_listener=LISTENER_DB1 --- on tnsnames.ora file, it lists as follows: LISTENER_DB1= (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip.domain_name)(PORT = 1521)) )
rcc50886 wrote:That was it, thank you. Turns out local_listener was not set at all. It works now.
oracle picks the vip name from the local_listener parameter defined on the database.
So make sure your local_listener parameter of all the DB instance have the domain name append to the vip name.