ORA-12154: TNS:could not resolve service

[Anon]

Any ideas on the above error would be helpfull

I'm setting the environment variables of TNS_ADMIN, ORACLE_HOME, and ORACLE_SID

and still nothing.

[Anon]

Check your tnsnames.ora file to make sure that the service name is listed exactly as you are using it in the script. Use all three parameters in your OCILogon(). If on Linux, check whether TWO_TASK has been set correctly.

-- Michael
Darkstreak Consulting
www.darkstreak.com

[Anon]

Josh, you don't say which OS you are using. If windows then I've had the same problem - forget the environment variables, simply strip carriage returns out of tnsnames.ora and sqlnet.ora and all will start to work.

I got this fix a little while ago courtisy of someone on another mailing list, so all thanks go to him.

By the way, if you don't have an editor that can save the .ora files without CR's just ftp the files in ascii mode to a Unix box then ftp them back in binary mode...that will do the trick.

Paul

[Anon]

Guys you should check out www.dbasupport.com
for anything remotely to do with Oracle.

Wes