SQLDeveloper – on a connect – Got minus one from a read call on an EBS VIS instance

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.

Leave a Comment

Scroll to Top