Group,
When I edited my tnsnames.ora file to remove .claritas.com from the service_name the script made the db connection and ran fine. Thanks everyone! ________________________________ From: Ethridge, David Sent: Friday, March 09, 2007 12:48 PM To: '[email protected]' Subject: FME connection to Oracle--Error while trying to retrieve text for error ORA-24327 Dear group, I have a Shape to Oracle spatial FME script. A coworker can run the same script using Feature Manipulation Engine Version 2004 ICE 3 (20041108 - Build 1378). I can not run the script using Feature Manipulation Engine 2006 (O) (20051216 - Build 2182) My coworker does not have ORACLE_HOME env. var. set and his script works. I have tried having ORACLE_HOME both unset and set to C:\oracle\ora92\bin - but it does not work either way. The error message that I get is (servername and username changed for privacy): Error obtaining connection to database. (serverType=`ORACLE8I', serverName=`PRIVATE', userName=`MYUSERNAME', password=`***', dbname=`') Last error message reported by Oracle was: Error while trying to retrieve text for error ORA-24327 Our Oracle version is 10g. Thanks for any clues! David Ethridge GIS Programmer Programming and Project Services Claritas Inc. _________________________________ 53 Brown Rd. Ithaca, NY 14850 Direct 1 607 266 3112 Tel 1 607 257 5757 Fax 1 607 266 0891 www.claritas.com
