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 Reply

Your email address will not be published. Required fields are marked *