Tuesday, February 12, 2013

Troubleshoot : Can't Access DB From Some Node/TOAD

Symptom :

Yesterday I had case, my developer can't access db with TOAD but he can access it on machine.

Solutin :

Check : $TNS_ADMIN/sqlnet.ora

There are lines :
tcp.validate_checking = yes

tcp.invited_nodes = ....

First line is sett db should check node who can access db. yes means db machine would check who access the db.

Second line is define nodes who accepted to access db.

Both of lines is addition, after install db, the lines is not exist, we should add those lines for security issue.

No comments:

Post a Comment