This content has been marked as final. Show 2 replies
5? You mean 5 000 000, right?
Error says the lookup of connect id/alias and resolution for connect descriptor failed, before actual connection was attempted, possibly because missing tnsnames entry or wrong .ora file used.
Get Process Monitor tool and trace the web service as it searches for and reads tnsnames.ora, assuming local naming is used.
An alternative is to use Easy connect naming instead. Enter as connect string 'hostname:port/service_name' (replace with actual values, e.g. 'mydbhost:1521/xe')
Thanks for the suggestion orafad. I will try the tool. BTW, sarcasm is always extremely helpful when someone is trying to solve a problem. Always a funny guy in the bunch, eh?