SQLDeveloper on a connect – I received the error: got minus one from a read call on an EBS VIS instance
Oracle protects EBS R12 instances by limiting who can connect – it appears by using TCP.VALID_NODE_CHECKING=YES.
Login to your VIS host server.
cd $ORACLE_HOME/network/admin
cd VIS_oel66-79
vi sqlnet.ora
change this
tcp.validnode_checking = yes
to
tcp.validnode_checking = no
Looks like EBS installs disable remote connects via this mechanism by default – following line was created by the startCD install of VIS – you don’t need to touch it – but the checking must be turned off above
tcp.invited_nodes=(OEL66-79.localdomain)
I would I could instead just add a server / IP tot he “tcp.invited_nodes” list and that would work too, I’ll test that theory later.