This content has been marked as final. Show 4 replies
Firstly check from command prompt if you are able to get the reply from the db server using
tnsping <<connect string>>
here the connect string would be LHS part of corresponding entry in tnsnames.ora file
If you are able to get the reply ensure that the call interface u select in the rpd connection pool to be OCI 10g (or 11g whichever version of db u r using) and in the name give the above connect string.
If you are not able to get any reply it might be either network issue or improper install of sql client
Hope this helps