1 person found this helpful
There are few things you need to consider and check in your environment -
1. sqlnet.ora configuration.
2. value of remote_listener
3. Changes in tnsnames.ora file after executing autoconfig.
4. autoconfig version.
Below is reference note from MOS for you-
SCAN Registration Issue: Services Fail to Register to SCAN Listeners (Doc ID 1448717.1
I have documented few things under -
Summarising this, you can use scan entry provided your sqlnet.ora has configuration like below, -
This implies EZCONNECT having higher preference than TNSNAMES and value of REMOTE_LISTENER will be resolved by EZCONNECT method first.
Considering other way like below -
This will resulting in name getting resolved by entry found in tnsnames.ora.
Hope this helps.